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.Columns
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_fromToken | STRING | Contract address of the source token being swapped. Hex-encoded, 0x-prefixed, 42-character string. |
in_toToken | STRING | Contract address of the destination token being received in the swap. Hex-encoded, 0x-prefixed, 42-character string. |
in_fromAmount | STRING | Amount of tokens being swapped from the source token. String-encoded integer value representing the quantity in the smallest unit of the token. |
in_toAmount | STRING | Amount 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_trader | STRING | Address that initiated or executed the trade transaction. Hex-encoded, 0x-prefixed, 42-character string. |
in_receiver | STRING | Address that receives tokens, assets, or rewards from the transaction. Hex-encoded, 0x-prefixed, 42-character string. |
Sample Data
Sample Data
| address | removed | in_trader | log_index | in_toToken | in_receiver | in_toAmount | block_number | in_fromToken | in_fromAmount | block_timestamp | transaction_hash |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 0xeee69c0ac5115104295489194981b564c15b15df | false | 0xd72b354bd39f8f11d0ca07bd5724896bb1a42707 | 5 | 0x130966628846bfd36ff31a822705796e8cb8c18d | 0x0b64c1769cc9fe9064d2507c1b13125fd664026f | 8473403205871399320 | 20956580 | 0x5541d83efad1f281571b343977648b75d95cdac2 | 25049959876622824690 | 2022-10-12T05:27:14.000Z | 0xd7dc6f0a4b3549dfac1cafdb1cf1576aab0a4c8e322cb0d0e055b5319ca71e33 |
| 0xeee69c0ac5115104295489194981b564c15b15df | false | 0xd72b354bd39f8f11d0ca07bd5724896bb1a42707 | 9 | 0x130966628846bfd36ff31a822705796e8cb8c18d | 0x0b64c1769cc9fe9064d2507c1b13125fd664026f | 1963741574813867704 | 20957299 | 0x5541d83efad1f281571b343977648b75d95cdac2 | 5776323628528674526 | 2022-10-12T05:52:30.000Z | 0x42f7f32962a1c65d0228d5b4691b74232654852b49f08b30b36643c347794cd8 |
| 0x1ccc652b6a104b7e3adf7ff030b892e37097c111 | false | 0xf01ef4051130cc8871fa0c17024a6d62e379e856 | 28 | 0xb97ef9ef8734c71904d8002f8b6bc66dd9c48a6e | 0xf1f4ce5dd70d4384f9b764020f26e8cabee39070 | 42183670 | 29454219 | 0x152b9d0fdc40c096757f570a51e494bd4b943e50 | 147758 | 2023-05-01T11:02:31.000Z | 0x904fa12eb4ddf37bad0a4dfeb46b62a4b171c76adf036faf23f718b360dac376 |
Example Query
Example Query
Query with partition filter
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.Columns
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_newLpFeeRate | STRING | New liquidity provider fee rate set by the pool update. String-encoded integer representing the fee rate in basis points or wei-denominated fractional units. |
Sample Data
Sample Data
| address | removed | log_index | block_number | block_timestamp | in_newLpFeeRate | transaction_hash |
|---|---|---|---|---|---|---|
| 0x1ccc652b6a104b7e3adf7ff030b892e37097c111 | false | 0 | 30937850 | 2023-06-05T11:00:05.000Z | 1326238500000000 | 0x39e469e3d6ba2342faf900346ae1387d42d6a590997b00731dfc2c3b0b855a86 |
| 0x1ccc652b6a104b7e3adf7ff030b892e37097c111 | false | 0 | 30928682 | 2023-06-05T05:53:22.000Z | 1067030800000000 | 0x3c9d435fc2709175c8e5a60fb58fb2b08b6917fbdba5b2116d56c4f0d35bd8df |
| 0x1ccc652b6a104b7e3adf7ff030b892e37097c111 | false | 0 | 30937765 | 2023-06-05T10:57:13.000Z | 884061800000000 | 0x47bcbe15a1df63904cf82751534e4430630b64341df682533db4b6b679561139 |
Example Query
Example Query
Query with partition filter
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.Columns
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_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_creator | STRING | Address of the account that initiated the creation event. Hex-encoded, 0x-prefixed, 42-character string. |
in_dpp | STRING | Contract address of the DODO Private Pool (DPP) created by the factory. Hex-encoded, 0x-prefixed, 42-character string. |
Sample Data
Sample Data
| in_dpp | address | removed | log_index | in_creator | block_number | in_baseToken | in_quoteToken | block_timestamp | transaction_hash |
|---|---|---|---|---|---|---|---|---|---|
| 0x8a40309a9ed92b4521aec52c368907ab2f97dec2 | 0xb7865a5cee051d35b09a48b624d7057d3362655a | false | 2 | 0x0b64c1769cc9fe9064d2507c1b13125fd664026f | 24408558 | 0x130966628846bfd36ff31a822705796e8cb8c18d | 0xdea949fc7c9dae3893c0a033eda19d1dd1eb450b | 2023-01-02T03:46:34.000Z | 0x866a17a52c44aa5429b1f7114c0a302ad9cd169127a1dc909ddc349a39cd72a0 |
| 0xc995fbec7f4780ac6c0cba8d811ed9da5387676f | 0xb7865a5cee051d35b09a48b624d7057d3362655a | false | 14 | 0x15c4c90d0ccb73ace46e25a6a9c94581f14e63dc | 30266406 | 0xb97ef9ef8734c71904d8002f8b6bc66dd9c48a6e | 0xaec8318a9a59baeb39861d10ff6c7f7bf1f96c57 | 2023-05-20T14:36:41.000Z | 0x1e33d0ec23edba4bbd781334293a60905116ee81a622a847c3b03ccc8e72848b |
| 0x900b1ea3e06127e5c53fe491fd62880018fae920 | 0xb7865a5cee051d35b09a48b624d7057d3362655a | false | 5 | 0x995be1ca945174d5ba75410c1e658a41eb13a2fa | 27287415 | 0xb31f66aa3c1e785363f0875a1b74e27b85fd66c7 | 0x9702230a8ea53601f5cd2dc00fdbc13d4df4a8c7 | 2023-03-11T05:55:13.000Z | 0x7859c928418cb83090bbb459c6c18add35a3e416525ab6c380effbcf8b98ec6a |
Example Query
Example Query
Query with partition filter
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.Columns
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_fromToken | STRING | Contract address of the source token being swapped. Hex-encoded, 0x-prefixed, 42-character string. |
in_toToken | STRING | Contract address of the destination token being received in the swap. Hex-encoded, 0x-prefixed, 42-character string. |
in_fromAmount | STRING | Amount of tokens being swapped from the source token. String-encoded integer value representing the quantity in the smallest unit of the token. |
in_toAmount | STRING | Amount 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_trader | STRING | Address that initiated or executed the trade transaction. Hex-encoded, 0x-prefixed, 42-character string. |
in_receiver | STRING | Address that receives tokens, assets, or rewards from the transaction. Hex-encoded, 0x-prefixed, 42-character string. |
Sample Data
Sample Data
| address | removed | in_trader | log_index | in_toToken | in_receiver | in_toAmount | block_number | in_fromToken | in_fromAmount | block_timestamp | transaction_hash |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 0xbb02ae33acbe46b80e5767130b9a13333d93b844 | false | 0xf081470f5c6fbccf48cc4e5b82dd926409dcdd67 | 12 | 0xb97ef9ef8734c71904d8002f8b6bc66dd9c48a6e | 0xf081470f5c6fbccf48cc4e5b82dd926409dcdd67 | 1769631 | 36224843 | 0xf4003f4efbe8691b60249e6afbd307abe7758adb | 312248396786 | 2023-10-09T08:07:17.000Z | 0x2292be0a32ac05d3c03034e21437af73839f56447f3b2df422d7d8f15163887b |
| 0xbb02ae33acbe46b80e5767130b9a13333d93b844 | false | 0xebf00ad513e398a336c61b3b8a59c8a6fcf4f770 | 32 | 0xf4003f4efbe8691b60249e6afbd307abe7758adb | 0xebf00ad513e398a336c61b3b8a59c8a6fcf4f770 | 72267440311 | 36224843 | 0xb97ef9ef8734c71904d8002f8b6bc66dd9c48a6e | 486131 | 2023-10-09T08:07:17.000Z | 0xf3bcee071dc57ec10d960cecea1a816f8c2b3108f9752460a0bde154285bb2de |
| 0xbb02ae33acbe46b80e5767130b9a13333d93b844 | false | 0xbdd1cda63d5243fe563756065e94f23e3577e1ef | 17 | 0xf4003f4efbe8691b60249e6afbd307abe7758adb | 0xbdd1cda63d5243fe563756065e94f23e3577e1ef | 332859254962 | 37636181 | 0xb97ef9ef8734c71904d8002f8b6bc66dd9c48a6e | 3639699 | 2023-11-11T20:00:17.000Z | 0x77dfa17a9763e8ee780b95190dd5531d28857b630fc3910643c1d99c0cc4f367 |
Example Query
Example Query
Query with partition filter
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.Columns
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_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_creator | STRING | Address of the account that initiated the creation event. Hex-encoded, 0x-prefixed, 42-character string. |
in_DSP | STRING | Contract address of the DODO Stable Pool (DSP) created by the factory. Hex-encoded, 0x-prefixed, 42-character string. |
Sample Data
Sample Data
| in_DSP | address | removed | log_index | in_creator | block_number | in_baseToken | in_quoteToken | block_timestamp | transaction_hash |
|---|---|---|---|---|---|---|---|---|---|
| 0x2aaeeb914a796267ce4e1db5dda21d6a5088dd40 | 0x2b0d94eb7a63b8a2909de1cb3951ecf7ae76d2fe | false | 21 | 0x78f4948af786245e00ac615519b43b52eaecd64c | 10803054 | 0xb31f66aa3c1e785363f0875a1b74e27b85fd66c7 | 0xb27f379c050f6ed0973a01667458af6ecebc1d90 | 2022-02-12T01:40:11.000Z | 0x8f74c97156802c04a0f51b9ec35df18cdadeef7e1eca99ddf65fffc5f8cff99e |
| 0xbb02ae33acbe46b80e5767130b9a13333d93b844 | 0x2b0d94eb7a63b8a2909de1cb3951ecf7ae76d2fe | false | 2 | 0x7f1abbe76c281b46f46af479360e6e58b2e6b9f0 | 23408980 | 0xf4003f4efbe8691b60249e6afbd307abe7758adb | 0xb97ef9ef8734c71904d8002f8b6bc66dd9c48a6e | 2022-12-09T10:34:51.000Z | 0xc02091e2c2537e5693b0a0eb6d70b62c21f44e4ccd542ac40bb7197e3acd63af |
| 0x3086d2d30aad816b72d642f482ad88f6d09d20b8 | 0x2b0d94eb7a63b8a2909de1cb3951ecf7ae76d2fe | false | 5 | 0x82149613a938746f18fc1844cc7e103dbf87c527 | 20630133 | 0xc7198437980c041c805a1edcba50c1ce5db95118 | 0x2759ddfdc21dae722288d01250a4b695f95ab0b3 | 2022-10-04T09:43:51.000Z | 0x94a426392f347c13d22033a91b9adf9bb1dd189c6a5a1c56e44b62076224d7de |
Example Query
Example Query
Query with partition filter
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.Columns
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_fromToken | STRING | Contract address of the source token being swapped. Hex-encoded, 0x-prefixed, 42-character string. |
in_toToken | STRING | Contract address of the destination token being received in the swap. Hex-encoded, 0x-prefixed, 42-character string. |
in_fromAmount | STRING | Amount of tokens being swapped from the source token. String-encoded integer value representing the quantity in the smallest unit of the token. |
in_toAmount | STRING | Amount 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_trader | STRING | Address that initiated or executed the trade transaction. Hex-encoded, 0x-prefixed, 42-character string. |
in_receiver | STRING | Address that receives tokens, assets, or rewards from the transaction. Hex-encoded, 0x-prefixed, 42-character string. |
Sample Data
Sample Data
| address | removed | in_trader | log_index | in_toToken | in_receiver | in_toAmount | block_number | in_fromToken | in_fromAmount | block_timestamp | transaction_hash |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 0xb9c2ef7a515c1db214a75f5b8d7d8864ad87b672 | false | 0xd72b354bd39f8f11d0ca07bd5724896bb1a42707 | 44 | 0xb31f66aa3c1e785363f0875a1b74e27b85fd66c7 | 0x3b3e4b4741e91af52d0e9ad8660573e951c88524 | 81837270985590212 | 37045859 | 0xa7d7079b0fead91f3e65f86e8915cb59c1a4c664 | 891462 | 2023-10-28T22:00:56.000Z | 0xe07728b3e7a0987dd83a964ca588afef5590b2e7ffe98e1c504723f368287c72 |
| 0xb9c2ef7a515c1db214a75f5b8d7d8864ad87b672 | false | 0x1d5702c6d7eb30e42a8c94b8db7ea2e8444a37fd | 8 | 0xb31f66aa3c1e785363f0875a1b74e27b85fd66c7 | 0x1d5702c6d7eb30e42a8c94b8db7ea2e8444a37fd | 119638833146308304 | 28044118 | 0xa7d7079b0fead91f3e65f86e8915cb59c1a4c664 | 1999343 | 2023-03-29T09:22:59.000Z | 0x369b07a68c3d6f4afa6e7306510ee2953c65f7c305622e75c5d81af4e13b8004 |
| 0xb9c2ef7a515c1db214a75f5b8d7d8864ad87b672 | false | 0xd72b354bd39f8f11d0ca07bd5724896bb1a42707 | 66 | 0xb31f66aa3c1e785363f0875a1b74e27b85fd66c7 | 0x900b1ea3e06127e5c53fe491fd62880018fae920 | 132768863161648745 | 28061199 | 0xa7d7079b0fead91f3e65f86e8915cb59c1a4c664 | 2288464 | 2023-03-29T19:09:58.000Z | 0xfe457c32c9af898a6fc0bb53f36c8cd67a1981ac14f7b871f698a6dda638e67f |
Example Query
Example Query
Query with partition filter
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.Columns
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_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_creator | STRING | Address of the account that initiated the creation event. Hex-encoded, 0x-prefixed, 42-character string. |
in_dvm | STRING | Contract address of the DVM (DODO Vending Machine) pool created by the factory. Hex-encoded, 0x-prefixed, 42-character string. |
Sample Data
Sample Data
| in_dvm | address | removed | log_index | in_creator | block_number | in_baseToken | in_quoteToken | block_timestamp | transaction_hash |
|---|---|---|---|---|---|---|---|---|---|
| 0xe72e842a0969e34054d390b8c58891c0de96fe08 | 0xff133a6d335b50bdaa6612d19e1352b049a8ae6a | false | 43 | 0x78f4948af786245e00ac615519b43b52eaecd64c | 11249461 | 0x130966628846bfd36ff31a822705796e8cb8c18d | 0xc6710e83abbbbaa6d1576dd30df3baf6147823d8 | 2022-02-22T12:07:37.000Z | 0xa2a78d0297b0401302a4e6a3aa62daabeabac0b10e662d4ec2ea7c203a2239d1 |
| 0xd6a472a1fcf4c8a893985205cd6fa5452d8a31cf | 0xff133a6d335b50bdaa6612d19e1352b049a8ae6a | false | 1 | 0x3cca2cbb23e2eb86afcce43bbd46cf9d3d3eddaf | 15006498 | 0x63bbaa858cfaadc1a4ed795a1bd7351c1f6a5a00 | 0xb31f66aa3c1e785363f0875a1b74e27b85fd66c7 | 2022-05-21T23:45:29.000Z | 0xdc7a5ccb95deab649c457efa504473eb03331f831b4d563acf0a15bc927a6200 |
| 0xc3c79b56d948f35625467c9b7ea3c7f9240b173b | 0xff133a6d335b50bdaa6612d19e1352b049a8ae6a | false | 9 | 0x3cca2cbb23e2eb86afcce43bbd46cf9d3d3eddaf | 15006453 | 0x63bbaa858cfaadc1a4ed795a1bd7351c1f6a5a00 | 0xb31f66aa3c1e785363f0875a1b74e27b85fd66c7 | 2022-05-21T23:43:59.000Z | 0x4f7714f7a489d31275e075e7032d999b19c42b95a331aa6238079cd0bed64fb6 |
Example Query
Example Query
Query with partition filter