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

# kyber_v3_fantom

> Tables in tt-contracts.kyber_v3_fantom

## Tables

### ElasticFactory\_PoolCreated\_event

Pool creation events emitted by KyberSwap Elastic (concentrated liquidity) factory contracts. Records new liquidity pool deployments with token pair addresses, fee tier configuration in basis points, and tick spacing parameters that define price granularity for liquidity positions.

<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_swapFeeUnits`  | `STRING`    | Swap fee for the pool expressed in basis points. Numeric string value where 100 represents 0.01% and 10000 represents 1%.                                      |
  | `in_tickDistance`  | `INT64`     | Minimum spacing between initialized price ticks in the liquidity pool. Integer value determining the granularity of price points where liquidity can be added. |
  | `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 | in\_token0                                 | in\_token1                                 | log\_index | block\_number | block\_timestamp         | in\_swapFeeUnits | in\_tickDistance | transaction\_hash                                                  |
  | ------------------------------------------ | ------------------------------------------ | ------- | ------------------------------------------ | ------------------------------------------ | ---------- | ------------- | ------------------------ | ---------------- | ---------------- | ------------------------------------------------------------------ |
  | 0xc7a590291e07b9fe9e64b86c58fd8fc764308c4a | 0x6993d01c7a99bebcbcb04efbbf106bfa69273cb2 | false   | 0x1b6382dbdea11d97f24495c9a90b7c88469134a4 | 0x21be370d5312f44cb42ce377bc9b8a0cef1a4c83 | 0          | 65808953      | 2023-07-14T20:45:46.000Z | 300              | 60               | 0xba39fea183a0615f61feca6f9e9599d1baca063cfa8e4de485e1833a15a10ecb |
  | 0xc7a590291e07b9fe9e64b86c58fd8fc764308c4a | 0x9019fda2bc40ac05798a9f08a5620925a940fe31 | false   | 0x04068da6c83afcfa0e13ba15a6696662335d5b75 | 0x8669b2bae36561c2c8ac1e8af39a9cd34dc21b55 | 0          | 65818751      | 2023-07-14T23:41:55.000Z | 300              | 60               | 0x53650f51ce9efdb4936072a8d54398a2492cefc4e188f0fe14451ad4d7768112 |
  | 0xc7a590291e07b9fe9e64b86c58fd8fc764308c4a | 0xa3b2e6bd9962c8a25e5f763bde5184082b2896f0 | false   | 0x21be370d5312f44cb42ce377bc9b8a0cef1a4c83 | 0x8669b2bae36561c2c8ac1e8af39a9cd34dc21b55 | 0          | 65817615      | 2023-07-14T23:19:50.000Z | 300              | 60               | 0xa63619bb485230e28951d4470d9f13e57d426aa0507da97274ef955fe838a6c5 |
</Accordion>

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

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

***

### ElasticPool\_Burn\_event

Liquidity removal events from KyberSwap Elastic concentrated liquidity pools. Records position burns with owner address, liquidity quantity, token amounts withdrawn, and tick range boundaries for tracking DEX liquidity changes.

