> ## 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_base

> Tables in tt-contracts.dodo_v2_base

## 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.

<Accordion title="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.                                       |
</Accordion>

<Accordion title="Sample Data">
  | address                                    | removed | in\_trader                                 | log\_index | in\_toToken                                | in\_receiver                               | in\_toAmount   | block\_number | in\_fromToken                              | in\_fromAmount | block\_timestamp         | transaction\_hash                                                  |
  | ------------------------------------------ | ------- | ------------------------------------------ | ---------- | ------------------------------------------ | ------------------------------------------ | -------------- | ------------- | ------------------------------------------ | -------------- | ------------------------ | ------------------------------------------------------------------ |
  | 0x72e663c4e8fd50184c8b8135315c20326cc4ad75 | false   | 0x66c45ff040e86dc613f239123a5e21ffdc3a3fec | 11         | 0x4200000000000000000000000000000000000006 | 0x987bfbe33c9cf18caa665b792db66339a9c16d32 | 48913428492348 | 9082503       | 0xd9aaec86b65d86f6a7b5b1b0c42ffa531710b6ca | 119735         | 2024-01-11T06:25:53.000Z | 0x6d7286738f31ca5e07af4f85510f23824e2287fe7df4ad60e7e1074ee25951b6 |
  | 0xd804cf0ac2a4b6dd6d375504a27874f5db073625 | false   | 0x66c45ff040e86dc613f239123a5e21ffdc3a3fec | 91         | 0x4200000000000000000000000000000000000006 | 0x987bfbe33c9cf18caa665b792db66339a9c16d32 | 51919724238418 | 9091329       | 0xd9aaec86b65d86f6a7b5b1b0c42ffa531710b6ca | 131408         | 2024-01-11T11:20:05.000Z | 0x9e07d722b7f016efbeaf6a3f87763288f4cd3d10c37c6e6b01cfcb66de57691c |
  | 0xd804cf0ac2a4b6dd6d375504a27874f5db073625 | false   | 0x66c45ff040e86dc613f239123a5e21ffdc3a3fec | 69         | 0xd9aaec86b65d86f6a7b5b1b0c42ffa531710b6ca | 0x987bfbe33c9cf18caa665b792db66339a9c16d32 | 11827          | 9093621       | 0x4200000000000000000000000000000000000006 | 4449600000000  | 2024-01-11T12:36:29.000Z | 0x47bbac1b3a532f0f892b39344a62c2a46dff8ced68a1f3a25193e765c0c203ae |
</Accordion>

<Accordion title="Example Query">
  **Query with partition filter**

  ```sql theme={null}
  SELECT *
  FROM `tt-contracts.dodo_v2_base.PrivatePool_DODOSwap_event`
  WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
  LIMIT 100
  ```
</Accordion>

***

### 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.

<Accordion title="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. |
</Accordion>

<Accordion title="Sample Data">
  | address                                    | removed | log\_index | block\_number | block\_timestamp         | in\_newLpFeeRate | transaction\_hash                                                  |
  | ------------------------------------------ | ------- | ---------- | ------------- | ------------------------ | ---------------- | ------------------------------------------------------------------ |
  | 0x1172035a744ea18161497e94f0bbce244d51de9f | false   | 9          | 2911743       | 2023-08-21T10:13:53.000Z | 1000000000000000 | 0xfbf4ba5c0fe37da69e846a437852a52a11776f67709eaee21a27038e29c237fb |
  | 0x1172035a744ea18161497e94f0bbce244d51de9f | false   | 6          | 2921288       | 2023-08-21T15:32:03.000Z | 1000000000000000 | 0xdf0365d3c7664c82ee122d600b0a907e58b1c2142e6310477baee792f37f67c4 |
  | 0x1172035a744ea18161497e94f0bbce244d51de9f | false   | 2          | 2910655       | 2023-08-21T09:37:37.000Z | 1000000000000000 | 0xb6a07ad7de8f9e2418e31f889d6b8204304eadf0c52604b0dad8768600e3c863 |
</Accordion>

