tokemak_v2_ethereum - Token Terminal Docs

Tables

AutopoolETH_AddedToRemovalQueue_event

Events tracking destinations added to withdrawal queue for Tokemak v2 AutopoolETH vaults on Ethereum. Used to monitor vault rebalancing operations and analyze which destination vaults are being marked for liquidity removal.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_destination`	`STRING`	Target address receiving tokens, funds, or messages in the operation. Hex-encoded, 0x-prefixed, 42-character string.

Sample Data

address	removed	log_index	block_number	in_destination	block_timestamp	transaction_hash
0xe800e3760fc20aa98c5df6a9816147f190455af3	false	296	20939503	0x777faf85c8e5fc6f4332e56b989c5c94201a273c	2024-10-11T02:49:35.000Z	0x0928a563d0ab58ac4a98bf23d71c49b025a88ba173d0d550eed9360b1291ac3b
0x0a2b94f6871c1d7a32fe58e1ab5e6dea2f114e56	false	1347	20945620	0x896ecc16ab4afff6ce0765a5b924baecd7fa455a	2024-10-11T23:21:35.000Z	0xf3695f3da97bff9984831f8631899764290506c919f770ae16051da9395ac219
0xe800e3760fc20aa98c5df6a9816147f190455af3	false	141	20949834	0x4e12227b350e8f8feec41a58d36ce2fb2e2d4575	2024-10-12T13:31:23.000Z	0xa9b7e57b8202064b6fd48accbcfea54cb08fbb362638aa47681203c5daf7b722

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.tokemak_v2_ethereum.AutopoolETH_AddedToRemovalQueue_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

AutopoolETH_Approval_event

ERC-20 token approval events from Tokemak v2’s AutopoolETH vault on Ethereum, tracking owner authorization of spender addresses with approved token amounts. Used for monitoring vault share delegation and third-party protocol integrations.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_owner`	`STRING`	Address that owns or controls the shares or position being deposited or withdrawn. Hex-encoded, 0x-prefixed, 42-character string.
`in_spender`	`STRING`	Address authorized to spend tokens on behalf of the owner. Hex-encoded, 0x-prefixed, 42-character string.
`in_value`	`STRING`	Amount of tokens transferred, minted, or burned in the operation. Numeric string representation preserving precision for large integer values.

Sample Data

address	removed	in_owner	in_value	log_index	in_spender	block_number	block_timestamp	transaction_hash
0x0a2b94f6871c1d7a32fe58e1ab5e6dea2f114e56	false	0xc45e939ca8c43822a2a233404ecf420712084c30	0	288	0x60882d6f70857606cdd37729ccce882015d1755e	20764939	2024-09-16T18:23:35.000Z	0xcb66a08c9278db4048e6653b99c9cbd41f8b61d410202a6b8c68314d26ef05cc
0x0a2b94f6871c1d7a32fe58e1ab5e6dea2f114e56	false	0xc45e939ca8c43822a2a233404ecf420712084c30	115792089237316195423570985008687907853269984665640564039457584007913129639935	289	0x60882d6f70857606cdd37729ccce882015d1755e	20764939	2024-09-16T18:23:35.000Z	0xcb66a08c9278db4048e6653b99c9cbd41f8b61d410202a6b8c68314d26ef05cc
0x0a2b94f6871c1d7a32fe58e1ab5e6dea2f114e56	false	0xc45e939ca8c43822a2a233404ecf420712084c30	115792089237316195423570985008687907853269984665640564039457584007913129639935	212	0x60882d6f70857606cdd37729ccce882015d1755e	20765196	2024-09-16T19:15:11.000Z	0x21bd65665599c253197fe5018fd3e86fa8c25a2b863f7af2bc6fef2c64a4091e

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.tokemak_v2_ethereum.AutopoolETH_Approval_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

AutopoolETH_Deposit_event

Deposit events from Tokemak v2’s AutopoolETH vault on Ethereum, recording user deposits with ETH amounts and vault shares minted. Used for tracking liquidity provision and calculating share prices over time.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_sender`	`STRING`	Address that initiated the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_owner`	`STRING`	Address that owns or controls the shares or position being deposited or withdrawn. Hex-encoded, 0x-prefixed, 42-character string.
`in_assets`	`STRING`	Number of asset units involved in the deposit or withdrawal transaction. String-encoded integer representing the asset quantity in the protocol’s accounting system.
`in_shares`	`STRING`	Number of shares involved in the deposit or withdrawal transaction. String-encoded integer representing the share quantity in the protocol’s accounting system.

Sample Data

address	removed	in_owner	in_assets	in_sender	in_shares	log_index	block_number	block_timestamp	transaction_hash
0x0a2b94f6871c1d7a32fe58e1ab5e6dea2f114e56	false	0x4f2f72ae86e123d4f69b07e29f20034403db6893	96001119635391012	0x4f2f72ae86e123d4f69b07e29f20034403db6893	95701347427743507	420	21140316	2024-11-08T03:44:47.000Z	0x3793b8b5aabd63e610805f899ce22ef7599e36a57626783ecf935670cc97910a
0x0a2b94f6871c1d7a32fe58e1ab5e6dea2f114e56	false	0xc45e939ca8c43822a2a233404ecf420712084c30	53000000000000000000	0xc45e939ca8c43822a2a233404ecf420712084c30	52826499255716920419	244	21144624	2024-11-08T18:09:59.000Z	0xfddca7cd19365b757641011fe19c68c79ca7f671ba6c38e950f55bf41afcd739
0x0a2b94f6871c1d7a32fe58e1ab5e6dea2f114e56	false	0xc45e939ca8c43822a2a233404ecf420712084c30	321000000000000000000	0xc45e939ca8c43822a2a233404ecf420712084c30	319989013849156429044	174	21140995	2024-11-08T06:00:59.000Z	0xfd6d2e5a9414944d6770fadd283e2d5009cb93c42dbaf68cf34b95a28b1fb78b

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.tokemak_v2_ethereum.AutopoolETH_Deposit_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

AutopoolETH_deposit_function

Deposit transactions into Tokemak v2’s AutopoolETH vault on Ethereum, recording asset amounts deposited and vault shares minted. Used for analyzing liquidity provision patterns and share exchange rates over time.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`trace_address`	`STRING`	Hierarchical position of the internal call within a transaction’s execution trace. Comma-separated sequence of integers representing the call path, where each number indicates the index of the call at that nesting level, with null representing top-level calls.
`status`	`BOOL`	Transaction execution outcome indicator. Boolean value where true represents successful execution and false represents failed execution.
`from_address`	`STRING`	Address that initiated the transaction or contract call. Hex-encoded, 0x-prefixed, 42-character string.
`to_address`	`STRING`	Address receiving the transaction or contract call. Hex-encoded, 0x-prefixed, 42-character string.
`value`	`FLOAT64`	Amount of native cryptocurrency sent with the transaction. Floating-point representation in whole units (e.g., ETH, BNB, MATIC).
`gas_used`	`INT64`	Amount of gas consumed by the transaction execution. Integer representing the actual computational steps used.
`gas`	`INT64`	Gas limit allocated for the transaction execution. Integer representing the maximum computational steps allowed.
`signature`	`STRING`	Function selector identifying which contract function was called. 10-character hex string including 0x prefix.
`in_assets`	`STRING`	Number of asset units involved in the deposit or withdrawal transaction. String-encoded integer representing the asset quantity in the protocol’s accounting system.
`in_receiver`	`STRING`	Address that receives tokens, assets, or rewards from the transaction. Hex-encoded, 0x-prefixed, 42-character string.
`out_shares`	`STRING`	Number of shares issued or burned as a result of the transaction. String-encoded integer representing the share quantity in the protocol’s accounting system.

Sample Data

gas	status	gas_used	in_assets	signature	out_shares	to_address	in_receiver	block_number	from_address	trace_address	block_timestamp	transaction_hash
239709	true	132199	21000000000000000000	0x6e553f65	20646151469357971866	0x0a2b94f6871c1d7a32fe58e1ab5e6dea2f114e56	0xc45e939ca8c43822a2a233404ecf420712084c30	21640956	0xc45e939ca8c43822a2a233404ecf420712084c30	3,0	2025-01-17T01:33:35.000Z	0x0b7b5dbf5df85a51feffc4f16c668f4d60b45b5c1fc6bdbee1985b5d729133d3
252450	true	132199	1000000000000000	0x6e553f65	983124897654256	0x0a2b94f6871c1d7a32fe58e1ab5e6dea2f114e56	0xddb756853030bb1ec4a22de2379a4e94cd508c3d	21641885	0xc45e939ca8c43822a2a233404ecf420712084c30	3,0	2025-01-17T04:40:11.000Z	0x4f5ae39edc94007356fed464ff1fc304412353639e6c4e22bd05ed591468d5e0
864030	true	130976	62405541637905993	0x6e553f65	61499572860491439	0x0a2b94f6871c1d7a32fe58e1ab5e6dea2f114e56	0x4f2f72ae86e123d4f69b07e29f20034403db6893	21547220	0x4f2f72ae86e123d4f69b07e29f20034403db6893	0,0,0,0,0,0,4,1,16	2025-01-03T23:24:47.000Z	0x8d5100e2bd30d3ec53943aee76af3d89fa76b30d8aa7673562e14c50d4f6a13c

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.tokemak_v2_ethereum.AutopoolETH_deposit_function`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

AutopoolETH_DestinationDebtReporting_event

No description available.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_destination`	`STRING`	Target address receiving tokens, funds, or messages in the operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_debtValue`	`STRING`	-
`in_claimed`	`STRING`	Amount of tokens or rewards claimed in the transaction. String-encoded integer representing the claimed value in smallest token units.
`in_claimGasUsed`	`STRING`	-

Sample Data

No sample data available.

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.tokemak_v2_ethereum.AutopoolETH_DestinationDebtReporting_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

AutopoolETH_DestinationVaultAdded_event

Events tracking destination vault additions to Tokemak v2 AutopoolETH contracts on Ethereum. Records autopool addresses, newly added destination vault addresses, and removal flags for analyzing vault composition changes and rebalancing activity.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_destination`	`STRING`	Target address receiving tokens, funds, or messages in the operation. Hex-encoded, 0x-prefixed, 42-character string.

Sample Data

address	removed	log_index	block_number	in_destination	block_timestamp	transaction_hash
0x0a2b94f6871c1d7a32fe58e1ab5e6dea2f114e56	false	243	20935941	0xe4433d00cf48bfe0c672d9949f2cd2c008bffc04	2024-10-10T14:54:59.000Z	0xc01e82fb33853b9656c1cb1cb08c11eb94076e5a0836b52b877a37c322a3c99b
0x72cf6d7c85ffd73f18a83989e7ba8c1c30211b73	false	377	20464397	0x2b7612998d9c979b125d3a4f4bb2af88a80f0c0f	2024-08-05T19:16:47.000Z	0xe0f55315a35003177deb1ce2fe2a997363083b339ff2b5103b9fe26c353cba6e
0x49c4719eacc746b87703f964f09c22751f397ba0	false	89	20464396	0x2b7612998d9c979b125d3a4f4bb2af88a80f0c0f	2024-08-05T19:16:35.000Z	0x66e86b4276c7149127ad481c5c92525409a226478cd8ed7c638dd185a30061b9

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.tokemak_v2_ethereum.AutopoolETH_DestinationVaultAdded_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

AutopoolETH_DestinationVaultRemoved_event

Event logs tracking destination vault removals from Tokemak v2 AutopoolETH strategies on Ethereum. Records which destination vaults are removed from autopool configurations, useful for analyzing portfolio rebalancing and vault allocation changes.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_destination`	`STRING`	Target address receiving tokens, funds, or messages in the operation. Hex-encoded, 0x-prefixed, 42-character string.

Sample Data

address	removed	log_index	block_number	in_destination	block_timestamp	transaction_hash
0x6dc3ce9c57b20131347fdc9089d740daf6eb34c5	false	272	20966549	0x8ca2201bc34780f14bca452913ecac8e9928d4ca	2024-10-14T21:40:23.000Z	0x862921210d71bb704a2090218715901800e2ed6b6e33573edb042d7c1aac1980
0x0a2b94f6871c1d7a32fe58e1ab5e6dea2f114e56	false	165	20966549	0x8ca2201bc34780f14bca452913ecac8e9928d4ca	2024-10-14T21:40:23.000Z	0x862921210d71bb704a2090218715901800e2ed6b6e33573edb042d7c1aac1980
0xe800e3760fc20aa98c5df6a9816147f190455af3	false	105	21022789	0x5c6aeb9ef0d5bba4e6691f381003503fd0d45126	2024-10-22T18:03:47.000Z	0xa6f5f0429bc5025c70458f0b80f86b66c60c597674ff69c511349267ddbda2c7

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.tokemak_v2_ethereum.AutopoolETH_DestinationVaultRemoved_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

AutopoolETH_FeeCollected_event

Fee collection events from Tokemak v2 AutopoolETH vaults on Ethereum, recording profit-based fees extracted and vault shares minted to the fee sink address. Useful for analyzing vault performance, fee generation rates, and protocol revenue across different autopool strategies.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_fees`	`STRING`	Array of fee amounts charged in the transaction. Numeric string representations in smallest token denomination.
`in_feeSink`	`STRING`	Address of the fee sink contract that receives collected fees. Hex-encoded, 0x-prefixed, 42-character string.
`in_mintedShares`	`STRING`	Number of shares minted in the operation. String-encoded integer representing share amounts in the smallest denomination.
`in_profit`	`STRING`	Profit amount generated by the protocol operation or position. String-encoded integer representing token amounts in the smallest denomination.
`in_totalAssets`	`STRING`	Total vault assets under management at the time of fee collection, denominated in the base token (wei for ETH). Represents the complete value of the Tokemak autopool after accounting for profits and fees.

Sample Data

address	in_fees	removed	in_profit	log_index	in_feeSink	block_number	in_totalAssets	block_timestamp	in_mintedShares	transaction_hash
0xe800e3760fc20aa98c5df6a9816147f190455af3	95468840213418360	false	6364589347561223974406	34	0x4c0169b48c5a22503f1c3b871b921d55024a5939	21129112	3190379967567521641677	2024-11-06T14:09:47.000Z	95229745762289121	0x60cd58cfa260bf03af0b122726625fc5899d3a7bf9d20eeddd33e9da1be284a2
0x0a2b94f6871c1d7a32fe58e1ab5e6dea2f114e56	154949652590464662	false	10329976839364310753190	416	0x4c0169b48c5a22503f1c3b871b921d55024a5939	21126868	10359834096510435625290	2024-11-06T06:37:47.000Z	154505395373420036	0x9c6e5bc81f4244d6b594c2bb7e736058977eadb566efef3863901b4502080f26
0xe800e3760fc20aa98c5df6a9816147f190455af3	88591693784834046	false	5906112918988936359710	406	0x4c0169b48c5a22503f1c3b871b921d55024a5939	21069105	2960180679781169013671	2024-10-29T05:08:23.000Z	88381126601334640	0x34d8283a85c61682fd73af90c28a2426214246e8079b77f663429baf4fe5b928

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.tokemak_v2_ethereum.AutopoolETH_FeeCollected_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

AutopoolETH_flashRebalance_function

Flash rebalance function calls for Tokemak v2 AutopoolETH vaults on Ethereum, recording token swaps between destinations with input/output amounts and receiver addresses. Used for analyzing vault rebalancing strategies and liquidity management across DeFi protocols.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`trace_address`	`STRING`	Hierarchical position of the internal call within a transaction’s execution trace. Comma-separated sequence of integers representing the call path, where each number indicates the index of the call at that nesting level, with null representing top-level calls.
`status`	`BOOL`	Transaction execution outcome indicator. Boolean value where true represents successful execution and false represents failed execution.
`from_address`	`STRING`	Address that initiated the transaction or contract call. Hex-encoded, 0x-prefixed, 42-character string.
`to_address`	`STRING`	Address receiving the transaction or contract call. Hex-encoded, 0x-prefixed, 42-character string.
`value`	`FLOAT64`	Amount of native cryptocurrency sent with the transaction. Floating-point representation in whole units (e.g., ETH, BNB, MATIC).
`gas_used`	`INT64`	Amount of gas consumed by the transaction execution. Integer representing the actual computational steps used.
`gas`	`INT64`	Gas limit allocated for the transaction execution. Integer representing the maximum computational steps allowed.
`signature`	`STRING`	Function selector identifying which contract function was called. 10-character hex string including 0x prefix.
`in_receiver`	`STRING`	Address that receives tokens, assets, or rewards from the transaction. Hex-encoded, 0x-prefixed, 42-character string.
`in_rebalanceParams`	`STRUCT<destinationIn STRING, tokenIn STRING, amountIn STRING, destinationOut STRING, tokenOut STRING, amountOut STRING>`	Parameters defining the token swap executed during this flash rebalance, including input/output tokens, amounts, and destination addresses for each leg of the trade. Contains structured data specifying tokenIn, amountIn, tokenOut, amountOut, destinationIn, and destinationOut fields.
`in_data`	`STRING`	Encoded input data for the contract function call. Hex-encoded byte string representing function parameters and additional call data.