<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_owner`         | `STRING`    | Address that owns or controls the shares or position being deposited or withdrawn. Hex-encoded, 0x-prefixed, 42-character string.                                      |
  | `in_tickLower`     | `INT64`     | Lower tick boundary of a concentrated liquidity position in a Uniswap V3-style pool. Signed integer representing a discrete price point on the logarithmic tick scale. |
  | `in_tickUpper`     | `INT64`     | Upper tick boundary of a concentrated liquidity position in a Uniswap V3-style pool. Signed integer representing a discrete price point on the logarithmic tick scale. |
  | `in_qty`           | `STRING`    | Quantity of liquidity tokens being minted or burned in the operation. String-encoded integer representing the change in position size.                                 |
  | `in_qty0`          | `STRING`    | Amount of token0 involved in the liquidity operation. String-encoded integer representing token quantity in smallest denomination.                                     |
  | `in_qty1`          | `STRING`    | Amount of token1 involved in the liquidity operation. String-encoded integer representing token quantity in smallest denomination.                                     |
</Accordion>

<Accordion title="Sample Data">
  | in\_qty                | address                                    | in\_qty0            | in\_qty1              | removed | in\_owner                                  | log\_index | block\_number | in\_tickLower | in\_tickUpper | block\_timestamp         | transaction\_hash                                                  |
  | ---------------------- | ------------------------------------------ | ------------------- | --------------------- | ------- | ------------------------------------------ | ---------- | ------------- | ------------- | ------------- | ------------------------ | ------------------------------------------------------------------ |
  | 145978552045819111427  | 0xeb5ffdaabc50b32a20b24e415f34fe9fef913a73 | 9456150342348204155 | 0                     | false   | 0xe222fbe074a436145b255442d919e4e3a6c6a480 | 163        | 69124315      | 9500          | 11700         | 2023-10-08T17:07:57.000Z | 0xb93d2a880e12ec77ec884778e94e7032952e4044b54a7d02a171c2c9dab9db47 |
  | 875697182433991        | 0xb76d3ef99d06ef1a7334dd5c1fe8d533023a9e89 | 0                   | 382322348446269132547 | false   | 0xe222fbe074a436145b255442d919e4e3a6c6a480 | 2          | 69115036      | 286800        | 291400        | 2023-10-08T10:39:23.000Z | 0xbe782d30dab03880003787c210eb5779b8f59bf39a258e6637e359c629e140a6 |
  | 9515752609572453356074 | 0x0a7d1349d7bc8bb353bf5915d644b5582932f1ff | 0                   | 400151093792613859382 | false   | 0xe222fbe074a436145b255442d919e4e3a6c6a480 | 3          | 69115062      | 600           | 1400          | 2023-10-08T10:40:24.000Z | 0xab02078c4a0a7303936fb4957ebec424223a140268d3badda59691a357e5a28a |
</Accordion>

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

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

***

### ElasticPool\_BurnRTokens\_event

KyberSwap Elastic liquidity removal events emitted when reinvestment tokens (rTokens) are burned and underlying token pairs are withdrawn from the pool. Records position owner, liquidity quantity burned, and token0/token1 amounts returned.

<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_owner`         | `STRING`    | Address that owns or controls the shares or position being deposited or withdrawn. Hex-encoded, 0x-prefixed, 42-character string.                    |
  | `in_qty`           | `STRING`    | Quantity of liquidity tokens being minted or burned in the operation. String-encoded integer representing the change in position size.               |
  | `in_qty0`          | `STRING`    | Amount of token0 involved in the liquidity operation. String-encoded integer representing token quantity in smallest denomination.                   |
  | `in_qty1`          | `STRING`    | Amount of token1 involved in the liquidity operation. String-encoded integer representing token quantity in smallest denomination.                   |
</Accordion>

<Accordion title="Sample Data">
  | in\_qty            | address                                    | in\_qty0          | in\_qty1            | removed | in\_owner                                  | log\_index | block\_number | block\_timestamp         | transaction\_hash                                                  |
  | ------------------ | ------------------------------------------ | ----------------- | ------------------- | ------- | ------------------------------------------ | ---------- | ------------- | ------------------------ | ------------------------------------------------------------------ |
  | 34259513993        | 0x2a5f7550f8ef2dce85a4ab368a54c0403b26653f | 31192             | 37643324795772870   | false   | 0xe222fbe074a436145b255442d919e4e3a6c6a480 | 28         | 64409456      | 2023-06-20T18:36:29.000Z | 0xa30917f237065b15b3447f4466e185619ca1a2a27e43e0beb110a85f0f41a3bc |
  | 1709370846507      | 0x2a5f7550f8ef2dce85a4ab368a54c0403b26653f | 1527027           | 1913855919342498569 | false   | 0xe222fbe074a436145b255442d919e4e3a6c6a480 | 10         | 64406975      | 2023-06-20T17:50:24.000Z | 0xcf4769eb7a87cbc793fe185c6034415ac35a9342893d667c3defbe62f17099d4 |
  | 106011765842793051 | 0xc5a4af7ec019546026085f4b84b3f472873a6814 | 97267288295342674 | 115550325055695026  | false   | 0xe222fbe074a436145b255442d919e4e3a6c6a480 | 105        | 63809083      | 2023-06-09T07:01:03.000Z | 0x0c5b6154db7868bb563e574353788a8050ae2578f91537efff3f09f097996a82 |
</Accordion>

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

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

***

### ElasticPool\_Flash\_event

Flash loan events from KyberSwap Elastic liquidity pools recording borrowed amounts, repayment fees, and transaction participants. Used for tracking flash loan arbitrage activity and protocol fee generation.

