dodo_v2_ethereum

Tables

Mine_Claim_event

Mining reward claim events recording user withdrawals from liquidity mining programs. Captures claimed reward amounts and user addresses for tracking incentive distributions across DODO protocol versions.

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_i`	`STRING`	Index or identifier parameter used in protocol operations. Numeric string representing a position, rate, or configuration value.
`in_user`	`STRING`	Address of the user account associated with the transaction or protocol operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_reward`	`STRING`	Contract address of the reward token being distributed or claimed. Hex-encoded, 0x-prefixed, 42-character string.

Sample Data

address	in_user	removed	in_reward	log_index	block_number	block_timestamp	transaction_hash
0x1a4f8705e1c0428d020e1558a371b7e6134455a2	0xa5d62640081d2a1bc5ded398f2aa5ac6e463746b	false	2983106045708020216013	165	15678511	2022-10-05T01:03:59.000Z	0x04ade87014976f41f3a708111ab6409f43d6c062e20450b06b817e7b3590e7e7
0x1a4f8705e1c0428d020e1558a371b7e6134455a2	0xd3fc8f66cade1003b2d40f647d3ecb5a0c2331f3	false	158917090477207425166	42	15684797	2022-10-05T22:10:11.000Z	0xc7b58d60df9786378fe02e36e4c666a357daf3507b4770d4ad37e226115b7409
0x1a4f8705e1c0428d020e1558a371b7e6134455a2	0x258d9aef9184d9e21f9b882e243c42fac1466a59	false	1077135364847591363373	41	14330565	2022-03-06T02:09:23.000Z	0xc17524bd7ae01c43380f1be1be57f6900f6a91fa594fe569ecfa9c8c9d8c93ef

Example Query

Query with partition filter

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

PrivatePool_DODOSwap_event

DODOSwap event logs from DODO v2 private pool contracts recording token exchanges. Contains trader address, source and destination token addresses with amounts, and receiver address for tracking decentralized exchange swaps.

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_fromToken`	`STRING`	Contract address of the source token being swapped. Hex-encoded, 0x-prefixed, 42-character string.
`in_toToken`	`STRING`	Contract address of the destination token being received in the swap. Hex-encoded, 0x-prefixed, 42-character string.
`in_fromAmount`	`STRING`	Amount of tokens being swapped from the source token. String-encoded integer value representing the quantity in the smallest unit of the token.
`in_toAmount`	`STRING`	Amount of tokens received from the swap to the destination token. String-encoded integer value representing the quantity in the smallest unit of the token.
`in_trader`	`STRING`	Address that initiated or executed the trade transaction. 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.

Sample Data

address	removed	in_trader	log_index	in_toToken	in_receiver	in_toAmount	block_number	in_fromToken	in_fromAmount	block_timestamp	transaction_hash
0x9efe8abd830f1d2062fdcc38f53349db008fe7dc	false	0x3208684f96458c540eb08f6f01b9e9afb2b7d4f0	141	0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2	0x3208684f96458c540eb08f6f01b9e9afb2b7d4f0	47102857718389023	18145387	0x112b08621e27e10773ec95d250604a041f36c582	155853472725	2023-09-16T01:14:35.000Z	0x3db4cdb1690b107fdca1801762bfbe7c61ca5e5dc8f4585e331542a41d9a736e
0x9efe8abd830f1d2062fdcc38f53349db008fe7dc	false	0x3208684f96458c540eb08f6f01b9e9afb2b7d4f0	81	0x112b08621e27e10773ec95d250604a041f36c582	0x1111111254eeb25477b68fb85ed929f73a960582	115389032052	18147212	0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2	34693750000000000	2023-09-16T07:23:47.000Z	0x896ecf9ecbc49c5162b582f35bc526ba4c7638ccd3f023b27d3e1f18d9004bec
0x32a4425b0246100a526fc94865620e00af05ae2f	false	0xdb38ae75c5f44276803345f7f02e95a0aeef5944	64	0xca0e7269600d353f70b14ad118a49575455c0f2f	0xdb38ae75c5f44276803345f7f02e95a0aeef5944	37702804752177750497085	12272141	0xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb48	3016827885	2021-04-19T18:35:55.000Z	0x3b5974277f5c1d1c25bca17384866577125ef7076abd27aa1a326594059e401b

Example Query

Query with partition filter

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

PrivatePool_LpFeeRateChange_event

Liquidity provider (LP) fee rate adjustment events emitted by DODO V2 private pool contracts. Captures new fee rate values applied to LP positions within private pools for fee structure tracking.

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_newLpFeeRate`	`STRING`	New liquidity provider fee rate set by the pool update. String-encoded integer representing the fee rate in basis points or wei-denominated fractional units.