Sample Data

gas	status	in_data	gas_used	signature	to_address	in_receiver	block_number	from_address	block_timestamp	transaction_hash	in_rebalanceParams
4409343	true	0x00000000000000000000000000000000000000000000000000000000000000400000000000000000000000000000000000000000000000000000000000000200000000000000000000000000000000000000000000000000000000000000000d095ea7b3010001ffffffffffc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2e3547335000082ffffffffff33356a9d8bc8207c6ea152f2f3a648dd6f8028a1095ea7b3010003ffffffffffc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2e3547335000084ffffffffff33356a9d8bc8207c6ea152f2f3a648dd6f8028a1196deb950005ffffffffff047518acf169ab501a7531bbbe1175f47e638ccf5370a082310106ffffffffff007f39c581f595b53c5cb19bd0b3f8da6c935e2ca0095ea7b3010400ffffffffff7f39c581f595b53c5cb19bd0b3f8da6c935e2ca070a082310106ffffffffff03a35b1b31ce002fbf2058d22f30f95d405200a15b095ea7b3010403ffffffffffa35b1b31ce002fbf2058d22f30f95d405200a15b70a082310106ffffffffff06b91159aa527d4769cb9faf3e4adb760c7e8c8ea7095ea7b3010406ffffffffffb91159aa527d4769cb9faf3e4adb760c7e8c8ea77d6940a200000306ffffff866d5f489a2459c2557043ff17eb7492fc7074bbd879fed60e00050486870809ff7518acf169ab501a7531bbbe1175f47e638ccf53000000000000000000000000000000000000000000000000000000000000000a0000000000000000000000000000000000000000000000000000000000000140000000000000000000000000000000000000000000000000000000000000018000000000000000000000000000000000000000000000000000000000000001c000000000000000000000000000000000000000000000000000000000000008c000000000000000000000000000000000000000000000000000000000000009000000000000000000000000000000000000000000000000000000000000000f600000000000000000000000000000000000000000000000000000000000000fa00000000000000000000000000000000000000000000000000000000000000fe0000000000000000000000000000000000000000000000000000000000000108000000000000000000000000000000000000000000000000000000000000010c000000000000000000000000000000000000000000000000000000000000000200000000000000000000000000000000000001ff3684f28c67538d4d072c227340000000000000000000000000000000000000000000000000000000000000020000000000000000000000000000000000000000000000000ae1bbc22e1a1980000000000000000000000000000000000000000000000000000000000000006e000000000000000000000000000000000000000000000000000000000000006a42213bc0b0000000000000000000000000d0e364aa7852291883c162b22d6d81f6355428f000000000000000000000000c02aaa39b223fe8d0a0e5c4f27ead9083c756cc2000000000000000000000000000000000000000000000000ae1bbc22e1a198000000000000000000000000000d0e364aa7852291883c162b22d6d81f6355428f00000000000000000000000000000000000000000000000000000000000000a000000000000000000000000000000000000000000000000000000000000005c41fff991f000000000000000000000000952d7a7eb2e0804d37d9244be8e47341356d2f5d0000000000000000000000007f39c581f595b53c5cb19bd0b3f8da6c935e2ca0000000000000000000000000000000000000000000000000911bef90f5805f8000000000000000000000000000000000000000000000000000000000000000a0494d97323395ac422f628e5d000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000030000000000000000000000000000000000000000000000000000000000000060000000000000000000000000000000000000000000000000000000000000018000000000000000000000000000000000000000000000000000000000000002c000000000000000000000000000000000000000000000000000000000000000e4c1fb425e0000000000000000000000000d0e364aa7852291883c162b22d6d81f6355428f000000000000000000000000c02aaa39b223fe8d0a0e5c4f27ead9083c756cc2000000000000000000000000000000000000000000000000ae1bbc22e1a1980000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000067b2928100000000000000000000000000000000000000000000000000000000000000c0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000010438c9c147000000000000000000000000c02aaa39b223fe8d0a0e5c4f27ead9083c756cc20000000000000000000000000000000000000000000000000000000000002710000000000000000000000000c02aaa39b223fe8d0a0e5c4f27ead9083c756cc2000000000000000000000000000000000000000000000000000000000000000400000000000000000000000000000000000000000000000000000000000000a000000000000000000000000000000000000000000000000000000000000000242e1a7d4d00000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000020438c9c147000000000000000000000000eeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeee0000000000000000000000000000000000000000000000000000000000002710000000000000000000000000cd87828f4f279d3c5fd7af531370298964b5eaab00000000000000000000000000000000000000000000000000000000000000c400000000000000000000000000000000000000000000000000000000000000a00000000000000000000000000000000000000000000000000000000000000124ab81aca50000000000000000000000000000000000000000000000000000eeeeee0000000000000000000000000000007f39c581f595b53c5cb19bd0b3f8da6c935e2ca00000000000000000000000000000000000068db8bac710cb400000000000000000000000000000000000000000000000000000000000000000000000000000c8000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000001000196a05dfeb89e0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000020000000000000000000000000000000000000000000000000dffd5ebd013bf000000000000000000000000000000000000000000000000000000000000000064000000000000000000000000000000000000000000000000000000000000006042213bc0b0000000000000000000000000d0e364aa7852291883c162b22d6d81f6355428f000000000000000000000000c02aaa39b223fe8d0a0e5c4f27ead9083c756cc2000000000000000000000000000000000000000000000000dffd5ebd013bf0000000000000000000000000000d0e364aa7852291883c162b22d6d81f6355428f00000000000000000000000000000000000000000000000000000000000000a000000000000000000000000000000000000000000000000000000000000005241fff991f000000000000000000000000952d7a7eb2e0804d37d9244be8e47341356d2f5d000000000000000000000000a35b1b31ce002fbf2058d22f30f95d405200a15b000000000000000000000000000000000000000000000000d3ad77826afa3a4000000000000000000000000000000000000000000000000000000000000000a030018c10b324a6d176db4653000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000030000000000000000000000000000000000000000000000000000000000000060000000000000000000000000000000000000000000000000000000000000018000000000000000000000000000000000000000000000000000000000000002c000000000000000000000000000000000000000000000000000000000000000e4c1fb425e0000000000000000000000000d0e364aa7852291883c162b22d6d81f6355428f000000000000000000000000c02aaa39b223fe8d0a0e5c4f27ead9083c756cc2000000000000000000000000000000000000000000000000dffd5ebd013bf00000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000067b2928300000000000000000000000000000000000000000000000000000000000000c0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000010438c9c147000000000000000000000000c02aaa39b223fe8d0a0e5c4f27ead9083c756cc20000000000000000000000000000000000000000000000000000000000002710000000000000000000000000c02aaa39b223fe8d0a0e5c4f27ead9083c756cc2000000000000000000000000000000000000000000000000000000000000000400000000000000000000000000000000000000000000000000000000000000a000000000000000000000000000000000000000000000000000000000000000242e1a7d4d00000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000016438c9c147000000000000000000000000eeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeee000000000000000000000000000000000000000000000000000000000000271000000000000000000000000059ab5a5b5d617e478a2479b0cad80da7e2831492000000000000000000000000000000000000000000000000000000000000004400000000000000000000000000000000000000000000000000000000000000a000000000000000000000000000000000000000000000000000000000000000843df021240000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000100000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000001000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000020000000000000000000000000b91159aa527d4769cb9faf3e4adb760c7e8c8ea70000000000000000000000000000000000000000000000000000000000000020000000000000000000000000952d7a7eb2e0804d37d9244be8e47341356d2f5d000000000000000000000000000000000000000000000000000000000000008000000000000000000000000000000000000000000000000000000000000000030000000000000000000000007f39c581f595b53c5cb19bd0b3f8da6c935e2ca0000000000000000000000000a35b1b31ce002fbf2058d22f30f95d405200a15b000000000000000000000000b91159aa527d4769cb9faf3e4adb760c7e8c8ea70000000000000000000000000000000000000000000000000000000000000020000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000200000000000000000000000000000000000000000000000000000000000000001	3602953	0xdc47c23a	0x0a2b94f6871c1d7a32fe58e1ab5e6dea2f114e56	0x952d7a7eb2e0804d37d9244be8e47341356d2f5d	21862843	0x952d7a7eb2e0804d37d9244be8e47341356d2f5d	2025-02-17T01:31:11.000Z	0x4df0842973423a28a8050980699a72f727a12a3561d996818ebefb6741eb86c8	{“tokenIn”:“0xb91159aa527d4769cb9faf3e4adb760c7e8c8ea7”,“amountIn”:“28083857590927208448”,“tokenOut”:“0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2”,“amountOut”:“28690292394258423808”,“destinationIn”:“0xdfe3fa7027e84f59b266459c567278c79fe86f0c”,“destinationOut”:“0x0a2b94f6871c1d7a32fe58e1ab5e6dea2f114e56”}
4305667	true	0x000000000000000000000000000000000000000000000000000000000000004000000000000000000000000000000000000000000000000000000000000001a0000000000000000000000000000000000000000000000000000000000000000a095ea7b3010001ffffffffffc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2e3547335000082ffffffffff33356a9d8bc8207c6ea152f2f3a648dd6f8028a1095ea7b3010003ffffffffffc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2e3547335000084ffffffffff33356a9d8bc8207c6ea152f2f3a648dd6f8028a170a082310105ffffffffff0404c154b66cb340f3ae24111cc767e0184ed00cc6095ea7b3010604ffffffffff04c154b66cb340f3ae24111cc767e0184ed00cc670a082310105ffffffffff05ae7ab96520de3a18e5e111b5eaab095312d7fe84095ea7b3010605ffffffffffae7ab96520de3a18e5e111b5eaab095312d7fe8466e1d1ef000405ffffffff856d5f489a2459c2557043ff17eb7492fc7074bbd824042872000685070708ffff3867be9cc9425e8ed809f314c3df0c1a8be76c6c00000000000000000000000000000000000000000000000000000000000000090000000000000000000000000000000000000000000000000000000000000120000000000000000000000000000000000000000000000000000000000000016000000000000000000000000000000000000000000000000000000000000001a0000000000000000000000000000000000000000000000000000000000000058000000000000000000000000000000000000000000000000000000000000005c00000000000000000000000000000000000000000000000000000000000000b400000000000000000000000000000000000000000000000000000000000000b800000000000000000000000000000000000000000000000000000000000000bc00000000000000000000000000000000000000000000000000000000000000c0000000000000000000000000000000000000000000000000000000000000000200000000000000000000000000000000000001ff3684f28c67538d4d072c227340000000000000000000000000000000000000000000000000000000000000020000000000000000000000000000000000000000000000000b3c11031668c100000000000000000000000000000000000000000000000000000000000000003c000000000000000000000000000000000000000000000000000000000000003842213bc0b0000000000000000000000000d0e364aa7852291883c162b22d6d81f6355428f000000000000000000000000c02aaa39b223fe8d0a0e5c4f27ead9083c756cc2000000000000000000000000000000000000000000000000b3c11031668c10000000000000000000000000000d0e364aa7852291883c162b22d6d81f6355428f00000000000000000000000000000000000000000000000000000000000000a000000000000000000000000000000000000000000000000000000000000002a41fff991f00000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000a0e9d8fd12269c72e4c0931138000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000010000000000000000000000000000000000000000000000000000000000000020000000000000000000000000000000000000000000000000000000000000018422ce6ede000000000000000000000000952d7a7eb2e0804d37d9244be8e47341356d2f5d0000000000000000000000000000000000000000000000000000000000000100000000000000000000000000c02aaa39b223fe8d0a0e5c4f27ead9083c756cc2000000000000000000000000000000000000000000000000b3c11031668c100000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000067b365760000000000000000000000000000000000000000000000000000000000000160000000000000000000000000000000000000000000000000b33204be569cf360000000000000000000000000000000000000000000000000000000000000002cc02aaa39b223fe8d0a0e5c4f27ead9083c756cc20000006404c154b66cb340f3ae24111cc767e0184ed00cc60000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000200000000000000000000000000000000000000000000000005e80029190454800000000000000000000000000000000000000000000000000000000000000056000000000000000000000000000000000000000000000000000000000000005242213bc0b0000000000000000000000000d0e364aa7852291883c162b22d6d81f6355428f000000000000000000000000c02aaa39b223fe8d0a0e5c4f27ead9083c756cc20000000000000000000000000000000000000000000000005e800291904548000000000000000000000000000d0e364aa7852291883c162b22d6d81f6355428f00000000000000000000000000000000000000000000000000000000000000a000000000000000000000000000000000000000000000000000000000000004441fff991f000000000000000000000000952d7a7eb2e0804d37d9244be8e47341356d2f5d000000000000000000000000ae7ab96520de3a18e5e111b5eaab095312d7fe840000000000000000000000000000000000000000000000005e0c5eb29bf618e000000000000000000000000000000000000000000000000000000000000000a0740697dbb9bb615c470d45ff000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000020000000000000000000000000000000000000000000000000000000000000040000000000000000000000000000000000000000000000000000000000000016000000000000000000000000000000000000000000000000000000000000000e4c1fb425e0000000000000000000000000d0e364aa7852291883c162b22d6d81f6355428f000000000000000000000000c02aaa39b223fe8d0a0e5c4f27ead9083c756cc20000000000000000000000000000000000000000000000005e8002919045480000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000067b3657700000000000000000000000000000000000000000000000000000000000000c000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000001e438c9c147000000000000000000000000c02aaa39b223fe8d0a0e5c4f27ead9083c756cc2000000000000000000000000000000000000000000000000000000000000271000000000000000000000000085b78aca6deae198fbf201c82daf6ca21942acc6000000000000000000000000000000000000000000000000000000000000000400000000000000000000000000000000000000000000000000000000000000a0000000000000000000000000000000000000000000000000000000000000010438ed17390000000000000000000000000000000000000000000000005e80029190454800000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000a00000000000000000000000000d0e364aa7852291883c162b22d6d81f6355428f0000000000000000000000000000000000000000000000000000000067b365770000000000000000000000000000000000000000000000000000000000000002000000000000000000000000c02aaa39b223fe8d0a0e5c4f27ead9083c756cc2000000000000000000000000ae7ab96520de3a18e5e111b5eaab095312d7fe84000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000020000000000000000000000000952d7a7eb2e0804d37d9244be8e47341356d2f5d00000000000000000000000000000000000000000000000000000000000000200000000000000000000000006951bdc4734b9f7f3e1b74afebc670c736a0edb60000000000000000000000000000000000000000000000000000000000000020000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000200000000000000000000000000000000000000000000000000000000000000001	3519602	0xdc47c23a	0x0a2b94f6871c1d7a32fe58e1ab5e6dea2f114e56	0x952d7a7eb2e0804d37d9244be8e47341356d2f5d	21867304	0x952d7a7eb2e0804d37d9244be8e47341356d2f5d	2025-02-17T16:31:23.000Z	0xdfd2f74dd79ef19e16d29111a167295e2d09a09e5cf0f1f8fe9086d381289d4d	{“tokenIn”:“0x6951bdc4734b9f7f3e1b74afebc670c736a0edb6”,“amountIn”:“19479398595389153280”,“tokenOut”:“0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2”,“amountOut”:“19765062027756478464”,“destinationIn”:“0xe4433d00cf48bfe0c672d9949f2cd2c008bffc04”,“destinationOut”:“0x0a2b94f6871c1d7a32fe58e1ab5e6dea2f114e56”}
4015174	true	0x000000000000000000000000000000000000000000000000000000000000004000000000000000000000000000000000000000000000000000000000000001a0000000000000000000000000000000000000000000000000000000000000000a095ea7b3010001ffffffffffc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2e3547335000082ffffffffff33356a9d8bc8207c6ea152f2f3a648dd6f8028a1095ea7b3010003ffffffffffc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2e3547335000084ffffffffff33356a9d8bc8207c6ea152f2f3a648dd6f8028a170a082310105ffffffffff0404c154b66cb340f3ae24111cc767e0184ed00cc6095ea7b3010604ffffffffff04c154b66cb340f3ae24111cc767e0184ed00cc670a082310105ffffffffff05ae7ab96520de3a18e5e111b5eaab095312d7fe84095ea7b3010605ffffffffffae7ab96520de3a18e5e111b5eaab095312d7fe8466e1d1ef000405ffffffff856d5f489a2459c2557043ff17eb7492fc7074bbd824042872000685070708ffff3867be9cc9425e8ed809f314c3df0c1a8be76c6c00000000000000000000000000000000000000000000000000000000000000090000000000000000000000000000000000000000000000000000000000000120000000000000000000000000000000000000000000000000000000000000016000000000000000000000000000000000000000000000000000000000000001a0000000000000000000000000000000000000000000000000000000000000058000000000000000000000000000000000000000000000000000000000000005c00000000000000000000000000000000000000000000000000000000000000b400000000000000000000000000000000000000000000000000000000000000b800000000000000000000000000000000000000000000000000000000000000bc00000000000000000000000000000000000000000000000000000000000000c0000000000000000000000000000000000000000000000000000000000000000200000000000000000000000000000000000001ff3684f28c67538d4d072c227340000000000000000000000000000000000000000000000000000000000000020000000000000000000000000000000000000000000000000f015f9d27edb480000000000000000000000000000000000000000000000000000000000000003c000000000000000000000000000000000000000000000000000000000000003842213bc0b0000000000000000000000000d0e364aa7852291883c162b22d6d81f6355428f000000000000000000000000c02aaa39b223fe8d0a0e5c4f27ead9083c756cc2000000000000000000000000000000000000000000000000f015f9d27edb48000000000000000000000000000d0e364aa7852291883c162b22d6d81f6355428f00000000000000000000000000000000000000000000000000000000000000a000000000000000000000000000000000000000000000000000000000000002a41fff991f00000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000a07a34d611a16624cb28a600aa000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000010000000000000000000000000000000000000000000000000000000000000020000000000000000000000000000000000000000000000000000000000000018422ce6ede00000000000000000000000076187c3b976101a4b886b76068ad6b91eec18d9d0000000000000000000000000000000000000000000000000000000000000100000000000000000000000000c02aaa39b223fe8d0a0e5c4f27ead9083c756cc2000000000000000000000000000000000000000000000000f015f9d27edb480000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000067b2fbff0000000000000000000000000000000000000000000000000000000000000160000000000000000000000000000000000000000000000000ef5c62b5995d2040000000000000000000000000000000000000000000000000000000000000002cc02aaa39b223fe8d0a0e5c4f27ead9083c756cc20100006404c154b66cb340f3ae24111cc767e0184ed00cc60000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000200000000000000000000000000000000000000000000000007c4c5854af601400000000000000000000000000000000000000000000000000000000000000056000000000000000000000000000000000000000000000000000000000000005242213bc0b0000000000000000000000000d0e364aa7852291883c162b22d6d81f6355428f000000000000000000000000c02aaa39b223fe8d0a0e5c4f27ead9083c756cc20000000000000000000000000000000000000000000000007c4c5854af6014000000000000000000000000000d0e364aa7852291883c162b22d6d81f6355428f00000000000000000000000000000000000000000000000000000000000000a000000000000000000000000000000000000000000000000000000000000004441fff991f00000000000000000000000076187c3b976101a4b886b76068ad6b91eec18d9d000000000000000000000000ae7ab96520de3a18e5e111b5eaab095312d7fe840000000000000000000000000000000000000000000000007bb43da1d83d60a000000000000000000000000000000000000000000000000000000000000000a080b97492c32942a75aa33896000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000020000000000000000000000000000000000000000000000000000000000000040000000000000000000000000000000000000000000000000000000000000016000000000000000000000000000000000000000000000000000000000000000e4c1fb425e0000000000000000000000000d0e364aa7852291883c162b22d6d81f6355428f000000000000000000000000c02aaa39b223fe8d0a0e5c4f27ead9083c756cc20000000000000000000000000000000000000000000000007c4c5854af60140000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000067b2fc0000000000000000000000000000000000000000000000000000000000000000c000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000001e438c9c147000000000000000000000000c02aaa39b223fe8d0a0e5c4f27ead9083c756cc2000000000000000000000000000000000000000000000000000000000000271000000000000000000000000085b78aca6deae198fbf201c82daf6ca21942acc6000000000000000000000000000000000000000000000000000000000000000400000000000000000000000000000000000000000000000000000000000000a0000000000000000000000000000000000000000000000000000000000000010438ed17390000000000000000000000000000000000000000000000007c4c5854af601400000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000a00000000000000000000000000d0e364aa7852291883c162b22d6d81f6355428f0000000000000000000000000000000000000000000000000000000067b2fc000000000000000000000000000000000000000000000000000000000000000002000000000000000000000000c02aaa39b223fe8d0a0e5c4f27ead9083c756cc2000000000000000000000000ae7ab96520de3a18e5e111b5eaab095312d7fe8400000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000002000000000000000000000000076187c3b976101a4b886b76068ad6b91eec18d9d00000000000000000000000000000000000000000000000000000000000000200000000000000000000000006951bdc4734b9f7f3e1b74afebc670c736a0edb60000000000000000000000000000000000000000000000000000000000000020000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000200000000000000000000000000000000000000000000000000000000000000001	3281252	0xdc47c23a	0x35911af1b570e26f668905595ded133d01cd3e5a	0x76187c3b976101a4b886b76068ad6b91eec18d9d	21865070	0x76187c3b976101a4b886b76068ad6b91eec18d9d	2025-02-17T09:01:23.000Z	0x9f507cc34285636f494214b279f5d2d1503fafc74e16bad36e1dea858f6edc5f	{“tokenIn”:“0x6951bdc4734b9f7f3e1b74afebc670c736a0edb6”,“amountIn”:“25883216884530384896”,“tokenOut”:“0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2”,“amountOut”:“26260578192485130240”,“destinationIn”:“0xe4433d00cf48bfe0c672d9949f2cd2c008bffc04”,“destinationOut”:“0x35911af1b570e26f668905595ded133d01cd3e5a”}

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.tokemak_v2_ethereum.AutopoolETH_flashRebalance_function`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

AutopoolETH_initialize_function

Initialization events for Tokemak v2 Autopool ETH vaults on Ethereum, capturing deployment parameters including vault strategy addresses, name prefixes, and token symbols. Used to track new vault launches and their initial configuration across different ETH liquid staking token (LST) and liquid restaking token (LRT) strategies.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`trace_address`	`STRING`	Hierarchical position of the internal call within a transaction’s execution trace. Comma-separated sequence of integers representing the call path, where each number indicates the index of the call at that nesting level, with null representing top-level calls.
`status`	`BOOL`	Transaction execution outcome indicator. Boolean value where true represents successful execution and false represents failed execution.
`from_address`	`STRING`	Address that initiated the transaction or contract call. Hex-encoded, 0x-prefixed, 42-character string.
`to_address`	`STRING`	Address receiving the transaction or contract call. Hex-encoded, 0x-prefixed, 42-character string.
`value`	`FLOAT64`	Amount of native cryptocurrency sent with the transaction. Floating-point representation in whole units (e.g., ETH, BNB, MATIC).
`gas_used`	`INT64`	Amount of gas consumed by the transaction execution. Integer representing the actual computational steps used.
`gas`	`INT64`	Gas limit allocated for the transaction execution. Integer representing the maximum computational steps allowed.
`signature`	`STRING`	Function selector identifying which contract function was called. 10-character hex string including 0x prefix.
`in_strategy`	`STRING`	Contract address of the strategy or strategy contract being referenced. Hex-encoded, 0x-prefixed, 42-character string.
`in_symbolSuffix`	`STRING`	Token symbol suffix appended during Tokemak Autopool initialization (e.g., ‘autoETH’, ‘balETH_guarded’). Identifies the vault variant and optional modifiers like ‘guarded’ for permissioned pools.
`in_descPrefix`	`STRING`	Human-readable description prefix for the Tokemak autopool being initialized. Combined with `in_symbolSuffix` to form the full vault name identifying the protocol partners and underlying asset (e.g., “Balancer/Tokemak balETH”).
`in_anon3`	`STRING`	Sequential counter tracking the total number of pairs created by the factory contract.

Sample Data

gas	status	gas_used	in_anon3	signature	to_address	in_strategy	block_number	from_address	in_descPrefix	trace_address	block_timestamp	in_symbolSuffix	transaction_hash
1889065	true	433452	0x	0x267eb9ed	0x72cf6d7c85ffd73f18a83989e7ba8c1c30211b73	0xb86723da7d02c91b5e421ed7883c35f732556f13	20212437	0xc8302a79fd249080ee2ba7aae3f914c79edb81dd	Balancer/Tokemak Guarded balETH	10	2024-07-01T15:03:11.000Z	balETH_guarded	0xd25c4c28e44e7c6792ad6a3b435f1ddc00976feb2651dcbede5b5e35b4b5de45
2147200	true	382510	0x	0x267eb9ed	0x6dc3ce9c57b20131347fdc9089d740daf6eb34c5	0xabe104560d0b390309bcf20b73dca335457aa32e	20722909	0x7fed74094b7010c6fb3010ed5efc00772fd2ed1f	Balancer/Tokemak balETH	10	2024-09-10T21:30:59.000Z	balETH	0xb254f901f1c3a9eae581bc03bfd4043da6b3b9d7c8b775e74f885ca99387ccb1
1893840	true	382510	0x	0x267eb9ed	0xe800e3760fc20aa98c5df6a9816147f190455af3	0x72a726c10220280049687e58b7b05fb03d579109	20722910	0x7fed74094b7010c6fb3010ed5efc00772fd2ed1f	Tokemak autoLRT	10	2024-09-10T21:31:11.000Z	autoLRT	0x5cf227be54a41b13ff578cf409e738a53ad1c07037b459158685d8af0d10527c

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.tokemak_v2_ethereum.AutopoolETH_initialize_function`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

