Skip to main content

Tables

PrivatePool_DODOSwap_event

DODOSwap event logs from DODO v2 private pool contracts recording token exchanges. Contains trader address, source and destination token addresses with amounts, and receiver address for tracking decentralized exchange swaps.
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_fromTokenSTRINGContract address of the source token being swapped. Hex-encoded, 0x-prefixed, 42-character string.
in_toTokenSTRINGContract address of the destination token being received in the swap. Hex-encoded, 0x-prefixed, 42-character string.
in_fromAmountSTRINGAmount of tokens being swapped from the source token. String-encoded integer value representing the quantity in the smallest unit of the token.
in_toAmountSTRINGAmount of tokens received from the swap to the destination token. String-encoded integer value representing the quantity in the smallest unit of the token.
in_traderSTRINGAddress that initiated or executed the trade transaction. Hex-encoded, 0x-prefixed, 42-character string.
in_receiverSTRINGAddress that receives tokens, assets, or rewards from the transaction. Hex-encoded, 0x-prefixed, 42-character string.
addressremovedin_traderlog_indexin_toTokenin_receiverin_toAmountblock_numberin_fromTokenin_fromAmountblock_timestamptransaction_hash
0xeee69c0ac5115104295489194981b564c15b15dffalse0xd72b354bd39f8f11d0ca07bd5724896bb1a4270750x130966628846bfd36ff31a822705796e8cb8c18d0x0b64c1769cc9fe9064d2507c1b13125fd664026f8473403205871399320209565800x5541d83efad1f281571b343977648b75d95cdac2250499598766228246902022-10-12T05:27:14.000Z0xd7dc6f0a4b3549dfac1cafdb1cf1576aab0a4c8e322cb0d0e055b5319ca71e33
0xeee69c0ac5115104295489194981b564c15b15dffalse0xd72b354bd39f8f11d0ca07bd5724896bb1a4270790x130966628846bfd36ff31a822705796e8cb8c18d0x0b64c1769cc9fe9064d2507c1b13125fd664026f1963741574813867704209572990x5541d83efad1f281571b343977648b75d95cdac257763236285286745262022-10-12T05:52:30.000Z0x42f7f32962a1c65d0228d5b4691b74232654852b49f08b30b36643c347794cd8
0x1ccc652b6a104b7e3adf7ff030b892e37097c111false0xf01ef4051130cc8871fa0c17024a6d62e379e856280xb97ef9ef8734c71904d8002f8b6bc66dd9c48a6e0xf1f4ce5dd70d4384f9b764020f26e8cabee3907042183670294542190x152b9d0fdc40c096757f570a51e494bd4b943e501477582023-05-01T11:02:31.000Z0x904fa12eb4ddf37bad0a4dfeb46b62a4b171c76adf036faf23f718b360dac376
Query with partition filter
SELECT *
FROM `tt-contracts.dodo_v2_avalanche.PrivatePool_DODOSwap_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

PrivatePool_LpFeeRateChange_event

Liquidity provider (LP) fee rate adjustment events emitted by DODO V2 private pool contracts. Captures new fee rate values applied to LP positions within private pools for fee structure tracking.
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_newLpFeeRateSTRINGNew liquidity provider fee rate set by the pool update. String-encoded integer representing the fee rate in basis points or wei-denominated fractional units.
addressremovedlog_indexblock_numberblock_timestampin_newLpFeeRatetransaction_hash
0x1ccc652b6a104b7e3adf7ff030b892e37097c111false0309378502023-06-05T11:00:05.000Z13262385000000000x39e469e3d6ba2342faf900346ae1387d42d6a590997b00731dfc2c3b0b855a86
0x1ccc652b6a104b7e3adf7ff030b892e37097c111false0309286822023-06-05T05:53:22.000Z10670308000000000x3c9d435fc2709175c8e5a60fb58fb2b08b6917fbdba5b2116d56c4f0d35bd8df
0x1ccc652b6a104b7e3adf7ff030b892e37097c111false0309377652023-06-05T10:57:13.000Z8840618000000000x47bcbe15a1df63904cf82751534e4430630b64341df682533db4b6b679561139
Query with partition filter
SELECT *
FROM `tt-contracts.dodo_v2_avalanche.PrivatePool_LpFeeRateChange_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

PrivatePoolFactory_NewDPP_event