<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_recipient`     | `STRING`    | Address designated to receive the output tokens from a swap or operation. Hex-encoded, 0x-prefixed, 42-character string.                             |
  | `in_qty0`          | `STRING`    | Amount of token0 involved in the liquidity operation. String-encoded integer representing token quantity in smallest denomination.                   |
  | `in_qty1`          | `STRING`    | Amount of token1 involved in the liquidity operation. String-encoded integer representing token quantity in smallest denomination.                   |
  | `in_paid0`         | `STRING`    | Amount of token0 paid as flash loan fee. Numeric string representation of token quantity in smallest denomination.                                   |
  | `in_paid1`         | `STRING`    | Amount of token1 paid as flash loan fee. Numeric string representation of token quantity in smallest denomination.                                   |
</Accordion>

<Accordion title="Sample Data">
  | address                                    | in\_qty0 | in\_qty1           | removed | in\_paid0 | in\_paid1        | in\_sender                                 | log\_index | block\_number | in\_recipient                              | block\_timestamp         | transaction\_hash                                                  |
  | ------------------------------------------ | -------- | ------------------ | ------- | --------- | ---------------- | ------------------------------------------ | ---------- | ------------- | ------------------------------------------ | ------------------------ | ------------------------------------------------------------------ |
  | 0x2a5f7550f8ef2dce85a4ab368a54c0403b26653f | 0        | 318063087784709500 | false   | 0         | 3180630877847095 | 0xa43bab5cb642bacb180f19aa7c5d8c04e6725c6e | 37         | 67989975      | 0xa43bab5cb642bacb180f19aa7c5d8c04e6725c6e | 2023-09-08T21:35:35.000Z | 0x50bdd343c433c03c83a3faf7c170bf43ea8d2e874050943393f693ea641ad93b |
  | 0x2a5f7550f8ef2dce85a4ab368a54c0403b26653f | 0        | 304574018435982400 | false   | 0         | 3045740184359824 | 0xa43bab5cb642bacb180f19aa7c5d8c04e6725c6e | 44         | 67271477      | 0xa43bab5cb642bacb180f19aa7c5d8c04e6725c6e | 2023-08-21T22:45:14.000Z | 0x30b35f725d2e599b4a21194d2c9cd6fa4b224d2294e90029091baf81f09c46ce |
  | 0x2a5f7550f8ef2dce85a4ab368a54c0403b26653f | 0        | 135366230415992180 | false   | 0         | 1353662304159922 | 0xa43bab5cb642bacb180f19aa7c5d8c04e6725c6e | 35         | 67271470      | 0xa43bab5cb642bacb180f19aa7c5d8c04e6725c6e | 2023-08-21T22:44:56.000Z | 0x260ea5ada202771e3d71e39ddb1281811e354b3c52c881907af73a868295663a |
</Accordion>

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

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

***

### ElasticPool\_Mint\_event

Liquidity provision events emitted when tokens are deposited into concentrated liquidity positions within KyberSwap Elastic pools. Contains sender, owner, tick boundaries, liquidity quantity minted, and token amounts for tracking position creation and modification across DEX (Decentralized Exchange) 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_sender`        | `STRING`    | Address that initiated the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string.                                                                    |
  | `in_owner`         | `STRING`    | Address that owns or controls the shares or position being deposited or withdrawn. Hex-encoded, 0x-prefixed, 42-character string.                                      |
  | `in_tickLower`     | `INT64`     | Lower tick boundary of a concentrated liquidity position in a Uniswap V3-style pool. Signed integer representing a discrete price point on the logarithmic tick scale. |
  | `in_tickUpper`     | `INT64`     | Upper tick boundary of a concentrated liquidity position in a Uniswap V3-style pool. Signed integer representing a discrete price point on the logarithmic tick scale. |
  | `in_qty`           | `STRING`    | Quantity of liquidity tokens being minted or burned in the operation. String-encoded integer representing the change in position size.                                 |
  | `in_qty0`          | `STRING`    | Amount of token0 involved in the liquidity operation. String-encoded integer representing token quantity in smallest denomination.                                     |
  | `in_qty1`          | `STRING`    | Amount of token1 involved in the liquidity operation. String-encoded integer representing token quantity in smallest denomination.                                     |
</Accordion>

<Accordion title="Sample Data">
  | in\_qty        | address                                    | in\_qty0             | in\_qty1 | removed | in\_owner                                  | in\_sender                                 | log\_index | block\_number | in\_tickLower | in\_tickUpper | block\_timestamp         | transaction\_hash                                                  |
  | -------------- | ------------------------------------------ | -------------------- | -------- | ------- | ------------------------------------------ | ------------------------------------------ | ---------- | ------------- | ------------- | ------------- | ------------------------ | ------------------------------------------------------------------ |
  | 3846467269132  | 0x0a2a91b6063a08f516496f7e618dc6e672592db7 | 6280122837364186795  | 11653    | false   | 0xe222fbe074a436145b255442d919e4e3a6c6a480 | 0xe222fbe074a436145b255442d919e4e3a6c6a480 | 16         | 65152184      | -347100       | -344040       | 2023-07-05T07:35:08.000Z | 0xa501c645c35435b3f99cef24f7483497051ec499dfd16b8d3e7ddc7e21880458 |
  | 7906555627214  | 0x0a2a91b6063a08f516496f7e618dc6e672592db7 | 49947235231424388246 | 309      | false   | 0xe222fbe074a436145b255442d919e4e3a6c6a480 | 0xe222fbe074a436145b255442d919e4e3a6c6a480 | 17         | 65170098      | -345600       | -341160       | 2023-07-05T16:33:27.000Z | 0x76d7b20de47678df4c97afdd75590ff4eaa19f1d1aa1e3997ec6f0ee5009c55f |
  | 14452279035850 | 0x0a2a91b6063a08f516496f7e618dc6e672592db7 | 0                    | 98695    | false   | 0xe222fbe074a436145b255442d919e4e3a6c6a480 | 0xe222fbe074a436145b255442d919e4e3a6c6a480 | 15         | 65169834      | -350520       | -345600       | 2023-07-05T16:25:47.000Z | 0xde1be62e4c7c5744c31f42aee3d4dc672d172c5a892b26ce3de656174e93ef55 |