AutopoolETH_Initialized_event

Initialization events for Tokemak v2 AutopoolETH vault contracts on Ethereum, capturing when new autopool instances are deployed with their contract addresses and version numbers. Used for tracking the creation and deployment history of Tokemak’s automated liquidity management vaults.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_version`	`INT64`	Version identifier for the contract or event schema. String or integer value indicating the initialization or state version.

Sample Data

address	removed	log_index	in_version	block_number	block_timestamp	transaction_hash
0x49c4719eacc746b87703f964f09c22751f397ba0	false	303	1	20062439	2024-06-10T15:50:59.000Z	0x95ca2feac0491b7a8c7db7d4e90c819d175ad512443e4ac2c9069facaa1ec1e1
0x94a2fa8fd1864be4f675d7617a400e87123b56aa	false	224	1	19883312	2024-05-16T15:04:11.000Z	0xeab7312e605300c6b24eeca9a27b75b5583c0a6567adacbff02cc0273a065868
0x6dc3ce9c57b20131347fdc9089d740daf6eb34c5	false	175	1	20722909	2024-09-10T21:30:59.000Z	0xb254f901f1c3a9eae581bc03bfd4043da6b3b9d7c8b775e74f885ca99387ccb1

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.tokemak_v2_ethereum.AutopoolETH_Initialized_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

AutopoolETH_Nav_event

Net Asset Value (NAV) snapshots for Tokemak v2 AutopoolETH vaults on Ethereum, tracking debt deployed to strategies, idle reserves, and total supply. Used for analyzing vault composition, capital efficiency, and tracking how assets are allocated between active strategies and idle capital.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_idle`	`STRING`	Amount of idle or undeployed capital in the vault. Numeric string representation in smallest token denomination.
`in_debt`	`STRING`	Amount of debt outstanding in the protocol position or vault. Numeric string representation in smallest token denomination.
`in_totalSupply`	`STRING`	Total supply of the pool or vault token after the event. Numeric string representation of token quantity in smallest denomination.

Sample Data

address	in_debt	in_idle	removed	log_index	block_number	in_totalSupply	block_timestamp	transaction_hash
0x72cf6d7c85ffd73f18a83989e7ba8c1c30211b73	80373375080083838957	33836712979437832	false	264	20513084	79910179796200544622	2024-08-12T14:19:35.000Z	0xd5a3f9a879a0842c8447f111a0d1c3bedc4b44cac3926aee9ebed5173031e134
0x49c4719eacc746b87703f964f09c22751f397ba0	35653910989596580147	113698768845587894	false	539	20513083	35522650502650205451	2024-08-12T14:19:23.000Z	0x9e6545dd67acd0ec1e8c2346fb82bea4e5cde36c755ca81b7c9db757972b372b
0xe800e3760fc20aa98c5df6a9816147f190455af3	2832947427989400367507	118549141110564258235	false	449	21062992	2945202959334117950753	2024-10-28T08:39:35.000Z	0xca874454dc470c0f7146a9b1f88288e7989ae970ff89bbd25e466ddb90530e1a

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.tokemak_v2_ethereum.AutopoolETH_Nav_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

AutopoolETH_Paused_event

Pause events from Tokemak v2 AutopoolETH vaults on Ethereum, recording when vault operations were halted by authorized accounts. Tracks emergency stops and operational state changes across different autopool vault addresses.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_account`	`STRING`	Account address involved in the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string.

Sample Data

address	removed	log_index	in_account	block_number	block_timestamp	transaction_hash
0xe800e3760fc20aa98c5df6a9816147f190455af3	false	45	0x127563761083d2ac7794c17d04e17393d8ad9013	23733991	2025-11-05T15:29:11.000Z	0xad92ae016524ecd4d7902c3903969d841bfaf9cd07e89dfd4f6538069d511e8a
0x6dc3ce9c57b20131347fdc9089d740daf6eb34c5	false	44	0x127563761083d2ac7794c17d04e17393d8ad9013	23733991	2025-11-05T15:29:11.000Z	0xad92ae016524ecd4d7902c3903969d841bfaf9cd07e89dfd4f6538069d511e8a
0xe800e3760fc20aa98c5df6a9816147f190455af3	false	66	0x127563761083d2ac7794c17d04e17393d8ad9013	23786115	2025-11-12T22:26:47.000Z	0xe0eef7c34f85221584e06ee5357d90279fbec8010cdece8fd844149daa2e666f

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.tokemak_v2_ethereum.AutopoolETH_Paused_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

AutopoolETH_PeriodicFeeCollected_event

Fee collection events from Tokemak v2 AutopoolETH vaults on Ethereum, recording periodic protocol fees collected in ETH with corresponding vault shares minted to the fee recipient. Used for tracking protocol revenue and fee distribution mechanics across different autopool strategies.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_fees`	`STRING`	Array of fee amounts charged in the transaction. Numeric string representations in smallest token denomination.
`in_feeSink`	`STRING`	Address of the fee sink contract that receives collected fees. Hex-encoded, 0x-prefixed, 42-character string.
`in_mintedShares`	`STRING`	Number of shares minted in the operation. String-encoded integer representing share amounts in the smallest denomination.

Sample Data

address	in_fees	removed	log_index	in_feeSink	block_number	block_timestamp	in_mintedShares	transaction_hash
0x0a2b94f6871c1d7a32fe58e1ab5e6dea2f114e56	204175344730211064	false	298	0x4c0169b48c5a22503f1c3b871b921d55024a5939	20899455	2024-10-05T12:52:23.000Z	203908948462455011	0xaabcfbac4777dda6090c4fa60954617a661ba0c87dd3cf00d30eb69a5a448f9d
0x0a2b94f6871c1d7a32fe58e1ab5e6dea2f114e56	62095556749081775	false	327	0x4c0169b48c5a22503f1c3b871b921d55024a5939	20901521	2024-10-05T19:46:59.000Z	62020037806049632	0xcaead7b24755cc098a29ba019de37366a09f5c735405fc04b7228264e8097404
0x6dc3ce9c57b20131347fdc9089d740daf6eb34c5	101385115624864197	false	454	0x4c0169b48c5a22503f1c3b871b921d55024a5939	20899456	2024-10-05T12:52:35.000Z	101219663914169852	0x9b1f883f8a0a56c275965eb2db23cb9843ff5a920032bc0b224b5cf7cdb0adee

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.tokemak_v2_ethereum.AutopoolETH_PeriodicFeeCollected_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

AutopoolETH_permit_function

EIP-2612 permit function calls on Tokemak v2 AutopoolETH vault, recording gasless approvals where token owners authorize spenders using off-chain signatures (v, r, s). Useful for analyzing meta-transaction patterns and identifying spender contracts interacting with the vault.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`trace_address`	`STRING`	Hierarchical position of the internal call within a transaction’s execution trace. Comma-separated sequence of integers representing the call path, where each number indicates the index of the call at that nesting level, with null representing top-level calls.
`status`	`BOOL`	Transaction execution outcome indicator. Boolean value where true represents successful execution and false represents failed execution.
`from_address`	`STRING`	Address that initiated the transaction or contract call. Hex-encoded, 0x-prefixed, 42-character string.
`to_address`	`STRING`	Address receiving the transaction or contract call. Hex-encoded, 0x-prefixed, 42-character string.
`value`	`FLOAT64`	Amount of native cryptocurrency sent with the transaction. Floating-point representation in whole units (e.g., ETH, BNB, MATIC).
`gas_used`	`INT64`	Amount of gas consumed by the transaction execution. Integer representing the actual computational steps used.
`gas`	`INT64`	Gas limit allocated for the transaction execution. Integer representing the maximum computational steps allowed.
`signature`	`STRING`	Function selector identifying which contract function was called. 10-character hex string including 0x prefix.
`in_owner`	`STRING`	Address that owns or controls the shares or position being deposited or withdrawn. Hex-encoded, 0x-prefixed, 42-character string.
`in_spender`	`STRING`	Address authorized to spend tokens on behalf of the owner. Hex-encoded, 0x-prefixed, 42-character string.
`in_value`	`STRING`	Amount of tokens transferred, minted, or burned in the operation. Numeric string representation preserving precision for large integer values.
`in_deadline`	`STRING`	Timestamp after which the transaction or operation becomes invalid and will revert. Unix timestamp in seconds.
`in_v`	`INT64`	ECDSA signature component v used for cryptographic verification of signed messages or permits. Integer value representing the recovery identifier, typically 27 or 28.
`in_r`	`STRING`	ECDSA signature component r used for cryptographic verification of signed messages or permits. 66-character hex string including 0x prefix.
`in_s`	`STRING`	ECDSA signature component s used for cryptographic verification of signed messages or permits. 66-character hex string including 0x prefix.

