dodo_v1_bsc

Tables

Mine_Claim_event

Mining reward claim events recording user withdrawals from liquidity mining programs. Captures claimed reward amounts and user addresses for tracking incentive distributions across DODO protocol versions.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_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
0x01f9bfac04e6184e90bd7eafd51999ce430cc750	0x00002b503a75998c97508916a74fdb41934fa030	false	22268986500331698121844	188	31221270	2023-08-27T14:44:47.000Z	0x2523c8f057a39cd91e3efe040c31697affb1aa14b978ce78b334b6b492b387f2
0x01f9bfac04e6184e90bd7eafd51999ce430cc750	0x00002b503a75998c97508916a74fdb41934fa030	false	270748158163910365	127	31221328	2023-08-27T14:47:41.000Z	0xb2b2e2baa2e7f57abc6d9fc4992b37021a4808194d691a0d49cc1bb497e29e23
0x01f9bfac04e6184e90bd7eafd51999ce430cc750	0x3a1d1e65a1fdf9292ac19f24323916e16a2aa775	false	1293117925602188532220	38	31212215	2023-08-27T07:06:43.000Z	0x97e91188ff552e1039f55d8f5cfb903f242a2d8c76fa10180a4583d26a857fe9

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.dodo_v1_bsc.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
0xbe60d4c4250438344bec816ec2dec99925deb4c7	false	0x0596908263ef2724fbfbcafa1c983fcd7a629038	81	3293990119431647203491	9493857	3295090756788350957387	2021-07-26T12:35:10.000Z	0x9065d71dcb6438160fbbda0dbb1cf8e35f532c77b0f6eff1f0f9f624584c4488
0xbe60d4c4250438344bec816ec2dec99925deb4c7	false	0x0596908263ef2724fbfbcafa1c983fcd7a629038	1018	99999999999999999998	9493113	100033572553161128687	2021-07-26T11:56:47.000Z	0xa47ae648747882ce951e27b3ab120909c1dd31339457c70f7935d4e4db3784c5
0x6064dbd0ff10bfed5a797807042e9f63f18cfe10	false	0x0596908263ef2724fbfbcafa1c983fcd7a629038	572	316633428306387134241	9496936	316612723688369589215	2021-07-26T15:14:35.000Z	0xc9a4844e8dfd22fe7673c577143e433bf58502c6e1fe536cf47f7b2bfedcf9c0

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.dodo_v1_bsc.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
0x82aff931d74f0645ce80e8f419b94c8f93952686	false	0x0596908263ef2724fbfbcafa1c983fcd7a629038	154	100000000000000	7106753	2021-05-03T17:30:23.000Z	67184126900113206	0x859ce5ef449d7b8190460aedc9129c89358eba5b2c5604071f05532b7b18adba
0x82aff931d74f0645ce80e8f419b94c8f93952686	false	0x0596908263ef2724fbfbcafa1c983fcd7a629038	229	1000000000000000	7107948	2021-05-03T18:30:08.000Z	672774725699097326	0x2be0f5222eb652d4d2ded43a4986480d40b9915911afe8fbbc93086abd6b49c3
0x82aff931d74f0645ce80e8f419b94c8f93952686	false	0x0596908263ef2724fbfbcafa1c983fcd7a629038	205	7432286713503956	7102622	2021-05-03T13:58:38.000Z	4825267689305091729	0xe1e7f579816779c6cdf89273482e55b42bd6a3bf7a5eee98c00c3a4b781f31a6

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.dodo_v1_bsc.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
0x327134de48fcdd75320f4c32498d1980470249ae	false	216	5979633	2021-03-25T04:42:22.000Z	0xe0790e33fc088e2cbb259efd0bf5f8e8dfef94cb4b79741a6c0df11ec8ce7332	700000000000000	500000000000000
0x82aff931d74f0645ce80e8f419b94c8f93952686	false	671	7603200	2021-05-21T13:48:09.000Z	0x0b634c6b9fff7b9613e3043a307aaf371500ff1dcd4ef41a7c8fa7c6b57c19f0	900000000000000000	0
0x82aff931d74f0645ce80e8f419b94c8f93952686	false	663	7603200	2021-05-21T13:48:09.000Z	0x0b634c6b9fff7b9613e3043a307aaf371500ff1dcd4ef41a7c8fa7c6b57c19f0	0	900000000000000000

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.dodo_v1_bsc.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
0x82aff931d74f0645ce80e8f419b94c8f93952686	false	664	7603200	2021-05-21T13:48:09.000Z	0x0b634c6b9fff7b9613e3043a307aaf371500ff1dcd4ef41a7c8fa7c6b57c19f0
0x327134de48fcdd75320f4c32498d1980470249ae	false	173	6804608	2021-04-23T03:38:16.000Z	0x2c9ca8835961e5d83adec8492edd3a33c9ceb8f78ab80686e6dfe1dbfd5dc5fa
0xb1327b6402ddba34584ab59fbe8ac7cbf43f6353	false	215	6804476	2021-04-23T03:31:40.000Z	0x24ecf03376d08aa56a03576f87923bcd74b0eb8374dbbc9224238934e6e3f19e

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.dodo_v1_bsc.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 Binance Smart Chain (BSC). Records pool deployment parameters including base/quote token pairs, oracle addresses, fee rates (LP and maintenance), k slippage parameter, and resulting pool contract addresses for tracking automated market maker (AMM) pool initialization.

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`	Contract address designated to receive maintainer fees for the DODO liquidity pool being created. Typically set to an administrative or treasury address that manages protocol fees.
`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 pool, expressed as a fixed-point decimal (typically 14-16 decimals). Often set to 0 or small values like 10000000000000 representing fees collected by 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 allowed gas price for this pool operation, preventing transaction execution if network fees exceed this threshold. Typically set to very high values (e.g., 100000000000000000000000000000000000000) to effectively disable the limit.
`out_newBornDODO`	`STRING`	Contract address of the newly deployed DODO liquidity pool created by this breedDODO function call. Returns null when pool creation fails (status=false).

