dodo_v1_polygon

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
0xb14da65459db957bceec86a79086036dea6fc3ad	0x0b90ba95a2f87eddce1432f1d176266f65a41b1d	false	406265080260748920958	405	26871168	2022-04-08T00:38:46.000Z	0x964afa341da56eb6a48343d01d0db21d59f4280ee7699e3a4e02dbe9c0a4801a
0xb14da65459db957bceec86a79086036dea6fc3ad	0x0b90ba95a2f87eddce1432f1d176266f65a41b1d	false	550841038284122854975	140	26871216	2022-04-08T00:40:22.000Z	0x0f8009a538144bf2a36ddeb27b5047e5903d433dbd8cec1a81f59cce27f27c8f
0xb14da65459db957bceec86a79086036dea6fc3ad	0x0e2e2febc90db8edc8ecd2d43b816fc6e45d6448	false	74228579279778617281	120	26871926	2022-04-08T01:09:13.000Z	0xbeb5976555e9d45eebfe31374a9d0afd7d9ba62511291031daed85895e566b86

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.dodo_v1_polygon.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
0x813fddeccd0401c4fa73b092b074802440544e52	false	0x0f85a912448279111694f4ba4f85dc641c54b594	505	2104467529	17234273	2104572539	2021-07-24T23:31:54.000Z	0x3fd025a09adf6979b6c574875f90e446f3040cc94135feb388d07c3c709a7215
0x813fddeccd0401c4fa73b092b074802440544e52	false	0x0f85a912448279111694f4ba4f85dc641c54b594	53	229892507	17198350	229863801	2021-07-24T00:24:39.000Z	0x6a3cef5967d997e5aa3ebc862fab359ad5f63fe0ec2f9833612e32faec22777b
0x813fddeccd0401c4fa73b092b074802440544e52	false	0x0f85a912448279111694f4ba4f85dc641c54b594	324	987434479	17224922	987408156	2021-07-24T17:09:03.000Z	0xe775f65f6b23a32757c30bfdead9a47edb96f8bf4bb3f4155698447b070923a8

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.dodo_v1_polygon.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
0x813fddeccd0401c4fa73b092b074802440544e52	false	0x11431a89893025d2a48dca4eddc396f8c8117187	19	957589988	25759158	2022-03-09T09:06:39.000Z	957429902	0x934096b0723d959a5a6876a57730c29254f917b6227c2c6e7631fefea0b5686d
0x813fddeccd0401c4fa73b092b074802440544e52	false	0x11431a89893025d2a48dca4eddc396f8c8117187	31	347292398	25774771	2022-03-09T18:47:27.000Z	347205879	0xf3703bff17977e7e80a5b47b5300747938d3ba47f0481e1d1c4ef21888151d07
0x813fddeccd0401c4fa73b092b074802440544e52	false	0x11431a89893025d2a48dca4eddc396f8c8117187	36	617875445	25777636	2022-03-09T20:38:44.000Z	617723032	0xa504d0fc93b7e9c6a5bdc7178dd49205900b96703061780f67361a0f912edf2f

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.dodo_v1_polygon.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
0xb16f2ff8e8499e31b257d2a02d25e8956ae6afe7	false	445	21804524	2021-11-26T01:24:23.000Z	0x6a492834d8222d0cc8e0995147cd314a9b8be5fdc313437b4faf5de41b6c7387	3000000000000000
0xa46f5ec3219f956d14c6816ef9cf6cabf13bdd77	false	373	21804492	2021-11-26T01:23:19.000Z	0xcdcd02440ea6f8cd24877929c46b98e51ded51720f196bec956679bac291afc2	3000000000000000
0x3d9d765b0fbaf594f90f07bc42889473e6613c7a	false	266	21804434	2021-11-26T01:21:19.000Z	0x15776a38ef884953f1e61021c481f6f5e26826f158c4e52b1df54783fdf36807	3000000000000000

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.dodo_v1_polygon.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
0x813fddeccd0401c4fa73b092b074802440544e52	false	222	23948234	2022-01-20T13:46:25.000Z	0x00bc27144e40c08da0b968bd115066f34d692d18d33b64232a1ebf1a85b3bc2c	20000000000000	0

Example Query

Query with partition filter

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

Zoo_breedDODO_function