</Accordion>

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

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

***

### ElasticPool\_Swap\_event

Token swap events from KyberSwap Elastic (concentrated liquidity) pools containing sender, recipient, token quantity deltas, and post-swap pool state. Used for tracking DEX trading activity and liquidity pool dynamics.

<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_recipient`     | `STRING`    | Address designated to receive the output tokens from a swap or operation. Hex-encoded, 0x-prefixed, 42-character string.                                                                                                     |
  | `in_deltaQty0`     | `STRING`    | Change in token0 balance resulting from the swap. Numeric string representation in smallest denomination, where positive values indicate token0 added to the pool and negative values indicate token0 removed from the pool. |
  | `in_deltaQty1`     | `STRING`    | Change in token1 balance resulting from the swap. Numeric string representation in smallest denomination, where positive values indicate token1 added to the pool and negative values indicate token1 removed from the pool. |
  | `in_sqrtP`         | `STRING`    | Square root of the current price ratio between token0 and token1 in the liquidity pool after the swap execution. Numeric string representation using Q64.96 fixed-point encoding.                                            |
  | `in_liquidity`     | `STRING`    | Total liquidity available in the pool at the time of the event. Numeric string representation of liquidity in smallest denomination.                                                                                         |
  | `in_currentTick`   | `INT64`     | Current tick index of the liquidity pool after the swap execution. Signed integer representing the price tick position in the concentrated liquidity model.                                                                  |
</Accordion>

<Accordion title="Sample Data">
  | address                                    | removed | in\_sqrtP                            | in\_sender                                 | log\_index | block\_number | in\_deltaQty0        | in\_deltaQty1           | in\_liquidity            | in\_recipient                              | in\_currentTick | block\_timestamp         | transaction\_hash                                                  |
  | ------------------------------------------ | ------- | ------------------------------------ | ------------------------------------------ | ---------- | ------------- | -------------------- | ----------------------- | ------------------------ | ------------------------------------------ | --------------- | ------------------------ | ------------------------------------------------------------------ |
  | 0x18207a891042cca54b0fa78d4569d7eb2e5bf797 | false   | 320263961502755639056342847810835003 | 0x06e14af4abba8f7dfd1f10909fe446bc01ce3a73 | 66         | 64106395      | -9814785             | 160126615663508895407   | 9760486656077147         | 0x831cda98ad2defb7af03156c6a1ab623c9220131 | 304261          | 2023-06-14T18:15:16.000Z | 0x67a29d0d33c2c3b38e5ca7a8fc91a1dd0c9d54e9324ef3f9338a2fe9dd394a9c |
  | 0x18207a891042cca54b0fa78d4569d7eb2e5bf797 | false   | 325799584921377390878441565240161718 | 0x06e14af4abba8f7dfd1f10909fe446bc01ce3a73 | 12         | 64114591      | -10496617            | 177158699619549713654   | 9760486656077147         | 0x286ab107c5e9083dbed35a2b5fb0242538f4f9bf | 304604          | 2023-06-14T20:46:09.000Z | 0x56888be9353b3b707baa40c84a848f6c4fe3939c876bb43516ff39e6bdf76056 |
  | 0x7210aa69813e9bfbcd0745d61226859ffbc8ecb6 | false   | 767652961364418824533248118765       | 0x06e14af4abba8f7dfd1f10909fe446bc01ce3a73 | 26         | 64071434      | 95331405531842412544 | -8891803830939322284784 | 256971913732343183199259 | 0xb66e5c89eba830b31b3ddcc468dd50b3256737c5 | 45422           | 2023-06-14T01:04:09.000Z | 0x900df0f4374e6e1bebf444ec07dd9abf6a1ec1f5dbb373b02012d9f1c8bee4f6 |
</Accordion>

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

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

***

### Factory\_PoolCreated\_event

Factory contract event emitted when a new liquidity pool is created, recording token pairs and pool configuration parameters. Used for tracking DEX pool deployments and liquidity market initialization.

<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_swapFeeUnits`  | `STRING`    | Swap fee for the pool expressed in basis points. Numeric string value where 100 represents 0.01% and 10000 represents 1%.                                      |
  | `in_tickDistance`  | `INT64`     | Minimum spacing between initialized price ticks in the liquidity pool. Integer value determining the granularity of price points where liquidity can be added. |
  | `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 | in\_token0                                 | in\_token1                                 | log\_index | block\_number | block\_timestamp         | in\_swapFeeUnits | in\_tickDistance | transaction\_hash                                                  |
  | ------------------------------------------ | ------------------------------------------ | ------- | ------------------------------------------ | ------------------------------------------ | ---------- | ------------- | ------------------------ | ---------------- | ---------------- | ------------------------------------------------------------------ |
  | 0x5f1dddbf348ac2fbe22a163e30f99f9ece3dd50a | 0x90e8ac6382bf4f0bfd58f0b1e074498d9caab2fc | false   | 0x21be370d5312f44cb42ce377bc9b8a0cef1a4c83 | 0x66eed5ff1701e6ed8470dc391f05e27b1d0657eb | 0          | 56080035      | 2023-02-19T03:15:44.000Z | 1000             | 200              | 0xd3ecd869907c529923602316242c23642940715695bbf153b7ea2d8501858299 |
  | 0x5f1dddbf348ac2fbe22a163e30f99f9ece3dd50a | 0x02529ba8a0012a4e4f935ef76295958b03ffcb78 | false   | 0x21be370d5312f44cb42ce377bc9b8a0cef1a4c83 | 0xf16e81dce15b08f326220742020379b855b87df9 | 10         | 60109084      | 2023-04-17T02:59:58.000Z | 1000             | 200              | 0x13d5e725c58fff8567a4531b847698f9796f359efc5df5c8e54e7b9466bba9f9 |
  | 0x5f1dddbf348ac2fbe22a163e30f99f9ece3dd50a | 0x2de1b029e1d103d2815ab8518a180be8540d82b5 | false   | 0x21be370d5312f44cb42ce377bc9b8a0cef1a4c83 | 0x2f6f07cdcf3588944bf4c42ac74ff24bf56e7590 | 1          | 60101850      | 2023-04-17T00:53:14.000Z | 1000             | 200              | 0x28c5e0951bf1097fa59e7c2afc42c70731c09aa6c573466fe9772bfb75757ef5 |
</Accordion>

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

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

***

### Pool\_Burn\_event

Liquidity removal events from concentrated liquidity pools recording withdrawn token amounts and position tick ranges. Contains owner address, liquidity amount burned, token amounts withdrawn (amount0/amount1), and tick boundaries for tracking position liquidations and TVL changes.

<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_owner`         | `STRING`    | Address that owns or controls the shares or position being deposited or withdrawn. Hex-encoded, 0x-prefixed, 42-character string.                                      |
  | `in_tickLower`     | `INT64`     | Lower tick boundary of a concentrated liquidity position in a Uniswap V3-style pool. Signed integer representing a discrete price point on the logarithmic tick scale. |
  | `in_tickUpper`     | `INT64`     | Upper tick boundary of a concentrated liquidity position in a Uniswap V3-style pool. Signed integer representing a discrete price point on the logarithmic tick scale. |
  | `in_qty`           | `STRING`    | Quantity of liquidity tokens being minted or burned in the operation. String-encoded integer representing the change in position size.                                 |
  | `in_qty0`          | `STRING`    | Amount of token0 involved in the liquidity operation. String-encoded integer representing token quantity in smallest denomination.                                     |
  | `in_qty1`          | `STRING`    | Amount of token1 involved in the liquidity operation. String-encoded integer representing token quantity in smallest denomination.                                     |
