> ## Documentation Index
> Fetch the complete documentation index at: https://tokenterminal.com/docs/llms.txt
> Use this file to discover all available pages before exploring further.
# dodo_v2_arbitrum
> Tables in tt-contracts.dodo_v2_arbitrum
## 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.
| 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_i` | `STRING` | Index or identifier parameter used in protocol operations. Numeric string representing a position, rate, or configuration value. |
| `in_user` | `STRING` | Address of the user account associated with the transaction or protocol operation. Hex-encoded, 0x-prefixed, 42-character string. |
| `in_reward` | `STRING` | Contract address of the reward token being distributed or claimed. Hex-encoded, 0x-prefixed, 42-character string. |
| in\_i | address | in\_user | removed | in\_reward | log\_index | block\_number | block\_timestamp | transaction\_hash |
| ----- | ------------------------------------------ | ------------------------------------------ | ------- | -------------------- | ---------- | ------------- | ------------------------ | ------------------------------------------------------------------ |
| 0 | 0x38dbb42c4972116c88e27edfacd2451cf1b14255 | 0x03d45ed1f865e52af716deda00734795ab617f4b | false | 19812286046520941504 | 1 | 271557 | 2021-09-04T09:25:16.000Z | 0x99ca54c0246c4eee5ce327d8d3313d885f4002027dfe208b5072056ea2045154 |
| 0 | 0x38dbb42c4972116c88e27edfacd2451cf1b14255 | 0x0abc081c9afbe045b4605bd1bbc85fa879f7d0d0 | false | 18377839697383834277 | 1 | 269002 | 2021-09-04T01:14:54.000Z | 0x0778ac73c3753ba41078e13d5472f52085748e7a9829b6fd91634a440dbcac9d |
| 0 | 0x38dbb42c4972116c88e27edfacd2451cf1b14255 | 0x0abc081c9afbe045b4605bd1bbc85fa879f7d0d0 | false | 8308183954190073352 | 1 | 271645 | 2021-09-04T09:46:36.000Z | 0x15900c22e2802202fe592ad61e575d74082ac9cabfcd03138a39115daf050407 |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.dodo_v2_arbitrum.Mine_Claim_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### 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.
| 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. |
| address | removed | in\_trader | log\_index | in\_toToken | in\_receiver | in\_toAmount | block\_number | in\_fromToken | in\_fromAmount | block\_timestamp | transaction\_hash |
| ------------------------------------------ | ------- | ------------------------------------------ | ---------- | ------------------------------------------ | ------------------------------------------ | -------------- | ------------- | ------------------------------------------ | -------------- | ------------------------ | ------------------------------------------------------------------ |
| 0x4c93609ba98675be8705383d9736f43c045460ef | false | 0x8ab2d334ce64b50be9ab04184f7ccba2a6bb6391 | 10 | 0xff970a61a04b1ca14834a43f5de4533ebddb5cc8 | 0xbce44767af0a53a108b3b7ba4f740e03d228ec0a | 105643 | 86878535 | 0x82af49447d8a07e3bd95bd0d56f35241523fbab1 | 55105156624441 | 2023-05-03T13:22:31.000Z | 0x4a8b1c0a9f7b752a93366127fdcbee4b486ed33b506c15950d8f3d09d5e797be |
| 0x4c93609ba98675be8705383d9736f43c045460ef | false | 0x8ab2d334ce64b50be9ab04184f7ccba2a6bb6391 | 21 | 0xff970a61a04b1ca14834a43f5de4533ebddb5cc8 | 0x6a58c68ff5c4e4d90eb6561449cc74a64f818da5 | 177427 | 86914197 | 0x82af49447d8a07e3bd95bd0d56f35241523fbab1 | 94452594713858 | 2023-05-03T15:50:47.000Z | 0xbdc498131b7062689809a2c966785785fc908e895be4878a6ccb0401a84fc232 |
| 0x8f11519f4f7c498e1f940b9de187d9c390321016 | false | 0x8ab2d334ce64b50be9ab04184f7ccba2a6bb6391 | 18 | 0x82af49447d8a07e3bd95bd0d56f35241523fbab1 | 0x3b6067d4caa8a14c63fdbe6318f27a0bbc9f9237 | 26310212671271 | 86914197 | 0xfd086bc7cd5c481dcc9c85ebe478a1c0b69fcbb9 | 48550 | 2023-05-03T15:50:47.000Z | 0xbdc498131b7062689809a2c966785785fc908e895be4878a6ccb0401a84fc232 |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.dodo_v2_arbitrum.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.
| 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. |
| address | removed | log\_index | block\_number | block\_timestamp | in\_newLpFeeRate | transaction\_hash |
| ------------------------------------------ | ------- | ---------- | ------------- | ------------------------ | ------------------- | ------------------------------------------------------------------ |
| 0x1666ea6e83bcc3473111732ef086ba47e6eddeb7 | false | 79 | 240387510 | 2024-08-07T13:25:28.000Z | 1000000000000000000 | 0x92420ff95c1459af16463d2fe7fc809751cedff01ead62ba99e82ec9be6b2bee |
| 0x869f51989bbe4a49a03daf49ec57572fccef3b81 | false | 37 | 240387511 | 2024-08-07T13:25:28.000Z | 1000000000000000000 | 0x2acc5fe82e030818dc7d52ce24a666b103a91bc7d3daf4c3f5cc4acf758da6e6 |
| 0x716aa091d30a88a3e1874d56e99fbf1487cbc65a | false | 38 | 240387511 | 2024-08-07T13:25:28.000Z | 1000000000000000000 | 0x3ddf744175669963c28dd87291d64e82a89c1e6334500d2ef9ae5889a777e133 |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.dodo_v2_arbitrum.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.
| 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. |
| in\_dpp | address | removed | log\_index | in\_creator | block\_number | in\_baseToken | in\_quoteToken | block\_timestamp | transaction\_hash |
| ------------------------------------------ | ------------------------------------------ | ------- | ---------- | ------------------------------------------ | ------------- | ------------------------------------------ | ------------------------------------------ | ------------------------ | ------------------------------------------------------------------ |
| 0x09caee5f8e2c24b09c48fea8ff802ae2af7490f6 | 0xa6cf3d163358af376ec5e8b7cc5e102a05fde63d | false | 34 | 0xc72ed51dbb7acf64871ab3eb2770870093d66b5f | 85407049 | 0x82af49447d8a07e3bd95bd0d56f35241523fbab1 | 0x390609e6e1e75743c882331d65a9f523c48f50e9 | 2023-04-29T05:47:31.000Z | 0x20e61b070d4d642390eb308229a61502330a1fd9b2407ecfbe8a8c70b74a402f |
| 0x95e5b46b4d350b2688d27d5a57cb43456a697065 | 0xa6cf3d163358af376ec5e8b7cc5e102a05fde63d | false | 8 | 0x968cd825522c50a9e1d393a546e560e49940d8e2 | 233651798 | 0xfd086bc7cd5c481dcc9c85ebe478a1c0b69fcbb9 | 0xff970a61a04b1ca14834a43f5de4533ebddb5cc8 | 2024-07-18T23:41:30.000Z | 0x3cd8270956521f7578d548304fbd403a92c14769884ba3bddc93e45ae1ad8aee |
| 0xa9733980d009578ba51cd100d75b7e6be4850691 | 0xa6cf3d163358af376ec5e8b7cc5e102a05fde63d | false | 30 | 0xcd152b4450acbfdd3bc1541514a624f5da45b5df | 233463582 | 0xfd086bc7cd5c481dcc9c85ebe478a1c0b69fcbb9 | 0xff970a61a04b1ca14834a43f5de4533ebddb5cc8 | 2024-07-18T10:31:51.000Z | 0x73b6b45ada0a7951622ff64e3d5f585aa1ace65df0a60d0ca27828fa5fd841c8 |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.dodo_v2_arbitrum.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.
| 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. |
| address | removed | in\_trader | log\_index | in\_toToken | in\_receiver | in\_toAmount | block\_number | in\_fromToken | in\_fromAmount | block\_timestamp | transaction\_hash |
| ------------------------------------------ | ------- | ------------------------------------------ | ---------- | ------------------------------------------ | ------------------------------------------ | ------------------ | ------------- | ------------------------------------------ | ----------------- | ------------------------ | ------------------------------------------------------------------ |
| 0xe6cecb7460c9e52aa483cb1f0e87d78d7085686f | false | 0x00000000cfe3369bcdbc76071ba6e0a4e0fe98bd | 3 | 0x82af49447d8a07e3bd95bd0d56f35241523fbab1 | 0x00000000cfe3369bcdbc76071ba6e0a4e0fe98bd | 60179880913855878 | 258667256 | 0x2416092f143378750bb29b79ed961ab195cceea5 | 59102036793517684 | 2024-09-29T18:44:55.000Z | 0x99aa4fd670b4e9f84b03f9ee688ec0ac19986d3a69d92d9b0bdc0f19c83dcda0 |
| 0xe6cecb7460c9e52aa483cb1f0e87d78d7085686f | false | 0x00000000cfe3369bcdbc76071ba6e0a4e0fe98bd | 9 | 0x82af49447d8a07e3bd95bd0d56f35241523fbab1 | 0x00000000cfe3369bcdbc76071ba6e0a4e0fe98bd | 32176904985189051 | 258654200 | 0x2416092f143378750bb29b79ed961ab195cceea5 | 31577860049823027 | 2024-09-29T17:49:58.000Z | 0x0437d954285002f0d393f9d5fcbb28d06eb358b99d5ab6296432f15f28f4bfb0 |
| 0x3a7bc5f9e41356728f037f17d88c642ee46d1aaa | false | 0x00000000cfe3369bcdbc76071ba6e0a4e0fe98bd | 28 | 0x82af49447d8a07e3bd95bd0d56f35241523fbab1 | 0x00000000cfe3369bcdbc76071ba6e0a4e0fe98bd | 104193195213044014 | 258737235 | 0x35751007a407ca6feffe80b3cb397736d2cf4dbe | 99720181954596217 | 2024-09-29T23:40:52.000Z | 0x4c823826f24912242d94674f08c419be6c41f4a0e2fc479021929ba796de011e |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.dodo_v2_arbitrum.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.
| 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. |
| in\_DSP | address | removed | log\_index | in\_creator | block\_number | in\_baseToken | in\_quoteToken | block\_timestamp | transaction\_hash |
| ------------------------------------------ | ------------------------------------------ | ------- | ---------- | ------------------------------------------ | ------------- | ------------------------------------------ | ------------------------------------------ | ------------------------ | ------------------------------------------------------------------ |
| 0x798be01888b06b9c6d4d74e4d4cbb8019645a57c | 0xc8fe2440744dcd733246a4db14093664defd5a53 | false | 31 | 0x12d23991bd8a25333036cf41f44af6894f2ca61c | 233191801 | 0xfd086bc7cd5c481dcc9c85ebe478a1c0b69fcbb9 | 0xff970a61a04b1ca14834a43f5de4533ebddb5cc8 | 2024-07-17T15:19:14.000Z | 0x4bd13bfa6fb284bdaba3324acf151be10594396d2cbb720f3c7ebd9321e71683 |
| 0xc1649de4ca3247a15835f41a38db28d1d737f5e7 | 0xc8fe2440744dcd733246a4db14093664defd5a53 | false | 2 | 0xd7016d27964e7a32a60c5c1d9b751bde39596b9a | 233259969 | 0xfd086bc7cd5c481dcc9c85ebe478a1c0b69fcbb9 | 0xff970a61a04b1ca14834a43f5de4533ebddb5cc8 | 2024-07-17T20:04:03.000Z | 0x7319dc94ca93ebd2f54cd56c5c28e31c675737406e3d6a53234f85066ef8f7df |
| 0x8d80b391f87768310992e7e616899489fd23e1ff | 0xc8fe2440744dcd733246a4db14093664defd5a53 | false | 2 | 0x17f80ece5b9b56ef9122c4fce4ad65af8342c41b | 233314703 | 0xfd086bc7cd5c481dcc9c85ebe478a1c0b69fcbb9 | 0xff970a61a04b1ca14834a43f5de4533ebddb5cc8 | 2024-07-17T23:53:01.000Z | 0x197f551b5234331141dd6811b372c438e12bddad8bc4af0cc976d61162eb4a74 |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.dodo_v2_arbitrum.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.
| 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. |
| address | removed | in\_trader | log\_index | in\_toToken | in\_receiver | in\_toAmount | block\_number | in\_fromToken | in\_fromAmount | block\_timestamp | transaction\_hash |
| ------------------------------------------ | ------- | ------------------------------------------ | ---------- | ------------------------------------------ | ------------------------------------------ | -------------------- | ------------- | ------------------------------------------ | -------------- | ------------------------ | ------------------------------------------------------------------ |
| 0x6a58c68ff5c4e4d90eb6561449cc74a64f818da5 | false | 0x0aacc6124269f9591a5fcb33d34654918c151221 | 29 | 0x69eb4fa4a2fbd498c257c57ea8b7655a2559a581 | 0x1087a3254c35a7809cd6112422ea195ecda6e993 | 13621399676902058336 | 82267012 | 0xff970a61a04b1ca14834a43f5de4533ebddb5cc8 | 2333096 | 2023-04-20T00:59:19.000Z | 0x8b3fd60c3716415ec43463efb5da8c948f5ef7c6da601fc03a1265d335ca6cb8 |
| 0x6a58c68ff5c4e4d90eb6561449cc74a64f818da5 | false | 0x0aacc6124269f9591a5fcb33d34654918c151221 | 45 | 0x69eb4fa4a2fbd498c257c57ea8b7655a2559a581 | 0x1087a3254c35a7809cd6112422ea195ecda6e993 | 20038540272227156703 | 82572828 | 0xff970a61a04b1ca14834a43f5de4533ebddb5cc8 | 3239469 | 2023-04-20T22:14:15.000Z | 0x8e6259963fe73adb116e44fc576b028937879c713477d1039f2df3a05b001465 |
| 0x34851ea13bde818b1efe26d31377906b47c9bbe2 | false | 0x0aacc6124269f9591a5fcb33d34654918c151221 | 22 | 0x4e352cf164e64adcbad318c3a1e222e9eba4ce42 | 0x0aacc6124269f9591a5fcb33d34654918c151221 | 13481404508221159247 | 82399855 | 0xff970a61a04b1ca14834a43f5de4533ebddb5cc8 | 196632957 | 2023-04-20T10:15:49.000Z | 0x16c6e9cf8fe8bb959a726511eaf818d7f554b2177d4564fbc805bd0889765207 |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.dodo_v2_arbitrum.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.
| 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. |
| in\_dvm | address | removed | log\_index | in\_creator | block\_number | in\_baseToken | in\_quoteToken | block\_timestamp | transaction\_hash |
| ------------------------------------------ | ------------------------------------------ | ------- | ---------- | ------------------------------------------ | ------------- | ------------------------------------------ | ------------------------------------------ | ------------------------ | ------------------------------------------------------------------ |
| 0x78c73272e4657d1d7dc17dd334f04b40b6db53fc | 0xda4c4411c55b0785e501332354a036c04833b72b | false | 6 | 0x13add9bf8f578647432925e4f449aee7d81fadfc | 123581310 | 0x97927626b089eb1de1f7f85ece3ee022d7432454 | 0x82af49447d8a07e3bd95bd0d56f35241523fbab1 | 2023-08-21T14:57:10.000Z | 0x1fbb45f4bea9e166482e568c36bb2987c75447da7a720655c1fa6f71f405f57b |
| 0xf26c525c3eada8ed9ebffc7045f3a571961b547a | 0xda4c4411c55b0785e501332354a036c04833b72b | false | 0 | 0x597dc4159a4b85c086c3c679a0b6c8fe2836886f | 147201936 | 0x82af49447d8a07e3bd95bd0d56f35241523fbab1 | 0xff970a61a04b1ca14834a43f5de4533ebddb5cc8 | 2023-11-04T23:50:48.000Z | 0x9ef979d3366a968b33fe99e3733fcc11e975c597e61823fdb7142790d8525f70 |
| 0xdb1bc79542d5ca6504b42286b238032e7c8d9c15 | 0xda4c4411c55b0785e501332354a036c04833b72b | false | 2 | 0x8eda0bd868eb10604e9f773edb8fb0cf25c8a3d6 | 270812348 | 0xaf88d065e77c8cc2239327c5edb3a432268e5831 | 0xfd086bc7cd5c481dcc9c85ebe478a1c0b69fcbb9 | 2024-11-04T03:19:23.000Z | 0x5b45347ce199290e783079dd3f40fc377a111fc3c594ab15c28be36e5911b4df |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.dodo_v2_arbitrum.VendingMachineFactory_NewDVM_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***