Sample Data

gas	in_k	status	gas_used	in_oracle	signature	to_address	block_number	from_address	in_baseToken	in_lpFeeRate	in_mtFeeRate	in_maintainer	in_quoteToken	trace_address	block_timestamp	out_newBornDODO	in_gasPriceLimit	transaction_hash
499359	200000000000000	false	483657	0xf1d5d3c3bfcc8af238998e8969190b33c4680581	0x6ace4afd	0xca459456a45e300aa7ef447dbb60f87cccb42828	29862365	0xcaa42f09af66a8bae3a7445a7f63dad97c11638b	0x55d398326f99059ff775485246999027b3197955	0	10000000000000	0xcaa42f09af66a8bae3a7445a7f63dad97c11638b	0x8ac76a51cc950d9822d68b83fe1ad97b32cd580d	0,1	2023-07-11T06:35:59.000Z		100000000000000000000000000000000000000	0x70aae6e8214fb737858f62c59ee4f161a63ad9f2e2275d601b9b4acda0e6b7f3
43503	200000000000000	false	42969	0xa952f8716a753d9e094c4041febd163e38b21edb	0x6ace4afd	0xca459456a45e300aa7ef447dbb60f87cccb42828	5018065	0xcaa42f09af66a8bae3a7445a7f63dad97c11638b	0xe9e7cea3dedca5984780bafc599bd69add087d56	100000000000000	0	0xcaa42f09af66a8bae3a7445a7f63dad97c11638b	0x55d398326f99059ff775485246999027b3197955	0,1	2021-02-19T14:23:42.000Z		100000000000000000000000000000000000000	0xd31da8b9ae732532658c788dbe30b27d2a20ae24becdfeaf5fb5d88334c090db
3353169	200000000000000	true	2114956	0xa952f8716a753d9e094c4041febd163e38b21edb	0x6ace4afd	0xca459456a45e300aa7ef447dbb60f87cccb42828	5018391	0xcaa42f09af66a8bae3a7445a7f63dad97c11638b	0xe9e7cea3dedca5984780bafc599bd69add087d56	100000000000000	0	0xcaa42f09af66a8bae3a7445a7f63dad97c11638b	0x55d398326f99059ff775485246999027b3197955	0,1	2021-02-19T14:40:10.000Z	0xbe60d4c4250438344bec816ec2dec99925deb4c7	100000000000000000000000000000000000000	0xcee8148436395dd3a913f63f63955d7915e3ec6b1a278c6571d0a995784fa658

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.dodo_v1_bsc.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
0xca459456a45e300aa7ef447dbb60f87cccb42828	false	282	0x89e5015ff12e4536691abfe5f115b1cb37a35465	6126149	0x2170ed0880ac9a755fd29b2688956bd959f933f8	0xe9e7cea3dedca5984780bafc599bd69add087d56	2021-03-30T07:59:34.000Z	0xcfe5df4cf595327262656bb8937763debd7ea87c3f1b407a4ff23e0187ceee05
0xca459456a45e300aa7ef447dbb60f87cccb42828	false	167	0xc64a1d5c819b3c9113ce3db32b66d5d2b05b4cef	6126135	0x7130d2a12b9bcbfae4f2634d864a1ee1ce3ead9c	0xe9e7cea3dedca5984780bafc599bd69add087d56	2021-03-30T07:58:52.000Z	0x3d20b7525636e3b8ebf6810bb401854e2429477f25e3a2217ddfc1ea74eb0570
0xca459456a45e300aa7ef447dbb60f87cccb42828	false	77	0xbe60d4c4250438344bec816ec2dec99925deb4c7	5018391	0xe9e7cea3dedca5984780bafc599bd69add087d56	0x55d398326f99059ff775485246999027b3197955	2021-02-19T14:40:10.000Z	0xcee8148436395dd3a913f63f63955d7915e3ec6b1a278c6571d0a995784fa658

Example Query

Query with partition filter

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