dodo_v1_ethereum

Tables

ERC20Mine_Claim_event

Mining reward claim events from DODO V1’s ERC20Mine liquidity mining contracts on Ethereum. Tracks reward withdrawals by liquidity providers with reward amounts in wei and mining pool identifiers for analyzing incentive distribution.

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	0x6cf9aa65ebad7028536e353393630e2340ca6049	false	2515427487959730049914	169	12573199	2021-06-05T07:43:32.000Z	0xa19d35ad7b776c4d8e54c71b531b0015813322113d7e06c3b0d8e576832d31af
0x1a4f8705e1c0428d020e1558a371b7e6134455a2	0xfa54dab921c65050ccb7ed5afffdd2178cedeb91	false	236276637611671743923	109	12573599	2021-06-05T09:09:59.000Z	0xc688910fdb337467f3f0910587f78d691b8602d789324aee59f9fd320d2f1414
0x44024b60575cf5d032f80a55da37924f123b4151	0xecd7c4c41d32915b233cf44786be7a7612af7d69	false	53263318519737419483	149	12571652	2021-06-05T01:49:44.000Z	0xf19a8b2e752f6a29b83052662ad7cadce8b5301e75cc027ed793eeca7cbbe5b6

Example Query

Query with partition filter

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

ERC20MineV2_Claim_event

Liquidity mining reward claim events from DODO V1’s ERC20MineV2 contract on Ethereum, tracking user addresses, reward amounts, and claim indexes. Used for analyzing liquidity provider reward distributions and mining incentive program participation.

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

in_i	address	in_user	removed	in_reward	log_index	block_number	block_timestamp	transaction_hash
1	0x748f4dff5996711a3e127aaba2e9b95347ccdc74	0x49519579d9d7f1e782daff0d1139c6f6c7b51235	false	1244455801263715391694	147	14597233	2022-04-16T15:47:30.000Z	0xc6e7c42bb07ed3aea4adb9899fe286ddd74f799132c5d466ab75895bfbf7cf23
0	0x748f4dff5996711a3e127aaba2e9b95347ccdc74	0x49519579d9d7f1e782daff0d1139c6f6c7b51235	false	24880857399	145	14597233	2022-04-16T15:47:30.000Z	0xc6e7c42bb07ed3aea4adb9899fe286ddd74f799132c5d466ab75895bfbf7cf23
0	0x136829c258e31b3ab1975fe7d03d3870c3311651	0x86aabcd459587bc1a347ae1e2d15223856354ec9	false	1287689304770638445409	356	13618892	2021-11-15T07:02:57.000Z	0xd3e22794f6984c0ffe06187486926eab6d87e83d421d4c22c650f75f979a1703

Example Query

Query with partition filter

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

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_user`	`STRING`	Address of the user account associated with the transaction or protocol operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_amount`	`STRING`	Input amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination.

Sample Data

address	in_user	removed	in_amount	log_index	block_number	block_timestamp	transaction_hash
0xaed7384f03844af886b830862ff0a7afce0a632c	0x07a2e516993972ecd674058e173f02694617e233	false	1649469165402293725008	8	14123244	2022-02-01T23:55:47.000Z	0xe6e0a4bf82f0574e8ea6cb47f1295eb1c95bd7a9974e879627c7ea2f97b0b073
0xaed7384f03844af886b830862ff0a7afce0a632c	0x53fb0162bc8d5eec2fb1532923c4f8997bace111	false	17813596583512930175756	233	14119510	2022-02-01T10:06:57.000Z	0x98bd285ae2a48a2fc9fff17777fc8df1260e707a1b8d3dc1998dfa3c97cb84ec
0xaed7384f03844af886b830862ff0a7afce0a632c	0x53fb0162bc8d5eec2fb1532923c4f8997bace111	false	8322148127645964355575	31	14119725	2022-02-01T11:00:26.000Z	0x7cb6f7cc1ffd9b4d35c960f028c7a7545c2b4f10d0a5b3eb2ef3f3a633819226

Example Query

Query with partition filter

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

MineV2Factory_NewMineV2_event

