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

# camelot_v2_arbitrum

> Tables in tt-contracts.camelot_v2_arbitrum

## Tables

### Factory\_PairCreated\_event

Decentralized exchange (DEX) liquidity pool creation events emitted by Automated Market Maker (AMM) factory contracts. Records new trading pair deployments with token addresses, deployed pair contract address, and creation sequence number for tracking pool instantiation across DEX protocols.

<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_token0`        | `STRING`    | Contract address of the first token in the trading pair. Hex-encoded, 0x-prefixed, 42-character string.                                                                                            |
  | `in_token1`        | `STRING`    | Contract address of the second token in the trading pair. Hex-encoded, 0x-prefixed, 42-character string.                                                                                           |
  | `in_pair`          | `STRING`    | Contract address of the liquidity pool pair created for trading between two tokens. Hex-encoded, 0x-prefixed, 42-character string.                                                                 |
  | `in_length`        | `STRING`    | Total number of token pairs created by the Camelot V2 factory contract at the time of this event emission. Represents cumulative pair count, incrementing with each new liquidity pool deployment. |
</Accordion>

<Accordion title="Sample Data">
  | address                                    | in\_pair                                   | removed | in\_length | in\_token0                                 | in\_token1                                 | log\_index | block\_number | block\_timestamp         | transaction\_hash                                                  |
  | ------------------------------------------ | ------------------------------------------ | ------- | ---------- | ------------------------------------------ | ------------------------------------------ | ---------- | ------------- | ------------------------ | ------------------------------------------------------------------ |
  | 0x6eccab422d763ac031210895c81787e87b43a652 | 0xf7303eff1c7099c868c0a5389b31ba0986c28bc6 | false   | 55         | 0x3c998a2c7408b1043a047a3fe10114483ed1958d | 0x82af49447d8a07e3bd95bd0d56f35241523fbab1 | 0          | 50817535      | 2023-01-04T14:27:41.000Z | 0xe6660255e9ddbce13d646340bba42f22bccf7c7de886838c024097d92036f933 |
  | 0x6eccab422d763ac031210895c81787e87b43a652 | 0xe3770e273985503a49727bb5062a61e0bdbcd799 | false   | 326        | 0x070622449e7980a1709c576ecbfa1c02b3fd8681 | 0x82af49447d8a07e3bd95bd0d56f35241523fbab1 | 0          | 64470869      | 2023-02-25T15:00:34.000Z | 0xe5c68b006c25c4a739f7ae0807d0d439434792345691d66f92391a66e8e102a1 |
  | 0x6eccab422d763ac031210895c81787e87b43a652 | 0x9db141742c3c508183b5b4337cb2a251832def17 | false   | 328        | 0x7d250a5f7476e1f85c3c364e6a64125ee07839b4 | 0x82af49447d8a07e3bd95bd0d56f35241523fbab1 | 0          | 64496900      | 2023-02-25T16:55:04.000Z | 0xe9e173da9ce266a1bb25ea801620186735e5e9352f3d6b1633312187ad6a08eb |
</Accordion>

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

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

***

### NFTPool\_HarvestPosition\_event

NFT position harvest events from Camelot V2 liquidity pools on Arbitrum, recording when users claim pending rewards from their NFT-based LP positions. Tracks recipient addresses, token IDs, and unclaimed reward amounts for analyzing yield farming 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_tokenId`       | `STRING`    | Unique identifier for a non-fungible token within its contract. Numeric string representation of the token's ID.                                                                                      |
  | `in_to`            | `STRING`    | Destination address receiving tokens or assets in the operation. Hex-encoded, 0x-prefixed, 42-character string.                                                                                       |
  | `in_pending`       | `STRING`    | Pending state information containing timestamp of last update, boolean flag for native token handling, pending amount, and exemption amount. String-encoded numeric values for timestamp and amounts. |
</Accordion>