Sample Data

address	removed	log_index	block_number	block_timestamp	in_newLpFeeRate	transaction_hash
0x2c22477cf2cd255d0a6cbddb4675453248bdf466	false	268	16098079	2022-12-02T15:40:23.000Z	0	0xc3e64aebdc946aac1a4771949fda6f72e0cfd3a431fcdacbabe17eebcc5da24c
0xd53dd744d09bf92d5f9ee2fbd39f0e23204c3b6e	false	127	16097056	2022-12-02T12:14:47.000Z	0	0xde2c7017c5b58c629bb13adf204daa34adf62fb97cd47723e3be099eee77ca78
0x6e94fddbb7ab473fbf684f882a7a1a5e042b481c	false	71	13316169	2021-09-28T19:34:29.000Z	2400000000000000	0xa01cc7aa5bae262a1a11d4ae61a85304b1af6c7e4dde7fafc7103c5302dd3cba

Example Query

Query with partition filter

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

PrivatePoolFactory_createDODOPrivatePool_function

Private pool deployment transactions from DODO v2’s PrivatePoolFactory contract on Ethereum, capturing creator addresses and newly created pool contract addresses. Used for tracking DODO private pool creation activity and analyzing liquidity provisioning 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.
`out_newPrivatePool`	`STRING`	Contract address of the newly created DODO private pool deployed by this factory function call. Hex-encoded, 0x-prefixed 40-character Ethereum address uniquely identifying each pool instance.

Sample Data

gas	status	gas_used	signature	to_address	block_number	from_address	block_timestamp	transaction_hash	out_newPrivatePool
660485	true	47002	0x09b8adb8	0x5336ede8f971339f6c0e304c66ba16f1296a2fbe	16565654	0xff7c8f518e6f1435957ed3d3e0692c94676dae7a	2023-02-05T22:45:47.000Z	0x1d18f99bbcb3597f3e16b1427b2e65c028b6ba131808ea69e58e251cb6c8f12b	0xf8073b40e05ef0b6d60cd13e865ad651d54ad602
645243	true	47006	0x09b8adb8	0x5336ede8f971339f6c0e304c66ba16f1296a2fbe	23206292	0xff7c8f518e6f1435957ed3d3e0692c94676dae7a	2025-08-23T20:52:35.000Z	0x087d91f3fdaf92894af14c2c464674da0edcc53aae8f2ff4b8c4bd3950e49e83	0xb23c9f37514211ed361a215bad43663778f6923a
849604	true	47006	0x09b8adb8	0x5336ede8f971339f6c0e304c66ba16f1296a2fbe	21881200	0xff7c8f518e6f1435957ed3d3e0692c94676dae7a	2025-02-19T15:06:23.000Z	0x86b4e387304e8253f228edaf0f3e1140d16445dae7c2334f6e1ff2538d05aca0	0x335f2c13dc0656a29d38d17dd010a44b1121617c

Example Query

Query with partition filter

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

PrivatePoolFactory_NewDPP_event

