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

> Tables in tt-contracts.dodo_v1_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.

<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_user`          | `STRING`    | Address of the user account associated with the transaction or protocol operation. Hex-encoded, 0x-prefixed, 42-character string.                    |
  | `in_amount`        | `STRING`    | Input amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination.                      |
</Accordion>

<Accordion title="Sample Data">
  | address                                    | in\_user                                   | removed | in\_amount            | log\_index | block\_number | block\_timestamp         | transaction\_hash                                                  |
  | ------------------------------------------ | ------------------------------------------ | ------- | --------------------- | ---------- | ------------- | ------------------------ | ------------------------------------------------------------------ |
  | 0xe3c10989ddc5df5b1b9c0e6229c2e4e0862fde3e | 0xfbb7b5eb128f4d023a365cb7658222d30b9ab4e0 | false   | 232877962833559266374 | 17         | 102418215     | 2023-06-18T12:31:48.000Z | 0x6af0f60878eafee4021a244d194365f027aca1d5fe1a27b322a857915944157c |
  | 0xe3c10989ddc5df5b1b9c0e6229c2e4e0862fde3e | 0x046a65107b7f4ca5ba7742b928303c0f0917d843 | false   | 2768128257745182079   | 1          | 14983735      | 2022-06-18T10:13:36.000Z | 0xb38551998304d544c1ac0be2f5d1e93cfcc6b55e3202f9311dc82146bebcd4c0 |
  | 0xe3c10989ddc5df5b1b9c0e6229c2e4e0862fde3e | 0x22bf900bdfd4cdf0af25e142bf0d12f383c6ba75 | false   | 79720195419755288800  | 1          | 15019143      | 2022-06-18T19:23:17.000Z | 0xb58913889448ddacbdcb1f742cabbb67006eef37480fa1744e56f04a2ee67e38 |
</Accordion>

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

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

***

### NewBornDODO\_BuyBaseToken\_event

Base token purchase events from DODO v1 liquidity pools. Records buyer address, quote token amount paid, and base token amount received for tracking DEX swap activity.

<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_buyer`         | `STRING`    | Address of the account purchasing tokens or assets in the transaction. Hex-encoded, 0x-prefixed, 42-character string.                                |
  | `in_receiveBase`   | `STRING`    | Amount of base tokens received by the buyer in the transaction. Integer value representing the token amount in its smallest unit.                    |
  | `in_payQuote`      | `STRING`    | Amount of quote tokens paid by the buyer in the transaction. Integer value representing the token amount in its smallest unit.                       |
</Accordion>

<Accordion title="Sample Data">
  | address                                    | removed | in\_buyer                                  | log\_index | in\_payQuote | block\_number | in\_receiveBase | block\_timestamp         | transaction\_hash                                                  |
  | ------------------------------------------ | ------- | ------------------------------------------ | ---------- | ------------ | ------------- | --------------- | ------------------------ | ------------------------------------------------------------------ |
  | 0xe4b2dfc82977dd2dce7e8d37895a6a8f50cbb4fb | false   | 0x26271dfddbd250014f87f0f302c099d5a798bab1 | 9          | 43094224393  | 4070426       | 43111565971     | 2021-12-24T23:33:39.000Z | 0xf116ded7e7a94f8b5a73adac7bc6eba681a8961376072c6561190526c696ed12 |
  | 0xe4b2dfc82977dd2dce7e8d37895a6a8f50cbb4fb | false   | 0x88cbf433471a0cd8240d2a12354362988b4593e5 | 18         | 2652407600   | 4053282       | 2653224599      | 2021-12-24T01:58:18.000Z | 0xd5375b67a8868831f06f493db7d55d719a9373e593748354b23b37d2d82fe4e9 |
  | 0xe4b2dfc82977dd2dce7e8d37895a6a8f50cbb4fb | false   | 0x88cbf433471a0cd8240d2a12354362988b4593e5 | 46         | 4020975741   | 4062111       | 4021829821      | 2021-12-24T13:43:53.000Z | 0x9b3f36e8d1c2752ac8a3daa44808add84c41390e6e4f3b0fbb6a6499ccaf9683 |
</Accordion>

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

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

***

### NewBornDODO\_SellBaseToken\_event

Base token sell events from DODO v1 liquidity pools. Records the seller address, base token amount paid, and quote token amount received for tracking swap activity and pricing on the DODO DEX (Decentralized Exchange Operator).

