dodo_v2_base

Tables

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
0x72e663c4e8fd50184c8b8135315c20326cc4ad75	false	0x66c45ff040e86dc613f239123a5e21ffdc3a3fec	11	0x4200000000000000000000000000000000000006	0x987bfbe33c9cf18caa665b792db66339a9c16d32	48913428492348	9082503	0xd9aaec86b65d86f6a7b5b1b0c42ffa531710b6ca	119735	2024-01-11T06:25:53.000Z	0x6d7286738f31ca5e07af4f85510f23824e2287fe7df4ad60e7e1074ee25951b6
0xd804cf0ac2a4b6dd6d375504a27874f5db073625	false	0x66c45ff040e86dc613f239123a5e21ffdc3a3fec	91	0x4200000000000000000000000000000000000006	0x987bfbe33c9cf18caa665b792db66339a9c16d32	51919724238418	9091329	0xd9aaec86b65d86f6a7b5b1b0c42ffa531710b6ca	131408	2024-01-11T11:20:05.000Z	0x9e07d722b7f016efbeaf6a3f87763288f4cd3d10c37c6e6b01cfcb66de57691c
0xd804cf0ac2a4b6dd6d375504a27874f5db073625	false	0x66c45ff040e86dc613f239123a5e21ffdc3a3fec	69	0xd9aaec86b65d86f6a7b5b1b0c42ffa531710b6ca	0x987bfbe33c9cf18caa665b792db66339a9c16d32	11827	9093621	0x4200000000000000000000000000000000000006	4449600000000	2024-01-11T12:36:29.000Z	0x47bbac1b3a532f0f892b39344a62c2a46dff8ced68a1f3a25193e765c0c203ae

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.dodo_v2_base.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
0x1172035a744ea18161497e94f0bbce244d51de9f	false	9	2911743	2023-08-21T10:13:53.000Z	1000000000000000	0xfbf4ba5c0fe37da69e846a437852a52a11776f67709eaee21a27038e29c237fb
0x1172035a744ea18161497e94f0bbce244d51de9f	false	6	2921288	2023-08-21T15:32:03.000Z	1000000000000000	0xdf0365d3c7664c82ee122d600b0a907e58b1c2142e6310477baee792f37f67c4
0x1172035a744ea18161497e94f0bbce244d51de9f	false	2	2910655	2023-08-21T09:37:37.000Z	1000000000000000	0xb6a07ad7de8f9e2418e31f889d6b8204304eadf0c52604b0dad8768600e3c863

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.dodo_v2_base.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
0x1172035a744ea18161497e94f0bbce244d51de9f	0xc0f9553df63de5a97fe64422c8578d0657c360f7	false	9	0xe66eb681394e6ca9e9d2e3dc2d05f5a683439894	2644987	0x4200000000000000000000000000000000000006	0xd9aaec86b65d86f6a7b5b1b0c42ffa531710b6ca	2023-08-15T06:02:01.000Z	0xe7729272857acf6f25d5d54afbecd72567a935eaf381203ca6cd89ba3325a8bc
0x3c388c812dada10e597f802a766e7ce898bc7751	0xc0f9553df63de5a97fe64422c8578d0657c360f7	false	21	0x9dc0b6b56935af5b6327bbae15f4a13adb0bc742	5590030	0x4200000000000000000000000000000000000006	0x78a087d713be963bf307b18f2ff8122ef9a63ae9	2023-10-22T10:10:07.000Z	0x819cb09d12e3026079d6b534aec1dfc3d25d212cb9406115304349bf70cc4b5c
0x72e663c4e8fd50184c8b8135315c20326cc4ad75	0xc0f9553df63de5a97fe64422c8578d0657c360f7	false	8	0x777b5d4790da64e76d26633b0c313047c9741737	8841102	0x4200000000000000000000000000000000000006	0xd9aaec86b65d86f6a7b5b1b0c42ffa531710b6ca	2024-01-05T16:19:11.000Z	0xf2183eea9c4e314eb817f04356964c51a4df42ea48959ab9d078fb2c32ea5bab

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.dodo_v2_base.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
0xd0a7db7d77c2ba70f659f05b76762019dbbb1fd9	false	0x66c45ff040e86dc613f239123a5e21ffdc3a3fec	30	0x4200000000000000000000000000000000000006	0xb130a49065178465931d4f887056328cea5d723f	35674937127044	7592434	0x78a087d713be963bf307b18f2ff8122ef9a63ae9	146051657583433747	2023-12-07T18:36:55.000Z	0x217961622b9da298fcbaea91c434e5aed9af7913f9f066c66bc9e23de1a62156
0x81e7f9cc7b4c19edea430018a0bea263dff14a36	false	0x66c45ff040e86dc613f239123a5e21ffdc3a3fec	12	0xd9aaec86b65d86f6a7b5b1b0c42ffa531710b6ca	0x987bfbe33c9cf18caa665b792db66339a9c16d32	201452	7572253	0x833589fcd6edb6e08f4c7c32d4f71b54bda02913	201457	2023-12-07T07:24:13.000Z	0x1963171a351e160d9439597c0a2653d6655fa5d03a3260babde596b07f0342b8
0xd0a7db7d77c2ba70f659f05b76762019dbbb1fd9	false	0x66c45ff040e86dc613f239123a5e21ffdc3a3fec	8	0x4200000000000000000000000000000000000006	0x987bfbe33c9cf18caa665b792db66339a9c16d32	111991349611519	5040642	0x78a087d713be963bf307b18f2ff8122ef9a63ae9	264998102729063028	2023-10-09T16:57:11.000Z	0x406356ab3aa2ee5fdf6c96ecfef5e2b556a38b7fdf633a880c728f339f3d7cce

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.dodo_v2_base.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
658003	1580181	30000000000000000	true	379311	0xcf5c2f10	0x200d866edf41070de251ef92715a6ea825a5eb80	14984673	0x49186e32fed50fd6b5604a2618c7b0b03cd41414	0xcd2f22236dd9dfe2356d7c543161d4d260fd9bcb	27200000000000000	false	0x833589fcd6edb6e08f4c7c32d4f71b54bda02913	2024-05-26T21:24:53.000Z	0xa9b04c0e367c72aa3ad8ca440422646b08c19996a11af647dd8518a6d7ccf3ff	0xaa60bcd8ba941dd65dd5a8229c055b24066033be
636370	799708	2000000000000000	true	364432	0xcf5c2f10	0x200d866edf41070de251ef92715a6ea825a5eb80	23719701	0x49186e32fed50fd6b5604a2618c7b0b03cd41414	0x462f0085cb261ab49ad048a2b35ee77135684308	80000000000000000	false	0xd9aaec86b65d86f6a7b5b1b0c42ffa531710b6ca	2024-12-15T02:12:29.000Z	0xc10302093c71c9100f938aca65af962125f9c943e128b159952ea428a72b61c6	0xf442c5fa349a77732c2966b1f0b59b0fcc3b8d76
653470	1000000	100000000000000000	true	381532	0xcf5c2f10	0x200d866edf41070de251ef92715a6ea825a5eb80	23719396	0x49186e32fed50fd6b5604a2618c7b0b03cd41414	0x462f0085cb261ab49ad048a2b35ee77135684308	80000000000000000	false	0xd9aaec86b65d86f6a7b5b1b0c42ffa531710b6ca	2024-12-15T02:02:19.000Z	0x3ac30f71b10b202fc0f19a6b9477c99e8926f6be4a28672b514769af447137ba	0x7b9d5af11cde0c0223da13a89288971d4ef73ceb

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.dodo_v2_base.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
0x081a6fef83325cdcc575adc13455cddd6f51973c	0x200d866edf41070de251ef92715a6ea825a5eb80	false	16	0xe01cc9be6926b93ec0b1b64d571f82529ec6aae7	7006854	0x4200000000000000000000000000000000000006	0x50c5725949a6f0c72e6c4a641f24049a917db0cb	2023-11-24T05:17:35.000Z	0x5083922178d6387a83448f58006b66bf3e9105912ee73b165c2664b8af29ecc5
0x26c82d2ca823537e1e19f82fec5e499cb219db58	0x200d866edf41070de251ef92715a6ea825a5eb80	false	21	0xf60de76791c2f09995df52aa1c6e2e7dcf1e75d7	4725600	0x6ab98f051915e8c57b066b3017c51df1dbd0a846	0x3a17ad2b4c4a75d2905d888220f6779cdfa89b44	2023-10-02T09:55:47.000Z	0xad304457443adb86bd0903b01d0861e9c6141cbfdc35fb552d2efb7c7e1469e7
0x0aeb7a8d3dbca90e9a51eda898a10aee702ae3d4	0x200d866edf41070de251ef92715a6ea825a5eb80	false	26	0x0d316b5892faacf88a52f0c6f4bb612abd6b95bb	6451854	0x4200000000000000000000000000000000000006	0xd9aaec86b65d86f6a7b5b1b0c42ffa531710b6ca	2023-11-11T08:57:35.000Z	0xd33979ef93e092e5940ba58cae1c33c04182d3443d55016a13e397146ea1a2a5

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.dodo_v2_base.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
0x9c5de5b37ad5ad32c26d796a6bf8a71de0ea6ba1	false	0x66c45ff040e86dc613f239123a5e21ffdc3a3fec	32	0xd9aaec86b65d86f6a7b5b1b0c42ffa531710b6ca	0x29a706a49bae714bcfcc96ac1a43e116cb57794c	505	5632845	0x4200000000000000000000000000000000000006	300000000000	2023-10-23T09:57:17.000Z	0xb3be72edc1696d2e87332a026bbc1b7cd194869a0713e1884c0e1ad1c6accabb
0x6abda6810d6f563fccb87fa7a5d2590692ccc7f7	false	0x66c45ff040e86dc613f239123a5e21ffdc3a3fec	29	0xd9aaec86b65d86f6a7b5b1b0c42ffa531710b6ca	0x29a706a49bae714bcfcc96ac1a43e116cb57794c	1178	5632845	0x4200000000000000000000000000000000000006	700000000000	2023-10-23T09:57:17.000Z	0xb3be72edc1696d2e87332a026bbc1b7cd194869a0713e1884c0e1ad1c6accabb
0x6abda6810d6f563fccb87fa7a5d2590692ccc7f7	false	0x66c45ff040e86dc613f239123a5e21ffdc3a3fec	20	0xd9aaec86b65d86f6a7b5b1b0c42ffa531710b6ca	0x987bfbe33c9cf18caa665b792db66339a9c16d32	20232	5629093	0x4200000000000000000000000000000000000006	12000000000000	2023-10-23T07:52:13.000Z	0x0d1ef24a917ebfd3f9b114a9f4664c68b20e5a8cd4d635252be2548fc50887ac

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.dodo_v2_base.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
637432	100000000000000000	1000000000000000000	true	388631	0xe18c40c7	0x0226fce8c969604c3a0ad19c37d1fafac73e13c2	15123543	0x4cad0052524648a7fa2cfe279997b00239295f33	0x833589fcd6edb6e08f4c7c32d4f71b54bda02913	2400000000000000	false	0x50c5725949a6f0c72e6c4a641f24049a917db0cb	2024-05-30T02:33:53.000Z	0x7a73e5b41852d62e81e5fdeed0f8d6f78840c69833ae0cba6a468a3a1e432989	0x97e6f59a7e61ab9a34d8f27f6449246ca3a19c85
657929	1	1000000000000000000	true	381424	0xe18c40c7	0x0226fce8c969604c3a0ad19c37d1fafac73e13c2	19031160	0x4cad0052524648a7fa2cfe279997b00239295f33	0x4200000000000000000000000000000000000006	2400000000000000	false	0x833589fcd6edb6e08f4c7c32d4f71b54bda02913	2024-08-28T13:27:47.000Z	0x940a13d87a381bccb34435cc82f487ad9effbcfa5522a24c57c9f6fdf1179983	0xd6f098cf8e6346ce2b18c3e3c76df2230616662e
614641	3648682400	1000000000000000000	true	381424	0xe18c40c7	0x0226fce8c969604c3a0ad19c37d1fafac73e13c2	19031080	0x4cad0052524648a7fa2cfe279997b00239295f33	0x4200000000000000000000000000000000000006	2400000000000000	false	0xd9aaec86b65d86f6a7b5b1b0c42ffa531710b6ca	2024-08-28T13:25:07.000Z	0xcd42adbd16cda881afb0c6c4057ee4cf3c39548953ced654a4df754be501d544	0x7572ef630424f11f607ae18f1d84822a9ea9f540

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.dodo_v2_base.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
0x102bfb1afaddf32f0994c4a60b28e737efa02933	0x0226fce8c969604c3a0ad19c37d1fafac73e13c2	false	14	0x98a44e2eebfeb30a398183523392576b5b53d3fe	6064875	0x4200000000000000000000000000000000000006	0xd9aaec86b65d86f6a7b5b1b0c42ffa531710b6ca	2023-11-02T09:58:17.000Z	0xf529f838178d7045cbe0c84989beea03e99ba1d3b3fc2c9ae029065775634c9f
0xaaa90901a4bf3cf153489ddd62664fdcb75818a4	0x0226fce8c969604c3a0ad19c37d1fafac73e13c2	false	23	0x92d3bca54b67e5d1928df5fca0bce260d46aa6fd	6065884	0x4200000000000000000000000000000000000006	0xd9aaec86b65d86f6a7b5b1b0c42ffa531710b6ca	2023-11-02T10:31:55.000Z	0xd522e4e73e09eeaf9b613bdc0411ced3426a6b616ce44679894ba2688e12b9c8
0x47040671a7122ab2c52e70fa7a09aff38fb9aec6	0x0226fce8c969604c3a0ad19c37d1fafac73e13c2	false	24	0x0632172ea6a07e9374d9033148e2a2b1b9803401	8250276	0x50c5725949a6f0c72e6c4a641f24049a917db0cb	0x833589fcd6edb6e08f4c7c32d4f71b54bda02913	2023-12-23T00:04:59.000Z	0x5fed64be7e44fb306296217bc2adf98dc9b68b950ab31e0ee3775c0d71c3445a

Example Query

Query with partition filter

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

Metrics

Primitives

Contracts

Blockchain

Tables

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

​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

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