DODO V2 private pool creation events emitted when a new DPP (DODO Private Pool) is deployed via the PrivatePoolFactory contract. Records pool creator address, base/quote token pair, and deployed pool contract address for tracking custom liquidity pool instantiation.

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_baseToken`	`STRING`	Contract address of the base token in a trading pair. Hex-encoded, 0x-prefixed, 42-character string.
`in_quoteToken`	`STRING`	Contract address of the quote token in a trading pair. Hex-encoded, 0x-prefixed, 42-character string.
`in_creator`	`STRING`	Address of the account that initiated the creation event. Hex-encoded, 0x-prefixed, 42-character string.
`in_dpp`	`STRING`	Contract address of the DODO Private Pool (DPP) created by the factory. Hex-encoded, 0x-prefixed, 42-character string.

Sample Data

in_dpp	address	removed	log_index	in_creator	block_number	in_baseToken	in_quoteToken	block_timestamp	transaction_hash
0x23caccbb8c2509a88a32c48b7a903d3d779f3187	0x5336ede8f971339f6c0e304c66ba16f1296a2fbe	false	283	0x2bfd8833dce4a1fdbe6aa4f132f0e412cf001c7f	17538943	0xdac17f958d2ee523a2206206994597c13d831ec7	0x905f06debcd355809c0eabe2abc1332a5c7159cd	2023-06-23T01:13:23.000Z	0x5dec34ca9d042e377bdb4f48d4ae7a1caa1d6b5b6ca755df644445dc5944607e
0xf8073b40e05ef0b6d60cd13e865ad651d54ad602	0x5336ede8f971339f6c0e304c66ba16f1296a2fbe	false	217	0x69283ff7a80868ebdf5d38ef5a6bc37e7bfbac5f	16565654	0xdac17f958d2ee523a2206206994597c13d831ec7	0xe346c1d7d4a36e4a79f91401d1d18e0c454edda0	2023-02-05T22:45:47.000Z	0x1d18f99bbcb3597f3e16b1427b2e65c028b6ba131808ea69e58e251cb6c8f12b
0xa224f2e653f22145599f46f2368e1acdbec9b941	0x5336ede8f971339f6c0e304c66ba16f1296a2fbe	false	153	0x4461d605a73f4f0ea2d52b89c8b36ec78d7f56fd	15652694	0xdac17f958d2ee523a2206206994597c13d831ec7	0xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb48	2022-10-01T10:24:11.000Z	0xf84c8971cc440419e0cfd2137167417541a371d371a572e668cbd3e2b87f557c

Example Query

Query with partition filter

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

RouteProxy_OrderHistory_event

Order execution records from DODO V2’s RouteProxy contract on Ethereum, capturing token swaps with input/output amounts and token addresses. Used for analyzing DEX trading volume, token pair liquidity routing, and user swap 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.
`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_fromToken`	`STRING`	Contract address of the source token being swapped. Hex-encoded, 0x-prefixed, 42-character string.
`in_toToken`	`STRING`	Contract address of the destination token being received in the swap. Hex-encoded, 0x-prefixed, 42-character string.
`in_sender`	`STRING`	Address that initiated the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_fromAmount`	`STRING`	Amount of tokens being swapped from the source token. String-encoded integer value representing the quantity in the smallest unit of the token.
`in_returnAmount`	`STRING`	Actual amount of destination tokens received from the swap. Numeric string representation of token quantity in smallest denomination.

Sample Data