<Accordion title="Sample Data">
  | in\_to                                     | address                                    | removed | log\_index | in\_pending      | in\_tokenId | block\_number | block\_timestamp         | transaction\_hash                                                  |
  | ------------------------------------------ | ------------------------------------------ | ------- | ---------- | ---------------- | ----------- | ------------- | ------------------------ | ------------------------------------------------------------------ |
  | 0x0000000000000000000000000000000000000000 | 0x0f07c3d5dcadc6194a5ec2f9c4106ff5b0db3c18 | false   | 50         | 28961115113      | 390         | 83643392      | 2023-04-24T01:18:35.000Z | 0xfb21742cc654de5ac623d78465ca53e2f45711c314553ef4de2cb879f20ae5c3 |
  | 0xccbb5eec512f1085cab86a10c29ba10e75290040 | 0x0f07c3d5dcadc6194a5ec2f9c4106ff5b0db3c18 | false   | 32         | 7024254577460    | 451         | 83648262      | 2023-04-24T01:39:24.000Z | 0x3ef2bf9e8397e3c91f18560c82eed45fdef0684919f16b1a1bab54fd41942fa8 |
  | 0x39a236ebd2a6dc72f91d373efc4dd90c8f4bf121 | 0x2a9766a73999a7de16a4b4e345c8a6fc4e4288cc | false   | 124        | 1853037858772526 | 354         | 83637461      | 2023-04-24T00:53:15.000Z | 0xa4bb409006096896bd7e84e3e126a68d410526bd6df46bc6b4c5d1c27f8a6972 |
</Accordion>

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

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

***

### NFTPoolFactory\_PoolCreated\_event

NFT liquidity pool creation events from Camelot V2 DEX on Arbitrum, capturing new pool deployments with their LP token addresses. Used for tracking NFT-based liquidity pool launches and analyzing Camelot's NFT pool ecosystem growth.

<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_lpToken`       | `STRING`    | Contract address of the liquidity provider (LP) token associated with the newly created NFT pool. Hex-encoded, 0x-prefixed 40-character string representing the token that liquidity providers receive when depositing assets. |
  | `in_pool`          | `STRING`    | Contract address of the pool being referenced in the event. Hex-encoded, 0x-prefixed, 42-character string.                                                                                                                     |
</Accordion>

<Accordion title="Sample Data">
  | address                                    | in\_pool                                   | removed | log\_index | in\_lpToken                                | block\_number | block\_timestamp         | transaction\_hash                                                  |
  | ------------------------------------------ | ------------------------------------------ | ------- | ---------- | ------------------------------------------ | ------------- | ------------------------ | ------------------------------------------------------------------ |
  | 0x6db1ef0df42e30acf139a70c1ed0b7e6c51dbf6d | 0xfbe02a6d990f4f8b00934f2312135476f4834d68 | false   | 2          | 0x80a1fe04e7c2cfb62cfee67361d1a3b57902766a | 221226066     | 2024-06-12T22:58:03.000Z | 0x738bcebd2b95179f069e51120e464bebf2b72d8b2e4be2310a5b00caa3852f63 |
  | 0x6db1ef0df42e30acf139a70c1ed0b7e6c51dbf6d | 0xc6c76422d0f9451b6e4742e7412908dc2c3d3c45 | false   | 6          | 0xf8137c8cf3e049998dfd83c7b2fb680269e31b55 | 221225939     | 2024-06-12T22:57:32.000Z | 0x33da458ed5064b1c2a193dc1e7e4767756c0c8327f810565b6ebba8227a62642 |
  | 0x6db1ef0df42e30acf139a70c1ed0b7e6c51dbf6d | 0x135bb634bcbf6ea2f90a80a96c161c0e360dc633 | false   | 1          | 0x3fee6e8fbde48b727f82c55639ed2dd0cd9ba642 | 47384075      | 2022-12-19T18:53:37.000Z | 0x26bc91f049a1b3fb8b3bc68b7d66f0b4f46dff619c36e47b3f82a95463185ba7 |
</Accordion>

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

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

***

### Pair\_Burn\_event

Liquidity removal events from DEX (Decentralized Exchange) trading pairs recording amounts of both tokens withdrawn when liquidity providers burn LP tokens. Used for tracking liquidity provision activity and calculating total value locked (TVL) changes in 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_sender`        | `STRING`    | Address that initiated the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string.                                                  |
  | `in_amount0`       | `STRING`    | Amount of token0 involved in the liquidity pool operation. Numeric string representation of token quantity in smallest denomination.                 |
  | `in_amount1`       | `STRING`    | Amount of token1 involved in the liquidity pool operation. Numeric string representation of token quantity in smallest denomination.                 |
  | `in_to`            | `STRING`    | Destination address receiving tokens or assets in the operation. Hex-encoded, 0x-prefixed, 42-character string.                                      |
</Accordion>