Sample Data

gas	in_r	in_s	in_v	status	gas_used	in_owner	in_value	signature	in_spender	to_address	in_deadline	block_number	from_address	block_timestamp	transaction_hash
375240	0xcd0bbd138b1e4bc206d4c267c67718cc1db5bb6a87db2a43f56cfda0a96fa422	0x73bd4d468f20819d7e32ba0d872d46247bb57aeb8ec1855c050bd58d3ebf7a59	28	true	58976	0x14003545e8e49268125b279c1c50cd4586c69e31	192185752543593647519	0xd505accf	0x37dd409f5e98ab4f151f4259ea0cc13e97e8ae21	0x0a2b94f6871c1d7a32fe58e1ab5e6dea2f114e56	1748806654	22611906	0x37dd409f5e98ab4f151f4259ea0cc13e97e8ae21	2025-06-01T19:23:47.000Z	0x920ca4fe7c6c0a0d5af31fc21efc8ea3fe45a1dd9078b08598c752062cd8947c
325412	0xd43271888edee65811d07ad58c3769ef010a982884b26fcb35eea6d87b973955	0x01674a03dbf3b1a22e75c8167c668a1331e6cb0ee4f39e022d3f4d98f328d352	27	true	41876	0xffc7ff21f6212c82eb0c3c87bc901eebce1a7f7a	47059381429133122363	0xd505accf	0x37dd409f5e98ab4f151f4259ea0cc13e97e8ae21	0x0a2b94f6871c1d7a32fe58e1ab5e6dea2f114e56	1748807849	22612003	0x37dd409f5e98ab4f151f4259ea0cc13e97e8ae21	2025-06-01T19:43:11.000Z	0x7abaf12549e950fbc9d357df04d4ac2dcaa666d9850d04246ea72aa610f0d3a5
255787	0x5139c3c92e9d28e68454cecf41991a44e8ce53dd721babcd568299abe3c83112	0x2574ca679d8cbde3ce8088110a0dac8dd7cd868867d896c451eb8a2e1709a129	27	true	58976	0xd5eab065622099a25a9001d0a5ae22c20ffec960	81145533459794437000	0xd505accf	0x37dd409f5e98ab4f151f4259ea0cc13e97e8ae21	0x0a2b94f6871c1d7a32fe58e1ab5e6dea2f114e56	1748788618	22610413	0x37dd409f5e98ab4f151f4259ea0cc13e97e8ae21	2025-06-01T14:22:11.000Z	0xecc40e081d5bc454a7d124d9074ad7b5a910e713e8cd5207c8ed4d3a9d99295d

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.tokemak_v2_ethereum.AutopoolETH_permit_function`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

AutopoolETH_recover_function

Token recovery transactions from Tokemak v2’s AutopoolETH contract on Ethereum, capturing administrative rescue operations for stuck or misplaced ERC-20 tokens with destination addresses and amounts.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`trace_address`	`STRING`	Hierarchical position of the internal call within a transaction’s execution trace. Comma-separated sequence of integers representing the call path, where each number indicates the index of the call at that nesting level, with null representing top-level calls.
`status`	`BOOL`	Transaction execution outcome indicator. Boolean value where true represents successful execution and false represents failed execution.
`from_address`	`STRING`	Address that initiated the transaction or contract call. Hex-encoded, 0x-prefixed, 42-character string.
`to_address`	`STRING`	Address receiving the transaction or contract call. Hex-encoded, 0x-prefixed, 42-character string.
`value`	`FLOAT64`	Amount of native cryptocurrency sent with the transaction. Floating-point representation in whole units (e.g., ETH, BNB, MATIC).
`gas_used`	`INT64`	Amount of gas consumed by the transaction execution. Integer representing the actual computational steps used.
`gas`	`INT64`	Gas limit allocated for the transaction execution. Integer representing the maximum computational steps allowed.
`signature`	`STRING`	Function selector identifying which contract function was called. 10-character hex string including 0x prefix.
`in_tokens`	`ARRAY<STRING>`	Array of token contract addresses involved in the operation. Hex-encoded, 0x-prefixed, 42-character strings.
`in_amounts`	`ARRAY<STRING>`	Array of token amounts involved in the operation. String-encoded integers representing amounts in the token’s smallest unit (e.g., wei for ETH).
`in_destinations`	`ARRAY<STRING>`	Array of destination addresses for token transfers or operations. Hex-encoded, 0x-prefixed, 42-character strings.

Sample Data

gas	value	status	gas_used	in_tokens	signature	in_amounts	to_address	block_number	from_address	trace_address	block_timestamp	in_destinations	transaction_hash
2094183	0	true	140660	[“0xf9779aef9f77e78c857cb4a068c65ccbee25baac”]	0xbef893e8	[“130000000000000000”]	0xe800e3760fc20aa98c5df6a9816147f190455af3	23798111	0xa9900b2d550c406d1cf58da27228feeef21d447b	0,6,10	2025-11-14T14:45:35.000Z	[“0xa9900b2d550c406d1cf58da27228feeef21d447b”]	0x577b0ed37be57983e218d3c58831405ba65fe1012dc2363f4f8b4521dec75c1b

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.tokemak_v2_ethereum.AutopoolETH_recover_function`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

AutopoolETH_redeem_function

Redemption transactions from Tokemak v2 AutopoolETH vault on Ethereum, recording conversions of vault shares back to underlying ETH assets. Used to analyze withdrawal patterns, share-to-asset exchange rates, and liquidity provider exit behavior.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`trace_address`	`STRING`	Hierarchical position of the internal call within a transaction’s execution trace. Comma-separated sequence of integers representing the call path, where each number indicates the index of the call at that nesting level, with null representing top-level calls.
`status`	`BOOL`	Transaction execution outcome indicator. Boolean value where true represents successful execution and false represents failed execution.
`from_address`	`STRING`	Address that initiated the transaction or contract call. Hex-encoded, 0x-prefixed, 42-character string.
`to_address`	`STRING`	Address receiving the transaction or contract call. Hex-encoded, 0x-prefixed, 42-character string.
`value`	`FLOAT64`	Amount of native cryptocurrency sent with the transaction. Floating-point representation in whole units (e.g., ETH, BNB, MATIC).
`gas_used`	`INT64`	Amount of gas consumed by the transaction execution. Integer representing the actual computational steps used.
`gas`	`INT64`	Gas limit allocated for the transaction execution. Integer representing the maximum computational steps allowed.
`signature`	`STRING`	Function selector identifying which contract function was called. 10-character hex string including 0x prefix.
`in_shares`	`STRING`	Number of shares involved in the deposit or withdrawal transaction. String-encoded integer representing the share quantity in the protocol’s accounting system.
`in_receiver`	`STRING`	Address that receives tokens, assets, or rewards from the transaction. Hex-encoded, 0x-prefixed, 42-character string.
`in_owner`	`STRING`	Address that owns or controls the shares or position being deposited or withdrawn. Hex-encoded, 0x-prefixed, 42-character string.
`out_assets`	`STRING`	Amount of underlying assets returned from redeeming shares. String-encoded integer representing token quantity in the token’s smallest unit.

Sample Data

gas	status	gas_used	in_owner	in_shares	signature	out_assets	to_address	in_receiver	block_number	from_address	trace_address	block_timestamp	transaction_hash
423049	true	97808	0x4c0169b48c5a22503f1c3b871b921d55024a5939	335934519336195	0xba087652	352755295439671	0xe800e3760fc20aa98c5df6a9816147f190455af3	0xd1057b6c6736bf4f5b4a850cff02054f1f38e581	23651956	0xd1057b6c6736bf4f5b4a850cff02054f1f38e581	9	2025-10-25T04:01:23.000Z	0x4c400cbdeaf4d32a8fc1aed3c182bfe2c1fbf9d5be990a19e86fdc7517921d30
531554	true	97808	0x4c0169b48c5a22503f1c3b871b921d55024a5939	786262402022089	0xba087652	823888400553545	0x6dc3ce9c57b20131347fdc9089d740daf6eb34c5	0xd1057b6c6736bf4f5b4a850cff02054f1f38e581	23651956	0xd1057b6c6736bf4f5b4a850cff02054f1f38e581	7	2025-10-25T04:01:23.000Z	0x4c400cbdeaf4d32a8fc1aed3c182bfe2c1fbf9d5be990a19e86fdc7517921d30
685677	true	150708	0x4c0169b48c5a22503f1c3b871b921d55024a5939	24129832426085645	0xba087652	24454403473268157	0x35911af1b570e26f668905595ded133d01cd3e5a	0xd1057b6c6736bf4f5b4a850cff02054f1f38e581	23651956	0xd1057b6c6736bf4f5b4a850cff02054f1f38e581	5	2025-10-25T04:01:23.000Z	0x4c400cbdeaf4d32a8fc1aed3c182bfe2c1fbf9d5be990a19e86fdc7517921d30

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.tokemak_v2_ethereum.AutopoolETH_redeem_function`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

AutopoolETH_RemovedFromRemovalQueue_event

Events tracking destinations removed from Tokemak v2 AutopoolETH withdrawal queues on Ethereum. Records autopool addresses, destination vault addresses, and removal status for analyzing liquidity rebalancing operations.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_destination`	`STRING`	Target address receiving tokens, funds, or messages in the operation. Hex-encoded, 0x-prefixed, 42-character string.

Sample Data

address	removed	log_index	block_number	in_destination	block_timestamp	transaction_hash
0x0a2b94f6871c1d7a32fe58e1ab5e6dea2f114e56	false	422	20956721	0xc001f23397db71b17602ce7d90a983edc38db0d1	2024-10-13T12:42:47.000Z	0xfb52528e64cd15f018911a03a128181c68f8999dfd0aa00a41b539ea79c593bb
0x0a2b94f6871c1d7a32fe58e1ab5e6dea2f114e56	false	75	20959478	0xfb6f99fdf12e37bfe3c4cf81067fab10c465fb24	2024-10-13T21:56:35.000Z	0x5a088e71e51c5b8c05db282989f21975d14e44d9c615aa00e451a68dcbebd0dc
0x6dc3ce9c57b20131347fdc9089d740daf6eb34c5	false	172	20959478	0xfb6f99fdf12e37bfe3c4cf81067fab10c465fb24	2024-10-13T21:56:35.000Z	0x5a088e71e51c5b8c05db282989f21975d14e44d9c615aa00e451a68dcbebd0dc

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.tokemak_v2_ethereum.AutopoolETH_RemovedFromRemovalQueue_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

AutopoolETH_RewarderSet_event

Rewarder contract assignment events for Tokemak v2 AutopoolETH vaults on Ethereum, tracking when reward distribution contracts are updated or initially set. Records transitions from old to new rewarder addresses for analyzing vault reward mechanism changes.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_newRewarder`	`STRING`	Contract address of the new rewarder being set for the Tokemak V2 autopool. Hex-encoded, 0x-prefixed 40-character string; transitions from zero address (0x00…00) indicate initial rewarder assignments.
`in_oldRewarder`	`STRING`	Contract address of the previous rewarder contract associated with the Tokemak v2 autopool. Typically the zero address (0x00…00) during initial rewarder setup, indicating no prior rewarder was configured.

Sample Data

address	removed	log_index	block_number	in_newRewarder	in_oldRewarder	block_timestamp	transaction_hash
0x72cf6d7c85ffd73f18a83989e7ba8c1c30211b73	false	127	20212437	0x012eb837926099eb1577e6e6f660a33418501665	0x0000000000000000000000000000000000000000	2024-07-01T15:03:11.000Z	0xd25c4c28e44e7c6792ad6a3b435f1ddc00976feb2651dcbede5b5e35b4b5de45
0xf0ef0dfcd5a39afafb51ca0c0024a49d67cd8c68	false	228	19911807	0x00382e2e4642fb0c8a112eb9c25fce55f10c0348	0x0000000000000000000000000000000000000000	2024-05-20T14:42:59.000Z	0xe61724a8f5a9ac4637fb0c67b1efb19b0da82c99c52b950caf62277f1e48cf8b
0x49c4719eacc746b87703f964f09c22751f397ba0	false	304	20062439	0x8d6556fbd44113a3d2d8fdd49eaf47e46aefb9be	0x0000000000000000000000000000000000000000	2024-06-10T15:50:59.000Z	0x95ca2feac0491b7a8c7db7d4e90c819d175ad512443e4ac2c9069facaa1ec1e1

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.tokemak_v2_ethereum.AutopoolETH_RewarderSet_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

AutopoolETH_Shutdown_event

Shutdown events for Tokemak v2 AutopoolETH vaults on Ethereum, recording when liquidity pools were deactivated with reason codes. Used to track protocol vault lifecycle and analyze shutdown patterns across different pool addresses.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_reason`	`INT64`	Enumerated code indicating the cause or category of the operation or state change. Non-negative integer value representing different reason types defined by the protocol.

Sample Data

address	removed	in_reason	log_index	block_number	block_timestamp	transaction_hash
0x49c4719eacc746b87703f964f09c22751f397ba0	false	1	88	20885860	2024-10-03T15:23:59.000Z	0x17c329f073e1f1bafa224037f882d1da608e0600fda1ebf147c5e66ab6992124
0x72cf6d7c85ffd73f18a83989e7ba8c1c30211b73	false	1	251	20885858	2024-10-03T15:23:35.000Z	0x9f6683d61917188ccf87d2cef68bbd18b438a0482156cf555dc7468535bb1167
0x52f0d57fb5d4780a37164f918746f9bd51c684a3	false	1	127	23877360	2025-11-25T17:43:11.000Z	0x6248ee1884113edd9160582ec02725a5e5385dabd2eca1ae36b0710265353f15

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.tokemak_v2_ethereum.AutopoolETH_Shutdown_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

AutopoolETH_StreamingFeeSet_event

Fee configuration events from Tokemak v2 AutopoolETH vaults on Ethereum, recording streaming fee parameter changes in basis points. Used for tracking fee adjustments across different autopool vault addresses and analyzing protocol fee economics.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_newFee`	`STRING`	Updated liquidation protocol fee. Numeric string representing basis points where 1000 equals 10%.

Sample Data

address	removed	in_newFee	log_index	block_number	block_timestamp	transaction_hash
0xe800e3760fc20aa98c5df6a9816147f190455af3	false	2000	501	20744441	2024-09-13T21:41:11.000Z	0x70b367e44cedb97aade65ff74761f2d2e476a25d08dec18611a13787cb203908
0x6dc3ce9c57b20131347fdc9089d740daf6eb34c5	false	2000	417	20744447	2024-09-13T21:42:23.000Z	0xe3275a3d824100d4a3bb2e6830dd09cffb9ea4fb791ab7ebb1bedc161eedf0d9
0x0a2b94f6871c1d7a32fe58e1ab5e6dea2f114e56	false	2000	375	20744434	2024-09-13T21:39:47.000Z	0x4c4b88a9fd93357482925bcccd64e275952cb40d535b5f7c9e21dd9863f3999e

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.tokemak_v2_ethereum.AutopoolETH_StreamingFeeSet_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

AutopoolETH_SymbolAndDescSet_event

No description available.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_symbol`	`STRING`	Symbol of the token involved in the transaction or event.
`in_desc`	`STRING`	Swap operation parameters struct containing source and destination token addresses, receiver addresses, token amounts, minimum return amount, execution flags, and permit signature data.

Sample Data

No sample data available.

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.tokemak_v2_ethereum.AutopoolETH_SymbolAndDescSet_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

AutopoolETH_TokensPulled_event

No description available.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_tokens`	`ARRAY<STRING>`	Array of token contract addresses involved in the operation. Hex-encoded, 0x-prefixed, 42-character strings.
`in_amounts`	`ARRAY<STRING>`	Array of token amounts involved in the operation. String-encoded integers representing amounts in the token’s smallest unit (e.g., wei for ETH).
`in_destinations`	`ARRAY<STRING>`	Array of destination addresses for token transfers or operations. Hex-encoded, 0x-prefixed, 42-character strings.

Sample Data

No sample data available.

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.tokemak_v2_ethereum.AutopoolETH_TokensPulled_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

AutopoolETH_TokensRecovered_event

Token recovery events from Tokemak v2 AutopoolETH vault on Ethereum, tracking transfers of mistakenly sent or stuck tokens back to designated destinations. Used for monitoring vault security operations and accidental token deposit recovery.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_tokens`	`ARRAY<STRING>`	Array of token contract addresses involved in the operation. Hex-encoded, 0x-prefixed, 42-character strings.
`in_amounts`	`ARRAY<STRING>`	Array of token amounts involved in the operation. String-encoded integers representing amounts in the token’s smallest unit (e.g., wei for ETH).
`in_destinations`	`ARRAY<STRING>`	Array of destination addresses for token transfers or operations. Hex-encoded, 0x-prefixed, 42-character strings.