address	removed	in_sender	log_index	in_toToken	block_number	in_fromToken	in_fromAmount	block_timestamp	in_returnAmount	transaction_hash
0xa2398842f37465f89540430bdc00219fa9e4d28a	false	0x87013f055b698337d5abc3dd695dc89637f44514	166	0x090185f2135308bad17527004364ebcc2d37e5f6	13220273	0xeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeee	195930885943524152	2021-09-13T23:09:59.000Z	499555311730863504519204	0xdc57a8f7c509b56591205a329cdd7e6ab23ddf555838ba882285887570c4fe1c
0xa2398842f37465f89540430bdc00219fa9e4d28a	false	0x87013f055b698337d5abc3dd695dc89637f44514	143	0x090185f2135308bad17527004364ebcc2d37e5f6	13220368	0xeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeee	80000000000000000	2021-09-13T23:30:43.000Z	202416350299536841488928	0x2faf26ef84bfd090a0ce092941ea0c8648dd4e2cb7ccfd22acf080694d553402
0xa2398842f37465f89540430bdc00219fa9e4d28a	false	0x9f0e54570933ebf5f9ee496c09cde54ba4cfefc9	347	0x090185f2135308bad17527004364ebcc2d37e5f6	13214087	0xeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeee	30000000000000000	2021-09-13T00:02:47.000Z	82729938086835869646313	0xeb35e1a866b6d0031c6f723c5b66d45fab2a76492c51f4a2b1eb4fd6b7a912ed

Example Query

Query with partition filter

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

StablePool_DODOSwap_event

Token swap events emitted by DODO StablePool contracts containing trader address, source and destination token addresses, input and output amounts, and receiver address. Used for tracking stableswap trades and liquidity pool activity across DODO’s decentralized exchange 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.
`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_fromToken`	`STRING`	Contract address of the source token being swapped. Hex-encoded, 0x-prefixed, 42-character string.
`in_toToken`	`STRING`	Contract address of the destination token being received in the swap. Hex-encoded, 0x-prefixed, 42-character string.
`in_fromAmount`	`STRING`	Amount of tokens being swapped from the source token. String-encoded integer value representing the quantity in the smallest unit of the token.
`in_toAmount`	`STRING`	Amount of tokens received from the swap to the destination token. String-encoded integer value representing the quantity in the smallest unit of the token.
`in_trader`	`STRING`	Address that initiated or executed the trade transaction. 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.

Sample Data

address	removed	in_trader	log_index	in_toToken	in_receiver	in_toAmount	block_number	in_fromToken	in_fromAmount	block_timestamp	transaction_hash
0x3058ef90929cb8180174d74c507176cca6835d73	false	0x1136b25047e142fa3018184793aec68fbb173ce4	265	0xdac17f958d2ee523a2206206994597c13d831ec7	0x1136b25047e142fa3018184793aec68fbb173ce4	101098974886	17402649	0x6b175474e89094c44da98b954eedeac495271d0f	101133248517131497082118	2023-06-03T20:55:23.000Z	0x0fb259ca88dbed8856072a0b724a269edbecb01a578ac3a1f0cdeeee5fd528c7
0x3058ef90929cb8180174d74c507176cca6835d73	false	0x23ebcd701fd92867235aeb0174b7c444b9b2b3ad	80	0xdac17f958d2ee523a2206206994597c13d831ec7	0x23ebcd701fd92867235aeb0174b7c444b9b2b3ad	9780844415	17400372	0x6b175474e89094c44da98b954eedeac495271d0f	9783632888791489942366	2023-06-03T13:11:35.000Z	0xfb12cbb5405d50957fa0f46bf04fb9a447346c8356de6f94474848acfb1193c6
0x3058ef90929cb8180174d74c507176cca6835d73	false	0x56bd269db96a089295d742351ba459fb0c279fe2	158	0xdac17f958d2ee523a2206206994597c13d831ec7	0x3b3ae790df4f312e745d270119c6052904fb6790	11312363563	17400381	0x6b175474e89094c44da98b954eedeac495271d0f	11429744332652121654828	2023-06-03T13:13:23.000Z	0xeb87c7f74f55bd5b278b2c039022502a8d315fef659929eed4ef735e109f9e81

Example Query

Query with partition filter

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

StablePoolFactory_createDODOStablePool_function