<Accordion title="Example Query">
  **Query with partition filter**

  ```sql theme={null}
  SELECT *
  FROM `tt-contracts.dodo_v2_base.PrivatePool_LpFeeRateChange_event`
  WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
  LIMIT 100
  ```
</Accordion>

***

### 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.

<Accordion title="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.                               |
</Accordion>

<Accordion title="Sample Data">
  | in\_dpp                                    | address                                    | removed | log\_index | in\_creator                                | block\_number | in\_baseToken                              | in\_quoteToken                             | block\_timestamp         | transaction\_hash                                                  |
  | ------------------------------------------ | ------------------------------------------ | ------- | ---------- | ------------------------------------------ | ------------- | ------------------------------------------ | ------------------------------------------ | ------------------------ | ------------------------------------------------------------------ |
  | 0x1172035a744ea18161497e94f0bbce244d51de9f | 0xc0f9553df63de5a97fe64422c8578d0657c360f7 | false   | 9          | 0xe66eb681394e6ca9e9d2e3dc2d05f5a683439894 | 2644987       | 0x4200000000000000000000000000000000000006 | 0xd9aaec86b65d86f6a7b5b1b0c42ffa531710b6ca | 2023-08-15T06:02:01.000Z | 0xe7729272857acf6f25d5d54afbecd72567a935eaf381203ca6cd89ba3325a8bc |
  | 0x3c388c812dada10e597f802a766e7ce898bc7751 | 0xc0f9553df63de5a97fe64422c8578d0657c360f7 | false   | 21         | 0x9dc0b6b56935af5b6327bbae15f4a13adb0bc742 | 5590030       | 0x4200000000000000000000000000000000000006 | 0x78a087d713be963bf307b18f2ff8122ef9a63ae9 | 2023-10-22T10:10:07.000Z | 0x819cb09d12e3026079d6b534aec1dfc3d25d212cb9406115304349bf70cc4b5c |
  | 0x72e663c4e8fd50184c8b8135315c20326cc4ad75 | 0xc0f9553df63de5a97fe64422c8578d0657c360f7 | false   | 8          | 0x777b5d4790da64e76d26633b0c313047c9741737 | 8841102       | 0x4200000000000000000000000000000000000006 | 0xd9aaec86b65d86f6a7b5b1b0c42ffa531710b6ca | 2024-01-05T16:19:11.000Z | 0xf2183eea9c4e314eb817f04356964c51a4df42ea48959ab9d078fb2c32ea5bab |
</Accordion>

<Accordion title="Example Query">
  **Query with partition filter**

  ```sql theme={null}
  SELECT *
  FROM `tt-contracts.dodo_v2_base.PrivatePoolFactory_NewDPP_event`
  WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
  LIMIT 100
  ```
</Accordion>

***

### 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.

<Accordion title="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.                                       |
</Accordion>

<Accordion title="Sample Data">
  | address                                    | removed | in\_trader                                 | log\_index | in\_toToken                                | in\_receiver                               | in\_toAmount    | block\_number | in\_fromToken                              | in\_fromAmount     | block\_timestamp         | transaction\_hash                                                  |
  | ------------------------------------------ | ------- | ------------------------------------------ | ---------- | ------------------------------------------ | ------------------------------------------ | --------------- | ------------- | ------------------------------------------ | ------------------ | ------------------------ | ------------------------------------------------------------------ |
  | 0xd0a7db7d77c2ba70f659f05b76762019dbbb1fd9 | false   | 0x66c45ff040e86dc613f239123a5e21ffdc3a3fec | 30         | 0x4200000000000000000000000000000000000006 | 0xb130a49065178465931d4f887056328cea5d723f | 35674937127044  | 7592434       | 0x78a087d713be963bf307b18f2ff8122ef9a63ae9 | 146051657583433747 | 2023-12-07T18:36:55.000Z | 0x217961622b9da298fcbaea91c434e5aed9af7913f9f066c66bc9e23de1a62156 |
  | 0x81e7f9cc7b4c19edea430018a0bea263dff14a36 | false   | 0x66c45ff040e86dc613f239123a5e21ffdc3a3fec | 12         | 0xd9aaec86b65d86f6a7b5b1b0c42ffa531710b6ca | 0x987bfbe33c9cf18caa665b792db66339a9c16d32 | 201452          | 7572253       | 0x833589fcd6edb6e08f4c7c32d4f71b54bda02913 | 201457             | 2023-12-07T07:24:13.000Z | 0x1963171a351e160d9439597c0a2653d6655fa5d03a3260babde596b07f0342b8 |
  | 0xd0a7db7d77c2ba70f659f05b76762019dbbb1fd9 | false   | 0x66c45ff040e86dc613f239123a5e21ffdc3a3fec | 8          | 0x4200000000000000000000000000000000000006 | 0x987bfbe33c9cf18caa665b792db66339a9c16d32 | 111991349611519 | 5040642       | 0x78a087d713be963bf307b18f2ff8122ef9a63ae9 | 264998102729063028 | 2023-10-09T16:57:11.000Z | 0x406356ab3aa2ee5fdf6c96ecfef5e2b556a38b7fdf633a880c728f339f3d7cce |
