dodo_v1_arbitrum

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_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
0xe3c10989ddc5df5b1b9c0e6229c2e4e0862fde3e	0xfbb7b5eb128f4d023a365cb7658222d30b9ab4e0	false	232877962833559266374	17	102418215	2023-06-18T12:31:48.000Z	0x6af0f60878eafee4021a244d194365f027aca1d5fe1a27b322a857915944157c
0xe3c10989ddc5df5b1b9c0e6229c2e4e0862fde3e	0x046a65107b7f4ca5ba7742b928303c0f0917d843	false	2768128257745182079	1	14983735	2022-06-18T10:13:36.000Z	0xb38551998304d544c1ac0be2f5d1e93cfcc6b55e3202f9311dc82146bebcd4c0
0xe3c10989ddc5df5b1b9c0e6229c2e4e0862fde3e	0x22bf900bdfd4cdf0af25e142bf0d12f383c6ba75	false	79720195419755288800	1	15019143	2022-06-18T19:23:17.000Z	0xb58913889448ddacbdcb1f742cabbb67006eef37480fa1744e56f04a2ee67e38

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.dodo_v1_arbitrum.Mine_Claim_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
0xe4b2dfc82977dd2dce7e8d37895a6a8f50cbb4fb	false	0x26271dfddbd250014f87f0f302c099d5a798bab1	9	43094224393	4070426	43111565971	2021-12-24T23:33:39.000Z	0xf116ded7e7a94f8b5a73adac7bc6eba681a8961376072c6561190526c696ed12
0xe4b2dfc82977dd2dce7e8d37895a6a8f50cbb4fb	false	0x88cbf433471a0cd8240d2a12354362988b4593e5	18	2652407600	4053282	2653224599	2021-12-24T01:58:18.000Z	0xd5375b67a8868831f06f493db7d55d719a9373e593748354b23b37d2d82fe4e9
0xe4b2dfc82977dd2dce7e8d37895a6a8f50cbb4fb	false	0x88cbf433471a0cd8240d2a12354362988b4593e5	46	4020975741	4062111	4021829821	2021-12-24T13:43:53.000Z	0x9b3f36e8d1c2752ac8a3daa44808add84c41390e6e4f3b0fbb6a6499ccaf9683

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.dodo_v1_arbitrum.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
0xe4b2dfc82977dd2dce7e8d37895a6a8f50cbb4fb	false	0x0f54ee41c88c1bfa06ee95353849ea514b148e1d	8	39920159680	85322491	2023-04-28T23:37:50.000Z	39943383113	0x6bece604b5c56da77b4f3610fc6bc00f87a9fb6b13fa27da2ae6efe6118a0b1b
0xe4b2dfc82977dd2dce7e8d37895a6a8f50cbb4fb	false	0x0f54ee41c88c1bfa06ee95353849ea514b148e1d	39	120330586593	85254224	2023-04-28T18:30:28.000Z	120375266908	0x99d22f047777451ecb5c24fbe136046a9e360e49e64a0a4f03503ad3eafdf211
0xe4b2dfc82977dd2dce7e8d37895a6a8f50cbb4fb	false	0x1d5702c6d7eb30e42a8c94b8db7ea2e8444a37fd	9	10000002999	85027608	2023-04-28T02:38:49.000Z	10003315941	0x9a889fb70d3c08e93c5f9caf7ccd17046209e0c4b871e2b5b464a85d49433a1b

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.dodo_v1_arbitrum.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	block_number	block_timestamp	transaction_hash	in_newLiquidityProviderFeeRate	in_oldLiquidityProviderFeeRate
0xe4b2dfc82977dd2dce7e8d37895a6a8f50cbb4fb	false	59763168	2023-02-10T17:34:50.000Z	0xf88fcac7a786f7dc6377293a8b9cd0f97dd4691dc5e3f6957f6037fbde922f9f	0	80000000000000
0xfe176a2b1e1f67250d2903b8d25f56c0dabcd6b2	false	2289879	2021-10-17T03:26:37.000Z	0x35f1e4ca90e32c5ef048456e5130206c632b50dd3cf7034f4e57cb6dd7fd015f	2400000000000000	4000000000000000
0xfe176a2b1e1f67250d2903b8d25f56c0dabcd6b2	false	24733983	2022-09-15T11:23:07.000Z	0x381fc1fc3cb8662563d16c33e4500183a85990bab1e7b089ac8086fde1796702	2400000000000000	1200000000000000

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.dodo_v1_arbitrum.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	block_number	block_timestamp	transaction_hash	in_newMaintainerFeeRate	in_oldMaintainerFeeRate
0xe4b2dfc82977dd2dce7e8d37895a6a8f50cbb4fb	false	59763143	2023-02-10T17:34:43.000Z	0xf992ed87b08ab29b109483f630c54a19bc40793854036d42ba165070529bcce1	10000000000000	20000000000000
0xfe176a2b1e1f67250d2903b8d25f56c0dabcd6b2	false	23302320	2022-09-07T05:39:33.000Z	0x57cca28b744fc440feeee81ead70fa872f8d7adde22675be43d33c06669174f7	150000000000000	600000000000000
0xfe176a2b1e1f67250d2903b8d25f56c0dabcd6b2	false	2289882	2021-10-17T03:26:37.000Z	0xb2da64ff48e47c29e8ef1b189122b02e2f65a7ef414ee303cde564c6289be756	600000000000000	1000000000000000

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.dodo_v1_arbitrum.NewBornDODO_UpdateMaintainerFeeRate_event`
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
0xbcc3401e16c25eaf4d3fed632ce3288503883b1f	false	3	0xb42a054d950dafd872808b3c839fbb7afb86e14c	226946	0x2f2a2543b76a4166549f7aab2e75bef0aefc5b0f	0xff970a61a04b1ca14834a43f5de4533ebddb5cc8	2021-08-31T01:57:02.000Z	0xdfb47442cc7062075c06de214b2c97eca850aca23ab2963a4a2c19a785d4ca99
0xbcc3401e16c25eaf4d3fed632ce3288503883b1f	false	3	0x87b2ea5b97efff5fc4dcd0e2bd99f1c585ae100f	226940	0x2f2a2543b76a4166549f7aab2e75bef0aefc5b0f	0xff970a61a04b1ca14834a43f5de4533ebddb5cc8	2021-08-31T01:45:54.000Z	0xb3960b5078106a2365f89ee6e7ce79e07d507efde52cd91407c48b8a2bf73fed
0xbcc3401e16c25eaf4d3fed632ce3288503883b1f	false	3	0xfe176a2b1e1f67250d2903b8d25f56c0dabcd6b2	226961	0x82af49447d8a07e3bd95bd0d56f35241523fbab1	0xff970a61a04b1ca14834a43f5de4533ebddb5cc8	2021-08-31T02:22:42.000Z	0x464e79f5fe051696b2f2f7463dd9c85fbc27559874928a1eaf9392ecef28109e

Example Query

Query with partition filter

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

Metrics

Primitives

Contracts

Blockchain

Tables

Mine_Claim_event

NewBornDODO_BuyBaseToken_event

NewBornDODO_SellBaseToken_event

NewBornDODO_UpdateLiquidityProviderFeeRate_event

NewBornDODO_UpdateMaintainerFeeRate_event

Zoo_DODOBirth_event

Metrics

Primitives

Contracts

Blockchain

​Tables

​Mine_Claim_event

​NewBornDODO_BuyBaseToken_event

​NewBornDODO_SellBaseToken_event

​NewBornDODO_UpdateLiquidityProviderFeeRate_event

​NewBornDODO_UpdateMaintainerFeeRate_event

​Zoo_DODOBirth_event

Tables

Mine_Claim_event

NewBornDODO_BuyBaseToken_event

NewBornDODO_SellBaseToken_event

NewBornDODO_UpdateLiquidityProviderFeeRate_event

NewBornDODO_UpdateMaintainerFeeRate_event

Zoo_DODOBirth_event