Sample Data

address	removed	in_tokens	log_index	in_amounts	block_number	block_timestamp	in_destinations	transaction_hash
0xe800e3760fc20aa98c5df6a9816147f190455af3	false	[“0xf9779aef9f77e78c857cb4a068c65ccbee25baac”]	68	[“130000000000000000”]	23798111	2025-11-14T14:45:35.000Z	[“0xa9900b2d550c406d1cf58da27228feeef21d447b”]	0x577b0ed37be57983e218d3c58831405ba65fe1012dc2363f4f8b4521dec75c1b

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.tokemak_v2_ethereum.AutopoolETH_TokensRecovered_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

AutopoolETH_Transfer_event

Transfer events for Tokemak v2 Autopool ETH vault tokens on Ethereum, tracking mints (from zero address), burns (to zero address), and transfers between addresses. Used for analyzing vault share flows, liquidity provider positions, and deposit/withdrawal activity.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_from`	`STRING`	Address originating the transfer or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_to`	`STRING`	Destination address receiving tokens or assets in the operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_value`	`STRING`	Amount of tokens transferred, minted, or burned in the operation. Numeric string representation preserving precision for large integer values.

Sample Data

in_to	address	in_from	removed	in_value	log_index	block_number	block_timestamp	transaction_hash
0x0000000000000000000000000000000000000000	0x49c4719eacc746b87703f964f09c22751f397ba0	0x49c4719eacc746b87703f964f09c22751f397ba0	false	852859572199056	281	20291119	2024-07-12T14:48:23.000Z	0x45219efd9a3871851fd7ee2da600d61e981eb81903e28e8562dada23f5a8a19c
0x49c4719eacc746b87703f964f09c22751f397ba0	0x49c4719eacc746b87703f964f09c22751f397ba0	0x0000000000000000000000000000000000000000	false	4368094291566554	285	20291119	2024-07-12T14:48:23.000Z	0x45219efd9a3871851fd7ee2da600d61e981eb81903e28e8562dada23f5a8a19c
0x4c0169b48c5a22503f1c3b871b921d55024a5939	0x0a2b94f6871c1d7a32fe58e1ab5e6dea2f114e56	0x0000000000000000000000000000000000000000	false	74504667624614235	393	21069102	2024-10-29T05:07:47.000Z	0xdd97a7e72357e960fc453ace7c3ad326e5e271d0def1b430dfc6e51515d4794a

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.tokemak_v2_ethereum.AutopoolETH_Transfer_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

AutopoolETH_Unpaused_event

Unpaused events from Tokemak v2 AutopoolETH vaults on Ethereum, recording when contract functionality is re-enabled after being paused. Tracks administrative actions with the account that triggered the unpause for monitoring vault operational status.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_account`	`STRING`	Account address involved in the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string.

Sample Data

address	removed	log_index	in_account	block_number	block_timestamp	transaction_hash
0xe800e3760fc20aa98c5df6a9816147f190455af3	false	238	0x127563761083d2ac7794c17d04e17393d8ad9013	23785647	2025-11-12T20:52:23.000Z	0x66d65b6e402a221af010c40f4926953cfc29b8b0c1dc628f32cf767b70961398
0xe800e3760fc20aa98c5df6a9816147f190455af3	false	67	0xa9900b2d550c406d1cf58da27228feeef21d447b	23798111	2025-11-14T14:45:35.000Z	0x577b0ed37be57983e218d3c58831405ba65fe1012dc2363f4f8b4521dec75c1b
0xe800e3760fc20aa98c5df6a9816147f190455af3	false	372	0x127563761083d2ac7794c17d04e17393d8ad9013	23822108	2025-11-17T23:20:23.000Z	0x66a44e119411bff967dff37d0b52f7705640044aeb469bd5399a9323655a6b96

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.tokemak_v2_ethereum.AutopoolETH_Unpaused_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

AutopoolETH_Withdraw_event

Withdrawal events from Tokemak v2 Autopool ETH vaults on Ethereum, recording shares burned, assets received, and participant addresses. Used for tracking vault redemptions and analyzing liquidity provider exit activity.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_sender`	`STRING`	Address that initiated the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_receiver`	`STRING`	Address that receives tokens, assets, or rewards from the transaction. Hex-encoded, 0x-prefixed, 42-character string.
`in_owner`	`STRING`	Address that owns or controls the shares or position being deposited or withdrawn. Hex-encoded, 0x-prefixed, 42-character string.
`in_assets`	`STRING`	Number of asset units involved in the deposit or withdrawal transaction. String-encoded integer representing the asset quantity in the protocol’s accounting system.
`in_shares`	`STRING`	Number of shares involved in the deposit or withdrawal transaction. String-encoded integer representing the share quantity in the protocol’s accounting system.

Sample Data

address	removed	in_owner	in_assets	in_sender	in_shares	log_index	in_receiver	block_number	block_timestamp	transaction_hash
0x0a2b94f6871c1d7a32fe58e1ab5e6dea2f114e56	false	0xece29c59c308114ef903747a1ba7f65e28ba8c26	1001881027449649630	0xc45e939ca8c43822a2a233404ecf420712084c30	1000803649737633610	246	0xc45e939ca8c43822a2a233404ecf420712084c30	20945432	2024-10-11T22:43:35.000Z	0xffbce3bbd386017ba02a56abc9a46881e608873b77be56643ce6224bb4b683c2
0x0a2b94f6871c1d7a32fe58e1ab5e6dea2f114e56	false	0x39fa83042aff7e8e506730b4c8b1abe8ed6e0469	5005839485884027299	0xc45e939ca8c43822a2a233404ecf420712084c30	5000366485470639074	443	0xc45e939ca8c43822a2a233404ecf420712084c30	20940877	2024-10-11T07:25:59.000Z	0xbb0ed40c008eecab2900626e4b71e3d1a0191d3537fd6e6ae205cb1be1869b1c
0x0a2b94f6871c1d7a32fe58e1ab5e6dea2f114e56	false	0x4567aae2cf7fded860130e0fb2546b60d3b9b605	286644028428248943	0xc45e939ca8c43822a2a233404ecf420712084c30	286330760315899765	248	0xc45e939ca8c43822a2a233404ecf420712084c30	20940214	2024-10-11T05:12:35.000Z	0x261ca773b9c0116008b1958136c5f960964c79fc3aad9ee2a553e0bbb67b90b2

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.tokemak_v2_ethereum.AutopoolETH_Withdraw_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

AutopoolETH_withdraw_function

Withdraw function call records from Tokemak v2 AutopoolETH vault on Ethereum, capturing user redemptions of vault shares for underlying ETH assets. Tracks share burning amounts, asset outputs, and ownership transfers for analyzing liquidity provider exit behavior.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`trace_address`	`STRING`	Hierarchical position of the internal call within a transaction’s execution trace. Comma-separated sequence of integers representing the call path, where each number indicates the index of the call at that nesting level, with null representing top-level calls.
`status`	`BOOL`	Transaction execution outcome indicator. Boolean value where true represents successful execution and false represents failed execution.
`from_address`	`STRING`	Address that initiated the transaction or contract call. Hex-encoded, 0x-prefixed, 42-character string.
`to_address`	`STRING`	Address receiving the transaction or contract call. Hex-encoded, 0x-prefixed, 42-character string.
`value`	`FLOAT64`	Amount of native cryptocurrency sent with the transaction. Floating-point representation in whole units (e.g., ETH, BNB, MATIC).
`gas_used`	`INT64`	Amount of gas consumed by the transaction execution. Integer representing the actual computational steps used.
`gas`	`INT64`	Gas limit allocated for the transaction execution. Integer representing the maximum computational steps allowed.
`signature`	`STRING`	Function selector identifying which contract function was called. 10-character hex string including 0x prefix.
`in_assets`	`STRING`	Number of asset units involved in the deposit or withdrawal transaction. String-encoded integer representing the asset quantity in the protocol’s accounting system.
`in_receiver`	`STRING`	Address that receives tokens, assets, or rewards from the transaction. Hex-encoded, 0x-prefixed, 42-character string.
`in_owner`	`STRING`	Address that owns or controls the shares or position being deposited or withdrawn. Hex-encoded, 0x-prefixed, 42-character string.
`out_shares`	`STRING`	Number of shares issued or burned as a result of the transaction. String-encoded integer representing the share quantity in the protocol’s accounting system.

Sample Data

gas	status	gas_used	in_owner	in_assets	signature	out_shares	to_address	in_receiver	block_number	from_address	trace_address	block_timestamp	transaction_hash
2165029	true	1379216	0x0000000f2eb9f69274678c76222b35eec7588a65	394518694744	0xb460af94	389999880192206769315724	0xa7569a44f348d3d70d8ad5889e50f78e33d80d35	0x0000000f2eb9f69274678c76222b35eec7588a65	22683752	0x0000000f2eb9f69274678c76222b35eec7588a65	0,1,0,2	2025-06-11T20:37:59.000Z	0xa226b07f65c80a01c2f5c091f49afa4d43af6eda90ea9c0a17edbf2ddc20e1dc
4010930	true	2572963	0x3a43aec53490cb9fa922847385d82fe25d0e9de7	115048370555154447381	0xb460af94	112864686555812602031	0x35911af1b570e26f668905595ded133d01cd3e5a	0x3a43aec53490cb9fa922847385d82fe25d0e9de7	22769978	0x3a43aec53490cb9fa922847385d82fe25d0e9de7	0,0,0,2	2025-06-23T22:01:47.000Z	0xc27c240faabcc3e153aaada433f7c37250c8af0c566fae45e10c7422dbd8905f
245101	true	141517	0x3a43aec53490cb9fa922847385d82fe25d0e9de7	207154727400000000	0xb460af94	206347474966731473	0x35911af1b570e26f668905595ded133d01cd3e5a	0x3a43aec53490cb9fa922847385d82fe25d0e9de7	21940125	0x3a43aec53490cb9fa922847385d82fe25d0e9de7	0,2	2025-02-27T20:40:23.000Z	0x1f0b32b9aabaf14ba0d78d8ebe7ba0dbc60191f1caef541a437d043addaf34f0

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.tokemak_v2_ethereum.AutopoolETH_withdraw_function`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

AutopoolETH_WithdrawalQueueSet_event

No description available.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_destinations`	`ARRAY<STRING>`	Array of destination addresses for token transfers or operations. Hex-encoded, 0x-prefixed, 42-character strings.

Sample Data

No sample data available.

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.tokemak_v2_ethereum.AutopoolETH_WithdrawalQueueSet_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

AutopoolRegistry_VaultAdded_event

Event log of Autopool vault registrations in Tokemak v2 on Ethereum, capturing when new vaults are added to the registry with their underlying asset. Used for tracking vault deployment and registry management over time.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_asset`	`STRING`	Contract address of the asset or token. Hex-encoded, 0x-prefixed, 42-character string.
`in_vault`	`STRING`	Contract address of the vault. Hex-encoded, 0x-prefixed, 42-character string.

Sample Data

address	removed	in_asset	in_vault	log_index	block_number	block_timestamp	transaction_hash
0xd1ff8fd78f067ea2719730f5ca38d6da0bbd46c2	false	0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2	0x72cf6d7c85ffd73f18a83989e7ba8c1c30211b73	129	20212437	2024-07-01T15:03:11.000Z	0xd25c4c28e44e7c6792ad6a3b435f1ddc00976feb2651dcbede5b5e35b4b5de45
0xd1ff8fd78f067ea2719730f5ca38d6da0bbd46c2	false	0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2	0xf0ef0dfcd5a39afafb51ca0c0024a49d67cd8c68	230	19911807	2024-05-20T14:42:59.000Z	0xe61724a8f5a9ac4637fb0c67b1efb19b0da82c99c52b950caf62277f1e48cf8b
0x7e5828a3a6ae75426d739e798140513a2e2964e4	false	0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2	0x0a2b94f6871c1d7a32fe58e1ab5e6dea2f114e56	200	20722908	2024-09-10T21:30:47.000Z	0xc0a5ede7afe986e0fbb6d95afb742613b3a7330c52a75fd4212f73871a5d2213

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.tokemak_v2_ethereum.AutopoolRegistry_VaultAdded_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

LMPVault_Deposit_event

Deposit events from Tokemak v2 Liquidity Marketplace (LMP) Vaults on Ethereum, capturing user deposits with asset amounts and corresponding vault shares minted. Used for tracking vault inflows, share price analysis, and depositor behavior in Tokemak’s automated liquidity management system.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_sender`	`STRING`	Address that initiated the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_owner`	`STRING`	Address that owns or controls the shares or position being deposited or withdrawn. Hex-encoded, 0x-prefixed, 42-character string.
`in_assets`	`STRING`	Number of asset units involved in the deposit or withdrawal transaction. String-encoded integer representing the asset quantity in the protocol’s accounting system.
`in_shares`	`STRING`	Number of shares involved in the deposit or withdrawal transaction. String-encoded integer representing the share quantity in the protocol’s accounting system.

Sample Data

address	removed	in_owner	in_assets	in_sender	in_shares	log_index	block_number	block_timestamp	transaction_hash
0x57fa6bb127a428fe268104ab4d170fe4a99b73b6	false	0x804986f81826034f7753484b936a634c706f1adf	2700000000000000000	0x804986f81826034f7753484b936a634c706f1adf	2695393629642281057	43	19526921	2024-03-27T16:49:59.000Z	0x8cb72dbe9083b663c3089de92a57c1f453c8ccb86dd6b83019c17acabf7dc7a9
0x57fa6bb127a428fe268104ab4d170fe4a99b73b6	false	0x804986f81826034f7753484b936a634c706f1adf	400000000000000000	0x804986f81826034f7753484b936a634c706f1adf	400823005373682868	68	19443009	2024-03-15T21:25:47.000Z	0x44b1bc3d63541917820928a4a499313fe03a1ff3b28185fa09be6549bba4ca5d
0x57fa6bb127a428fe268104ab4d170fe4a99b73b6	false	0x804986f81826034f7753484b936a634c706f1adf	5000000000000000000	0x804986f81826034f7753484b936a634c706f1adf	5010287567171035851	58	19443023	2024-03-15T21:28:35.000Z	0x4fb46110874e19b05de9ddf623afb9228d695358b9a6a7203037e5ae6551488b

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.tokemak_v2_ethereum.LMPVault_Deposit_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

LMPVault_deposit_function

Deposit function calls into Tokemak v2 LMP (Liquidity Management Platform) Vaults on Ethereum, recording asset amounts deposited and vault shares minted to receivers. Used for analyzing vault inflows, share-to-asset ratios, and depositor behavior across Tokemak’s automated liquidity management protocol.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`trace_address`	`STRING`	Hierarchical position of the internal call within a transaction’s execution trace. Comma-separated sequence of integers representing the call path, where each number indicates the index of the call at that nesting level, with null representing top-level calls.
`status`	`BOOL`	Transaction execution outcome indicator. Boolean value where true represents successful execution and false represents failed execution.
`from_address`	`STRING`	Address that initiated the transaction or contract call. Hex-encoded, 0x-prefixed, 42-character string.
`to_address`	`STRING`	Address receiving the transaction or contract call. Hex-encoded, 0x-prefixed, 42-character string.
`value`	`FLOAT64`	Amount of native cryptocurrency sent with the transaction. Floating-point representation in whole units (e.g., ETH, BNB, MATIC).
`gas_used`	`INT64`	Amount of gas consumed by the transaction execution. Integer representing the actual computational steps used.
`gas`	`INT64`	Gas limit allocated for the transaction execution. Integer representing the maximum computational steps allowed.
`signature`	`STRING`	Function selector identifying which contract function was called. 10-character hex string including 0x prefix.
`in_assets`	`STRING`	Number of asset units involved in the deposit or withdrawal transaction. String-encoded integer representing the asset quantity in the protocol’s accounting system.
`in_receiver`	`STRING`	Address that receives tokens, assets, or rewards from the transaction. Hex-encoded, 0x-prefixed, 42-character string.
`out_shares`	`STRING`	Number of shares issued or burned as a result of the transaction. String-encoded integer representing the share quantity in the protocol’s accounting system.

Sample Data

gas	status	gas_used	in_assets	signature	out_shares	to_address	in_receiver	block_number	from_address	block_timestamp	transaction_hash
301100	true	217992	15500000000000000000	0x6e553f65	15500000000000000000	0x57fa6bb127a428fe268104ab4d170fe4a99b73b6	0xa6364f394616dd9238b284cff97cd7146c57808d	19392342	0xa6364f394616dd9238b284cff97cd7146c57808d	2024-03-08T18:49:35.000Z	0xb5aeb13d209ca389529484cfe62e59fba79d4532343abc8c14945a0b1f1600b1
618499	true	447783	2700000000000000000	0x6e553f65	2629213498456078979	0x57fa6bb127a428fe268104ab4d170fe4a99b73b6	0x804986f81826034f7753484b936a634c706f1adf	19477765	0x804986f81826034f7753484b936a634c706f1adf	2024-03-20T18:42:35.000Z	0x5a3f1c7e356f1f0f352607a0abbc84301ba2b184fef256204cf2a7d8624cf7b3
211634	true	153220	2100000000000000000	0x6e553f65	2095123750328921141	0x57fa6bb127a428fe268104ab4d170fe4a99b73b6	0x804986f81826034f7753484b936a634c706f1adf	19726297	0x804986f81826034f7753484b936a634c706f1adf	2024-04-24T16:03:11.000Z	0x1ebc73e6952e4ea3d8596366b46138bde1e6015e1a170f198a919db259397a11

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.tokemak_v2_ethereum.LMPVault_deposit_function`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

