Skip to main content

​
Tables

​
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.
ColumnTypeDescription
block_timestampTIMESTAMPTimestamp when the block was produced. UTC timezone, millisecond precision.
block_numberINT64Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
transaction_hashSTRINGUnique identifier for the transaction. 66-character hex string including 0x prefix.
log_indexINT64Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
addressSTRINGContract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
removedBOOLBoolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
in_newBornSTRINGContract address of the newly created liquidity pool. Hex-encoded, 0x-prefixed, 42-character string.
in_baseTokenSTRINGContract address of the base token in a trading pair. Hex-encoded, 0x-prefixed, 42-character string.
in_quoteTokenSTRINGContract address of the quote token in a trading pair. Hex-encoded, 0x-prefixed, 42-character string.
No sample data available.
Query with partition filter
SELECT *
FROM `tt-contracts.dodo_v1_avalanche.Zoo_DODOBirth_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100