</Accordion>

<Accordion title="Example Query">
  **Query with partition filter**

  ```sql theme={null}
  SELECT *
  FROM `tt-contracts.dodo_v2_base.StablePool_DODOSwap_event`
  WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
  LIMIT 100
  ```
</Accordion>

***

### StablePoolFactory\_createDODOStablePool\_function

Function call records for creating DODO v2 stable pools with base/quote token pairs, liquidity provider fee rates, and price curve parameters (k, i). Returns the deployed stable pool contract address for tracking new pool deployments on the DODO decentralized exchange.

<Accordion title="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.                                                                                                                                                                                  |
  | `trace_address`     | `STRING`    | Hierarchical position of the internal call within a transaction's execution trace. Comma-separated sequence of integers representing the call path, where each number indicates the index of the call at that nesting level, with null representing top-level calls. |
  | `status`            | `BOOL`      | Transaction execution outcome indicator. Boolean value where true represents successful execution and false represents failed execution.                                                                                                                             |
  | `from_address`      | `STRING`    | Address that initiated the transaction or contract call. Hex-encoded, 0x-prefixed, 42-character string.                                                                                                                                                              |
  | `to_address`        | `STRING`    | Address receiving the transaction or contract call. Hex-encoded, 0x-prefixed, 42-character string.                                                                                                                                                                   |
  | `value`             | `FLOAT64`   | Amount of native cryptocurrency sent with the transaction. Floating-point representation in whole units (e.g., ETH, BNB, MATIC).                                                                                                                                     |
  | `gas_used`          | `INT64`     | Amount of gas consumed by the transaction execution. Integer representing the actual computational steps used.                                                                                                                                                       |
  | `gas`               | `INT64`     | Gas limit allocated for the transaction execution. Integer representing the maximum computational steps allowed.                                                                                                                                                     |
  | `signature`         | `STRING`    | Function selector identifying which contract function was called. 10-character hex string including 0x prefix.                                                                                                                                                       |
  | `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_lpFeeRate`      | `STRING`    | Liquidity provider fee rate charged on trades in the pool. Numeric string representing the fee as a fraction with 18 decimal places.                                                                                                                                 |
  | `in_i`              | `STRING`    | Index or identifier parameter used in protocol operations. Numeric string representing a position, rate, or configuration value.                                                                                                                                     |
  | `in_k`              | `STRING`    | K parameter controlling price curve slope in DODO protocol pools. Numeric string representing the slippage coefficient where higher values indicate steeper bonding curves.                                                                                          |
  | `in_isOpenTWAP`     | `BOOL`      | Boolean flag indicating whether Time-Weighted Average Price (TWAP) oracle is enabled for the pool.                                                                                                                                                                   |
  | `out_newStablePool` | `STRING`    | Contract address of the newly created stable pool. Hex-encoded, 0x-prefixed, 42-character string.                                                                                                                                                                    |
</Accordion>