LMPVault_DestinationDebtReporting_event

No description available.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_destination`	`STRING`	Target address receiving tokens, funds, or messages in the operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_debtValue`	`STRING`	-
`in_claimed`	`STRING`	Amount of tokens or rewards claimed in the transaction. String-encoded integer representing the claimed value in smallest token units.
`in_claimGasUsed`	`STRING`	-

Sample Data

No sample data available.

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.tokemak_v2_ethereum.LMPVault_DestinationDebtReporting_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

LMPVault_DestinationVaultAdded_event

Event logs tracking destination vault additions and removals in Tokemak v2 Liquidity Marketplace (LMP) vaults on Ethereum. Used to monitor vault composition changes and analyze capital allocation strategies across destination vaults.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_destination`	`STRING`	Target address receiving tokens, funds, or messages in the operation. Hex-encoded, 0x-prefixed, 42-character string.

Sample Data

address	removed	log_index	block_number	in_destination	block_timestamp	transaction_hash
0x57fa6bb127a428fe268104ab4d170fe4a99b73b6	false	198	19640076	0x83d20591dfc00ec5f320acc16575cc27f87cf8f5	2024-04-12T14:18:35.000Z	0x5b476313226b946a0b8cce2d2fc6074f8a9a43398f96fc7288afe4c95449da39
0x57fa6bb127a428fe268104ab4d170fe4a99b73b6	false	168	19529120	0xba1a495630a948f0942081924a5682f4f55e3e82	2024-03-28T00:41:11.000Z	0xdebdc4fff02c2bebbef732735cf982a3b9c90a4c6dd1dc17a3c2589f9ed0022c
0x57fa6bb127a428fe268104ab4d170fe4a99b73b6	false	506	19841492	0x8cbb67d3bded3b8b9ed99dcc9c07d590e86170a4	2024-05-10T18:41:23.000Z	0x4b68c77fbf3c632d938a9a1b00579facde784164bb3b2ac635286ea9dffd671c

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.tokemak_v2_ethereum.LMPVault_DestinationVaultAdded_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

LMPVault_DestinationVaultRemoved_event

Event logs tracking destination vault additions and removals from Tokemak v2 Liquidity Management Pool (LMP) vaults on Ethereum. Used for monitoring vault composition changes and rebalancing activity across the protocol’s liquidity strategy.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_destination`	`STRING`	Target address receiving tokens, funds, or messages in the operation. Hex-encoded, 0x-prefixed, 42-character string.

Sample Data

address	removed	log_index	block_number	in_destination	block_timestamp	transaction_hash
0x57fa6bb127a428fe268104ab4d170fe4a99b73b6	false	113	19676562	0xba1a495630a948f0942081924a5682f4f55e3e82	2024-04-17T17:03:11.000Z	0x43850a9d6ad66c3882dfc15289162d599c7fc0d0471ca98dad9174a579b9b22b
0x57fa6bb127a428fe268104ab4d170fe4a99b73b6	false	87	19841639	0x8cbb67d3bded3b8b9ed99dcc9c07d590e86170a4	2024-05-10T19:11:11.000Z	0x6047dd2bb03a8274addaef770d6fa8b3153ec7ef999b76f9df6e31ca02557e43
0x57fa6bb127a428fe268104ab4d170fe4a99b73b6	false	138	19841488	0xb89956080e6f2a94276073dcae795489dd0afd0e	2024-05-10T18:40:35.000Z	0x3a61f52cb8ac14c10fce8fa71c793925f9dbad8a8681053a412303603eac2b43

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.tokemak_v2_ethereum.LMPVault_DestinationVaultRemoved_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

LMPVault_FeeCollected_event

No description available.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_fees`	`STRING`	Array of fee amounts charged in the transaction. Numeric string representations in smallest token denomination.
`in_feeSink`	`STRING`	Address of the fee sink contract that receives collected fees. Hex-encoded, 0x-prefixed, 42-character string.
`in_mintedShares`	`STRING`	Number of shares minted in the operation. String-encoded integer representing share amounts in the smallest denomination.
`in_profit`	`STRING`	Profit amount generated by the protocol operation or position. String-encoded integer representing token amounts in the smallest denomination.
`in_idle`	`STRING`	Amount of idle or undeployed capital in the vault. Numeric string representation in smallest token denomination.
`in_debt`	`STRING`	Amount of debt outstanding in the protocol position or vault. Numeric string representation in smallest token denomination.

Sample Data

No sample data available.

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.tokemak_v2_ethereum.LMPVault_FeeCollected_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

LMPVault_flashRebalance_function

Flash rebalance transaction executions for Tokemak v2 Liquidity Management Pool (LMP) Vaults on Ethereum, capturing token swaps between vault destinations with input/output amounts and receiver addresses. Used for tracking vault portfolio rebalancing operations and analyzing liquidity allocation strategies across DeFi protocols.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`trace_address`	`STRING`	Hierarchical position of the internal call within a transaction’s execution trace. Comma-separated sequence of integers representing the call path, where each number indicates the index of the call at that nesting level, with null representing top-level calls.
`status`	`BOOL`	Transaction execution outcome indicator. Boolean value where true represents successful execution and false represents failed execution.
`from_address`	`STRING`	Address that initiated the transaction or contract call. Hex-encoded, 0x-prefixed, 42-character string.
`to_address`	`STRING`	Address receiving the transaction or contract call. Hex-encoded, 0x-prefixed, 42-character string.
`value`	`FLOAT64`	Amount of native cryptocurrency sent with the transaction. Floating-point representation in whole units (e.g., ETH, BNB, MATIC).
`gas_used`	`INT64`	Amount of gas consumed by the transaction execution. Integer representing the actual computational steps used.
`gas`	`INT64`	Gas limit allocated for the transaction execution. Integer representing the maximum computational steps allowed.
`signature`	`STRING`	Function selector identifying which contract function was called. 10-character hex string including 0x prefix.
`in_receiver`	`STRING`	Address that receives tokens, assets, or rewards from the transaction. Hex-encoded, 0x-prefixed, 42-character string.
`in_rebalanceParams`	`STRUCT<destinationIn STRING, tokenIn STRING, amountIn STRING, destinationOut STRING, tokenOut STRING, amountOut STRING>`	Structured data containing the parameters for the flash rebalance operation, including token addresses, amounts, and destination vault addresses for both sides of the swap. Defines the complete execution path for rebalancing liquidity between Tokemak v2 LMP vault destinations.
`in_data`	`STRING`	Encoded input data for the contract function call. Hex-encoded byte string representing function parameters and additional call data.

Sample Data

gas	status	in_data	gas_used	signature	to_address	in_receiver	block_number	from_address	block_timestamp	transaction_hash	in_rebalanceParams
2363531	true	0x000000000000000000000000000000000000000000000000000000000000004000000000000000000000000000000000000000000000000000000000000000e00000000000000000000000000000000000000000000000000000000000000004c83abb8500000182ffffffffe506b3efff993f854928cc6ce54c9ec5f8dd5f9c095ea7b3010304ffffffffffae7ab96520de3a18e5e111b5eaab095312d7fe84e3547335000385ffffffffff33356a9d8bc8207c6ea152f2f3a648dd6f8028a1d0e30db00306ffffffffffffc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2000000000000000000000000000000000000000000000000000000000000000700000000000000000000000000000000000000000000000000000000000000e00000000000000000000000000000000000000000000000000000000000000120000000000000000000000000000000000000000000000000000000000000016000000000000000000000000000000000000000000000000000000000000001e00000000000000000000000000000000000000000000000000000000000000220000000000000000000000000000000000000000000000000000000000000026000000000000000000000000000000000000000000000000000000000000009e0000000000000000000000000000000000000000000000000000000000000002000000000000000000000000021e27a5e5513d6e65c4f830167390997aa84843a0000000000000000000000000000000000000000000000000000000000000020000000000000000000000000000000000000000000000001648fa276944205db0000000000000000000000000000000000000000000000000000000000000060000000000000000000000000000000000000000000000000000000000000000200000000000000000000000000000000000000000000000053d85f9c802e940000000000000000000000000000000000000000000000000119bd2d05471530000000000000000000000000000000000000000000000000000000000000000020000000000000000000000000def1c0ded9bec7f1a1670819833240f027b25eff000000000000000000000000000000000000000000000000000000000000002000000000000000000000000000000000000000000000000119bd2d054715300000000000000000000000000000000000000000000000000000000000000007600000000000000000000000000000000000000000000000000000000000000728415565b0000000000000000000000000ae7ab96520de3a18e5e111b5eaab095312d7fe84000000000000000000000000c02aaa39b223fe8d0a0e5c4f27ead9083c756cc200000000000000000000000000000000000000000000000119bd2d054715300000000000000000000000000000000000000000000000000117a9c64fe1a71f3c00000000000000000000000000000000000000000000000000000000000000a00000000000000000000000000000000000000000000000000000000000000003000000000000000000000000000000000000000000000000000000000000006000000000000000000000000000000000000000000000000000000000000003e000000000000000000000000000000000000000000000000000000000000004e000000000000000000000000000000000000000000000000000000000000000210000000000000000000000000000000000000000000000000000000000000040000000000000000000000000000000000000000000000000000000000000032000000000000000000000000000000000000000000000000000000000000000200000000000000000000000000000000000000000000000000000000000000000000000000000000000000000ae7ab96520de3a18e5e111b5eaab095312d7fe84000000000000000000000000c02aaa39b223fe8d0a0e5c4f27ead9083c756cc2000000000000000000000000000000000000000000000000000000000000014000000000000000000000000000000000000000000000000000000000000002e000000000000000000000000000000000000000000000000000000000000002e000000000000000000000000000000000000000000000000000000000000002a000000000000000000000000000000000000000000000000119bd2d0547153000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000002e000000000000000000000000000000000000000000000000000000000000000010000000000000000000000000000000000000000000000000000000000000020000000000000000000000000000000014375727665000000000000000000000000000000000000000000000000000000000000000000000119bd2d05471530000000000000000000000000000000000000000000000000011815539f189a0a8300000000000000000000000000000000000000000000000000000000000000800000000000000000000000000000000000000000000000000000000000000080000000000000000000000000dc24316b9ae028f1497c275eb9192a3ea0f670223df021240000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000010000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000100000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000001b000000000000000000000000000000000000000000000000000000000000004000000000000000000000000000000000000000000000000000000000000000a000000000000000000000000000000000000000000000000000000000000000200000000000000000000000000000000000000000000000000000000000000001000000000000000000000000c02aaa39b223fe8d0a0e5c4f27ead9083c756cc2000000000000000000000000000000000000000000000000006b8d4f36f2eb47000000000000000000000000ad01c20d5886137e056775af56915de824c8fce5000000000000000000000000000000000000000000000000000000000000001c000000000000000000000000000000000000000000000000000000000000004000000000000000000000000000000000000000000000000000000000000000e00000000000000000000000000000000000000000000000000000000000000020000000000000000000000000000000000000000000000000000000000000004000000000000000000000000000000000000000000000000000000000000000a00000000000000000000000000000000000000000000000000000000000000002000000000000000000000000ae7ab96520de3a18e5e111b5eaab095312d7fe84000000000000000000000000eeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeee0000000000000000000000000000000000000000000000000000000000000000869584cd000000000000000000000000100000000000000000000000000000000000001100000000000000000000000000000000fe48ab5d0d2d19595a8aa332beee1504000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000002000000000000000000000000000000000000000000000000053d85f9c802e9400	2323333	0xdc47c23a	0x57fa6bb127a428fe268104ab4d170fe4a99b73b6	0xf30c9e441dc743aa99316717602ef5ade75ad223	19641086	0xf30c9e441dc743aa99316717602ef5ade75ad223	2024-04-12T17:43:23.000Z	0x60855e4f693ed2431abb0d889b3853f6440fdc763ced5c6d5461c4ca0c33febd	{“tokenIn”:“0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2”,“amountIn”:“26266122500212400128”,“tokenOut”:“0x21e27a5e5513d6e65c4f830167390997aa84843a”,“amountOut”:“25692933029349164507”,“destinationIn”:“0x57fa6bb127a428fe268104ab4d170fe4a99b73b6”,“destinationOut”:“0xba1a495630a948f0942081924a5682f4f55e3e82”}
2512757	true	0x000000000000000000000000000000000000000000000000000000000000004000000000000000000000000000000000000000000000000000000000000000c00000000000000000000000000000000000000000000000000000000000000003c83abb8500000182ffffffffe506b3efff993f854928cc6ce54c9ec5f8dd5f9c095ea7b3010304ffffffffffbe9895146f7af43049ca1c1ae358b0541ea49704e3547335000385ffffffffff33356a9d8bc8207c6ea152f2f3a648dd6f8028a1000000000000000000000000000000000000000000000000000000000000000600000000000000000000000000000000000000000000000000000000000000c00000000000000000000000000000000000000000000000000000000000000100000000000000000000000000000000000000000000000000000000000000014000000000000000000000000000000000000000000000000000000000000001c00000000000000000000000000000000000000000000000000000000000000200000000000000000000000000000000000000000000000000000000000000024000000000000000000000000000000000000000000000000000000000000000200000000000000000000000005fae7e604fc3e24fd43a72867cebac94c65b404a00000000000000000000000000000000000000000000000000000000000000200000000000000000000000000000000000000000000000009cda3497a24a30c200000000000000000000000000000000000000000000000000000000000000600000000000000000000000000000000000000000000000000000000000000002000000000000000000000000000000000000000000000000ada915944968d000000000000000000000000000000000000000000000000000906443eea251b0000000000000000000000000000000000000000000000000000000000000000020000000000000000000000000def1c0ded9bec7f1a1670819833240f027b25eff0000000000000000000000000000000000000000000000000000000000000020000000000000000000000000000000000000000000000000906443eea251b00000000000000000000000000000000000000000000000000000000000000009800000000000000000000000000000000000000000000000000000000000000948415565b0000000000000000000000000be9895146f7af43049ca1c1ae358b0541ea49704000000000000000000000000c02aaa39b223fe8d0a0e5c4f27ead9083c756cc2ffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffff000000000000000000000000000000000000000000000000989cfbccc25aaa9900000000000000000000000000000000000000000000000000000000000000a0000000000000000000000000000000000000000000000000000000000000000300000000000000000000000000000000000000000000000000000000000000600000000000000000000000000000000000000000000000000000000000000600000000000000000000000000000000000000000000000000000000000000070000000000000000000000000000000000000000000000000000000000000000210000000000000000000000000000000000000000000000000000000000000040000000000000000000000000000000000000000000000000000000000000054000000000000000000000000000000000000000000000000000000000000000200000000000000000000000000000000000000000000000000000000000000000000000000000000000000000be9895146f7af43049ca1c1ae358b0541ea49704000000000000000000000000c02aaa39b223fe8d0a0e5c4f27ead9083c756cc200000000000000000000000000000000000000000000000000000000000001400000000000000000000000000000000000000000000000000000000000000500000000000000000000000000000000000000000000000000000000000000050000000000000000000000000000000000000000000000000000000000000004c0ffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffff00000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000500000000000000000000000000000000000000000000000000000000000000000100000000000000000000000000000000000000000000000000000000000000200000000000000000000000000000001942616c616e6365725632000000000000000000000000000000000000000000000000000000000000906443eea251b00000000000000000000000000000000000000000000000000098d7acd3bb98768d000000000000000000000000000000000000000000000000000000000000008000000000000000000000000000000000000000000000000000000000000002a0000000000000000000000000ba12222222228d8ba445958a75a0704d566bf2c8000000000000000000000000000000000000000000000000000000000000006000000000000000000000000000000000000000000000000000000000000002200000000000000000000000000000000000000000000000000000000000000002000000000000000000000000000000000000000000000000000000000000004000000000000000000000000000000000000000000000000000000000000000e0f7a826d47c8e02835d94fb0aa40f0cc9505cb1340002000000000000000005e0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000010000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000014093d199263632a4ef4bb438f1feb99e57b4b5f0bd0000000000000000000005c200000000000000000000000000000000000000000000000000000000000000010000000000000000000000000000000000000000000000000000000000000002000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000a000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000003000000000000000000000000be9895146f7af43049ca1c1ae358b0541ea497040000000000000000000000007f39c581f595b53c5cb19bd0b3f8da6c935e2ca0000000000000000000000000c02aaa39b223fe8d0a0e5c4f27ead9083c756cc2000000000000000000000000000000000000000000000000000000000000000100000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000001b000000000000000000000000000000000000000000000000000000000000004000000000000000000000000000000000000000000000000000000000000000a000000000000000000000000000000000000000000000000000000000000000200000000000000000000000000000000000000000000000000000000000000001000000000000000000000000c02aaa39b223fe8d0a0e5c4f27ead9083c756cc2000000000000000000000000000000000000000000000000003ab106f93dcbf4000000000000000000000000ad01c20d5886137e056775af56915de824c8fce5000000000000000000000000000000000000000000000000000000000000001c000000000000000000000000000000000000000000000000000000000000004000000000000000000000000000000000000000000000000000000000000000e00000000000000000000000000000000000000000000000000000000000000020000000000000000000000000000000000000000000000000000000000000004000000000000000000000000000000000000000000000000000000000000000a00000000000000000000000000000000000000000000000000000000000000002000000000000000000000000be9895146f7af43049ca1c1ae358b0541ea49704000000000000000000000000eeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeee0000000000000000000000000000000000000000000000000000000000000000869584cd0000000000000000000000001000000000000000000000000000000000000011000000000000000000000000000000003022c00b1caced3b577ccf9dc20e84d1000000000000000000000000000000000000000000000000	2470168	0xdc47c23a	0x57fa6bb127a428fe268104ab4d170fe4a99b73b6	0xf30c9e441dc743aa99316717602ef5ade75ad223	19541469	0xf30c9e441dc743aa99316717602ef5ade75ad223	2024-03-29T18:34:47.000Z	0xe146dde119520b169156bc5b3b64b48e653045ae200a26eead011f288598a722	{“tokenIn”:“0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2”,“amountIn”:“23545794441674104832”,“tokenOut”:“0x5b6c539b224014a09b3388e51caaa8e354c959c8”,“amountOut”:“11302404040707158210”,“destinationIn”:“0x57fa6bb127a428fe268104ab4d170fe4a99b73b6”,“destinationOut”:“0x258ef53417f3ce45a993b8ad777b87712322cc7b”}
3014293	true	0x000000000000000000000000000000000000000000000000000000000000004000000000000000000000000000000000000000000000000000000000000001000000000000000000000000000000000000000000000000000000000000000005095ea7b3010001ffffffffffc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2e3547335000082ffffffffff33356a9d8bc8207c6ea152f2f3a648dd6f8028a12e1a7d4d0103ffffffffffffc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2095ea7b3010405ffffffffffae7ab96520de3a18e5e111b5eaab095312d7fe84b08dc2850004860708ffffffe506b3efff993f854928cc6ce54c9ec5f8dd5f9c00000000000000000000000000000000000000000000000000000000000000090000000000000000000000000000000000000000000000000000000000000120000000000000000000000000000000000000000000000000000000000000016000000000000000000000000000000000000000000000000000000000000001a00000000000000000000000000000000000000000000000000000000000000920000000000000000000000000000000000000000000000000000000000000096000000000000000000000000000000000000000000000000000000000000009a000000000000000000000000000000000000000000000000000000000000009e00000000000000000000000000000000000000000000000000000000000000a600000000000000000000000000000000000000000000000000000000000000aa00000000000000000000000000000000000000000000000000000000000000020000000000000000000000000def1c0ded9bec7f1a1670819833240f027b25eff00000000000000000000000000000000000000000000000000000000000000200000000000000000000000000000000000000000000000013224cb6333a1400000000000000000000000000000000000000000000000000000000000000007600000000000000000000000000000000000000000000000000000000000000728415565b0000000000000000000000000c02aaa39b223fe8d0a0e5c4f27ead9083c756cc2000000000000000000000000ae7ab96520de3a18e5e111b5eaab095312d7fe84ffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffff0000000000000000000000000000000000000000000000013234ec35d6d572f200000000000000000000000000000000000000000000000000000000000000a00000000000000000000000000000000000000000000000000000000000000003000000000000000000000000000000000000000000000000000000000000006000000000000000000000000000000000000000000000000000000000000003e000000000000000000000000000000000000000000000000000000000000004e000000000000000000000000000000000000000000000000000000000000000210000000000000000000000000000000000000000000000000000000000000040000000000000000000000000000000000000000000000000000000000000032000000000000000000000000000000000000000000000000000000000000000200000000000000000000000000000000000000000000000000000000000000000000000000000000000000000c02aaa39b223fe8d0a0e5c4f27ead9083c756cc2000000000000000000000000ae7ab96520de3a18e5e111b5eaab095312d7fe84000000000000000000000000000000000000000000000000000000000000014000000000000000000000000000000000000000000000000000000000000002e000000000000000000000000000000000000000000000000000000000000002e000000000000000000000000000000000000000000000000000000000000002a0ffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffff000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000002e00000000000000000000000000000000000000000000000000000000000000001000000000000000000000000000000000000000000000000000000000000002000000000000000000000000000000001437572766500000000000000000000000000000000000000000000000000000000000000000000013224cb6333a1400000000000000000000000000000000000000000000000000132aaaec6c701194100000000000000000000000000000000000000000000000000000000000000800000000000000000000000000000000000000000000000000000000000000080000000000000000000000000dc24316b9ae028f1497c275eb9192a3ea0f670223df021240000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000001000000000000000000000000000000000000000000000000000000000000000100000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000001b000000000000000000000000000000000000000000000000000000000000004000000000000000000000000000000000000000000000000000000000000000a000000000000000000000000000000000000000000000000000000000000000200000000000000000000000000000000000000000000000000000000000000001000000000000000000000000ae7ab96520de3a18e5e111b5eaab095312d7fe840000000000000000000000000000000000000000000000000075c290f02ba64f000000000000000000000000ad01c20d5886137e056775af56915de824c8fce5000000000000000000000000000000000000000000000000000000000000001c000000000000000000000000000000000000000000000000000000000000004000000000000000000000000000000000000000000000000000000000000000e00000000000000000000000000000000000000000000000000000000000000020000000000000000000000000000000000000000000000000000000000000004000000000000000000000000000000000000000000000000000000000000000a00000000000000000000000000000000000000000000000000000000000000002000000000000000000000000c02aaa39b223fe8d0a0e5c4f27ead9083c756cc2000000000000000000000000eeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeee0000000000000000000000000000000000000000000000000000000000000000869584cd000000000000000000000000100000000000000000000000000000000000001100000000000000000000000000000000f6f2ba440b43406e216f1560dbfcc4b900000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000200000000000000000000000000000000000000000000000003afeb4a6a1fccc00000000000000000000000000000000000000000000000000000000000000002000000000000000000000000021e27a5e5513d6e65c4f830167390997aa84843a0000000000000000000000000000000000000000000000000000000000000020000000000000000000000000000000000000000000000001328b62a701817000000000000000000000000000000000000000000000000000000000000000006000000000000000000000000000000000000000000000000000000000000000020000000000000000000000000000000000000000000000003afeb4a6a1fccc00000000000000000000000000000000000000000000000001328b62a7018170000000000000000000000000000000000000000000000000000000000000000020000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000200000000000000000000000000000000000000000000000000000000000000001	2964022	0xdc47c23a	0x57fa6bb127a428fe268104ab4d170fe4a99b73b6	0xf30c9e441dc743aa99316717602ef5ade75ad223	19541621	0xf30c9e441dc743aa99316717602ef5ade75ad223	2024-03-29T19:05:23.000Z	0x27aa763a9cd82c100f3d3600c70d97371fe9802d9a48517165e7927e41e813fb	{“tokenIn”:“0x21e27a5e5513d6e65c4f830167390997aa84843a”,“amountIn”:“25680891381423194112”,“tokenOut”:“0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2”,“amountOut”:“26333610358874995227”,“destinationIn”:“0xba1a495630a948f0942081924a5682f4f55e3e82”,“destinationOut”:“0x57fa6bb127a428fe268104ab4d170fe4a99b73b6”}

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.tokemak_v2_ethereum.LMPVault_flashRebalance_function`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

