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
0x562d0e58f6940eb52574355096ce78383326b98afalse0x614fde56413fc27690e80eba780d3f18c55116f5180xc1525f2993fb81c394ed6051dabee9371c27ed430x614fde56413fc27690e80eba780d3f18c55116f57744987129886569011079922870xe47c0f27cf0c84a7326b75e508503108280464d5172779630536865272242023-08-09T12:15:51.000Z0x6c758445dd5db6ac8579c3ccda0f7dd4e753828b65481652335709184d838d24
0x562d0e58f6940eb52574355096ce78383326b98afalse0x614fde56413fc27690e80eba780d3f18c55116f5230xc1525f2993fb81c394ed6051dabee9371c27ed430x614fde56413fc27690e80eba780d3f18c55116f519548090380401576491079923050xe47c0f27cf0c84a7326b75e508503108280464d5450149033738070533142023-08-09T12:16:27.000Z0xc09ffa91ea07c48489fa881447a7b5db255e5f4bc2d0b73575389d0d8ff800ec
0x562d0e58f6940eb52574355096ce78383326b98afalse0x614fde56413fc27690e80eba780d3f18c55116f5250xc1525f2993fb81c394ed6051dabee9371c27ed430x614fde56413fc27690e80eba780d3f18c55116f523427276655858085471079923140xe47c0f27cf0c84a7326b75e508503108280464d5545051860185783381122023-08-09T12:16:45.000Z0x0e6fb5ad4e77f1d150777662c8abeb56f5371c0d6a233b8561acae65f9d126c8
Query with partition filter
SELECT *
FROM `tt-contracts.dodo_v2_optimism.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
0x60bdce55f4facf4dd3aefc4d915a89e7d5db4a89false3704453362023-01-25T22:26:53.000Z600000000000000000x5310967a9207b59f507327f6fc97936aa642eaadd6037e0b8ab3fa5280129bd5
0xe5f75576e93cbd3f51e079a03c8a8dc7a1e8df36false871091435912023-09-05T03:52:39.000Z100000000000000000x435b182f33cd582cef9cf13d81f4e041fa4555a2928a9096e2a52ddfae0fe62f
0x10349d274c7d8a2ba0f3da86fef6080bf4abad2cfalse71300862582025-01-01T22:41:33.000Z400000000000000000x235e57cecb74417f066101c5bc004d5000c05ff06e002a5e1825fc0360baa802
Query with partition filter
SELECT *
FROM `tt-contracts.dodo_v2_optimism.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
0x60bdce55f4facf4dd3aefc4d915a89e7d5db4a890xdb9c53f2ced34875685b607c97a61a65da2f30a8false40xe5a8de4b1f810369d1d8723198934c4987df7da6704336580xda4fcf19bef55b9d11d65a2a2926c81283d5aaf50xfb21b70922b9f6e3c6274bcd6cb1aa8a0fe20b802023-01-25T21:43:51.000Z0x41cc63406022c0213706637e3c54a8055f4b61135fefed275fbd07a6eb93b2c8
0xe5f75576e93cbd3f51e079a03c8a8dc7a1e8df360xdb9c53f2ced34875685b607c97a61a65da2f30a8false150x49cb62b515611699c3415ea28573dfdf58181b3d1091433570x42000000000000000000000000000000000000060x6699564f4c4cd7c5df2d5fdd28be0400e83df9862023-09-05T03:44:51.000Z0x887499625f0386d8c473881968d3e85999d470dd0a6a9d61d50416f1d1677f7a
0x562d0e58f6940eb52574355096ce78383326b98a0xdb9c53f2ced34875685b607c97a61a65da2f30a8false40x3c9f68e0f63541168907253acd3149b70b2f45c263393410xc1525f2993fb81c394ed6051dabee9371c27ed430xe47c0f27cf0c84a7326b75e508503108280464d52022-04-24T03:49:02.000Z0x3845282ac302a8db44f19f966b8b1ae2be159e1a50d64b428d6d1d0a96a2471a
Query with partition filter
SELECT *
FROM `tt-contracts.dodo_v2_optimism.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
0xd42bac50a828ed21cbd827e6e68d13c328a6d139false0x169ae3d5acc90f0895790f6321ee81cb040e8a6b330x42000000000000000000000000000000000000060x716fcc67dca500a91b4a28c9255262c398d8f97196057705547571162094500x94b008aa00579c1307b0ef2c499ad98a8ce58e58230912024-02-15T17:21:17.000Z0xb6b013932888df5082e8d7093a3e7849daa563bb1801549095c1e92e4d06fd9d
0x677ed69001b4be10ca884707509d6d549a63387afalse0x614fde56413fc27690e80eba780d3f18c55116f5270xe47c0f27cf0c84a7326b75e508503108280464d50x614fde56413fc27690e80eba780d3f18c55116f5936097435409454315621144827290xc1525f2993fb81c394ed6051dabee9371c27ed4333930828862961688092024-01-06T18:03:55.000Z0x9e9043f441b529fca16f4b256763552e52355e4a5ecfcd1b7b28cdf9adba1312
0xd42bac50a828ed21cbd827e6e68d13c328a6d139false0x169ae3d5acc90f0895790f6321ee81cb040e8a6b170x42000000000000000000000000000000000000060xd1778f9df3eee5473a9640f13682e3846f61febc74404698374621157613880x94b008aa00579c1307b0ef2c499ad98a8ce58e58168542024-02-05T08:25:53.000Z0xae24efe3c529bac326fe630a16abddad1be3179096da0df8734953318a934f6f
Query with partition filter
SELECT *
FROM `tt-contracts.dodo_v2_optimism.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
0x677ed69001b4be10ca884707509d6d549a63387a0x1f83858cd6d0ae7a08ab1fd977c06dabece6d711false00x3c9f68e0f63541168907253acd3149b70b2f45c263391930xc1525f2993fb81c394ed6051dabee9371c27ed430xe47c0f27cf0c84a7326b75e508503108280464d52022-04-24T03:44:17.000Z0xf96f320007ae7fd4c71b67636a57d2813488cc9e8771d40e505266f8e7cee4d1
0x5a4bedfc3ba13f242574089d2b9db9db4b7dd4e80x1f83858cd6d0ae7a08ab1fd977c06dabece6d711false3220x226713aa2c572a32a48e63ff0e0a1dbf078781f51143526160x597f9e2a36cc4a2febfbe3774dd5c3a60d6df38a0x0b2c639c533813f4aa9d7837caf62653d097ff852024-01-03T17:46:49.000Z0x0a3c068142aa55d8990fa845aaa6157d0406cf99ca06718916bf3eb5dbce4d1d
0x4d4d1308dad78e4f70c1b0de62e9e696b868062f0x1f83858cd6d0ae7a08ab1fd977c06dabece6d711false340x82e65918d19b1723c6367d1d5226d3713f38c3ec1085603670x2297aebd383787a160dd0d9f71508148769342e30x68f180fcce6836688e9084f035309e29bf0a20952023-08-22T15:51:51.000Z0xa9905ee5690c91e55bb5551f421342bb973f78476061c7ce88ee02a19476bc52
Query with partition filter
SELECT *
FROM `tt-contracts.dodo_v2_optimism.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
0x57a4cd063afc855ba2ad4e9dbfbd1be286632a44false0x169ae3d5acc90f0895790f6321ee81cb040e8a6b80x94b008aa00579c1307b0ef2c499ad98a8ce58e580xd073453a64c8697f54c028f0d20b449b2f796cbc179950943776130x4200000000000000000000000000000000000006894395015444732023-04-26T09:52:32.000Z0x51179b56e5ada87e3acab725f29c381d2fac5f1eb15735fd6d62aca3b72bb24d
0xadd0484fa00f03dbfe28be697477fa29fe14cc64false0x169ae3d5acc90f0895790f6321ee81cb040e8a6b120x7f5c764cbc14f9669b88837ca1490cca17c316070xd1778f9df3eee5473a9640f13682e3846f61febc27581110153650x420000000000000000000000000000000000000617006552323582023-10-18T11:45:07.000Z0xb0117c27be3c9944137279703ef121529c5cc48558763536acd88e147bc77a99
0xf874689d20ba87b5cd84aecb37b7e7a447d0c422false0x169ae3d5acc90f0895790f6321ee81cb040e8a6b230x7f5c764cbc14f9669b88837ca1490cca17c316070x31ac053c31a77055b2ae2d3899091c0a9c19ce3a11088821076799660x2885f7882b13af382481cc173a0335702f7905279688863637610517662023-08-02T06:45:09.000Z0x050fd26f9fede7c11ddbea6080ddfb56e6e9fdbf46dc0a26686d3dbcc62b9590
Query with partition filter
SELECT *
FROM `tt-contracts.dodo_v2_optimism.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
0x1356a96fd06f2e8e123c1a59e25f8688647e66630x2b800dc6270726f7e2266ce8cd5a3f8436fe0b40false500xb7b4d65cb5a0c44ccb9019ca74745686188173db1068629840x42000000000000000000000000000000000000420x94b008aa00579c1307b0ef2c499ad98a8ce58e582023-07-14T08:52:25.000Z0x80c30ee39b95a75425300aab7c14a7008282e9caa394fcb583b059e392f53e4d
0x3965ddef20cfa912e83e89610269c552526dc7a40x2b800dc6270726f7e2266ce8cd5a3f8436fe0b40false360x816f83e8ab35d17a21f7fed26f37fbf7803532291072535610x7f5c764cbc14f9669b88837ca1490cca17c316070x8c6f28f2f1a3c87f0f938b96d27520d9751ec8d92023-07-23T09:51:39.000Z0xfde730b79e136854f480f14ffb5da65e142bbab76c0a2ad9044f66ee0d58aabe
0xdb0d2772de5d9760ef4bee05dce012c6e4f9a5c80x2b800dc6270726f7e2266ce8cd5a3f8436fe0b40false00x3c9f68e0f63541168907253acd3149b70b2f45c264196580x7f5c764cbc14f9669b88837ca1490cca17c316070x42000000000000000000000000000000000000062022-04-25T09:16:16.000Z0x79f918e220c47dbd4a56974f01f2f4fa87e9cfc80e4fcaf5986c59f5b39d13b6
Query with partition filter
SELECT *
FROM `tt-contracts.dodo_v2_optimism.VendingMachineFactory_NewDVM_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100