DODO V2 private pool creation events emitted when a new DPP (DODO Private Pool) is deployed via the PrivatePoolFactory contract. Records pool creator address, base/quote token pair, and deployed pool contract address for tracking custom liquidity 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_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.
in_creatorSTRINGAddress of the account that initiated the creation event. Hex-encoded, 0x-prefixed, 42-character string.
in_dppSTRINGContract address of the DODO Private Pool (DPP) created by the factory. Hex-encoded, 0x-prefixed, 42-character string.
in_dppaddressremovedlog_indexin_creatorblock_numberin_baseTokenin_quoteTokenblock_timestamptransaction_hash
0x8a40309a9ed92b4521aec52c368907ab2f97dec20xb7865a5cee051d35b09a48b624d7057d3362655afalse20x0b64c1769cc9fe9064d2507c1b13125fd664026f244085580x130966628846bfd36ff31a822705796e8cb8c18d0xdea949fc7c9dae3893c0a033eda19d1dd1eb450b2023-01-02T03:46:34.000Z0x866a17a52c44aa5429b1f7114c0a302ad9cd169127a1dc909ddc349a39cd72a0
0xc995fbec7f4780ac6c0cba8d811ed9da5387676f0xb7865a5cee051d35b09a48b624d7057d3362655afalse140x15c4c90d0ccb73ace46e25a6a9c94581f14e63dc302664060xb97ef9ef8734c71904d8002f8b6bc66dd9c48a6e0xaec8318a9a59baeb39861d10ff6c7f7bf1f96c572023-05-20T14:36:41.000Z0x1e33d0ec23edba4bbd781334293a60905116ee81a622a847c3b03ccc8e72848b
0x900b1ea3e06127e5c53fe491fd62880018fae9200xb7865a5cee051d35b09a48b624d7057d3362655afalse50x995be1ca945174d5ba75410c1e658a41eb13a2fa272874150xb31f66aa3c1e785363f0875a1b74e27b85fd66c70x9702230a8ea53601f5cd2dc00fdbc13d4df4a8c72023-03-11T05:55:13.000Z0x7859c928418cb83090bbb459c6c18add35a3e416525ab6c380effbcf8b98ec6a
Query with partition filter
SELECT *
FROM `tt-contracts.dodo_v2_avalanche.PrivatePoolFactory_NewDPP_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

StablePool_DODOSwap_event

Token swap events emitted by DODO StablePool contracts containing trader address, source and destination token addresses, input and output amounts, and receiver address. Used for tracking stableswap trades and liquidity pool activity across DODO’s decentralized exchange protocol.
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_fromTokenSTRINGContract address of the source token being swapped. Hex-encoded, 0x-prefixed, 42-character string.
in_toTokenSTRINGContract address of the destination token being received in the swap. Hex-encoded, 0x-prefixed, 42-character string.
in_fromAmountSTRINGAmount of tokens being swapped from the source token. String-encoded integer value representing the quantity in the smallest unit of the token.
in_toAmountSTRINGAmount of tokens received from the swap to the destination token. String-encoded integer value representing the quantity in the smallest unit of the token.
in_traderSTRINGAddress that initiated or executed the trade transaction. Hex-encoded, 0x-prefixed, 42-character string.
in_receiverSTRINGAddress that receives tokens, assets, or rewards from the transaction. Hex-encoded, 0x-prefixed, 42-character string.
addressremovedin_traderlog_indexin_toTokenin_receiverin_toAmountblock_numberin_fromTokenin_fromAmountblock_timestamptransaction_hash
0xbb02ae33acbe46b80e5767130b9a13333d93b844false0xf081470f5c6fbccf48cc4e5b82dd926409dcdd67120xb97ef9ef8734c71904d8002f8b6bc66dd9c48a6e0xf081470f5c6fbccf48cc4e5b82dd926409dcdd671769631362248430xf4003f4efbe8691b60249e6afbd307abe7758adb3122483967862023-10-09T08:07:17.000Z0x2292be0a32ac05d3c03034e21437af73839f56447f3b2df422d7d8f15163887b
0xbb02ae33acbe46b80e5767130b9a13333d93b844false0xebf00ad513e398a336c61b3b8a59c8a6fcf4f770320xf4003f4efbe8691b60249e6afbd307abe7758adb0xebf00ad513e398a336c61b3b8a59c8a6fcf4f77072267440311362248430xb97ef9ef8734c71904d8002f8b6bc66dd9c48a6e4861312023-10-09T08:07:17.000Z0xf3bcee071dc57ec10d960cecea1a816f8c2b3108f9752460a0bde154285bb2de
0xbb02ae33acbe46b80e5767130b9a13333d93b844false0xbdd1cda63d5243fe563756065e94f23e3577e1ef170xf4003f4efbe8691b60249e6afbd307abe7758adb0xbdd1cda63d5243fe563756065e94f23e3577e1ef332859254962376361810xb97ef9ef8734c71904d8002f8b6bc66dd9c48a6e36396992023-11-11T20:00:17.000Z0x77dfa17a9763e8ee780b95190dd5531d28857b630fc3910643c1d99c0cc4f367
Query with partition filter
SELECT *
FROM `tt-contracts.dodo_v2_avalanche.StablePool_DODOSwap_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