LMPVault_initialize_function

Initialization events for Tokemak V2 Liquidity Marketplace (LMP) Vaults on Ethereum, capturing vault deployment parameters including strategy addresses, naming conventions, and deployment transactions. Used for tracking vault creation and initial configuration across the Tokemak protocol.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`trace_address`	`STRING`	Hierarchical position of the internal call within a transaction’s execution trace. Comma-separated sequence of integers representing the call path, where each number indicates the index of the call at that nesting level, with null representing top-level calls.
`status`	`BOOL`	Transaction execution outcome indicator. Boolean value where true represents successful execution and false represents failed execution.
`from_address`	`STRING`	Address that initiated the transaction or contract call. Hex-encoded, 0x-prefixed, 42-character string.
`to_address`	`STRING`	Address receiving the transaction or contract call. Hex-encoded, 0x-prefixed, 42-character string.
`value`	`FLOAT64`	Amount of native cryptocurrency sent with the transaction. Floating-point representation in whole units (e.g., ETH, BNB, MATIC).
`gas_used`	`INT64`	Amount of gas consumed by the transaction execution. Integer representing the actual computational steps used.
`gas`	`INT64`	Gas limit allocated for the transaction execution. Integer representing the maximum computational steps allowed.
`signature`	`STRING`	Function selector identifying which contract function was called. 10-character hex string including 0x prefix.
`in_strategy`	`STRING`	Contract address of the strategy or strategy contract being referenced. Hex-encoded, 0x-prefixed, 42-character string.
`in_symbolSuffix`	`STRING`	Token symbol suffix appended to create the vault’s trading symbol (e.g., “autoETH_guarded”). Identifies the vault variant or strategy type in a human-readable format.
`in_descPrefix`	`STRING`	User-friendly description prefix for the LMPVault, typically including the protocol name and vault type. This value is concatenated with other metadata to form the complete vault description.
`in_anon3`	`STRING`	Sequential counter tracking the total number of pairs created by the factory contract.

Sample Data

gas	value	status	gas_used	in_anon3	signature	to_address	in_strategy	block_number	from_address	in_descPrefix	trace_address	block_timestamp	in_symbolSuffix	transaction_hash
1865825	0	true	189286	0x	0x267eb9ed	0x57fa6bb127a428fe268104ab4d170fe4a99b73b6	0xb9058ee7866458cdd6f78b12bc3b401c8d284d8e	19392329	0xeea468310ac13d0ed61457552b212ada8fc874b7	Tokemak Guarded autoETH	4	2024-03-08T18:46:59.000Z	autoETH_guarded	0x9b7bf616fc0bf7f88065202ae9fe0a5e972dbe0ef290a3ad081a9d50ee49b113

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.tokemak_v2_ethereum.LMPVault_initialize_function`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

LMPVault_Nav_event

Net Asset Value (NAV) snapshots from Tokemak v2 Liquidity Marketplace (LMP) Vaults on Ethereum, tracking debt deployed to destinations, idle funds, and total supply. Used for monitoring vault performance, calculating share prices, and analyzing capital efficiency across rebalancing events.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_idle`	`STRING`	Amount of idle or undeployed capital in the vault. Numeric string representation in smallest token denomination.
`in_debt`	`STRING`	Amount of debt outstanding in the protocol position or vault. Numeric string representation in smallest token denomination.
`in_totalSupply`	`STRING`	Total supply of the pool or vault token after the event. Numeric string representation of token quantity in smallest denomination.

Sample Data

address	in_debt	in_idle	removed	log_index	block_number	in_totalSupply	block_timestamp	transaction_hash
0x57fa6bb127a428fe268104ab4d170fe4a99b73b6	26343318374211926580	4871395268261981	false	431	19633691	26235717700643078755	2024-04-11T16:52:59.000Z	0x914632a153aaac643f471b0162dc3aa9a323304b8f9b5b97b6a9a32164090d0e
0x57fa6bb127a428fe268104ab4d170fe4a99b73b6	34379233812611481117	11986566534226948	false	99	19841735	34316909309054631728	2024-05-10T19:30:23.000Z	0x44fbe9c7361a122ef3da762d82b0965d859ae0ba10e9892c9aff41945209a296
0x57fa6bb127a428fe268104ab4d170fe4a99b73b6	34423409090828581372	11986566534226948	false	1374	19839938	34316909309054631728	2024-05-10T13:29:23.000Z	0xe8c37ea67b4d70401c06fe8f36addc9c72c66ca23a001331acb72376717d3311

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.tokemak_v2_ethereum.LMPVault_Nav_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

LMPVault_NewNavShareFeeMark_event

NewNavShareFeeMark events from Tokemak v2 LMP (Liquidity Management Pool) vaults on Ethereum, recording net asset value (NAV) per share snapshots used for performance fee calculations. Enables tracking of vault share pricing and fee accrual timing across rebalance periods.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_navPerShare`	`STRING`	Net asset value (NAV) per share at the marked timestamp, expressed as an integer with implied decimals (typically 4, so 10010 = 1.0010). Tracks the vault’s share price for fee calculation purposes in Tokemak v2 LMP Vaults.
`in_timestamp`	`STRING`	Unix timestamp when the event or operation occurred. Numeric string representation of seconds since epoch.

Sample Data

address	removed	log_index	block_number	in_timestamp	in_navPerShare	block_timestamp	transaction_hash
0x57fa6bb127a428fe268104ab4d170fe4a99b73b6	false	351	19676714	1713375239	10010	2024-04-17T17:33:59.000Z	0xb22fcf1042deb774e8070e5b86605c4252f468ca87ff59f9c4303e30cb560eed
0x57fa6bb127a428fe268104ab4d170fe4a99b73b6	false	269	19676348	1713370823	10028	2024-04-17T16:20:23.000Z	0xfd17412118aa8b4664d8159e6bb6705469936626c2a1eb18f0ea688166ea32b4
0x57fa6bb127a428fe268104ab4d170fe4a99b73b6	false	522	20011696	1717422551	10042	2024-06-03T13:49:11.000Z	0x2c346fa287e1cafb6dc601599d6cabf02d2e436fa16d9bcbd0ea9693c8f10517

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.tokemak_v2_ethereum.LMPVault_NewNavShareFeeMark_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

LMPVault_PeriodicFeeCollected_event

No description available.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_fees`	`STRING`	Array of fee amounts charged in the transaction. Numeric string representations in smallest token denomination.
`in_feeSink`	`STRING`	Address of the fee sink contract that receives collected fees. Hex-encoded, 0x-prefixed, 42-character string.
`in_mintedShares`	`STRING`	Number of shares minted in the operation. String-encoded integer representing share amounts in the smallest denomination.

Sample Data

No sample data available.

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.tokemak_v2_ethereum.LMPVault_PeriodicFeeCollected_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

LMPVault_permit_function

No description available.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`trace_address`	`STRING`	Hierarchical position of the internal call within a transaction’s execution trace. Comma-separated sequence of integers representing the call path, where each number indicates the index of the call at that nesting level, with null representing top-level calls.
`status`	`BOOL`	Transaction execution outcome indicator. Boolean value where true represents successful execution and false represents failed execution.
`from_address`	`STRING`	Address that initiated the transaction or contract call. Hex-encoded, 0x-prefixed, 42-character string.
`to_address`	`STRING`	Address receiving the transaction or contract call. Hex-encoded, 0x-prefixed, 42-character string.
`value`	`FLOAT64`	Amount of native cryptocurrency sent with the transaction. Floating-point representation in whole units (e.g., ETH, BNB, MATIC).
`gas_used`	`INT64`	Amount of gas consumed by the transaction execution. Integer representing the actual computational steps used.
`gas`	`INT64`	Gas limit allocated for the transaction execution. Integer representing the maximum computational steps allowed.
`signature`	`STRING`	Function selector identifying which contract function was called. 10-character hex string including 0x prefix.
`in_owner`	`STRING`	Address that owns or controls the shares or position being deposited or withdrawn. Hex-encoded, 0x-prefixed, 42-character string.
`in_spender`	`STRING`	Address authorized to spend tokens on behalf of the owner. Hex-encoded, 0x-prefixed, 42-character string.
`in_value`	`STRING`	Amount of tokens transferred, minted, or burned in the operation. Numeric string representation preserving precision for large integer values.
`in_deadline`	`STRING`	Timestamp after which the transaction or operation becomes invalid and will revert. Unix timestamp in seconds.
`in_v`	`INT64`	ECDSA signature component v used for cryptographic verification of signed messages or permits. Integer value representing the recovery identifier, typically 27 or 28.
`in_r`	`STRING`	ECDSA signature component r used for cryptographic verification of signed messages or permits. 66-character hex string including 0x prefix.
`in_s`	`STRING`	ECDSA signature component s used for cryptographic verification of signed messages or permits. 66-character hex string including 0x prefix.

