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

# swapxsonic_v1_sonic

> Tables in tt-contracts.swapxsonic_v1_sonic

## Tables

### AlgebraFactory\_Pool\_event

Pool creation events emitted by Algebra DEX (Decentralized Exchange) factory contracts, recording the deployment of new liquidity pools with their token pair addresses. Used for tracking pool deployments and identifying tradable pairs across Algebra-based DEX implementations.

<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_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         | transaction\_hash                                                  |
  | ------------------------------------------ | ------------------------------------------ | ------- | ------------------------------------------ | ------------------------------------------ | ---------- | ------------- | ------------------------ | ------------------------------------------------------------------ |
  | 0x8121a3f8c4176e9765deea0b95fa2bdfd3016794 | 0x4586fa6c097f20155db32cc011c5fab0b8a6a566 | false   | 0x29219dd400f2bf60e5a23d13be72b486d4038894 | 0xe185a87803c6161974666ddf39ed8c3c2e3c642e | 2          | 20409976      | 2025-04-15T17:01:31.000Z | 0x2440003c4460b393f9b685f7089e5dbc3905d1c0d9943b296e40608797757d27 |
  | 0x8121a3f8c4176e9765deea0b95fa2bdfd3016794 | 0x518ad67c9c6a4a3b295aeae7adc9eb04a1ca6bf8 | false   | 0x29219dd400f2bf60e5a23d13be72b486d4038894 | 0x336491f467eb001d5bfa30a829466b8d35c2a07a | 5          | 20380716      | 2025-04-15T13:31:54.000Z | 0x54de858f655bb0e04da663fb2ad6d45c9af36c2090d959047437dbd585d172a1 |
  | 0x8121a3f8c4176e9765deea0b95fa2bdfd3016794 | 0x9255f31ef9b35d085ced6fe29f9e077eb1f513c6 | false   | 0x5bff88ca1442c2496f7e475e9e7786383bc070c0 | 0xb1e25689d55734fd3fffc939c4c3eb52dff8a794 | 2          | 8359942       | 2025-02-17T23:39:51.000Z | 0x31112404faa02db61bb2055776a53f18084feb209edd9c704fd940d11d65bdff |
</Accordion>

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

  ```sql theme={null}
  SELECT *
  FROM `tt-contracts.swapxsonic_v1_sonic.AlgebraFactory_Pool_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_bottomTick`      | `INT64`     | Lower bound of the tick range for a concentrated liquidity position. Signed integer value representing the price interval boundary in Uniswap V3-style concentrated liquidity pools. |
  | `in_topTick`         | `INT64`     | Upper bound of the tick range for a concentrated liquidity position. Signed integer value representing the price interval boundary in Uniswap V3-style concentrated liquidity pools. |
  | `in_liquidityAmount` | `STRING`    | Amount of liquidity added to or removed from a concentrated liquidity position. Numeric string representation of liquidity units in the position's tick range.                       |
  | `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\_owner                                  | log\_index | in\_amount0  | in\_amount1  | in\_topTick | block\_number | in\_bottomTick | block\_timestamp         | transaction\_hash                                                  | in\_liquidityAmount |
  | ------------------------------------------ | ------- | ------------------------------------------ | ---------- | ------------ | ------------ | ----------- | ------------- | -------------- | ------------------------ | ------------------------------------------------------------------ | ------------------- |
  | 0x0d13400cc7c46d77a43957fe614ba58c827dfde6 | false   | 0xd82fe82244ad01aad671576202f9b46b76fadfe2 | 13         | 304118804220 | 790682725689 | 7           | 24886194      | -13            | 2025-05-07T01:11:19.000Z | 0xf39227d00afe2b06fc4a70a5711c2d3d994808555ec5922c0fb35e8fc3983a73 | 1095148910812612    |
  | 0x0d13400cc7c46d77a43957fe614ba58c827dfde6 | false   | 0xd82fe82244ad01aad671576202f9b46b76fadfe2 | 14         | 368106041985 | 750225309948 | 8           | 24907485      | -12            | 2025-05-07T03:16:31.000Z | 0xfcdd634fc090db64cca790099e6f952bd115c9e6c3a2392211bab2bbdffddeb9 | 1118672440537865    |
  | 0x0d13400cc7c46d77a43957fe614ba58c827dfde6 | false   | 0xd82fe82244ad01aad671576202f9b46b76fadfe2 | 11         | 347881879    | 711012686    | 8           | 24949405      | -12            | 2025-05-07T07:17:37.000Z | 0x415c41d4fede452eaedc6103b545fae62b92b8c9db20a23d0a56b1b3b460d673 | 1059217432467       |