Function call records for creating DODO v2 stable pools with base/quote token pairs, liquidity provider fee rates, and price curve parameters (k, i). Returns the deployed stable pool contract address for tracking new pool deployments on the DODO decentralized exchange.

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_baseToken`	`STRING`	Contract address of the base token in a trading pair. Hex-encoded, 0x-prefixed, 42-character string.
`in_quoteToken`	`STRING`	Contract address of the quote token in a trading pair. Hex-encoded, 0x-prefixed, 42-character string.
`in_lpFeeRate`	`STRING`	Liquidity provider fee rate charged on trades in the pool. Numeric string representing the fee as a fraction with 18 decimal places.
`in_i`	`STRING`	Index or identifier parameter used in protocol operations. Numeric string representing a position, rate, or configuration value.
`in_k`	`STRING`	K parameter controlling price curve slope in DODO protocol pools. Numeric string representing the slippage coefficient where higher values indicate steeper bonding curves.
`in_isOpenTWAP`	`BOOL`	Boolean flag indicating whether Time-Weighted Average Price (TWAP) oracle is enabled for the pool.
`out_newStablePool`	`STRING`	Contract address of the newly created stable pool. Hex-encoded, 0x-prefixed, 42-character string.

Sample Data

gas	in_i	in_k	status	gas_used	signature	to_address	block_number	from_address	in_baseToken	in_lpFeeRate	in_isOpenTWAP	in_quoteToken	block_timestamp	transaction_hash	out_newStablePool
596593	85000000000000	2000000000000000	true	362304	0xcf5c2f10	0x6fddb76c93299d985f4d3fc7ac468f9a168577a4	19060119	0x4599ed18f34cfe06820e3684bf0aacb8d75c644d	0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2	24000000000000000	false	0x15d4c048f83bd7e37d49ea4c83a07267ec4203da	2024-01-22T05:11:35.000Z	0x982d7d22554c8f823274c2522a759ae49835c758e101d68a2ca16568723d58bc	0xb0c9cba2c8fc298c7e0a915ba6273a8ad250b10b
596593	84095038315771	100000000000000	true	362304	0xcf5c2f10	0x6fddb76c93299d985f4d3fc7ac468f9a168577a4	19064455	0x4599ed18f34cfe06820e3684bf0aacb8d75c644d	0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2	48000000000000000	false	0x15d4c048f83bd7e37d49ea4c83a07267ec4203da	2024-01-22T19:52:59.000Z	0xa1df2cbd185cba2ddadcfc25c0955ae85e9beb8944cd393ee6923e830c7c8ef0	0xe1bc99fd2a8e5a05e9fb0b8086f3bb58f7d1a5b3
659611	125000000000000000000000	100000000000000000	true	396504	0xcf5c2f10	0x6fddb76c93299d985f4d3fc7ac468f9a168577a4	22015242	0x5245f5e66792cfbacb64efaef3121e7c5ccd879b	0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2	80000000000000000	false	0xed328e9c1179a30ddc1e7595e036aed8760c22af	2025-03-10T08:20:47.000Z	0xe0a488db7ad37c7b9cd54fcf3d4be6ef738eb72c9ab84146a3b3bad3d2810ffd	0xeaf51b028f209e65f4ca06c463d280ca520e1754

Example Query

Query with partition filter

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

StablePoolFactory_NewDSP_event

DODO v2 StablePoolFactory event emitted when a new DSP (DODO Stable Pool) is created, containing the deployed pool contract address, base and quote token addresses, and creator address. Used for tracking stable swap pool deployments across DODO DEX instances.

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_baseToken`	`STRING`	Contract address of the base token in a trading pair. Hex-encoded, 0x-prefixed, 42-character string.
`in_quoteToken`	`STRING`	Contract address of the quote token in a trading pair. Hex-encoded, 0x-prefixed, 42-character string.
`in_creator`	`STRING`	Address of the account that initiated the creation event. Hex-encoded, 0x-prefixed, 42-character string.
`in_DSP`	`STRING`	Contract address of the DODO Stable Pool (DSP) created by the factory. Hex-encoded, 0x-prefixed, 42-character string.

Sample Data