Factory event logs capturing the creation of new DODO v2 mining pools on Ethereum, recording the deployed mining contract address and associated stake token for each new liquidity mining program.

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_mine`	`STRING`	Contract address of the newly deployed DODO MineV2 liquidity mining contract. Each address is unique to a specific staking pool and reward program on Ethereum.
`in_stakeToken`	`STRING`	Contract address of the token being staked or deposited. Hex-encoded, 0x-prefixed, 42-character string, or the zero address (0x0000000000000000000000000000000000000000) for native token operations.

Sample Data

address	in_mine	removed	log_index	block_number	in_stakeToken	block_timestamp	transaction_hash
0x37f4fd6791b3fe18faba2c9e5916bca4df5d68f3	0x136829c258e31b3ab1975fe7d03d3870c3311651	false	103	13234012	0x031816fd297228e4fd537c1789d51509247d0b43	2021-09-16T02:19:40.000Z	0x49bcd797d91a15b6b8f2592d3a51608e9d20f703d9f205a5cf5c64f6fee6648a
0x37f4fd6791b3fe18faba2c9e5916bca4df5d68f3	0xf9b8500b5012c059f30daa734d3a7131d668b1cd	false	57	13543790	0xaa89cab926dcd65b3779aa98d9342fd9a21e5d1c	2021-11-03T12:07:24.000Z	0x3c14f1967a953b7a774f7cdbb49f2dd79b79129f65310bf4a38697df5cd8cfce
0x37f4fd6791b3fe18faba2c9e5916bca4df5d68f3	0x3552fac00722ad60437ac173cda332acf4136810	false	144	12996547	0x6fd7c843cd747d7d29923d68473957921f60cd4c	2021-08-10T09:21:28.000Z	0x90ea7806a8a9eee99106fb5fbadc02d67cff6a12ee3f541590c529e4f1c3fbe6

Example Query

Query with partition filter

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

NewBornDODO_BuyBaseToken_event

Base token purchase events from DODO v1 liquidity pools. Records buyer address, quote token amount paid, and base token amount received for tracking DEX swap activity.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_buyer`	`STRING`	Address of the account purchasing tokens or assets in the transaction. Hex-encoded, 0x-prefixed, 42-character string.
`in_receiveBase`	`STRING`	Amount of base tokens received by the buyer in the transaction. Integer value representing the token amount in its smallest unit.
`in_payQuote`	`STRING`	Amount of quote tokens paid by the buyer in the transaction. Integer value representing the token amount in its smallest unit.

Sample Data

address	removed	in_buyer	log_index	in_payQuote	block_number	in_receiveBase	block_timestamp	transaction_hash
0x2109f78b46a789125598f5ad2b7f243751c2934d	false	0x0000006daea1723962647b7e189d311d757fb793	161	39913062782	12986349	91260000	2021-08-08T19:29:32.000Z	0x34eb215a45ba0658df25ed12dec7d4138569c5bd0131849c711d264dd7f084f7
0x2109f78b46a789125598f5ad2b7f243751c2934d	false	0x0000006daea1723962647b7e189d311d757fb793	7	39926994757	12986341	91530000	2021-08-08T19:27:23.000Z	0x8e080716a976d200001755f9cf84179cdf28e1c964aa396d0aad523032410e8c
0x2109f78b46a789125598f5ad2b7f243751c2934d	false	0x0000006daea1723962647b7e189d311d757fb793	286	59880136001	12981715	136080000	2021-08-08T02:32:24.000Z	0x43bf7608d4d4aa72a9d84b2ddb99b23ae224550f8a47bb1239b0f5d969f4d880

Example Query

Query with partition filter

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

NewBornDODO_SellBaseToken_event