<Accordion title="Sample Data">
  | in\_to                                     | address                                    | removed | in\_sender                                 | log\_index | in\_amount0            | in\_amount1 | block\_number | block\_timestamp         | transaction\_hash                                                  |
  | ------------------------------------------ | ------------------------------------------ | ------- | ------------------------------------------ | ---------- | ---------------------- | ----------- | ------------- | ------------------------ | ------------------------------------------------------------------ |
  | 0xbb3fee27601b2739d410f3f723cb8a4c65b6abbe | 0x01efed58b534d7a7464359a6f8d14d986125816b | false   | 0xc873fecbd354f5a56e00e710b90ef4201db2448d | 7          | 63452150061203689346   | 60755137    | 146547673     | 2023-11-03T00:55:02.000Z | 0x39d23d9f2a0b848cfc5963b942774827c3b6f3def792a4a5f26ccdf05dbe28ff |
  | 0xbb3fee27601b2739d410f3f723cb8a4c65b6abbe | 0x01efed58b534d7a7464359a6f8d14d986125816b | false   | 0xc873fecbd354f5a56e00e710b90ef4201db2448d | 7          | 3944040199872415873535 | 3776400058  | 146547559     | 2023-11-03T00:54:33.000Z | 0x22c7625e5c6a9d295b0f338b0083ba6a3bc637dd29e77474cbf11557f1e83ba4 |
  | 0x8ccaf951c46899aa11e96435261c271c3e5ba963 | 0x01efed58b534d7a7464359a6f8d14d986125816b | false   | 0xc873fecbd354f5a56e00e710b90ef4201db2448d | 7          | 7527769427078341661034 | 7228117750  | 146583730     | 2023-11-03T03:31:39.000Z | 0xe6c518167749b2a7dc6f0eda96b20adf03334baeed0055d59ad377c13f9687c2 |
</Accordion>

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

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

***

### Pair\_FeePercentUpdated\_event

Fee tier adjustment events from Camelot V2 automated market maker (AMM) liquidity pairs on Arbitrum. Tracks changes to swap fee percentages for token0 and token1 in basis points (e.g., 500 = 0.05%), useful for analyzing fee structure evolution and liquidity pool economics.

<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_token0FeePercent` | `STRING`    | Fee percentage charged on token0 in the Camelot V2 liquidity pair, expressed in basis points where 1000 = 1%. Values typically range from 50 (0.05%) to 2000 (2%) and can be updated asymmetrically from the token1 fee. |
  | `in_token1FeePercent` | `STRING`    | Fee percentage charged for swaps involving token1 in the liquidity pair, expressed in basis points (e.g., '500' = 5%, '1000' = 10%). Updated via governance or pool admin action when fee structures are adjusted.       |
</Accordion>

<Accordion title="Sample Data">
  | address                                    | removed | log\_index | block\_number | block\_timestamp         | transaction\_hash                                                  | in\_token0FeePercent | in\_token1FeePercent |
  | ------------------------------------------ | ------- | ---------- | ------------- | ------------------------ | ------------------------------------------------------------------ | -------------------- | -------------------- |
  | 0xaa6d06ceb39132b720b54259b70f41f9c975782a | false   | 1          | 70440946      | 2023-03-16T15:03:43.000Z | 0x5c44950fdb0dfb49fa32b6292bc61b0ce6df3a880a2e3f003e1d7792e0a86507 | 1000                 | 300                  |
  | 0xaa6d06ceb39132b720b54259b70f41f9c975782a | false   | 0          | 70441247      | 2023-03-16T15:04:59.000Z | 0x0244d0213e546b1eea0044295b381f73820c339675023c86afb274da7d0739f9 | 1000                 | 500                  |
  | 0x400ebc22c31bedcdab38a6b27963912df71840ed | false   | 6          | 76735127      | 2023-04-03T21:13:39.000Z | 0x65668e9d893a51674c3b88d52b9c0e77fd89a6007e99be6badd26e203c5ed2a2 | 50                   | 50                   |
</Accordion>

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

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

***

### Pair\_Mint\_event

Liquidity provision events emitted when users add tokens to a DEX pair contract. Records sender address and token amounts deposited for liquidity pool operations.

<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_sender`        | `STRING`    | Address that initiated the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string.                                                  |
  | `in_amount0`       | `STRING`    | Amount of token0 involved in the liquidity pool operation. Numeric string representation of token quantity in smallest denomination.                 |
  | `in_amount1`       | `STRING`    | Amount of token1 involved in the liquidity pool operation. Numeric string representation of token quantity in smallest denomination.                 |
</Accordion>