in_DSP	address	removed	log_index	in_creator	block_number	in_baseToken	in_quoteToken	block_timestamp	transaction_hash
0xaa89cab926dcd65b3779aa98d9342fd9a21e5d1c	0x6fddb76c93299d985f4d3fc7ac468f9a168577a4	false	313	0x16cc37d06fe5061cd0023fb8d142abaabb396a2b	13528955	0xca37530e7c5968627be470081d1c993eb1deaf90	0xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb48	2021-11-01T04:00:51.000Z	0x76f37b2a5fcd4b99c9f5ad4c5e3a4f861c6f0ae006dbe27735302ffab18ae712
0x5fd666a28c7e8f36c43ea3df31aeb3f69054b99e	0x6fddb76c93299d985f4d3fc7ac468f9a168577a4	false	599	0x16cc37d06fe5061cd0023fb8d142abaabb396a2b	13528747	0xca37530e7c5968627be470081d1c993eb1deaf90	0xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb48	2021-11-01T03:15:10.000Z	0x66bbf8073b7c5a208f9900ca7a5541284b0bd663f3dfabd9bf7f6f6dd51a8fb5
0x6d0806dfa6ab5bf8e96defa42244b3ce9f62e920	0x6fddb76c93299d985f4d3fc7ac468f9a168577a4	false	79	0xc87074b6f694bda13b565db9eb7269ad53acd39a	12605452	0xdef5ac7f333017de75cc9d8f75f46cf678a795a9	0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2	2021-06-10T07:35:52.000Z	0xf93f23fcf13f306d4e07660320b479d7d618e4b3e21010541babeb3675031418

Example Query

Query with partition filter

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

VendingMachine_DODOSwap_event

DODOSwap token swap events from DODO V2 vending machine contracts containing trader address, source and destination token addresses, swap amounts, and recipient. Used for DEX trade volume analysis and liquidity tracking across token pairs.

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_fromToken`	`STRING`	Contract address of the source token being swapped. Hex-encoded, 0x-prefixed, 42-character string.
`in_toToken`	`STRING`	Contract address of the destination token being received in the swap. Hex-encoded, 0x-prefixed, 42-character string.
`in_fromAmount`	`STRING`	Amount of tokens being swapped from the source token. String-encoded integer value representing the quantity in the smallest unit of the token.
`in_toAmount`	`STRING`	Amount of tokens received from the swap to the destination token. String-encoded integer value representing the quantity in the smallest unit of the token.
`in_trader`	`STRING`	Address that initiated or executed the trade transaction. 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.

Sample Data

address	removed	in_trader	log_index	in_toToken	in_receiver	in_toAmount	block_number	in_fromToken	in_fromAmount	block_timestamp	transaction_hash
0x22591994bc89174a5bdcec57c82c881b65f9b121	false	0xa0df3428ce64a481e3e4c791b64ad9c02b0c8518	27	0xd502f487e1841fdc805130e13eae80c61186bc98	0x0120b5473cc9b28321a8f6e712cb5b4d2df32b31	22849027306074644926132	14483131	0xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb48	2360085244	2022-03-29T19:56:42.000Z	0x3dd96a0590aed4c726aedb7ef9bd537d65dfb987a435a308079bd6ce9c861137
0xc8d5a3c04b99f8511435f2aa4d7215508154a7a9	false	0x2057cfb9fd11837d61b294d514c5bd03e5e7189a	78	0x903bef1736cddf2a537176cf3c64579c3867a881	0x1111111254fb6c44bac0bed2854e76f90643097d	35775880807	14481816	0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2	763196674371942369	2022-03-29T15:07:40.000Z	0x6793e18c49ea5ec95835e027d4ee28f94ca16f5ab5b6ec66ef265299f78a02c8
0x22591994bc89174a5bdcec57c82c881b65f9b121	false	0x220bda5c8994804ac96ebe4df184d25e5c2196d4	70	0xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb48	0x1111111254fb6c44bac0bed2854e76f90643097d	7107850861	14484018	0xd502f487e1841fdc805130e13eae80c61186bc98	67878179258000000000000	2022-03-29T23:12:36.000Z	0x0d4b6775a0c2b130b5d17f9e83f0039fba767659aa9d9b4e46703fe59f991638

Example Query

Query with partition filter

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

VendingMachineFactory_createDODOVendingMachine_function

Factory function calls for creating DODO V2 vending machine liquidity pools. Records pool deployment parameters including base/quote token pairs, pricing curve configuration (k parameter), LP fee rates, and TWAP oracle settings, returning the deployed pool contract address.

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_baseToken`	`STRING`	Contract address of the base token in a trading pair. Hex-encoded, 0x-prefixed, 42-character string.
`in_quoteToken`	`STRING`	Contract address of the quote token in a trading pair. Hex-encoded, 0x-prefixed, 42-character string.
`in_lpFeeRate`	`STRING`	Liquidity provider fee rate charged on trades in the pool. Numeric string representing the fee as a fraction with 18 decimal places.
`in_i`	`STRING`	Index or identifier parameter used in protocol operations. Numeric string representing a position, rate, or configuration value.
`in_k`	`STRING`	K parameter controlling price curve slope in DODO protocol pools. Numeric string representing the slippage coefficient where higher values indicate steeper bonding curves.
`in_isOpenTWAP`	`BOOL`	Boolean flag indicating whether Time-Weighted Average Price (TWAP) oracle is enabled for the pool.
`out_newVendingMachine`	`STRING`	Contract address of the newly created DODO vending machine pool. Hex-encoded, 0x-prefixed, 42-character string.