StablePoolFactory_NewDSP_event

DODO v2 StablePoolFactory event emitted when a new DSP (DODO Stable Pool) is created, containing the deployed pool contract address, base and quote token addresses, and creator address. Used for tracking stable swap pool deployments across DODO DEX instances.
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_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.
in_creatorSTRINGAddress of the account that initiated the creation event. Hex-encoded, 0x-prefixed, 42-character string.
in_DSPSTRINGContract address of the DODO Stable Pool (DSP) created by the factory. Hex-encoded, 0x-prefixed, 42-character string.
in_DSPaddressremovedlog_indexin_creatorblock_numberin_baseTokenin_quoteTokenblock_timestamptransaction_hash
0x2aaeeb914a796267ce4e1db5dda21d6a5088dd400x2b0d94eb7a63b8a2909de1cb3951ecf7ae76d2fefalse210x78f4948af786245e00ac615519b43b52eaecd64c108030540xb31f66aa3c1e785363f0875a1b74e27b85fd66c70xb27f379c050f6ed0973a01667458af6ecebc1d902022-02-12T01:40:11.000Z0x8f74c97156802c04a0f51b9ec35df18cdadeef7e1eca99ddf65fffc5f8cff99e
0xbb02ae33acbe46b80e5767130b9a13333d93b8440x2b0d94eb7a63b8a2909de1cb3951ecf7ae76d2fefalse20x7f1abbe76c281b46f46af479360e6e58b2e6b9f0234089800xf4003f4efbe8691b60249e6afbd307abe7758adb0xb97ef9ef8734c71904d8002f8b6bc66dd9c48a6e2022-12-09T10:34:51.000Z0xc02091e2c2537e5693b0a0eb6d70b62c21f44e4ccd542ac40bb7197e3acd63af
0x3086d2d30aad816b72d642f482ad88f6d09d20b80x2b0d94eb7a63b8a2909de1cb3951ecf7ae76d2fefalse50x82149613a938746f18fc1844cc7e103dbf87c527206301330xc7198437980c041c805a1edcba50c1ce5db951180x2759ddfdc21dae722288d01250a4b695f95ab0b32022-10-04T09:43:51.000Z0x94a426392f347c13d22033a91b9adf9bb1dd189c6a5a1c56e44b62076224d7de
Query with partition filter
SELECT *
FROM `tt-contracts.dodo_v2_avalanche.StablePoolFactory_NewDSP_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

VendingMachine_DODOSwap_event

DODOSwap token swap events from DODO V2 vending machine contracts containing trader address, source and destination token addresses, swap amounts, and recipient. Used for DEX trade volume analysis and liquidity tracking across token pairs.
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_fromTokenSTRINGContract address of the source token being swapped. Hex-encoded, 0x-prefixed, 42-character string.
in_toTokenSTRINGContract address of the destination token being received in the swap. Hex-encoded, 0x-prefixed, 42-character string.
in_fromAmountSTRINGAmount of tokens being swapped from the source token. String-encoded integer value representing the quantity in the smallest unit of the token.
in_toAmountSTRINGAmount of tokens received from the swap to the destination token. String-encoded integer value representing the quantity in the smallest unit of the token.
in_traderSTRINGAddress that initiated or executed the trade transaction. Hex-encoded, 0x-prefixed, 42-character string.
in_receiverSTRINGAddress that receives tokens, assets, or rewards from the transaction. Hex-encoded, 0x-prefixed, 42-character string.
addressremovedin_traderlog_indexin_toTokenin_receiverin_toAmountblock_numberin_fromTokenin_fromAmountblock_timestamptransaction_hash
0xb9c2ef7a515c1db214a75f5b8d7d8864ad87b672false0xd72b354bd39f8f11d0ca07bd5724896bb1a42707440xb31f66aa3c1e785363f0875a1b74e27b85fd66c70x3b3e4b4741e91af52d0e9ad8660573e951c8852481837270985590212370458590xa7d7079b0fead91f3e65f86e8915cb59c1a4c6648914622023-10-28T22:00:56.000Z0xe07728b3e7a0987dd83a964ca588afef5590b2e7ffe98e1c504723f368287c72
0xb9c2ef7a515c1db214a75f5b8d7d8864ad87b672false0x1d5702c6d7eb30e42a8c94b8db7ea2e8444a37fd80xb31f66aa3c1e785363f0875a1b74e27b85fd66c70x1d5702c6d7eb30e42a8c94b8db7ea2e8444a37fd119638833146308304280441180xa7d7079b0fead91f3e65f86e8915cb59c1a4c66419993432023-03-29T09:22:59.000Z0x369b07a68c3d6f4afa6e7306510ee2953c65f7c305622e75c5d81af4e13b8004
0xb9c2ef7a515c1db214a75f5b8d7d8864ad87b672false0xd72b354bd39f8f11d0ca07bd5724896bb1a42707660xb31f66aa3c1e785363f0875a1b74e27b85fd66c70x900b1ea3e06127e5c53fe491fd62880018fae920132768863161648745280611990xa7d7079b0fead91f3e65f86e8915cb59c1a4c66422884642023-03-29T19:09:58.000Z0xfe457c32c9af898a6fc0bb53f36c8cd67a1981ac14f7b871f698a6dda638e67f
Query with partition filter
SELECT *
FROM `tt-contracts.dodo_v2_avalanche.VendingMachine_DODOSwap_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