</Accordion>

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

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

***

### Pool\_Collect\_event

Concentrated liquidity position fee collection events from Uniswap V3 compatible decentralized exchanges. Records position owner, recipient, collected token amounts, and tick range boundaries for tracking earned trading fees and position management 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_owner`         | `STRING`    | Address that owns or controls the shares or position being deposited or withdrawn. 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_bottomTick`    | `INT64`     | Lower bound of the tick range for a concentrated liquidity position. Signed integer value representing the price interval boundary in Uniswap V3-style concentrated liquidity pools. |
  | `in_topTick`       | `INT64`     | Upper bound of the tick range for a concentrated liquidity position. Signed integer value representing the price interval boundary in Uniswap V3-style concentrated liquidity pools. |
  | `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\_owner                                  | log\_index | in\_amount0        | in\_amount1 | in\_topTick | block\_number | in\_recipient                              | in\_bottomTick | block\_timestamp         | transaction\_hash                                                  |
  | ------------------------------------------ | ------- | ------------------------------------------ | ---------- | ------------------ | ----------- | ----------- | ------------- | ------------------------------------------ | -------------- | ------------------------ | ------------------------------------------------------------------ |
  | 0xcd531dafd592be3ca9bef79cdb4c0df8a5104b81 | false   | 0xd82fe82244ad01aad671576202f9b46b76fadfe2 | 26         | 0                  | 20704203    | -351060     | 19647605      | 0x73eb2dd6b08d47af3081486df9345bd334a1fe01 | -352860        | 2025-04-11T19:32:23.000Z | 0x9bc25a44b368099d3a328577c783174f4bcfe30aa8c1eb6b298128fcac59496a |
  | 0xcd531dafd592be3ca9bef79cdb4c0df8a5104b81 | false   | 0xd82fe82244ad01aad671576202f9b46b76fadfe2 | 31         | 0                  | 2925        | -350940     | 19596468      | 0x1fab9d2d12c9aa65e23bb273c856d52ffba3afaf | -352800        | 2025-04-11T14:00:05.000Z | 0x0e6de3151ae368f72bd2bc5afa6c667a74d03789439522ee318e3978274304db |
  | 0xcd531dafd592be3ca9bef79cdb4c0df8a5104b81 | false   | 0xd82fe82244ad01aad671576202f9b46b76fadfe2 | 56         | 168754297924531092 | 8680        | -350940     | 19618672      | 0x1fab9d2d12c9aa65e23bb273c856d52ffba3afaf | -352800        | 2025-04-11T16:19:57.000Z | 0x13c757e7dedb1b30015081bf0269167e0302e7b70acbaa287d03671647a50911 |
</Accordion>

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

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

***

### Pool\_CommunityFee\_event

Community fee rate update events from liquidity pools, recording the new fee percentages allocated to the protocol or community for each token in a trading pair. Used for tracking fee structure changes and protocol revenue distribution configurations.

<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_communityFeeNew` | `STRING`    | The updated community fee rate for the SwapXSonic pool, expressed in basis points. Values like '220' represent 2.20% fee, while '0' indicates no community fee is charged. |
</Accordion>

<Accordion title="Sample Data">
  | address                                    | removed | log\_index | block\_number | block\_timestamp         | transaction\_hash                                                  | in\_communityFeeNew |
  | ------------------------------------------ | ------- | ---------- | ------------- | ------------------------ | ------------------------------------------------------------------ | ------------------- |
  | 0xce39d66872015a8d1b2070725e6bfc687a418bd0 | false   | 8          | 2198915       | 2025-01-01T21:42:46.000Z | 0x885222681e933102380b8a2e0df1cccb59bc1a1483dd01ead114fec26e0b16c9 | 0                   |
  | 0xa4b4325f3352758cdbd12d9fef021fb6f3fda7dd | false   | 8          | 22966969      | 2025-04-29T00:09:11.000Z | 0x2fc77c24b70271cb4ebc30b477f1eaa08efbfe778979e82f67b99f0e01fc5e2d | 220                 |
  | 0x300c140e4dc82be708c2a1ceb5a65cac8d472067 | false   | 8          | 23036804      | 2025-04-29T08:35:39.000Z | 0x9ae549c8e40470adf0df15f65b0e1124a20611a07c225600d74b8d142070a2f3 | 220                 |
</Accordion>

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

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

***