</Accordion>

<Accordion title="Sample Data">
  | in\_qty | address                                    | in\_qty0 | in\_qty1 | removed | in\_owner                                  | log\_index | block\_number | in\_tickLower | in\_tickUpper | block\_timestamp         | transaction\_hash                                                  |
  | ------- | ------------------------------------------ | -------- | -------- | ------- | ------------------------------------------ | ---------- | ------------- | ------------- | ------------- | ------------------------ | ------------------------------------------------------------------ |
  | 1       | 0x1b52770b19c8777802e9720c4ad9c112f47e1ec2 | 0        | 0        | false   | 0x2b1c7b41f6a8f2b2bc45c3233a5d5fb3cd6dc9a8 | 2          | 59647444      | 46200         | 48000         | 2023-04-11T16:03:26.000Z | 0xa8e783edad4ed33f7656cdb14286514a15f31daaf6080e5d355ee3c7686036b6 |
  | 1       | 0x57c107bf8bab567daffb324f908e1876ff226f08 | 0        | 411178   | false   | 0x2b1c7b41f6a8f2b2bc45c3233a5d5fb3cd6dc9a8 | 4          | 59646934      | 276400        | 290200        | 2023-04-11T15:55:07.000Z | 0x046d4f9aeaac419944f6888d99279887bc010f9e31bcdfd8763a8e97d18278d3 |
  | 1       | 0x67d1e5dec3500e99b97e699d3fa4c9d4a8afdf00 | 0        | 0        | false   | 0x2b1c7b41f6a8f2b2bc45c3233a5d5fb3cd6dc9a8 | 4          | 59639541      | -84000        | -82325        | 2023-04-11T14:04:39.000Z | 0x162c9d606220f3dd61d37274d9ff50c1f9d8b71614a72b7506a5ec71609c3a0a |