<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_seller`        | `STRING`    | Address of the account selling tokens or assets in the transaction. Hex-encoded, 0x-prefixed, 42-character string.                                   |
  | `in_payBase`       | `STRING`    | Amount of base tokens paid by the seller in the transaction. Numeric string representing token amount in smallest denomination.                      |
  | `in_receiveQuote`  | `STRING`    | Amount of quote tokens received by the seller in the transaction. Numeric string representing token amount in smallest denomination.                 |
</Accordion>

<Accordion title="Sample Data">
  | address                                    | removed | in\_seller                                 | log\_index | in\_payBase  | block\_number | block\_timestamp         | in\_receiveQuote | transaction\_hash                                                  |
  | ------------------------------------------ | ------- | ------------------------------------------ | ---------- | ------------ | ------------- | ------------------------ | ---------------- | ------------------------------------------------------------------ |
  | 0xe4b2dfc82977dd2dce7e8d37895a6a8f50cbb4fb | false   | 0x0f54ee41c88c1bfa06ee95353849ea514b148e1d | 8          | 39920159680  | 85322491      | 2023-04-28T23:37:50.000Z | 39943383113      | 0x6bece604b5c56da77b4f3610fc6bc00f87a9fb6b13fa27da2ae6efe6118a0b1b |
  | 0xe4b2dfc82977dd2dce7e8d37895a6a8f50cbb4fb | false   | 0x0f54ee41c88c1bfa06ee95353849ea514b148e1d | 39         | 120330586593 | 85254224      | 2023-04-28T18:30:28.000Z | 120375266908     | 0x99d22f047777451ecb5c24fbe136046a9e360e49e64a0a4f03503ad3eafdf211 |
  | 0xe4b2dfc82977dd2dce7e8d37895a6a8f50cbb4fb | false   | 0x1d5702c6d7eb30e42a8c94b8db7ea2e8444a37fd | 9          | 10000002999  | 85027608      | 2023-04-28T02:38:49.000Z | 10003315941      | 0x9a889fb70d3c08e93c5f9caf7ccd17046209e0c4b871e2b5b464a85d49433a1b |
</Accordion>

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

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

***

### NewBornDODO\_UpdateLiquidityProviderFeeRate\_event

DODO V1 liquidity pool event recording changes to liquidity provider fee rates. Emitted when pool operators adjust the fee structure, capturing both previous and new fee rate values for tracking pool economics over time.

<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_oldLiquidityProviderFeeRate` | `STRING`    | Previous liquidity provider fee rate before the update. Numeric string representing the fee rate with 18 decimal places of precision.                |
  | `in_newLiquidityProviderFeeRate` | `STRING`    | Updated liquidity provider fee rate after the change. Numeric string representing the fee rate in basis points with 18 decimal places of precision.  |
</Accordion>

<Accordion title="Sample Data">
  | address                                    | removed | log\_index | block\_number | block\_timestamp         | transaction\_hash                                                  | in\_newLiquidityProviderFeeRate | in\_oldLiquidityProviderFeeRate |
  | ------------------------------------------ | ------- | ---------- | ------------- | ------------------------ | ------------------------------------------------------------------ | ------------------------------- | ------------------------------- |
  | 0xe4b2dfc82977dd2dce7e8d37895a6a8f50cbb4fb | false   | 0          | 59763168      | 2023-02-10T17:34:50.000Z | 0xf88fcac7a786f7dc6377293a8b9cd0f97dd4691dc5e3f6957f6037fbde922f9f | 0                               | 80000000000000                  |
  | 0xfe176a2b1e1f67250d2903b8d25f56c0dabcd6b2 | false   | 0          | 2289879       | 2021-10-17T03:26:37.000Z | 0x35f1e4ca90e32c5ef048456e5130206c632b50dd3cf7034f4e57cb6dd7fd015f | 2400000000000000                | 4000000000000000                |
  | 0xfe176a2b1e1f67250d2903b8d25f56c0dabcd6b2 | false   | 0          | 24733983      | 2022-09-15T11:23:07.000Z | 0x381fc1fc3cb8662563d16c33e4500183a85990bab1e7b089ac8086fde1796702 | 2400000000000000                | 1200000000000000                |
</Accordion>

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

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

***

### NewBornDODO\_UpdateMaintainerFeeRate\_event