### Pool\_Fee\_event

Fee tier configuration events emitted by Automated Market Maker (AMM) pool contracts. Records updates to swap fee parameters measured in basis points for directional trades.

<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_fee`           | `STRING`    | Fee amount charged for the transaction or operation. String-encoded integer value representing the fee in the smallest unit of the relevant token or currency. |
</Accordion>

<Accordion title="Sample Data">
  | in\_fee | address                                    | removed | log\_index | block\_number | block\_timestamp         | transaction\_hash                                                  |
  | ------- | ------------------------------------------ | ------- | ---------- | ------------- | ------------------------ | ------------------------------------------------------------------ |
  | 2897    | 0x0db1717518c62fbc1422a49603c585c6043f5daf | false   | 4          | 24714461      | 2025-05-06T08:33:48.000Z | 0x814edfb752c555119e84f1d473826bf39ddeac0d6c6416c26ad7450771d191db |
  | 3000    | 0x0db1717518c62fbc1422a49603c585c6043f5daf | false   | 7          | 24749599      | 2025-05-06T11:55:08.000Z | 0x02594977436497000a66055710ff04639db467f7bf85f392cb2612a16ee3a231 |
  | 2932    | 0x0db1717518c62fbc1422a49603c585c6043f5daf | false   | 13         | 24673815      | 2025-05-06T04:39:14.000Z | 0xb180a54978ea54630678258d5becf3f8b87fc8d87316fcf22186c40231cc40de |
</Accordion>

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

  ```sql theme={null}
  SELECT *
  FROM `tt-contracts.swapxsonic_v1_sonic.Pool_Fee_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_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_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                                    | removed | in\_paid0         | in\_paid1 | in\_sender                                 | log\_index | in\_amount0           | in\_amount1 | block\_number | in\_recipient                              | block\_timestamp         | transaction\_hash                                                  |
  | ------------------------------------------ | ------- | ----------------- | --------- | ------------------------------------------ | ---------- | --------------------- | ----------- | ------------- | ------------------------------------------ | ------------------------ | ------------------------------------------------------------------ |
  | 0xd760791b29e7894fb827a94ca433254bb5afb653 | false   | 10968281212147555 | 0         | 0x0d9def4428ccef14d93ef64564dec292bb01b826 | 11         | 109682812121475549696 | 0           | 30165306      | 0x0d9def4428ccef14d93ef64564dec292bb01b826 | 2025-05-28T11:05:22.000Z | 0xc8af741769376969bb874d55e22a2812f341a3201d7ac607b5c5cbb2f0517267 |
  | 0xd760791b29e7894fb827a94ca433254bb5afb653 | false   | 12492872300635922 | 0         | 0x0d9def4428ccef14d93ef64564dec292bb01b826 | 22         | 124928723006359215554 | 0           | 30173337      | 0x0d9def4428ccef14d93ef64564dec292bb01b826 | 2025-05-28T11:53:19.000Z | 0x2df170b1759b87da25035488fc7e02abbd0a0272e643c79c64559659da36d226 |
  | 0xd760791b29e7894fb827a94ca433254bb5afb653 | false   | 26778249569585112 | 0         | 0x0d9def4428ccef14d93ef64564dec292bb01b826 | 11         | 267782495695851117267 | 0           | 30181763      | 0x0d9def4428ccef14d93ef64564dec292bb01b826 | 2025-05-28T12:40:37.000Z | 0xe36c3bd5d69113276e7b4f9d041a7397ea8f4f7156bd8edb0a7abf757ac26167 |
</Accordion>

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

  ```sql theme={null}
  SELECT *
  FROM `tt-contracts.swapxsonic_v1_sonic.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_bottomTick`      | `INT64`     | Lower bound of the tick range for a concentrated liquidity position. Signed integer value representing the price interval boundary in Uniswap V3-style concentrated liquidity pools. |
  | `in_topTick`         | `INT64`     | Upper bound of the tick range for a concentrated liquidity position. Signed integer value representing the price interval boundary in Uniswap V3-style concentrated liquidity pools. |
  | `in_liquidityAmount` | `STRING`    | Amount of liquidity added to or removed from a concentrated liquidity position. Numeric string representation of liquidity units in the position's tick range.                       |
  | `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\_owner                                  | in\_sender                                 | log\_index | in\_amount0   | in\_amount1   | in\_topTick | block\_number | in\_bottomTick | block\_timestamp         | transaction\_hash                                                  | in\_liquidityAmount |
  | ------------------------------------------ | ------- | ------------------------------------------ | ------------------------------------------ | ---------- | ------------- | ------------- | ----------- | ------------- | -------------- | ------------------------ | ------------------------------------------------------------------ | ------------------- |
  | 0x0d13400cc7c46d77a43957fe614ba58c827dfde6 | false   | 0xd82fe82244ad01aad671576202f9b46b76fadfe2 | 0xd82fe82244ad01aad671576202f9b46b76fadfe2 | 33         | 1978879733393 | 1323530323413 | 12          | 17585529      | -8             | 2025-04-02T01:31:24.000Z | 0x9c02da8ef61e4653e63f6481ee080449e1a4ed54744d786ce520ecd5284bc64f | 3303433868424021    |
  | 0x0d13400cc7c46d77a43957fe614ba58c827dfde6 | false   | 0xd82fe82244ad01aad671576202f9b46b76fadfe2 | 0xd82fe82244ad01aad671576202f9b46b76fadfe2 | 37         | 96199273835   | 0             | 12          | 17585529      | 1              | 2025-04-02T01:31:24.000Z | 0x9c02da8ef61e4653e63f6481ee080449e1a4ed54744d786ce520ecd5284bc64f | 174973367910002     |
  | 0x0d13400cc7c46d77a43957fe614ba58c827dfde6 | false   | 0xd82fe82244ad01aad671576202f9b46b76fadfe2 | 0xd82fe82244ad01aad671576202f9b46b76fadfe2 | 55         | 1613651643049 | 1322204152369 | 11          | 17604357      | -9             | 2025-04-02T03:37:13.000Z | 0xd927f27818c44250c7525639c97b7c1bd670d37b74b6c760d1a2dbb2ea839e95 | 2936743950164436    |
</Accordion>

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

  ```sql theme={null}
  SELECT *
  FROM `tt-contracts.swapxsonic_v1_sonic.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_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_price`         | `STRING`    | Price of the asset or position in the transaction or event. Numeric string representation in smallest denomination or with extended precision.                 |
  | `in_liquidity`     | `STRING`    | Total liquidity available in the pool at the time of the event. Numeric string representation of liquidity in smallest denomination.                           |
  | `in_tick`          | `INT64`     | Current tick index of the concentrated liquidity pool after the swap or operation. Integer value representing the price point on the pool's tick spacing grid. |