Sample Data

No sample data available.

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.tokemak_v2_ethereum.LMPVault_permit_function`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

LMPVault_recover_function

No description available.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`trace_address`	`STRING`	Hierarchical position of the internal call within a transaction’s execution trace. Comma-separated sequence of integers representing the call path, where each number indicates the index of the call at that nesting level, with null representing top-level calls.
`status`	`BOOL`	Transaction execution outcome indicator. Boolean value where true represents successful execution and false represents failed execution.
`from_address`	`STRING`	Address that initiated the transaction or contract call. Hex-encoded, 0x-prefixed, 42-character string.
`to_address`	`STRING`	Address receiving the transaction or contract call. Hex-encoded, 0x-prefixed, 42-character string.
`value`	`FLOAT64`	Amount of native cryptocurrency sent with the transaction. Floating-point representation in whole units (e.g., ETH, BNB, MATIC).
`gas_used`	`INT64`	Amount of gas consumed by the transaction execution. Integer representing the actual computational steps used.
`gas`	`INT64`	Gas limit allocated for the transaction execution. Integer representing the maximum computational steps allowed.
`signature`	`STRING`	Function selector identifying which contract function was called. 10-character hex string including 0x prefix.
`in_tokens`	`ARRAY<STRING>`	Array of token contract addresses involved in the operation. Hex-encoded, 0x-prefixed, 42-character strings.
`in_amounts`	`ARRAY<STRING>`	Array of token amounts involved in the operation. String-encoded integers representing amounts in the token’s smallest unit (e.g., wei for ETH).
`in_destinations`	`ARRAY<STRING>`	Array of destination addresses for token transfers or operations. Hex-encoded, 0x-prefixed, 42-character strings.

Sample Data

No sample data available.

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.tokemak_v2_ethereum.LMPVault_recover_function`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

LMPVault_redeem_function

Redemption transactions from Tokemak v2 Liquidity Marketplace Provider (LMP) Vaults on Ethereum, showing vault share burns and corresponding asset withdrawals. Contains share amounts redeemed, assets received, and participant addresses for analyzing vault liquidity flows and user withdrawal patterns.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`trace_address`	`STRING`	Hierarchical position of the internal call within a transaction’s execution trace. Comma-separated sequence of integers representing the call path, where each number indicates the index of the call at that nesting level, with null representing top-level calls.
`status`	`BOOL`	Transaction execution outcome indicator. Boolean value where true represents successful execution and false represents failed execution.
`from_address`	`STRING`	Address that initiated the transaction or contract call. Hex-encoded, 0x-prefixed, 42-character string.
`to_address`	`STRING`	Address receiving the transaction or contract call. Hex-encoded, 0x-prefixed, 42-character string.
`value`	`FLOAT64`	Amount of native cryptocurrency sent with the transaction. Floating-point representation in whole units (e.g., ETH, BNB, MATIC).
`gas_used`	`INT64`	Amount of gas consumed by the transaction execution. Integer representing the actual computational steps used.
`gas`	`INT64`	Gas limit allocated for the transaction execution. Integer representing the maximum computational steps allowed.
`signature`	`STRING`	Function selector identifying which contract function was called. 10-character hex string including 0x prefix.
`in_shares`	`STRING`	Number of shares involved in the deposit or withdrawal transaction. String-encoded integer representing the share quantity in the protocol’s accounting system.
`in_receiver`	`STRING`	Address that receives tokens, assets, or rewards from the transaction. Hex-encoded, 0x-prefixed, 42-character string.
`in_owner`	`STRING`	Address that owns or controls the shares or position being deposited or withdrawn. Hex-encoded, 0x-prefixed, 42-character string.
`out_assets`	`STRING`	Amount of underlying assets returned from redeeming shares. String-encoded integer representing token quantity in the token’s smallest unit.

Sample Data

gas	status	gas_used	in_owner	in_shares	signature	out_assets	to_address	in_receiver	block_number	from_address	trace_address	block_timestamp	transaction_hash
1525167	true	1249607	0x804986f81826034f7753484b936a634c706f1adf	7081191608411552973	0xba087652	7123736748804835290	0x57fa6bb127a428fe268104ab4d170fe4a99b73b6	0x902b1b5af7c34a80ac2c2957259b7b1606e606e5	20090694	0x902b1b5af7c34a80ac2c2957259b7b1606e606e5	4	2024-06-14T14:38:35.000Z	0xb77bd1dc05910b93902778a016918c06d87c8cc3ec0f3f0beddef16c84c38b9f
1659379	true	1266631	0x804986f81826034f7753484b936a634c706f1adf	1000000000000000000	0xba087652	1006007160969767444	0x57fa6bb127a428fe268104ab4d170fe4a99b73b6	0x902b1b5af7c34a80ac2c2957259b7b1606e606e5	20090401	0x902b1b5af7c34a80ac2c2957259b7b1606e606e5	4	2024-06-14T13:39:47.000Z	0x2a1d5939b39babacefb20cd8d89e0db259f187d19dec66cbd70523d33fdfa116
1688586	true	1311741	0x804986f81826034f7753484b936a634c706f1adf	26235717700643078755	0xba087652	26392906592875502717	0x57fa6bb127a428fe268104ab4d170fe4a99b73b6	0x902b1b5af7c34a80ac2c2957259b7b1606e606e5	20091487	0x902b1b5af7c34a80ac2c2957259b7b1606e606e5	4	2024-06-14T17:17:47.000Z	0xc6b190921283dbd5e1389671cd0bf830b4317a3b8066ebccef4de9d786eedbd5

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.tokemak_v2_ethereum.LMPVault_redeem_function`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

LMPVault_RewarderSet_event

Rewarder contract configuration changes for Tokemak v2 Liquidity Management Protocol (LMP) vaults on Ethereum. Tracks when reward distributor contracts are added or replaced for LMP vaults, capturing old and new rewarder addresses.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_newRewarder`	`STRING`	Contract address of the newly assigned rewarder for this Tokemak LMP Vault. Zero address (0x00…00) indicates no rewarder is being set.
`in_oldRewarder`	`STRING`	Contract address of the previous rewarder contract before the change event. Null address (0x000…000) indicates no prior rewarder was set.

Sample Data

address	removed	log_index	block_number	in_newRewarder	in_oldRewarder	block_timestamp	transaction_hash
0x57fa6bb127a428fe268104ab4d170fe4a99b73b6	false	2	19392329	0xa5e7672f88c4a8995f191d7b7e4725cd3a6d245b	0x0000000000000000000000000000000000000000	2024-03-08T18:46:59.000Z	0x9b7bf616fc0bf7f88065202ae9fe0a5e972dbe0ef290a3ad081a9d50ee49b113

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.tokemak_v2_ethereum.LMPVault_RewarderSet_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

LMPVault_RewarderSet2_event

No description available.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_rewarder`	`STRING`	-

Sample Data

No sample data available.

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.tokemak_v2_ethereum.LMPVault_RewarderSet2_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

LMPVault_TokensPulled_event

No description available.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_tokens`	`ARRAY<STRING>`	Array of token contract addresses involved in the operation. Hex-encoded, 0x-prefixed, 42-character strings.
`in_amounts`	`ARRAY<STRING>`	Array of token amounts involved in the operation. String-encoded integers representing amounts in the token’s smallest unit (e.g., wei for ETH).
`in_destinations`	`ARRAY<STRING>`	Array of destination addresses for token transfers or operations. Hex-encoded, 0x-prefixed, 42-character strings.

Sample Data

No sample data available.

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.tokemak_v2_ethereum.LMPVault_TokensPulled_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

LMPVault_TokensRecovered_event

No description available.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_tokens`	`ARRAY<STRING>`	Array of token contract addresses involved in the operation. Hex-encoded, 0x-prefixed, 42-character strings.
`in_amounts`	`ARRAY<STRING>`	Array of token amounts involved in the operation. String-encoded integers representing amounts in the token’s smallest unit (e.g., wei for ETH).
`in_destinations`	`ARRAY<STRING>`	Array of destination addresses for token transfers or operations. Hex-encoded, 0x-prefixed, 42-character strings.

Sample Data

No sample data available.

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.tokemak_v2_ethereum.LMPVault_TokensRecovered_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

LMPVault_Withdraw_event

Withdrawal events from Tokemak v2 LMP (Liquidity Marketplace) vaults on Ethereum, capturing vault share redemptions with corresponding asset amounts and participant addresses. Used for tracking liquidity provider exits and vault TVL (Total Value Locked) changes.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_sender`	`STRING`	Address that initiated the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_receiver`	`STRING`	Address that receives tokens, assets, or rewards from the transaction. Hex-encoded, 0x-prefixed, 42-character string.
`in_owner`	`STRING`	Address that owns or controls the shares or position being deposited or withdrawn. Hex-encoded, 0x-prefixed, 42-character string.
`in_assets`	`STRING`	Number of asset units involved in the deposit or withdrawal transaction. String-encoded integer representing the asset quantity in the protocol’s accounting system.
`in_shares`	`STRING`	Number of shares involved in the deposit or withdrawal transaction. String-encoded integer representing the share quantity in the protocol’s accounting system.

Sample Data

address	removed	in_owner	in_assets	in_sender	in_shares	log_index	in_receiver	block_number	block_timestamp	transaction_hash
0x57fa6bb127a428fe268104ab4d170fe4a99b73b6	false	0x804986f81826034f7753484b936a634c706f1adf	7123736748804835290	0x902b1b5af7c34a80ac2c2957259b7b1606e606e5	7081191608411552973	220	0x902b1b5af7c34a80ac2c2957259b7b1606e606e5	20090694	2024-06-14T14:38:35.000Z	0xb77bd1dc05910b93902778a016918c06d87c8cc3ec0f3f0beddef16c84c38b9f
0x57fa6bb127a428fe268104ab4d170fe4a99b73b6	false	0x804986f81826034f7753484b936a634c706f1adf	1006007160969767444	0x902b1b5af7c34a80ac2c2957259b7b1606e606e5	1000000000000000000	394	0x902b1b5af7c34a80ac2c2957259b7b1606e606e5	20090401	2024-06-14T13:39:47.000Z	0x2a1d5939b39babacefb20cd8d89e0db259f187d19dec66cbd70523d33fdfa116
0x57fa6bb127a428fe268104ab4d170fe4a99b73b6	false	0x804986f81826034f7753484b936a634c706f1adf	26392906592875502717	0x902b1b5af7c34a80ac2c2957259b7b1606e606e5	26235717700643078755	354	0x902b1b5af7c34a80ac2c2957259b7b1606e606e5	20091487	2024-06-14T17:17:47.000Z	0xc6b190921283dbd5e1389671cd0bf830b4317a3b8066ebccef4de9d786eedbd5

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.tokemak_v2_ethereum.LMPVault_Withdraw_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

LMPVault_withdraw_function

No description available.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`trace_address`	`STRING`	Hierarchical position of the internal call within a transaction’s execution trace. Comma-separated sequence of integers representing the call path, where each number indicates the index of the call at that nesting level, with null representing top-level calls.
`status`	`BOOL`	Transaction execution outcome indicator. Boolean value where true represents successful execution and false represents failed execution.
`from_address`	`STRING`	Address that initiated the transaction or contract call. Hex-encoded, 0x-prefixed, 42-character string.
`to_address`	`STRING`	Address receiving the transaction or contract call. Hex-encoded, 0x-prefixed, 42-character string.
`value`	`FLOAT64`	Amount of native cryptocurrency sent with the transaction. Floating-point representation in whole units (e.g., ETH, BNB, MATIC).
`gas_used`	`INT64`	Amount of gas consumed by the transaction execution. Integer representing the actual computational steps used.
`gas`	`INT64`	Gas limit allocated for the transaction execution. Integer representing the maximum computational steps allowed.
`signature`	`STRING`	Function selector identifying which contract function was called. 10-character hex string including 0x prefix.
`in_assets`	`STRING`	Number of asset units involved in the deposit or withdrawal transaction. String-encoded integer representing the asset quantity in the protocol’s accounting system.
`in_receiver`	`STRING`	Address that receives tokens, assets, or rewards from the transaction. Hex-encoded, 0x-prefixed, 42-character string.
`in_owner`	`STRING`	Address that owns or controls the shares or position being deposited or withdrawn. Hex-encoded, 0x-prefixed, 42-character string.
`out_shares`	`STRING`	Number of shares issued or burned as a result of the transaction. String-encoded integer representing the share quantity in the protocol’s accounting system.

Sample Data

No sample data available.

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.tokemak_v2_ethereum.LMPVault_withdraw_function`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

​Tables

​AutopoolETH_AddedToRemovalQueue_event

​AutopoolETH_Approval_event

​AutopoolETH_Deposit_event

​AutopoolETH_deposit_function

​AutopoolETH_DestinationDebtReporting_event

​AutopoolETH_DestinationVaultAdded_event

​AutopoolETH_DestinationVaultRemoved_event

​AutopoolETH_FeeCollected_event

​AutopoolETH_flashRebalance_function

​AutopoolETH_initialize_function

​AutopoolETH_Initialized_event

​AutopoolETH_Nav_event

​AutopoolETH_Paused_event

​AutopoolETH_PeriodicFeeCollected_event

​AutopoolETH_permit_function

​AutopoolETH_recover_function

​AutopoolETH_redeem_function

​AutopoolETH_RemovedFromRemovalQueue_event

​AutopoolETH_RewarderSet_event

​AutopoolETH_Shutdown_event

​AutopoolETH_StreamingFeeSet_event

​AutopoolETH_SymbolAndDescSet_event

​AutopoolETH_TokensPulled_event

​AutopoolETH_TokensRecovered_event

​AutopoolETH_Transfer_event

​AutopoolETH_Unpaused_event

​AutopoolETH_Withdraw_event

​AutopoolETH_withdraw_function

​AutopoolETH_WithdrawalQueueSet_event

​AutopoolRegistry_VaultAdded_event

​LMPVault_Deposit_event

​LMPVault_deposit_function

​LMPVault_DestinationDebtReporting_event

​LMPVault_DestinationVaultAdded_event

​LMPVault_DestinationVaultRemoved_event

​LMPVault_FeeCollected_event

​LMPVault_flashRebalance_function

​LMPVault_initialize_function

​LMPVault_Nav_event

​LMPVault_NewNavShareFeeMark_event

​LMPVault_PeriodicFeeCollected_event

​LMPVault_permit_function

​LMPVault_recover_function

​LMPVault_redeem_function

​LMPVault_RewarderSet_event

​LMPVault_RewarderSet2_event

​LMPVault_TokensPulled_event

​LMPVault_TokensRecovered_event

​LMPVault_Withdraw_event

​LMPVault_withdraw_function

Tables

AutopoolETH_AddedToRemovalQueue_event

AutopoolETH_Approval_event

AutopoolETH_Deposit_event

AutopoolETH_deposit_function

AutopoolETH_DestinationDebtReporting_event

AutopoolETH_DestinationVaultAdded_event

AutopoolETH_DestinationVaultRemoved_event

AutopoolETH_FeeCollected_event

AutopoolETH_flashRebalance_function

AutopoolETH_initialize_function

AutopoolETH_Initialized_event

AutopoolETH_Nav_event

AutopoolETH_Paused_event

AutopoolETH_PeriodicFeeCollected_event

AutopoolETH_permit_function

AutopoolETH_recover_function

AutopoolETH_redeem_function

AutopoolETH_RemovedFromRemovalQueue_event

AutopoolETH_RewarderSet_event

AutopoolETH_Shutdown_event

AutopoolETH_StreamingFeeSet_event

AutopoolETH_SymbolAndDescSet_event

AutopoolETH_TokensPulled_event

AutopoolETH_TokensRecovered_event

AutopoolETH_Transfer_event

AutopoolETH_Unpaused_event

AutopoolETH_Withdraw_event

AutopoolETH_withdraw_function

AutopoolETH_WithdrawalQueueSet_event

AutopoolRegistry_VaultAdded_event

LMPVault_Deposit_event

LMPVault_deposit_function

LMPVault_DestinationDebtReporting_event

LMPVault_DestinationVaultAdded_event

LMPVault_DestinationVaultRemoved_event

LMPVault_FeeCollected_event

LMPVault_flashRebalance_function

LMPVault_initialize_function

LMPVault_Nav_event

LMPVault_NewNavShareFeeMark_event

LMPVault_PeriodicFeeCollected_event

LMPVault_permit_function

LMPVault_recover_function

LMPVault_redeem_function

LMPVault_RewarderSet_event

LMPVault_RewarderSet2_event

LMPVault_TokensPulled_event

LMPVault_TokensRecovered_event

LMPVault_Withdraw_event

LMPVault_withdraw_function