</Accordion>

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

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

***

### Pool\_BurnRTokens\_event

Reinvestment token (RToken) burn events from KyberSwap V3 liquidity pools recording position withdrawals. Contains owner address, liquidity quantity burned, and token0/token1 amounts returned to position holders.

<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_owner`         | `STRING`    | Address that owns or controls the shares or position being deposited or withdrawn. Hex-encoded, 0x-prefixed, 42-character string.                    |
  | `in_qty`           | `STRING`    | Quantity of liquidity tokens being minted or burned in the operation. String-encoded integer representing the change in position size.               |
  | `in_qty0`          | `STRING`    | Amount of token0 involved in the liquidity operation. String-encoded integer representing token quantity in smallest denomination.                   |
  | `in_qty1`          | `STRING`    | Amount of token1 involved in the liquidity operation. String-encoded integer representing token quantity in smallest denomination.                   |
</Accordion>

<Accordion title="Sample Data">
  | in\_qty            | address                                    | in\_qty0           | in\_qty1           | removed | in\_owner                                  | log\_index | block\_number | block\_timestamp         | transaction\_hash                                                  |
  | ------------------ | ------------------------------------------ | ------------------ | ------------------ | ------- | ------------------------------------------ | ---------- | ------------- | ------------------------ | ------------------------------------------------------------------ |
  | 579588627503018690 | 0x7fe55b652e3f81c4fe2b508c0f1bfdf20a2342f8 | 577670485521856893 | 581514305590073093 | false   | 0x2b1c7b41f6a8f2b2bc45c3233a5d5fb3cd6dc9a8 | 18         | 46483467      | 2022-09-06T16:22:01.000Z | 0x0082873f239304d8230aae6c448d6eb2d0541e6835a5e76e1d067ae9f1ab3bf6 |
  | 745334296479368675 | 0x7fe55b652e3f81c4fe2b508c0f1bfdf20a2342f8 | 742891530027686440 | 747786535494893904 | false   | 0x2b1c7b41f6a8f2b2bc45c3233a5d5fb3cd6dc9a8 | 62         | 46473125      | 2022-09-06T12:14:12.000Z | 0xdac20d7ff756100e20907e4c3616b6a62e500de6f7862c8871a736e0e1d33624 |
  | 420991547513546030 | 0x7fe55b652e3f81c4fe2b508c0f1bfdf20a2342f8 | 419627921821731156 | 422360464767285041 | false   | 0x2b1c7b41f6a8f2b2bc45c3233a5d5fb3cd6dc9a8 | 10         | 46489468      | 2022-09-06T19:27:28.000Z | 0x202c5385a8db04e3c7aee24532bade9eb2d133aee8224871a999b8033a63bde8 |
</Accordion>

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

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

***

### Pool\_Flash\_event

Flash loan events from liquidity pools recording borrowed amounts and repayment fees for both tokens in the pair. Tracks sender, recipient, borrowed quantities, and actual fees paid for arbitrage and liquidation analysis.

<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_recipient`     | `STRING`    | Address designated to receive the output tokens from a swap or operation. Hex-encoded, 0x-prefixed, 42-character string.                             |
  | `in_qty0`          | `STRING`    | Amount of token0 involved in the liquidity operation. String-encoded integer representing token quantity in smallest denomination.                   |
  | `in_qty1`          | `STRING`    | Amount of token1 involved in the liquidity operation. String-encoded integer representing token quantity in smallest denomination.                   |
  | `in_paid0`         | `STRING`    | Amount of token0 paid as flash loan fee. Numeric string representation of token quantity in smallest denomination.                                   |
  | `in_paid1`         | `STRING`    | Amount of token1 paid as flash loan fee. Numeric string representation of token quantity in smallest denomination.                                   |