<Accordion title="Sample Data">
  | address                                    | removed | in\_sender                                 | log\_index | in\_amount0           | in\_amount1            | block\_number | block\_timestamp         | transaction\_hash                                                  |
  | ------------------------------------------ | ------- | ------------------------------------------ | ---------- | --------------------- | ---------------------- | ------------- | ------------------------ | ------------------------------------------------------------------ |
  | 0x5201f6482eea49c90fe609ed9d8f69328bac8dda | false   | 0xe458018ad4283c90fb7f5460e24c4016f81b8175 | 6          | 571454224375065       | 1335670409495539       | 126301434     | 2023-08-30T06:37:45.000Z | 0x7dcc7eae224aa0da30ba37f4034008140287b355564f1ab4b93cb0871d423a68 |
  | 0x6b8b78554db2f017cca749dad38e445cd8a3b5b4 | false   | 0xe458018ad4283c90fb7f5460e24c4016f81b8175 | 6          | 250080069597874974100 | 57483090               | 126431723     | 2023-08-30T15:57:53.000Z | 0x72e727ddf2b4c0d884ad1e73f37b34857342a05aec886f4df770ca6902f8aa7e |
  | 0x85c3e0f63e50a994215969ba9f5259ee9b96ff52 | false   | 0xc873fecbd354f5a56e00e710b90ef4201db2448d | 7          | 15000000000000000000  | 1284512995909323623613 | 126394140     | 2023-08-30T13:13:20.000Z | 0x76d45e69fae79142264d738228831aed7b51855e3b53057daec071183c769de5 |
</Accordion>

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

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

***

### Pair\_Swap\_event

Token swap events from decentralized exchange (DEX) liquidity pairs recording input and output amounts for both tokens. Primary source for tracking DEX trading activity and price discovery.

<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_sender`        | `STRING`    | Address that initiated the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string.                                                   |
  | `in_amount0In`     | `STRING`    | Amount of token0 transferred into the liquidity pool during a swap operation. Stored as decimal string representing the smallest unit of the token.   |
  | `in_amount1In`     | `STRING`    | Amount of token1 transferred into the liquidity pool during a swap operation. Stored as decimal string representing the smallest unit of the token.   |
  | `in_amount0Out`    | `STRING`    | Amount of token0 transferred out of the liquidity pool during a swap operation. Stored as decimal string representing the smallest unit of the token. |
  | `in_amount1Out`    | `STRING`    | Amount of token1 transferred out of the liquidity pool during a swap operation. Stored as decimal string representing the smallest unit of the token. |
  | `in_to`            | `STRING`    | Destination address receiving tokens or assets in the operation. Hex-encoded, 0x-prefixed, 42-character string.                                       |
</Accordion>

<Accordion title="Sample Data">
  | in\_to                                     | address                                    | removed | in\_sender                                 | log\_index | block\_number | in\_amount0In      | in\_amount1In | in\_amount0Out     | in\_amount1Out        | block\_timestamp         | transaction\_hash                                                  |
  | ------------------------------------------ | ------------------------------------------ | ------- | ------------------------------------------ | ---------- | ------------- | ------------------ | ------------- | ------------------ | --------------------- | ------------------------ | ------------------------------------------------------------------ |
  | 0x0000000000bf41eb500675cabaa1223e3c1ab90f | 0xa6c5c7d189fa4eb5af8ba34e63dcdd3a635d433f | false   | 0x0000000000bf41eb500675cabaa1223e3c1ab90f | 46         | 150049302     | 379236722433715537 | 0             | 0                  | 672986892345247850746 | 2023-11-13T16:01:39.000Z | 0x85f52cc466c82d54d02b27b395c9d3632a965462aa4a4ed8b56af5230037913a |
  | 0x0000000000bf41eb500675cabaa1223e3c1ab90f | 0x84652bb2539513baf36e225c930fdd8eaa63ce27 | false   | 0x0000000000bf41eb500675cabaa1223e3c1ab90f | 34         | 150112371     | 221443575686691778 | 0             | 0                  | 463317100             | 2023-11-13T20:56:30.000Z | 0x1b807766cb4ba3bf1da0cce828b7d71290d9484aeacc1e55373995d7964307d0 |
  | 0x0000000000bf41eb500675cabaa1223e3c1ab90f | 0x84652bb2539513baf36e225c930fdd8eaa63ce27 | false   | 0x0000000000bf41eb500675cabaa1223e3c1ab90f | 25         | 149845300     | 0                  | 460733589     | 223951612458027886 | 0                     | 2023-11-13T01:02:30.000Z | 0x2ed51231da99084f69d8423e2f2ace1edd6a401901f93b0fd6c15585d1bbcfa2 |
</Accordion>

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

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

***

### Pair\_Sync\_event

Liquidity pair reserve synchronization events emitted after each swap, mint, or burn operation. Contains updated reserve balances for both tokens in AMM (Automated Market Maker) pools, enabling real-time price calculation and liquidity 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_reserve0`      | `STRING`    | Reserve amount of the first token in a liquidity pool after a state-changing operation. Stored as decimal string representing the smallest unit of the token.  |
  | `in_reserve1`      | `STRING`    | Reserve amount of the second token in a liquidity pool after a state-changing operation. Stored as decimal string representing the smallest unit of the token. |