Base token sell events from DODO v1 liquidity pools. Records the seller address, base token amount paid, and quote token amount received for tracking swap activity and pricing on the DODO DEX (Decentralized Exchange Operator).

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_seller`	`STRING`	Address of the account selling tokens or assets in the transaction. Hex-encoded, 0x-prefixed, 42-character string.
`in_payBase`	`STRING`	Amount of base tokens paid by the seller in the transaction. Numeric string representing token amount in smallest denomination.
`in_receiveQuote`	`STRING`	Amount of quote tokens received by the seller in the transaction. Numeric string representing token amount in smallest denomination.

Sample Data

address	removed	in_seller	log_index	in_payBase	block_number	block_timestamp	in_receiveQuote	transaction_hash
0x2109f78b46a789125598f5ad2b7f243751c2934d	false	0x15bde30f94711b2bd9f27cacda6fd920ed892979	18	89800000	13791688	2021-12-12T17:30:49.000Z	44990939348	0x3cc41339b70ece9a897468169dba807c4d63217fcf87d710906262821d179e86
0x2109f78b46a789125598f5ad2b7f243751c2934d	false	0x15bde30f94711b2bd9f27cacda6fd920ed892979	136	71400000	13789295	2021-12-12T08:43:26.000Z	35064050262	0x19d970ce3b708ddde6d4464987fc076a7038c91627042facf7ee8718f2e05400
0x2109f78b46a789125598f5ad2b7f243751c2934d	false	0x15bde30f94711b2bd9f27cacda6fd920ed892979	83	80600000	13790869	2021-12-12T14:32:45.000Z	40080352510	0x5eebe0d74f9e42b812a5ef5412ce22caf7035466dd81833d0d34b908b52e6091

Example Query

Query with partition filter

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

NewBornDODO_UpdateLiquidityProviderFeeRate_event

DODO V1 liquidity pool event recording changes to liquidity provider fee rates. Emitted when pool operators adjust the fee structure, capturing both previous and new fee rate values for tracking pool economics over time.

Columns

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

Sample Data

address	removed	log_index	block_number	block_timestamp	transaction_hash	in_newLiquidityProviderFeeRate	in_oldLiquidityProviderFeeRate
0x1b7902a66f133d899130bf44d7d879da89913b2e	false	246	10880114	2020-09-17T14:01:22.000Z	0x3506b7038e35498ea92d65e4f758854f467e6bafc183424a94b17ca8e3775523	3500000000000000	2500000000000000
0x75c23271661d9d143dcb617222bc4bec783eff34	false	334	10880114	2020-09-17T14:01:22.000Z	0xf2304c1f947ccab4fecb56b1bf12a392d08d74ed80f51e32c9a45f3d7f644104	3000000000000000	2500000000000000
0x2109f78b46a789125598f5ad2b7f243751c2934d	false	221	11370739	2020-12-02T03:49:31.000Z	0x9216b7ce07506db6833c8fc627dcfaf3a4ea8675f5de5241a49d2285792a3d9a	3000000000000000	2500000000000000

Example Query

Query with partition filter

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

NewBornDODO_UpdateMaintainerFeeRate_event

DODO V1 protocol event emitted when a liquidity pool’s maintainer fee rate parameter is updated, recording both previous and new fee rate values. Used for tracking fee structure changes in DODO automated market maker (AMM) pools.

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_oldMaintainerFeeRate`	`STRING`	Previous maintainer fee rate value before the change. String-encoded integer representing the fee rate in basis points with 15 decimal places of precision.
`in_newMaintainerFeeRate`	`STRING`	Updated maintainer fee rate value after the change. String-encoded integer representing the fee rate in basis points with 15 decimal places of precision.

Sample Data

address	removed	log_index	block_number	block_timestamp	transaction_hash	in_newMaintainerFeeRate	in_oldMaintainerFeeRate
0xc9f93163c99695c6526b799ebca2207fdf7d61ad	false	254	16519431	2023-01-30T11:46:11.000Z	0x5ba6d324191624e7112336846eba4d93a924a8ddde66b8314f5e291702a35758	10000000000000	20000000000000
0xc9f93163c99695c6526b799ebca2207fdf7d61ad	false	71	12689658	2021-06-23T09:44:05.000Z	0x023c820b785248c025dcaf003e14b1eac8cbba434d3aa1a62f4392e5694b5699	20000000000000	0
0x2109f78b46a789125598f5ad2b7f243751c2934d	false	341	12689512	2021-06-23T09:14:28.000Z	0xd188aed9420fa9a280b31f3bf6df3e810eecfd4902f49f321a1e9ad386bb71da	600000000000000	0

Example Query

Query with partition filter

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

USTPair_BuyBaseToken_event