DODO V1 protocol event emitted when a liquidity pool's maintainer fee rate parameter is updated, recording both previous and new fee rate values. Used for tracking fee structure changes in DODO automated market maker (AMM) pools.

<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_oldMaintainerFeeRate` | `STRING`    | Previous maintainer fee rate value before the change. String-encoded integer representing the fee rate in basis points with 15 decimal places of precision. |
  | `in_newMaintainerFeeRate` | `STRING`    | Updated maintainer fee rate value after the change. String-encoded integer representing the fee rate in basis points with 15 decimal places of precision.   |
</Accordion>

<Accordion title="Sample Data">
  | address                                    | removed | log\_index | block\_number | block\_timestamp         | transaction\_hash                                                  | in\_newMaintainerFeeRate | in\_oldMaintainerFeeRate |
  | ------------------------------------------ | ------- | ---------- | ------------- | ------------------------ | ------------------------------------------------------------------ | ------------------------ | ------------------------ |
  | 0xe4b2dfc82977dd2dce7e8d37895a6a8f50cbb4fb | false   | 0          | 59763143      | 2023-02-10T17:34:43.000Z | 0xf992ed87b08ab29b109483f630c54a19bc40793854036d42ba165070529bcce1 | 10000000000000           | 20000000000000           |
  | 0xfe176a2b1e1f67250d2903b8d25f56c0dabcd6b2 | false   | 0          | 23302320      | 2022-09-07T05:39:33.000Z | 0x57cca28b744fc440feeee81ead70fa872f8d7adde22675be43d33c06669174f7 | 150000000000000          | 600000000000000          |
  | 0xfe176a2b1e1f67250d2903b8d25f56c0dabcd6b2 | false   | 0          | 2289882       | 2021-10-17T03:26:37.000Z | 0xb2da64ff48e47c29e8ef1b189122b02e2f65a7ef414ee303cde564c6289be756 | 600000000000000          | 1000000000000000         |
</Accordion>

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

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

***

### Zoo\_DODOBirth\_event

DODO decentralized exchange (DEX) pool creation events emitted when new liquidity pools are deployed through the Zoo factory contract. Records the newly created pool address along with its base and quote token pair for tracking DODO v1 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_newBorn`       | `STRING`    | Contract address of the newly created liquidity pool. Hex-encoded, 0x-prefixed, 42-character string.                                                 |
  | `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.                                                |
</Accordion>

<Accordion title="Sample Data">
  | address                                    | removed | log\_index | in\_newBorn                                | block\_number | in\_baseToken                              | in\_quoteToken                             | block\_timestamp         | transaction\_hash                                                  |
  | ------------------------------------------ | ------- | ---------- | ------------------------------------------ | ------------- | ------------------------------------------ | ------------------------------------------ | ------------------------ | ------------------------------------------------------------------ |
  | 0xbcc3401e16c25eaf4d3fed632ce3288503883b1f | false   | 3          | 0xb42a054d950dafd872808b3c839fbb7afb86e14c | 226946        | 0x2f2a2543b76a4166549f7aab2e75bef0aefc5b0f | 0xff970a61a04b1ca14834a43f5de4533ebddb5cc8 | 2021-08-31T01:57:02.000Z | 0xdfb47442cc7062075c06de214b2c97eca850aca23ab2963a4a2c19a785d4ca99 |
  | 0xbcc3401e16c25eaf4d3fed632ce3288503883b1f | false   | 3          | 0x87b2ea5b97efff5fc4dcd0e2bd99f1c585ae100f | 226940        | 0x2f2a2543b76a4166549f7aab2e75bef0aefc5b0f | 0xff970a61a04b1ca14834a43f5de4533ebddb5cc8 | 2021-08-31T01:45:54.000Z | 0xb3960b5078106a2365f89ee6e7ce79e07d507efde52cd91407c48b8a2bf73fed |
  | 0xbcc3401e16c25eaf4d3fed632ce3288503883b1f | false   | 3          | 0xfe176a2b1e1f67250d2903b8d25f56c0dabcd6b2 | 226961        | 0x82af49447d8a07e3bd95bd0d56f35241523fbab1 | 0xff970a61a04b1ca14834a43f5de4533ebddb5cc8 | 2021-08-31T02:22:42.000Z | 0x464e79f5fe051696b2f2f7463dd9c85fbc27559874928a1eaf9392ecef28109e |
</Accordion>

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

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

***