</Accordion>

<Accordion title="Sample Data">
  | address                                    | removed | log\_index | in\_reserve0          | in\_reserve1 | block\_number | block\_timestamp         | transaction\_hash                                                  |
  | ------------------------------------------ | ------- | ---------- | --------------------- | ------------ | ------------- | ------------------------ | ------------------------------------------------------------------ |
  | 0x367eb9df4c366438ae0e6f90748ca7dc7a50001d | false   | 53         | 308813234540942042795 | 5780756      | 289679200     | 2024-12-29T01:44:32.000Z | 0x6061617ffc763c99f1b860200dcd159f306d2214eedd047d8430d09c622c9459 |
  | 0x138c115bdcc8709d7f782ecc29dfb3829907d74b | false   | 71         | 138259090856753784377 | 102369227    | 289974829     | 2024-12-29T22:20:58.000Z | 0x7c811aaea75932bc34d6cdcdb5e0056e49e4c8283012aaab0f205d17e9cf8dbe |
  | 0xd40b7b05ab39a39658de1d7c9301a9ed765b3472 | false   | 68         | 164337049180554281272 | 125187910    | 289881585     | 2024-12-29T15:49:24.000Z | 0x9b57c45912110ca340ab0e4f00a736a03b85e40cbf46a43fa8394fbe563ba522 |
</Accordion>

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

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

***

### Pair\_Transfer\_event

ERC20 Transfer events emitted by liquidity pair contracts in automated market maker (AMM) decentralized exchanges (DEXs). Records minting, burning, and transfer of LP (liquidity provider) tokens representing ownership shares in trading 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_from`          | `STRING`    | Address originating the transfer or operation. Hex-encoded, 0x-prefixed, 42-character string.                                                        |
  | `in_to`            | `STRING`    | Destination address receiving tokens or assets in the operation. Hex-encoded, 0x-prefixed, 42-character string.                                      |
  | `in_value`         | `STRING`    | Amount of tokens transferred, minted, or burned in the operation. Numeric string representation preserving precision for large integer values.       |
</Accordion>

<Accordion title="Sample Data">
  | in\_to                                     | address                                    | in\_from                                   | removed | in\_value        | log\_index | block\_number | block\_timestamp         | transaction\_hash                                                  |
  | ------------------------------------------ | ------------------------------------------ | ------------------------------------------ | ------- | ---------------- | ---------- | ------------- | ------------------------ | ------------------------------------------------------------------ |
  | 0x8554792f0ecc2464122ddc5348acd86f4fb6ec8c | 0x01efed58b534d7a7464359a6f8d14d986125816b | 0x579942f9cce581ee83fae0b51cb40fc01391a169 | false   | 1960501625340337 | 18         | 50213093      | 2023-01-01T20:10:01.000Z | 0x0ad54e00a419ea0618783884a1ba023682a3e61e25fc971956cac3da44ff809e |
  | 0x0000000000000000000000000000000000000000 | 0x01efed58b534d7a7464359a6f8d14d986125816b | 0x01efed58b534d7a7464359a6f8d14d986125816b | false   | 1960501625340337 | 3          | 50213432      | 2023-01-01T20:12:32.000Z | 0x18a74d1b346d6ed5b22052a0d2dc506c6beffff589ebc5b5283396ad924507ce |
  | 0x01efed58b534d7a7464359a6f8d14d986125816b | 0x01efed58b534d7a7464359a6f8d14d986125816b | 0x8554792f0ecc2464122ddc5348acd86f4fb6ec8c | false   | 1960501625340337 | 2          | 50213432      | 2023-01-01T20:12:32.000Z | 0x18a74d1b346d6ed5b22052a0d2dc506c6beffff589ebc5b5283396ad924507ce |
</Accordion>

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

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

***