Base token purchase events from DODO v1 UST liquidity pools on Ethereum, recording quote token amounts paid and base token amounts received per buyer. Used for analyzing trading activity, swap volumes, and participant behavior in DODO’s Proactive Market Maker (PMM) algorithm pools.

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_buyer`	`STRING`	Address of the account purchasing tokens or assets in the transaction. Hex-encoded, 0x-prefixed, 42-character string.
`in_receiveBase`	`STRING`	Amount of base tokens received by the buyer in the transaction. Integer value representing the token amount in its smallest unit.
`in_payQuote`	`STRING`	Amount of quote tokens paid by the buyer in the transaction. Integer value representing the token amount in its smallest unit.

Sample Data

address	removed	in_buyer	log_index	in_payQuote	block_number	in_receiveBase	block_timestamp	transaction_hash
0x8876819535b48b551c9e97ebc07332c7482b4b2d	false	0x7122db0ebe4eb9b434a9f2ffe6760bc03bfbd0e0	157	1864063679	16805611	13106351073023154645561	2023-03-11T15:03:59.000Z	0xa6da3c98defe6f029a98bab8042ce26b88bf09a0c1bd289faee90664ab797b84
0x8876819535b48b551c9e97ebc07332c7482b4b2d	false	0x7122db0ebe4eb9b434a9f2ffe6760bc03bfbd0e0	146	2381969314	16802913	15736231226576092759013	2023-03-11T05:58:23.000Z	0x11f99d717b182066fc536f90da83ff0b97dfce174619ca82cc086c2220eaa03e
0x8876819535b48b551c9e97ebc07332c7482b4b2d	false	0xd2a66c0c6c9f38b4d94fabe0b96a909a37ed0f92	53	2879718343	16808221	20018333000000000229376	2023-03-11T23:52:47.000Z	0x1a1407980165a000c3abe249a8a583b32b7db9177ba7b25862194af22606a1c8

Example Query

Query with partition filter

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

USTPair_SellBaseToken_event

Sell order executions from DODO v1 UST stablecoin pairs on Ethereum, recording base token amounts sold and quote token amounts received. Useful for tracking UST trading volumes, seller behavior, and liquidity pool activity.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_seller`	`STRING`	Address of the account selling tokens or assets in the transaction. Hex-encoded, 0x-prefixed, 42-character string.
`in_payBase`	`STRING`	Amount of base tokens paid by the seller in the transaction. Numeric string representing token amount in smallest denomination.
`in_receiveQuote`	`STRING`	Amount of quote tokens received by the seller in the transaction. Numeric string representing token amount in smallest denomination.

Sample Data

address	removed	in_seller	log_index	in_payBase	block_number	block_timestamp	in_receiveQuote	transaction_hash
0x8876819535b48b551c9e97ebc07332c7482b4b2d	false	0xd2a66c0c6c9f38b4d94fabe0b96a909a37ed0f92	15	22017611000000001605632	17774006	2023-07-26T01:34:11.000Z	2013206731	0x17e8b9d5b76bcbc21abf1ec4a77a4e1c655cb59dc9589b29602d0240dda30831
0x8876819535b48b551c9e97ebc07332c7482b4b2d	false	0x22f9dcf4647084d6c31b2765f6910cd85c178c18	198	6279662993770936185168	12903126	2021-07-26T17:27:02.000Z	6960544049	0xe4b508cb4d602773a1c63a0e7420f7e8e99fea8d90c51e09f9e7cd31064ed1f0
0x8876819535b48b551c9e97ebc07332c7482b4b2d	false	0x22f9dcf4647084d6c31b2765f6910cd85c178c18	258	1153257899855837815263	12901680	2021-07-26T11:56:57.000Z	1295468858	0x689a3bbc4200d3c6c9dd7333b17afa367bc1686b47c20e9f32e3dbcae80dff98

Example Query

Query with partition filter

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

USTPair_UpdateLiquidityProviderFeeRate_event

Liquidity provider fee rate changes for DODO V1 UST trading pairs on Ethereum, capturing when pool operators adjust the fee percentage charged to liquidity providers. Used for tracking fee policy changes and analyzing LP incentive structures over time.

Columns

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

Sample Data

address	removed	log_index	block_number	block_timestamp	transaction_hash	in_newLiquidityProviderFeeRate	in_oldLiquidityProviderFeeRate
0x8876819535b48b551c9e97ebc07332c7482b4b2d	false	78	12835373	2021-07-16T02:54:00.000Z	0x0cb2026a6d93208fa4bd09a376f17e6ff530e1bd2eafbcceedc3dc8cbf62f825	3000000000000000	0

Example Query

Query with partition filter

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

USTPair_UpdateMaintainerFeeRate_event