</Accordion>

<Accordion title="Sample Data">
  | address                                    | in\_qty0 | in\_qty1              | removed | in\_paid0 | in\_paid1          | in\_sender                                 | log\_index | block\_number | in\_recipient                              | block\_timestamp         | transaction\_hash                                                  |
  | ------------------------------------------ | -------- | --------------------- | ------- | --------- | ------------------ | ------------------------------------------ | ---------- | ------------- | ------------------------------------------ | ------------------------ | ------------------------------------------------------------------ |
  | 0x65656e7a0a3ec47f5cc6d10eeb31235d7489e5f3 | 0        | 261303479312621040000 | false   | 0         | 104521391725048417 | 0xa43bab5cb642bacb180f19aa7c5d8c04e6725c6e | 58         | 59437125      | 0xa43bab5cb642bacb180f19aa7c5d8c04e6725c6e | 2023-04-08T22:57:02.000Z | 0x6ae4862e79395d4b9ea7a6b470902823d4f4524f9d2a82e71a7785741dc5af64 |
  | 0x65656e7a0a3ec47f5cc6d10eeb31235d7489e5f3 | 0        | 711022997878940100000 | false   | 0         | 284409199151576041 | 0xa43bab5cb642bacb180f19aa7c5d8c04e6725c6e | 107        | 59422371      | 0xa43bab5cb642bacb180f19aa7c5d8c04e6725c6e | 2023-04-08T18:52:21.000Z | 0x9a072fc30f7954aaee274253fbca546522333d3c9ced4cd23002f76390cb3af1 |
  | 0x8dcf5fed6ae6bf0befb5e4f0c9414c2cb9a4ed01 | 30678898 | 0                     | false   | 3068      | 0                  | 0xa43bab5cb642bacb180f19aa7c5d8c04e6725c6e | 32         | 60332528      | 0xa43bab5cb642bacb180f19aa7c5d8c04e6725c6e | 2023-04-19T23:17:05.000Z | 0xda99562bd743e606a14cb34fe75eaf8eb0959b44774f522f53d9425f6a052765 |
</Accordion>

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

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

***

### Pool\_Mint\_event

Liquidity provision events emitted when liquidity providers add tokens to concentrated liquidity pools. Records deposited token amounts, tick ranges, liquidity shares, and position owner for DEX pool analytics.