Sample Data

gas	in_i	in_k	status	gas_used	signature	to_address	block_number	from_address	in_baseToken	in_lpFeeRate	in_isOpenTWAP	in_quoteToken	block_timestamp	transaction_hash	out_newVendingMachine
605811	14700000000000000	50000000000000000	true	386656	0xe18c40c7	0x72d220ce168c4f361dd4dee5d826a01ad8598f6c	20509465	0xa356867fdcea8e71aeaf87805808803806231fdc	0x2f7b618993cc3848d6c7ed9cdd5e835e4fe22b98	2400000000000000	false	0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2	2024-08-12T02:10:35.000Z	0x23803d7fc4ba2e9779a9cc19715c45f2d62e0ec64375ed4ff6f0d661edb57fec	0xc675b21b9aaac783e53fcd63a0bab3e42784c947
590488	147258369000000000000000000	50000000000000000	true	379468	0xe18c40c7	0x72d220ce168c4f361dd4dee5d826a01ad8598f6c	20509343	0xa356867fdcea8e71aeaf87805808803806231fdc	0xfca47962d45adfdfd1ab2d972315db4ce7ccf094	2400000000000000	false	0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2	2024-08-12T01:46:11.000Z	0x757a834b9088ed2414c9447189d59a3a8b748b056c455c915527665a07d9665e	0x69a35050982d11e9968fa38a825f205bc634343c
607687	3690000000000000	50000000000000000	true	396519	0xe18c40c7	0x72d220ce168c4f361dd4dee5d826a01ad8598f6c	20509278	0xa356867fdcea8e71aeaf87805808803806231fdc	0x16b0a1a87ae8af5c792fabc429c4fe248834842b	2400000000000000	false	0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2	2024-08-12T01:33:11.000Z	0xf9a29ddb3a92be0d3dc05213d78b84e3d3d5dda4504c0ae5553b123b23b4ea5e	0x2c89bf4e9896ab9500351d8c17fd718831b8b2e2

Example Query

Query with partition filter

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

VendingMachineFactory_NewDVM_event