VendingMachineFactory_NewDVM_event

DODO Vending Machine (DVM) liquidity pool creation events emitted when a new trading pair is deployed. Records creator address, base/quote token addresses, and deployed DVM contract address for tracking pool deployments across DODO V2 exchanges.
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_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.
in_creatorSTRINGAddress of the account that initiated the creation event. Hex-encoded, 0x-prefixed, 42-character string.
in_dvmSTRINGContract address of the DVM (DODO Vending Machine) pool created by the factory. Hex-encoded, 0x-prefixed, 42-character string.
in_dvmaddressremovedlog_indexin_creatorblock_numberin_baseTokenin_quoteTokenblock_timestamptransaction_hash
0xe72e842a0969e34054d390b8c58891c0de96fe080xff133a6d335b50bdaa6612d19e1352b049a8ae6afalse430x78f4948af786245e00ac615519b43b52eaecd64c112494610x130966628846bfd36ff31a822705796e8cb8c18d0xc6710e83abbbbaa6d1576dd30df3baf6147823d82022-02-22T12:07:37.000Z0xa2a78d0297b0401302a4e6a3aa62daabeabac0b10e662d4ec2ea7c203a2239d1
0xd6a472a1fcf4c8a893985205cd6fa5452d8a31cf0xff133a6d335b50bdaa6612d19e1352b049a8ae6afalse10x3cca2cbb23e2eb86afcce43bbd46cf9d3d3eddaf150064980x63bbaa858cfaadc1a4ed795a1bd7351c1f6a5a000xb31f66aa3c1e785363f0875a1b74e27b85fd66c72022-05-21T23:45:29.000Z0xdc7a5ccb95deab649c457efa504473eb03331f831b4d563acf0a15bc927a6200
0xc3c79b56d948f35625467c9b7ea3c7f9240b173b0xff133a6d335b50bdaa6612d19e1352b049a8ae6afalse90x3cca2cbb23e2eb86afcce43bbd46cf9d3d3eddaf150064530x63bbaa858cfaadc1a4ed795a1bd7351c1f6a5a000xb31f66aa3c1e785363f0875a1b74e27b85fd66c72022-05-21T23:43:59.000Z0x4f7714f7a489d31275e075e7032d999b19c42b95a331aa6238079cd0bed64fb6
Query with partition filter
SELECT *
FROM `tt-contracts.dodo_v2_avalanche.VendingMachineFactory_NewDVM_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100