<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_owner`         | `STRING`    | Address that owns or controls the shares or position being deposited or withdrawn. Hex-encoded, 0x-prefixed, 42-character string.                                      |
  | `in_tickLower`     | `INT64`     | Lower tick boundary of a concentrated liquidity position in a Uniswap V3-style pool. Signed integer representing a discrete price point on the logarithmic tick scale. |
  | `in_tickUpper`     | `INT64`     | Upper tick boundary of a concentrated liquidity position in a Uniswap V3-style pool. Signed integer representing a discrete price point on the logarithmic tick scale. |
  | `in_qty`           | `STRING`    | Quantity of liquidity tokens being minted or burned in the operation. String-encoded integer representing the change in position size.                                 |
  | `in_qty0`          | `STRING`    | Amount of token0 involved in the liquidity operation. String-encoded integer representing token quantity in smallest denomination.                                     |
  | `in_qty1`          | `STRING`    | Amount of token1 involved in the liquidity operation. String-encoded integer representing token quantity in smallest denomination.                                     |
</Accordion>

<Accordion title="Sample Data">
  | in\_qty                     | address                                    | in\_qty0               | in\_qty1   | removed | in\_owner                                  | in\_sender                                 | log\_index | block\_number | in\_tickLower | in\_tickUpper | block\_timestamp         | transaction\_hash                                                  |
  | --------------------------- | ------------------------------------------ | ---------------------- | ---------- | ------- | ------------------------------------------ | ------------------------------------------ | ---------- | ------------- | ------------- | ------------- | ------------------------ | ------------------------------------------------------------------ |
  | 144522748182622668904332151 | 0x0abf6f06552abb62f195e55f9ae370defe2ebf34 | 7336257916368860422234 | 0          | false   | 0x2b1c7b41f6a8f2b2bc45c3233a5d5fb3cd6dc9a8 | 0x2b1c7b41f6a8f2b2bc45c3233a5d5fb3cd6dc9a8 | 62         | 48355277      | -304          | -303          | 2022-10-03T23:46:36.000Z | 0x1c884348c1824490617fb4ba8ad922b0f72846af01f90631395c9a670d3bbd05 |
  | 4407894115832               | 0x31a1b84245ac12d40a1ade5921f891290043b0d6 | 2191220199             | 2215351891 | false   | 0x2b1c7b41f6a8f2b2bc45c3233a5d5fb3cd6dc9a8 | 0x2b1c7b41f6a8f2b2bc45c3233a5d5fb3cd6dc9a8 | 5          | 56934902      | -10           | 10            | 2023-03-04T15:01:41.000Z | 0x74d0f5e6b8f45578cbae300b8161b04972c38843150345e0e71e6715fbe00e85 |
  | 4410562360487               | 0x31a1b84245ac12d40a1ade5921f891290043b0d6 | 2216311764             | 2192927768 | false   | 0x2b1c7b41f6a8f2b2bc45c3233a5d5fb3cd6dc9a8 | 0x2b1c7b41f6a8f2b2bc45c3233a5d5fb3cd6dc9a8 | 4          | 56907518      | -10           | 10            | 2023-03-04T05:17:07.000Z | 0xa2580a81053aabe7b44e6fb48be1594ec782b77444d91082e8ea615cc30c4e7b |
</Accordion>

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

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

***

### Pool\_Swap\_event

Decentralized exchange (DEX) swap execution events recording token exchanges within liquidity pools. Contains sender, recipient, token amounts, liquidity depth, price data (sqrtPriceX96 or tick), and transaction metadata for tracking trading activity and price movements.

<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_recipient`     | `STRING`    | Address designated to receive the output tokens from a swap or operation. Hex-encoded, 0x-prefixed, 42-character string.                                                                                                     |
  | `in_deltaQty0`     | `STRING`    | Change in token0 balance resulting from the swap. Numeric string representation in smallest denomination, where positive values indicate token0 added to the pool and negative values indicate token0 removed from the pool. |
  | `in_deltaQty1`     | `STRING`    | Change in token1 balance resulting from the swap. Numeric string representation in smallest denomination, where positive values indicate token1 added to the pool and negative values indicate token1 removed from the pool. |
  | `in_sqrtP`         | `STRING`    | Square root of the current price ratio between token0 and token1 in the liquidity pool after the swap execution. Numeric string representation using Q64.96 fixed-point encoding.                                            |
  | `in_liquidity`     | `STRING`    | Total liquidity available in the pool at the time of the event. Numeric string representation of liquidity in smallest denomination.                                                                                         |
  | `in_currentTick`   | `INT64`     | Current tick index of the liquidity pool after the swap execution. Signed integer representing the price tick position in the concentrated liquidity model.                                                                  |
</Accordion>

<Accordion title="Sample Data">
  | address                                    | removed | in\_sqrtP                           | in\_sender                                 | log\_index | block\_number | in\_deltaQty0       | in\_deltaQty1        | in\_liquidity | in\_recipient                              | in\_currentTick | block\_timestamp         | transaction\_hash                                                  |
  | ------------------------------------------ | ------- | ----------------------------------- | ------------------------------------------ | ---------- | ------------- | ------------------- | -------------------- | ------------- | ------------------------------------------ | --------------- | ------------------------ | ------------------------------------------------------------------ |
  | 0x9cd63066a381fe1b2a271d00add7bdd27c52fd4c | false   | 62008774753953949918091615279       | 0x06e14af4abba8f7dfd1f10909fe446bc01ce3a73 | 28         | 66596074      | 4462282963780512790 | -3315884983227239542 | 0             | 0x06e14af4abba8f7dfd1f10909fe446bc01ce3a73 | -4902           | 2023-08-04T01:12:26.000Z | 0x235452ff7d9645acc1c101354384882f8c1a9949d4c7a4c23bfca4ff69e122f3 |
  | 0x57c107bf8bab567daffb324f908e1876ff226f08 | false   | 67602387619930178302498771759822963 | 0x2de4133d5de12561f22c2c740a7bab40e3ef6ca1 | 23         | 66623897      | -5474781            | 4000000000000000000  | 0             | 0x2de4133d5de12561f22c2c740a7bab40e3ef6ca1 | 273150          | 2023-08-04T20:11:20.000Z | 0xf90fc4d245e5e7597acd6e6c0fdcc4fcfbed37d620b09b5b0fdbdb95ec34394b |
  | 0x57c107bf8bab567daffb324f908e1876ff226f08 | false   | 66717702496052457202830179357457946 | 0x2de4133d5de12561f22c2c740a7bab40e3ef6ca1 | 95         | 66618478      | -5621428            | 4000000000000000000  | 0             | 0x2de4133d5de12561f22c2c740a7bab40e3ef6ca1 | 272886          | 2023-08-04T16:49:12.000Z | 0x8e92e0b6148de1577f3b049a4fd620aba08c53af75b1ebabf00972f3421e0571 |
</Accordion>

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

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

***