DODO v1 liquidity pool creation function calls on Polygon, recording breedDODO invocations with oracle addresses, base/quote token pairs, fee parameters, and pool initialization status. Used for tracking DODO pool deployments and factory contract 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.
`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_maintainer`	`STRING`	Address of the maintainer account who receives protocol fees from this DODO pool. May be null for failed pool creation attempts.
`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`	Fee rate paid to the maintainer of the DODO liquidity pool, expressed as a string-encoded ratio. Typically set to ‘0’ in sample transactions.
`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 allowed gas price in wei for the DODO pool creation transaction. Null values indicate failed transactions where parameters were not properly decoded.
`out_newBornDODO`	`STRING`	Contract address of the newly deployed DODO pool instance created by the breedDODO function. Null when the pool creation transaction fails, as indicated by the status field.

Sample Data

gas	status	gas_used	signature	to_address	block_number	from_address	block_timestamp	transaction_hash
4832629	false	2071700	0x6ace4afd	0x357c5e9cfa8b834edcef7c7aabd8f9db09119d11	20973266	0x3cd6d7f5ff977bf8069548ea1f9441b061162b42	2021-11-04T13:29:54.000Z	0x8e466a23bc5b50d62f761aa2286fa51000ade0d8c5db1ca509fdf373aec216e2
4832629	false	2071700	0x6ace4afd	0x357c5e9cfa8b834edcef7c7aabd8f9db09119d11	20973219	0x3cd6d7f5ff977bf8069548ea1f9441b061162b42	2021-11-04T13:28:16.000Z	0x0d981e51aee5b45ac60ded2b25f536885cd47435b1c98bb035e6d40c22fff309
4832629	false	2071700	0x6ace4afd	0x357c5e9cfa8b834edcef7c7aabd8f9db09119d11	20973250	0x3cd6d7f5ff977bf8069548ea1f9441b061162b42	2021-11-04T13:29:22.000Z	0xaf2e03df6ca8a277da7ad6010b6f160d5fea03993c3f96e0c3031159e127038d

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.dodo_v1_polygon.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
0x357c5e9cfa8b834edcef7c7aabd8f9db09119d11	false	276	0x3854bdcb1a7cba4b1a5f9a7c8719e247df4c42c6	20975394	0xc8fa09426ce1aeac1bc28751f1f6c8d74fa53f3c	0x2791bca1f2de4661ed88a30c99a7a9449aa84174	2021-11-04T14:46:40.000Z	0x97ce0596519bf97dd56f4829a442dc2d9263151f1b0d590dad138f17afb0a7e6
0x357c5e9cfa8b834edcef7c7aabd8f9db09119d11	false	153	0xb16f2ff8e8499e31b257d2a02d25e8956ae6afe7	20976090	0xf4b3a195587d2735b656b7ffe9060f478faf1b32	0x2791bca1f2de4661ed88a30c99a7a9449aa84174	2021-11-04T15:12:44.000Z	0x789a749f1f98bf2ac4a415974ed049274110661838d28a315686c776719a2d53
0x357c5e9cfa8b834edcef7c7aabd8f9db09119d11	false	331	0xa46f5ec3219f956d14c6816ef9cf6cabf13bdd77	20975403	0xcc940b5c6136994bed41bff5d88b170929921e9e	0x2791bca1f2de4661ed88a30c99a7a9449aa84174	2021-11-04T14:46:58.000Z	0xf6bd91a0da32d4c965c80e8109afd122142bd487406484053ca6332946c13cc3

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.dodo_v1_polygon.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_breedDODO_function

Zoo_DODOBirth_event

Metrics

Primitives

Contracts

Blockchain

​Tables

​Mine_Claim_event

​NewBornDODO_BuyBaseToken_event

​NewBornDODO_SellBaseToken_event

​NewBornDODO_UpdateLiquidityProviderFeeRate_event

​NewBornDODO_UpdateMaintainerFeeRate_event

​Zoo_breedDODO_function

​Zoo_DODOBirth_event

Tables

Mine_Claim_event

NewBornDODO_BuyBaseToken_event

NewBornDODO_SellBaseToken_event

NewBornDODO_UpdateLiquidityProviderFeeRate_event

NewBornDODO_UpdateMaintainerFeeRate_event

Zoo_breedDODO_function

Zoo_DODOBirth_event