Maintainer fee rate change events from DODO v1 UST trading pairs on Ethereum, capturing old and new fee rates charged by pool maintainers. Used for tracking fee structure adjustments and protocol economics analysis.

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_oldMaintainerFeeRate`	`STRING`	Previous maintainer fee rate value before the change. String-encoded integer representing the fee rate in basis points with 15 decimal places of precision.
`in_newMaintainerFeeRate`	`STRING`	Updated maintainer fee rate value after the change. String-encoded integer representing the fee rate in basis points with 15 decimal places of precision.

Sample Data

address	removed	log_index	block_number	block_timestamp	transaction_hash	in_newMaintainerFeeRate	in_oldMaintainerFeeRate
0x8876819535b48b551c9e97ebc07332c7482b4b2d	false	251	11671796	2021-01-17T09:05:31.000Z	0x0148539544ff26a407b4c039aae99642398c6e5a67c8b868972ae6f0b1788b25	3000000000000000	0
0x8876819535b48b551c9e97ebc07332c7482b4b2d	false	41	12835367	2021-07-16T02:52:01.000Z	0x235a92ac187ed3f349cfc8e5302ce2177c318bce1c79c9ae3c94e1f2723c6514	0	3000000000000000

Example Query

Query with partition filter

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

Zoo_breedDODO_function

DODO v1 liquidity pool creation events on Ethereum, recording the breedDODO function calls that deploy new pool contracts with specified base/quote token pairs, oracle addresses, fee rates (LP and maintainer), and K slippage parameters. Contains deployment configuration for analyzing DODO pool launches and parameter choices.

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_maintainer`	`STRING`	Contract address designated to receive maintainer fees and perform administrative functions for the newly created DODO liquidity pool. Typically set to the transaction sender or protocol operator address.
`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_oracle`	`STRING`	Contract address of the oracle providing price feed data. 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_mtFeeRate`	`STRING`	Maintainer fee rate parameter for the DODO liquidity pool, specified as a wei-denominated value. Typically set to zero, with non-zero values indicating a fee percentage allocated to the pool maintainer.
`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_gasPriceLimit`	`STRING`	Maximum gas price limit for the transaction, specified in wei. Typically set to very high values (often 10^30+) to effectively disable price restrictions on pool creation.
`out_newBornDODO`	`STRING`	Contract address of the newly deployed DODO liquidity pool created by this breedDODO function call. Returns null if the pool creation transaction failed.

Sample Data

gas	in_k	status	gas_used	in_oracle	signature	to_address	block_number	from_address	in_baseToken	in_lpFeeRate	in_maintainer	in_quoteToken	trace_address	block_timestamp	out_newBornDODO	in_gasPriceLimit	transaction_hash
3138580	100000000000000000	true	2092387	0xdb5fe0d4ea64e3264fc1cd963462a246f079b55c	0x6ace4afd	0x3a97247df274a17c59a3bd12735ea3fcdfb49950	10616399	0x9c59990ec0177d87ed7d60a56f584e6b06c639a2	0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2	3000000000000000	0x9c59990ec0177d87ed7d60a56f584e6b06c639a2	0xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb48		2020-08-08T02:12:01.000Z	0x75c23271661d9d143dcb617222bc4bec783eff34	1000000000000000	0xc8725474385d3b0b0c6289b8a9656233f7fcdd56c0cc7b38549bb279dbb72ec5
3877359	200000000000000000	true	2054123	0x03d036fc6716a258d8fbb9a3d85684762570db75	0x6ace4afd	0x3a97247df274a17c59a3bd12735ea3fcdfb49950	10781116	0x6dae6ae227438378c117821c51fd61661faa8893	0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2	2500000000000000	0x9c59990ec0177d87ed7d60a56f584e6b06c639a2	0xdac17f958d2ee523a2206206994597c13d831ec7	0	2020-09-02T09:51:30.000Z	0x1a7fe5d6f0bb2d071e16bdd52c863233bbfd38e9	1000000000000000000000000000000000	0x882cd6d56d5f26d7c57987bef5c1e4510b6979e441f37fc6328c34da6071d3a2
3877359	200000000000000000	true	2054123	0xb77ddd925e69ddca799d9cc6abea5ae2c7c7f780	0x6ace4afd	0x3a97247df274a17c59a3bd12735ea3fcdfb49950	10781116	0x6dae6ae227438378c117821c51fd61661faa8893	0x2260fac5e5542a773aa44fbcfedf7c193bc2c599	2500000000000000	0x9c59990ec0177d87ed7d60a56f584e6b06c639a2	0xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb48	0	2020-09-02T09:51:30.000Z	0x2109f78b46a789125598f5ad2b7f243751c2934d	10000000000000000000000000000	0xc8b64f78d0aff3c6afd7127ebab1ae587007834e0f0d149e1502acdb3836e56f

Example Query

Query with partition filter

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

Zoo_DODOBirth_event

DODO decentralized exchange (DEX) pool creation events emitted when new liquidity pools are deployed through the Zoo factory contract. Records the newly created pool address along with its base and quote token pair for tracking DODO v1 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_newBorn`	`STRING`	Contract address of the newly created liquidity pool. Hex-encoded, 0x-prefixed, 42-character string.
`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.

Sample Data

address	removed	log_index	in_newBorn	block_number	in_baseToken	in_quoteToken	block_timestamp	transaction_hash
0x3a97247df274a17c59a3bd12735ea3fcdfb49950	false	64	0xc226118fcd120634400ce228d61e1538fb21755f	10746228	0x80fb784b7ed66730e8b1dbd9820afd29931aab03	0xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb48	2020-08-28T01:42:04.000Z	0x8248bf8e540f277a6ea7489a036f757b23dd667c75b1c98c67dbc202be8c5f6a
0x3a97247df274a17c59a3bd12735ea3fcdfb49950	false	86	0xc9f93163c99695c6526b799ebca2207fdf7d61ad	11106395	0xdac17f958d2ee523a2206206994597c13d831ec7	0xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb48	2020-10-22T13:54:32.000Z	0x43c9c32084e7454487130a096491b8b966575465b00782fb3dbb877aaed1f40c
0x3a97247df274a17c59a3bd12735ea3fcdfb49950	false	24	0xd4a36b0acfe2931cf922ea3d91063ddfe4aff01f	12197699	0x57ab1ec28d129707052df4df418d58a2d46d5f51	0xdac17f958d2ee523a2206206994597c13d831ec7	2021-04-08T07:02:46.000Z	0x07c9963ef979e526bee008cd0aaa9f08b6a58aea3a5a3bd128a63e8744a24210

Example Query

Query with partition filter

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

Overview

Metrics

Primitives

Contracts

Blockchain

Tables

ERC20Mine_Claim_event

ERC20MineV2_Claim_event

Mine_Claim_event

MineV2Factory_NewMineV2_event

NewBornDODO_BuyBaseToken_event

NewBornDODO_SellBaseToken_event

NewBornDODO_UpdateLiquidityProviderFeeRate_event

NewBornDODO_UpdateMaintainerFeeRate_event

USTPair_BuyBaseToken_event

USTPair_SellBaseToken_event

USTPair_UpdateLiquidityProviderFeeRate_event

USTPair_UpdateMaintainerFeeRate_event

Zoo_breedDODO_function

Zoo_DODOBirth_event

​Tables

​ERC20Mine_Claim_event

​ERC20MineV2_Claim_event

​Mine_Claim_event

​MineV2Factory_NewMineV2_event

​NewBornDODO_BuyBaseToken_event

​NewBornDODO_SellBaseToken_event

​NewBornDODO_UpdateLiquidityProviderFeeRate_event

​NewBornDODO_UpdateMaintainerFeeRate_event

​USTPair_BuyBaseToken_event

​USTPair_SellBaseToken_event

​USTPair_UpdateLiquidityProviderFeeRate_event

​USTPair_UpdateMaintainerFeeRate_event

​Zoo_breedDODO_function

​Zoo_DODOBirth_event

Tables

ERC20Mine_Claim_event

ERC20MineV2_Claim_event

Mine_Claim_event

MineV2Factory_NewMineV2_event

NewBornDODO_BuyBaseToken_event

NewBornDODO_SellBaseToken_event

NewBornDODO_UpdateLiquidityProviderFeeRate_event

NewBornDODO_UpdateMaintainerFeeRate_event

USTPair_BuyBaseToken_event

USTPair_SellBaseToken_event

USTPair_UpdateLiquidityProviderFeeRate_event

USTPair_UpdateMaintainerFeeRate_event

Zoo_breedDODO_function

Zoo_DODOBirth_event