<Accordion title="Sample Data">
  | gas    | in\_i   | in\_k              | value | status | gas\_used | signature  | to\_address                                | block\_number | from\_address                              | in\_baseToken                              | in\_lpFeeRate     | in\_isOpenTWAP | in\_quoteToken                             | trace\_address | block\_timestamp         | transaction\_hash                                                  | out\_newStablePool                         |
  | ------ | ------- | ------------------ | ----- | ------ | --------- | ---------- | ------------------------------------------ | ------------- | ------------------------------------------ | ------------------------------------------ | ----------------- | -------------- | ------------------------------------------ | -------------- | ------------------------ | ------------------------------------------------------------------ | ------------------------------------------ |
  | 658003 | 1580181 | 30000000000000000  | 0     | true   | 379311    | 0xcf5c2f10 | 0x200d866edf41070de251ef92715a6ea825a5eb80 | 14984673      | 0x49186e32fed50fd6b5604a2618c7b0b03cd41414 | 0xcd2f22236dd9dfe2356d7c543161d4d260fd9bcb | 27200000000000000 | false          | 0x833589fcd6edb6e08f4c7c32d4f71b54bda02913 | 0              | 2024-05-26T21:24:53.000Z | 0xa9b04c0e367c72aa3ad8ca440422646b08c19996a11af647dd8518a6d7ccf3ff | 0xaa60bcd8ba941dd65dd5a8229c055b24066033be |
  | 636370 | 799708  | 2000000000000000   | 0     | true   | 364432    | 0xcf5c2f10 | 0x200d866edf41070de251ef92715a6ea825a5eb80 | 23719701      | 0x49186e32fed50fd6b5604a2618c7b0b03cd41414 | 0x462f0085cb261ab49ad048a2b35ee77135684308 | 80000000000000000 | false          | 0xd9aaec86b65d86f6a7b5b1b0c42ffa531710b6ca | 0              | 2024-12-15T02:12:29.000Z | 0xc10302093c71c9100f938aca65af962125f9c943e128b159952ea428a72b61c6 | 0xf442c5fa349a77732c2966b1f0b59b0fcc3b8d76 |
  | 653470 | 1000000 | 100000000000000000 | 0     | true   | 381532    | 0xcf5c2f10 | 0x200d866edf41070de251ef92715a6ea825a5eb80 | 23719396      | 0x49186e32fed50fd6b5604a2618c7b0b03cd41414 | 0x462f0085cb261ab49ad048a2b35ee77135684308 | 80000000000000000 | false          | 0xd9aaec86b65d86f6a7b5b1b0c42ffa531710b6ca | 0              | 2024-12-15T02:02:19.000Z | 0x3ac30f71b10b202fc0f19a6b9477c99e8926f6be4a28672b514769af447137ba | 0x7b9d5af11cde0c0223da13a89288971d4ef73ceb |
</Accordion>

<Accordion title="Example Query">
  **Query with partition filter**

  ```sql theme={null}
  SELECT *
  FROM `tt-contracts.dodo_v2_base.StablePoolFactory_createDODOStablePool_function`
  WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
  LIMIT 100
  ```
</Accordion>

***

### 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.

<Accordion title="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.                                |
</Accordion>

<Accordion title="Sample Data">
  | in\_DSP                                    | address                                    | removed | log\_index | in\_creator                                | block\_number | in\_baseToken                              | in\_quoteToken                             | block\_timestamp         | transaction\_hash                                                  |
  | ------------------------------------------ | ------------------------------------------ | ------- | ---------- | ------------------------------------------ | ------------- | ------------------------------------------ | ------------------------------------------ | ------------------------ | ------------------------------------------------------------------ |
  | 0x081a6fef83325cdcc575adc13455cddd6f51973c | 0x200d866edf41070de251ef92715a6ea825a5eb80 | false   | 16         | 0xe01cc9be6926b93ec0b1b64d571f82529ec6aae7 | 7006854       | 0x4200000000000000000000000000000000000006 | 0x50c5725949a6f0c72e6c4a641f24049a917db0cb | 2023-11-24T05:17:35.000Z | 0x5083922178d6387a83448f58006b66bf3e9105912ee73b165c2664b8af29ecc5 |
  | 0x26c82d2ca823537e1e19f82fec5e499cb219db58 | 0x200d866edf41070de251ef92715a6ea825a5eb80 | false   | 21         | 0xf60de76791c2f09995df52aa1c6e2e7dcf1e75d7 | 4725600       | 0x6ab98f051915e8c57b066b3017c51df1dbd0a846 | 0x3a17ad2b4c4a75d2905d888220f6779cdfa89b44 | 2023-10-02T09:55:47.000Z | 0xad304457443adb86bd0903b01d0861e9c6141cbfdc35fb552d2efb7c7e1469e7 |
  | 0x0aeb7a8d3dbca90e9a51eda898a10aee702ae3d4 | 0x200d866edf41070de251ef92715a6ea825a5eb80 | false   | 26         | 0x0d316b5892faacf88a52f0c6f4bb612abd6b95bb | 6451854       | 0x4200000000000000000000000000000000000006 | 0xd9aaec86b65d86f6a7b5b1b0c42ffa531710b6ca | 2023-11-11T08:57:35.000Z | 0xd33979ef93e092e5940ba58cae1c33c04182d3443d55016a13e397146ea1a2a5 |
