dodo_v2_bsc

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
0x322b43e406d1b4df9bc36d058317dd1cd3b0385f	0x84dc05fbd40eadaa8f1065714cbf920fda3c0c41	false	85363075014607422277	1297	14789595	2022-01-29T13:21:05.000Z	0x8d1e67330e28e8f0e40a4e781510e2f182f580b83707e6c53af40a19b37e001c
0x322b43e406d1b4df9bc36d058317dd1cd3b0385f	0x5e3b3dee2912063294b71af0a327fb285b49e07a	false	23558014250568528000	287	14781114	2022-01-29T06:16:39.000Z	0x27ef72a5b64abde029bf3e9102828b454d89955ab11e8d25bb00694e2417d8d9
0x322b43e406d1b4df9bc36d058317dd1cd3b0385f	0x27d4193fe8ba4db5a47eff08423b42eebd77b786	false	461567918007487552124	814	14781105	2022-01-29T06:16:12.000Z	0xdc5db4d9ec2be282a66b915afde983f2711f90c356831a9b43fe8471dacdedc9

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.dodo_v2_bsc.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
0x9ba8966b706c905e594acbb946ad5e29509f45eb	false	0xab623fbcaeb522046185051911209f5b2c2a2e1f	11	0x2170ed0880ac9a755fd29b2688956bd959f933f8	0x345e85a2bfb732634ab0747d31b472102a54acdd	43811170742774722	7831449	0xe9e7cea3dedca5984780bafc599bd69add087d56	104777718119829320141	2021-05-29T12:56:24.000Z	0x293114430f3327919c23ad077b4fe6b72154e14630b8c0fc675273e149bfdc3e
0x9ba8966b706c905e594acbb946ad5e29509f45eb	false	0xc603a00595d5f8ea8d93c5c338c00ff29dba6258	71	0x2170ed0880ac9a755fd29b2688956bd959f933f8	0x04253ab3ff54d2e03b717bf6810a0a2fd228365a	504169004340984941	7842657	0xe9e7cea3dedca5984780bafc599bd69add087d56	1141173570427729281339	2021-05-29T22:20:24.000Z	0x21c940b4d834484f8b4905a3477346cd75de917edf4556e025ce9bb99f259807
0x9ba8966b706c905e594acbb946ad5e29509f45eb	false	0xc603a00595d5f8ea8d93c5c338c00ff29dba6258	329	0x2170ed0880ac9a755fd29b2688956bd959f933f8	0xa0c3ef24414ed9c9b456740128d8e63d016a9e11	710321266456504729	7839208	0xe9e7cea3dedca5984780bafc599bd69add087d56	1590000000000000000000	2021-05-29T19:26:52.000Z	0xe97ef5ea9aaea430b21c2bd986618c6ef99f37624aed3fd04a4beb14c880175e

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.dodo_v2_bsc.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
0x26d0c625e5f5d6de034495fbde1f6e9377185618	false	0	22367284	2022-10-21T12:14:02.000Z	2735941463021861	0xd6e8abcc0c6df4d39f8b02ea86f57c403db823f4f3db13433a3248c31e6fb37c
0x0fe261aee0d1c4dfddee4102e82dd425999065f4	false	256	22368603	2022-10-21T13:20:20.000Z	927030000000000	0xdb5ce9130bd6420955b0918047c518cf6ba11c85622a66c3ebc834fbcac9858b
0x9ba8966b706c905e594acbb946ad5e29509f45eb	false	256	22363018	2022-10-21T08:39:36.000Z	750000000000000	0xd9bf018168f6924ceeebf12e118092771326b732861350984d6b7ddaa6f5f646

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.dodo_v2_bsc.PrivatePool_LpFeeRateChange_event`
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
0x8351e66c513372789abfc2b89a70847dfe0b6bcf	0xd9cac3d964327e47399aebd8e1e6dcc4c251daae	false	677	0x432af553927e974bff4b5bfea0a9b86a9a88b530	12836710	0x55d398326f99059ff775485246999027b3197955	0xe9e7cea3dedca5984780bafc599bd69add087d56	2021-11-21T14:55:29.000Z	0x54d7636ed99bff2e332d19d42aed2e29d0c8502ecf3c90149237df1b6e2428e6
0xd09ffc7aacc490648bc40afe8a6d4c4d916e996e	0xd9cac3d964327e47399aebd8e1e6dcc4c251daae	false	1283	0x74a4b2eb449ccf990c4be0d043d8c0bf2014e788	12821775	0xbb4cdb9cbd36b01bd1cbaebf2de08d9173bc095c	0xe859b6a32d953a0ece0027c0fc8575571862c0bb	2021-11-21T02:09:19.000Z	0x3ae5971b9c3d4ede17bf50e80cc73c9e29407f0ab674f904353d4570b3c26a83
0xc2125e54175958b8f2993854397d004f8fa733c7	0xd9cac3d964327e47399aebd8e1e6dcc4c251daae	false	1412	0x74a4b2eb449ccf990c4be0d043d8c0bf2014e788	12821888	0xbb4cdb9cbd36b01bd1cbaebf2de08d9173bc095c	0xf65c1c0478efde3c19b49ecbe7acc57bb6b1d713	2021-11-21T02:15:01.000Z	0xfccb86bef1dba110448a1a07236c4e8c0eca29e45d20ca3160c5ba193f7ff1be

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.dodo_v2_bsc.PrivatePoolFactory_NewDPP_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
0x0dfb71f8d5775f247567ea5a65159fd217b00045	false	0xd18a710afcfe5ab4cc88e033fe165251f9bd4e4a	141	0x05faf555522fa3f93959f86b41a3808666093210	0xd18a710afcfe5ab4cc88e033fe165251f9bd4e4a	274317720607916843099	19124813	0xe9e7cea3dedca5984780bafc599bd69add087d56	234820981140776812544	2022-06-29T23:16:17.000Z	0x84b03e9ad99422fd18b6a6f153109e159b0710c6c7354d61138b56e3d0d4f718
0x0dfb71f8d5775f247567ea5a65159fd217b00045	false	0xd18a710afcfe5ab4cc88e033fe165251f9bd4e4a	255	0x05faf555522fa3f93959f86b41a3808666093210	0xd18a710afcfe5ab4cc88e033fe165251f9bd4e4a	529805172189923693754	19102384	0xe9e7cea3dedca5984780bafc599bd69add087d56	453352954188047843328	2022-06-29T04:32:51.000Z	0x744e6aaf6a594dec28339b3c0f00d84d65ce3c20b45fd597a600fc236490df88
0x0dfb71f8d5775f247567ea5a65159fd217b00045	false	0xd18a710afcfe5ab4cc88e033fe165251f9bd4e4a	154	0x05faf555522fa3f93959f86b41a3808666093210	0xd18a710afcfe5ab4cc88e033fe165251f9bd4e4a	9365969107673130882	19102350	0xe9e7cea3dedca5984780bafc599bd69add087d56	6937314524463950848	2022-06-29T04:31:09.000Z	0xe6fa192b1653194446a91e7424676f0bfb2c7f820211ea2e21966354d35fc1dd

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.dodo_v2_bsc.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`	`NUMERIC`	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
647264	100000000000000000000000000	100000000000000000	true	371400	0xcf5c2f10	0x0fb9815938ad069bf90e14fe6c596c514bede767	9946840	0x2442a8b5cdf1e659f3f949a7e454caa554d4e65a	0xbb4cdb9cbd36b01bd1cbaebf2de08d9173bc095c	80000000000000000	false	0x3bdca8ef7612ad094a10eba77ea73b0da082a226	2021-08-11T20:56:57.000Z	0xe66cb51b93ad0852ac340b8bfc7b601c0286820902fb38572dde79f7e95002b8	0x333d9a04b0932dbc0acdd465ccef6b1f829a9995
1874438	10000000000000000000000	10000000000000000	true	370575	0xcf5c2f10	0x0fb9815938ad069bf90e14fe6c596c514bede767	9949515	0x2442a8b5cdf1e659f3f949a7e454caa554d4e65a	0xa3902e6f17021121390603be54c1719dce19aeb5	400000000000000	false	0x3ee2200efb3400fabb9aacf31297cbdd1d435d47	2021-08-11T23:17:27.000Z	0xe8cafc0854041de43cd67e172ecbd2085f005a9bd22cf7e714d64f5ef8bdd9f9	0x957a095cd4132c6b6973ce7a8afe969e4fdfc6f9
685834	30787779909253585437	100000000000000000	true	396504	0xcf5c2f10	0x0fb9815938ad069bf90e14fe6c596c514bede767	47441190	0x69716e51e3f8bec9c3d4e1bb46396384ae11c594	0xbb4cdb9cbd36b01bd1cbaebf2de08d9173bc095c	80000000000000000	false	0x302cd8973be5ca2334b4ff7e7b01ba41455559b3	2025-03-13T22:33:28.000Z	0xfdae646d179441d9ccf2bcbd6721671549968b60d22051dfebf719be8983736f	0x135461ff98bde690fd4efd6f4e09b622e0f28c89

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.dodo_v2_bsc.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
0xdefeb27e9938cc04b43a2cddcebd3cc9030d0d17	0x0fb9815938ad069bf90e14fe6c596c514bede767	false	269	0x222b38fec42183288d752ed2926a142eec655967	16175706	0xe9e7cea3dedca5984780bafc599bd69add087d56	0x007ec643c7cc33a70c083fc305c283dd009c8b94	2022-03-18T20:06:28.000Z	0xf41f2c95b99713a69758ba06787a7a7ad980d7c8a243bbc0cd4b38ab471c8eaf
0x4508676f138b67cb8142395a6053e611db336113	0x0fb9815938ad069bf90e14fe6c596c514bede767	false	649	0x222b38fec42183288d752ed2926a142eec655967	16177527	0xe9e7cea3dedca5984780bafc599bd69add087d56	0x007ec643c7cc33a70c083fc305c283dd009c8b94	2022-03-18T21:37:37.000Z	0x7f0c1b69db854fb23b7c97e99aaf9a348713d23bfa8a9e046ac092dbf69bd17b
0x09c58f3dc1176b745a00c326198300f289ea5309	0x0fb9815938ad069bf90e14fe6c596c514bede767	false	188	0xff90e2396120659af6d09d651c99386492be3679	16159011	0xe9e7cea3dedca5984780bafc599bd69add087d56	0x1747af98ebf0b22d500014c7dd52985d736337d2	2022-03-18T06:06:44.000Z	0x7abf794189ff2304947d22d7fed8269b11b50702bd5e112757b0ba08fd6bd8ae

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.dodo_v2_bsc.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
0x7f5db76172730d51358dfa560eb8f704220e8c5b	false	0xf9909a4e6c64860af47e3b8de976879832b6ff4b	37	0xe9e7cea3dedca5984780bafc599bd69add087d56	0x58f876857a02d6762e0101bb5c46a8c1ed44dc16	14343505925545018907	23224996	0x0b15ddf19d47e6a86a56148fb4afffc6929bcb89	275125216572590699976	2022-11-20T18:02:46.000Z	0x094e6d4cc30c12d50aa38d2b1329e590fca24fc2e15a38d0892ba641eef792f8
0x7f5db76172730d51358dfa560eb8f704220e8c5b	false	0xbc3dd818affffdc12e9f5f1170ff0d878398980e	236	0xe9e7cea3dedca5984780bafc599bd69add087d56	0xf7fd3edfcd7c3c51f01e06557fa18ff7fb46e0ef	8661888148000787980	23208971	0x0b15ddf19d47e6a86a56148fb4afffc6929bcb89	149142086535255580739	2022-11-20T04:33:21.000Z	0x4c9e8084e64796c9c8f3ac91ca464f2fe499099b0c44f4f38104d62e63637e82
0x6cfbbe153a000043a518cfbb6136e12ff540a161	false	0xbc3dd818affffdc12e9f5f1170ff0d878398980e	434	0x9b71b5511998e0798625b8fa74e86d8192de78c1	0x118e1d1776e5c5e23ff8d6ac618b46b6cc5f44b0	48182126224424736842355	23215678	0x0e09fabb73bd3ade0a17ecc321fd13a19e81ce82	1241123222479719995	2022-11-20T10:12:14.000Z	0x474da28fc587a78c32896dccbb0c02264b44c127d366ea430a6e755c91fe7ee1

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.dodo_v2_bsc.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`	`NUMERIC`	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
579285	5000000000000000000	0	true	374637	0xe18c40c7	0x790b4a80fb1094589a3c0efc8740aa9b0c1733fb	64971006	0x8f8dd7db1bda5ed3da8c9daf3bfa471c12d58486	0x5b0b5c848a843c83c20dcfa25cde6e122898a614	2400000000000000	false	0x55d398326f99059ff775485246999027b3197955	2025-10-17T19:03:24.000Z	0x483b16d5a40a9b9324cdd1241bd3fbc6c7ed0f6374cf85e44110c2fea4300f0b	0xaf3dc64d0e842e2593dbe6ba624623a81789cc3c
548397	5000000000000000000	0	true	340437	0xe18c40c7	0x790b4a80fb1094589a3c0efc8740aa9b0c1733fb	64976994	0x8f8dd7db1bda5ed3da8c9daf3bfa471c12d58486	0x5b0b5c848a843c83c20dcfa25cde6e122898a614	2400000000000000	false	0x55d398326f99059ff775485246999027b3197955	2025-10-17T20:21:44.000Z	0x92228b5f7d3c263b17ddea2bdf08800c4dcbf3af8c5946ecc0bc4782ae246362	0xe716ffa6bba219d843ec405807663293ed938e04
651214	100000	1000000000000000000	true	399106	0xe18c40c7	0x790b4a80fb1094589a3c0efc8740aa9b0c1733fb	64967755	0x8f8dd7db1bda5ed3da8c9daf3bfa471c12d58486	0xb9934b1166e03608a7ec5bcd1764857466b9aef5	2400000000000000	false	0x55d398326f99059ff775485246999027b3197955	2025-10-17T18:22:46.000Z	0x0c5457b7d5379b4360c60a22cdb0354797b775c8e6b2dde080f8385208fc3f8a	0x082b8a63e3e85a6f048a43e0c6bfcf69cd277b1f

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.dodo_v2_bsc.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
0x894bad4826e4736a225324ab1111d49c4e7db85a	0x790b4a80fb1094589a3c0efc8740aa9b0c1733fb	false	252	0xffda6d3b8845e409db2315bd3cd61c33adf99985	30331380	0x217aaeeb3b9da49e5ceeb75ad286f8ff68d0b1ac	0x55d398326f99059ff775485246999027b3197955	2023-07-27T14:32:51.000Z	0xaa93e78efcec34445b911f53ee531027762f05ae0f86e96e9a855409041e33fa
0x1ff3b7ff490b2c6a0ae3846d9739c31f5ad223fc	0x790b4a80fb1094589a3c0efc8740aa9b0c1733fb	false	337	0xffda6d3b8845e409db2315bd3cd61c33adf99985	30331392	0x217aaeeb3b9da49e5ceeb75ad286f8ff68d0b1ac	0x8ac76a51cc950d9822d68b83fe1ad97b32cd580d	2023-07-27T14:33:27.000Z	0x97a94ba3a3b1e73e1c62e8cac84bb08af98f85037949041e89c1367cf625ee80
0xbb4a85b99952bfa36e8887046371f8b09fe0a3c1	0x790b4a80fb1094589a3c0efc8740aa9b0c1733fb	false	141	0xffda6d3b8845e409db2315bd3cd61c33adf99985	30329819	0x217aaeeb3b9da49e5ceeb75ad286f8ff68d0b1ac	0xe9e7cea3dedca5984780bafc599bd69add087d56	2023-07-27T13:14:18.000Z	0x7f8a69aee23351929fde6a90576c4895eb033dcfa95e3240f4dc3523e5c48f22

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.dodo_v2_bsc.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_NewDPP_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_NewDPP_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_NewDPP_event

StablePool_DODOSwap_event

StablePoolFactory_createDODOStablePool_function

StablePoolFactory_NewDSP_event

VendingMachine_DODOSwap_event

VendingMachineFactory_createDODOVendingMachine_function

VendingMachineFactory_NewDVM_event