</Accordion>

<Accordion title="Sample Data">
  | address                                    | in\_tick | removed | in\_price                      | in\_sender                                 | log\_index | in\_amount0             | in\_amount1       | block\_number | in\_liquidity             | in\_recipient                              | block\_timestamp         | transaction\_hash                                                  |
  | ------------------------------------------ | -------- | ------- | ------------------------------ | ------------------------------------------ | ---------- | ----------------------- | ----------------- | ------------- | ------------------------- | ------------------------------------------ | ------------------------ | ------------------------------------------------------------------ |
  | 0xcd531dafd592be3ca9bef79cdb4c0df8a5104b81 | -352476  | false   | 1759336917487679176730         | 0x0000000000d44e72f506b4817cd08dc6757d0a8e | 89         | -2470502822133842243455 | 1219645           | 27696208      | 166700317302571920        | 0x0000000000d44e72f506b4817cd08dc6757d0a8e | 2025-05-18T08:28:31.000Z | 0x6f319e1caf9aded02a62dae0d32a8643da938a02940d3f5615d4cf1e5806f0b4 |
  | 0xb96f401f789271bc14ade2229e6189084805c50c | 26       | false   | 79333738537699211915007444912  | 0x0000000000d44e72f506b4817cd08dc6757d0a8e | 86         | 1216525                 | -1219648          | 27696208      | 810291051403              | 0x0000000000d44e72f506b4817cd08dc6757d0a8e | 2025-05-18T08:28:31.000Z | 0x6f319e1caf9aded02a62dae0d32a8643da938a02940d3f5615d4cf1e5806f0b4 |
  | 0xbeca246a76942502f61bfe88f60bbc87dafefe80 | 14947    | false   | 167279137357792615751603110081 | 0xa047e2abf8263fca7c368f43e2f960a06fd9949f | 4          | 1000000000000000        | -4413260749688529 | 27748159      | 4331543384405367913615496 | 0x002748db885d4ccfe3c7c92143f0805f4ebeec01 | 2025-05-18T13:26:31.000Z | 0xea98426e7ac17ecf3581815f18a6384d5a6433551f8becdaa7f49804e83e1c00 |
</Accordion>

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

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

***