</Accordion>

<Accordion title="Example Query">
  **Query with partition filter**

  ```sql theme={null}
  SELECT *
  FROM `tt-contracts.dodo_v2_base.StablePoolFactory_NewDSP_event`
  WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
  LIMIT 100
  ```
</Accordion>

***

### 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.

<Accordion title="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.                                       |
</Accordion>

<Accordion title="Sample Data">
  | address                                    | removed | in\_trader                                 | log\_index | in\_toToken                                | in\_receiver                               | in\_toAmount | block\_number | in\_fromToken                              | in\_fromAmount | block\_timestamp         | transaction\_hash                                                  |
  | ------------------------------------------ | ------- | ------------------------------------------ | ---------- | ------------------------------------------ | ------------------------------------------ | ------------ | ------------- | ------------------------------------------ | -------------- | ------------------------ | ------------------------------------------------------------------ |
  | 0x9c5de5b37ad5ad32c26d796a6bf8a71de0ea6ba1 | false   | 0x66c45ff040e86dc613f239123a5e21ffdc3a3fec | 32         | 0xd9aaec86b65d86f6a7b5b1b0c42ffa531710b6ca | 0x29a706a49bae714bcfcc96ac1a43e116cb57794c | 505          | 5632845       | 0x4200000000000000000000000000000000000006 | 300000000000   | 2023-10-23T09:57:17.000Z | 0xb3be72edc1696d2e87332a026bbc1b7cd194869a0713e1884c0e1ad1c6accabb |
  | 0x6abda6810d6f563fccb87fa7a5d2590692ccc7f7 | false   | 0x66c45ff040e86dc613f239123a5e21ffdc3a3fec | 29         | 0xd9aaec86b65d86f6a7b5b1b0c42ffa531710b6ca | 0x29a706a49bae714bcfcc96ac1a43e116cb57794c | 1178         | 5632845       | 0x4200000000000000000000000000000000000006 | 700000000000   | 2023-10-23T09:57:17.000Z | 0xb3be72edc1696d2e87332a026bbc1b7cd194869a0713e1884c0e1ad1c6accabb |
  | 0x6abda6810d6f563fccb87fa7a5d2590692ccc7f7 | false   | 0x66c45ff040e86dc613f239123a5e21ffdc3a3fec | 20         | 0xd9aaec86b65d86f6a7b5b1b0c42ffa531710b6ca | 0x987bfbe33c9cf18caa665b792db66339a9c16d32 | 20232        | 5629093       | 0x4200000000000000000000000000000000000006 | 12000000000000 | 2023-10-23T07:52:13.000Z | 0x0d1ef24a917ebfd3f9b114a9f4664c68b20e5a8cd4d635252be2548fc50887ac |
</Accordion>

<Accordion title="Example Query">
  **Query with partition filter**

  ```sql theme={null}
  SELECT *
  FROM `tt-contracts.dodo_v2_base.VendingMachine_DODOSwap_event`
  WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
  LIMIT 100
  ```
</Accordion>

***

### VendingMachineFactory\_createDODOVendingMachine\_function