DODO Vending Machine (DVM) liquidity pool creation events emitted when a new trading pair is deployed. Records creator address, base/quote token addresses, and deployed DVM contract address for tracking pool deployments across DODO V2 exchanges.

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_baseToken`	`STRING`	Contract address of the base token in a trading pair. Hex-encoded, 0x-prefixed, 42-character string.
`in_quoteToken`	`STRING`	Contract address of the quote token in a trading pair. Hex-encoded, 0x-prefixed, 42-character string.
`in_creator`	`STRING`	Address of the account that initiated the creation event. Hex-encoded, 0x-prefixed, 42-character string.
`in_dvm`	`STRING`	Contract address of the DVM (DODO Vending Machine) pool created by the factory. Hex-encoded, 0x-prefixed, 42-character string.

Sample Data

in_dvm	address	removed	log_index	in_creator	block_number	in_baseToken	in_quoteToken	block_timestamp	transaction_hash
0xef5d36cff77ed9ac8b59544e8108bddca0f5f774	0x72d220ce168c4f361dd4dee5d826a01ad8598f6c	false	433	0xaf1e094df4b9f2ee00797a9c1d0d31b8a09333fd	12456155	0xe31861a693b6fc14b7ef8da8e1ae3edeb4e27845	0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2	2021-05-18T04:13:43.000Z	0x9121a2785714a9204151126471fe8befaa7e6ecb887794ec88d4e3256bae4e2e
0x7af1d714645548d0190c0d85afd7d33bd2d61e93	0x72d220ce168c4f361dd4dee5d826a01ad8598f6c	false	237	0xaab474702cee4dc0784d8091fe1cc139d5389214	17637541	0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2	0x32b86b99441480a7e5bd3a26c124ec2373e3f015	2023-07-06T21:41:35.000Z	0xefd4cbb2656ae93d50a6647086f80707b6ab542a019608060ca1c7c5c0a0ba18
0xd7702549918a57ff296ea5236870c66801319c14	0x72d220ce168c4f361dd4dee5d826a01ad8598f6c	false	245	0xa23f148c5733ff213f7608cd3288b933a4467211	18349841	0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2	0x485d17a6f1b8780392d53d64751824253011a260	2023-10-14T16:34:11.000Z	0xdb3b8661abf5a5195d3fe1f9e3830914c56a852032a8b34c3d4ddd20c4fd4daf

Example Query

Query with partition filter

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

Metrics

Primitives

Contracts

Blockchain

Tables

Mine_Claim_event

PrivatePool_DODOSwap_event

PrivatePool_LpFeeRateChange_event

PrivatePoolFactory_createDODOPrivatePool_function

PrivatePoolFactory_NewDPP_event

RouteProxy_OrderHistory_event

StablePool_DODOSwap_event

StablePoolFactory_createDODOStablePool_function

StablePoolFactory_NewDSP_event

VendingMachine_DODOSwap_event

VendingMachineFactory_createDODOVendingMachine_function

VendingMachineFactory_NewDVM_event

Metrics

Primitives

Contracts

Blockchain

​Tables

​Mine_Claim_event

​PrivatePool_DODOSwap_event

​PrivatePool_LpFeeRateChange_event

​PrivatePoolFactory_createDODOPrivatePool_function

​PrivatePoolFactory_NewDPP_event

​RouteProxy_OrderHistory_event

​StablePool_DODOSwap_event

​StablePoolFactory_createDODOStablePool_function

​StablePoolFactory_NewDSP_event

​VendingMachine_DODOSwap_event

​VendingMachineFactory_createDODOVendingMachine_function

​VendingMachineFactory_NewDVM_event

Tables

Mine_Claim_event

PrivatePool_DODOSwap_event

PrivatePool_LpFeeRateChange_event

PrivatePoolFactory_createDODOPrivatePool_function

PrivatePoolFactory_NewDPP_event

RouteProxy_OrderHistory_event

StablePool_DODOSwap_event

StablePoolFactory_createDODOStablePool_function

StablePoolFactory_NewDSP_event

VendingMachine_DODOSwap_event

VendingMachineFactory_createDODOVendingMachine_function

VendingMachineFactory_NewDVM_event