Factory function calls for creating DODO V2 vending machine liquidity pools. Records pool deployment parameters including base/quote token pairs, pricing curve configuration (k parameter), LP fee rates, and TWAP oracle settings, returning the deployed pool contract address.

<Accordion title="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.                                                                                                                                                                                  |
  | `trace_address`         | `STRING`    | Hierarchical position of the internal call within a transaction's execution trace. Comma-separated sequence of integers representing the call path, where each number indicates the index of the call at that nesting level, with null representing top-level calls. |
  | `status`                | `BOOL`      | Transaction execution outcome indicator. Boolean value where true represents successful execution and false represents failed execution.                                                                                                                             |
  | `from_address`          | `STRING`    | Address that initiated the transaction or contract call. Hex-encoded, 0x-prefixed, 42-character string.                                                                                                                                                              |
  | `to_address`            | `STRING`    | Address receiving the transaction or contract call. Hex-encoded, 0x-prefixed, 42-character string.                                                                                                                                                                   |
  | `value`                 | `FLOAT64`   | Amount of native cryptocurrency sent with the transaction. Floating-point representation in whole units (e.g., ETH, BNB, MATIC).                                                                                                                                     |
  | `gas_used`              | `INT64`     | Amount of gas consumed by the transaction execution. Integer representing the actual computational steps used.                                                                                                                                                       |
  | `gas`                   | `INT64`     | Gas limit allocated for the transaction execution. Integer representing the maximum computational steps allowed.                                                                                                                                                     |
  | `signature`             | `STRING`    | Function selector identifying which contract function was called. 10-character hex string including 0x prefix.                                                                                                                                                       |
  | `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_lpFeeRate`          | `STRING`    | Liquidity provider fee rate charged on trades in the pool. Numeric string representing the fee as a fraction with 18 decimal places.                                                                                                                                 |
  | `in_i`                  | `STRING`    | Index or identifier parameter used in protocol operations. Numeric string representing a position, rate, or configuration value.                                                                                                                                     |
  | `in_k`                  | `STRING`    | K parameter controlling price curve slope in DODO protocol pools. Numeric string representing the slippage coefficient where higher values indicate steeper bonding curves.                                                                                          |
  | `in_isOpenTWAP`         | `BOOL`      | Boolean flag indicating whether Time-Weighted Average Price (TWAP) oracle is enabled for the pool.                                                                                                                                                                   |
  | `out_newVendingMachine` | `STRING`    | Contract address of the newly created DODO vending machine pool. Hex-encoded, 0x-prefixed, 42-character string.                                                                                                                                                      |
</Accordion>

<Accordion title="Sample Data">
  | gas    | in\_i              | in\_k               | value | status | gas\_used | signature  | to\_address                                | block\_number | from\_address                              | in\_baseToken                              | in\_lpFeeRate    | in\_isOpenTWAP | in\_quoteToken                             | trace\_address | block\_timestamp         | transaction\_hash                                                  | out\_newVendingMachine                     |
  | ------ | ------------------ | ------------------- | ----- | ------ | --------- | ---------- | ------------------------------------------ | ------------- | ------------------------------------------ | ------------------------------------------ | ---------------- | -------------- | ------------------------------------------ | -------------- | ------------------------ | ------------------------------------------------------------------ | ------------------------------------------ |
  | 637432 | 100000000000000000 | 1000000000000000000 | 0     | true   | 388631    | 0xe18c40c7 | 0x0226fce8c969604c3a0ad19c37d1fafac73e13c2 | 15123543      | 0x4cad0052524648a7fa2cfe279997b00239295f33 | 0x833589fcd6edb6e08f4c7c32d4f71b54bda02913 | 2400000000000000 | false          | 0x50c5725949a6f0c72e6c4a641f24049a917db0cb | 0              | 2024-05-30T02:33:53.000Z | 0x7a73e5b41852d62e81e5fdeed0f8d6f78840c69833ae0cba6a468a3a1e432989 | 0x97e6f59a7e61ab9a34d8f27f6449246ca3a19c85 |
  | 657929 | 1                  | 1000000000000000000 | 0     | true   | 381424    | 0xe18c40c7 | 0x0226fce8c969604c3a0ad19c37d1fafac73e13c2 | 19031160      | 0x4cad0052524648a7fa2cfe279997b00239295f33 | 0x4200000000000000000000000000000000000006 | 2400000000000000 | false          | 0x833589fcd6edb6e08f4c7c32d4f71b54bda02913 | 0              | 2024-08-28T13:27:47.000Z | 0x940a13d87a381bccb34435cc82f487ad9effbcfa5522a24c57c9f6fdf1179983 | 0xd6f098cf8e6346ce2b18c3e3c76df2230616662e |
  | 614641 | 3648682400         | 1000000000000000000 | 0     | true   | 381424    | 0xe18c40c7 | 0x0226fce8c969604c3a0ad19c37d1fafac73e13c2 | 19031080      | 0x4cad0052524648a7fa2cfe279997b00239295f33 | 0x4200000000000000000000000000000000000006 | 2400000000000000 | false          | 0xd9aaec86b65d86f6a7b5b1b0c42ffa531710b6ca | 0              | 2024-08-28T13:25:07.000Z | 0xcd42adbd16cda881afb0c6c4057ee4cf3c39548953ced654a4df754be501d544 | 0x7572ef630424f11f607ae18f1d84822a9ea9f540 |
</Accordion>

<Accordion title="Example Query">
  **Query with partition filter**

  ```sql theme={null}
  SELECT *
  FROM `tt-contracts.dodo_v2_base.VendingMachineFactory_createDODOVendingMachine_function`
  WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
  LIMIT 100
  ```
</Accordion>

***

### 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.

<Accordion title="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.                       |
</Accordion>

<Accordion title="Sample Data">
  | in\_dvm                                    | address                                    | removed | log\_index | in\_creator                                | block\_number | in\_baseToken                              | in\_quoteToken                             | block\_timestamp         | transaction\_hash                                                  |
  | ------------------------------------------ | ------------------------------------------ | ------- | ---------- | ------------------------------------------ | ------------- | ------------------------------------------ | ------------------------------------------ | ------------------------ | ------------------------------------------------------------------ |
  | 0x102bfb1afaddf32f0994c4a60b28e737efa02933 | 0x0226fce8c969604c3a0ad19c37d1fafac73e13c2 | false   | 14         | 0x98a44e2eebfeb30a398183523392576b5b53d3fe | 6064875       | 0x4200000000000000000000000000000000000006 | 0xd9aaec86b65d86f6a7b5b1b0c42ffa531710b6ca | 2023-11-02T09:58:17.000Z | 0xf529f838178d7045cbe0c84989beea03e99ba1d3b3fc2c9ae029065775634c9f |
  | 0xaaa90901a4bf3cf153489ddd62664fdcb75818a4 | 0x0226fce8c969604c3a0ad19c37d1fafac73e13c2 | false   | 23         | 0x92d3bca54b67e5d1928df5fca0bce260d46aa6fd | 6065884       | 0x4200000000000000000000000000000000000006 | 0xd9aaec86b65d86f6a7b5b1b0c42ffa531710b6ca | 2023-11-02T10:31:55.000Z | 0xd522e4e73e09eeaf9b613bdc0411ced3426a6b616ce44679894ba2688e12b9c8 |
  | 0x47040671a7122ab2c52e70fa7a09aff38fb9aec6 | 0x0226fce8c969604c3a0ad19c37d1fafac73e13c2 | false   | 24         | 0x0632172ea6a07e9374d9033148e2a2b1b9803401 | 8250276       | 0x50c5725949a6f0c72e6c4a641f24049a917db0cb | 0x833589fcd6edb6e08f4c7c32d4f71b54bda02913 | 2023-12-23T00:04:59.000Z | 0x5fed64be7e44fb306296217bc2adf98dc9b68b950ab31e0ee3775c0d71c3445a |
</Accordion>

<Accordion title="Example Query">
  **Query with partition filter**

  ```sql theme={null}
  SELECT *
  FROM `tt-contracts.dodo_v2_base.VendingMachineFactory_NewDVM_event`
  WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
  LIMIT 100
  ```
</Accordion>

***