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

# thena_v2_bsc

> Tables in tt-contracts.thena_v2_bsc

## 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                                                  |
  | ------------------------------------------ | ------------------------------------------ | ------- | ------------------------------------------ | ------------------------------------------ | ---------- | ------------- | ------------------------ | ------------------------------------------------------------------ |
  | 0x306f06c147f064a010530292a1eb6737c3e378e4 | 0x739e561786c920d025d57ed99be5d4eca3458e3e | false   | 0x55d398326f99059ff775485246999027b3197955 | 0x953e94caf91a1e32337d0548b9274f337920edfa | 226        | 30557945      | 2023-08-04T11:57:40.000Z | 0xe428ad0341b0140eaa7f248c316ed95c89e184ef60f4f830fb04fd049d2899da |
  | 0x306f06c147f064a010530292a1eb6737c3e378e4 | 0x8171e3aa02f684bd4e8e04dad286451318cf27a9 | false   | 0x4b6b3d425f82248996d77ecc3f3df1e500aac1db | 0xbb4cdb9cbd36b01bd1cbaebf2de08d9173bc095c | 107        | 30327819      | 2023-07-27T11:34:13.000Z | 0xc937aec72d0c2bdd904aa645ef1c311758ebecce90f7786f46c72f80b887ec5d |
  | 0x306f06c147f064a010530292a1eb6737c3e378e4 | 0x6b32e9178a6670dc9b19a74fe5080c54ea5347c7 | false   | 0x1bdd3cf7f79cfb8edbb955f20ad99211551ba275 | 0x2170ed0880ac9a755fd29b2688956bd959f933f8 | 46         | 28642845      | 2023-05-29T19:31:10.000Z | 0x04d249a68cf3a6782ea964d2e6b2cb952cda8e831d49cbddbc21ec7374535721 |
</Accordion>

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

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

***

### AlgebraPool\_Burn\_event

Liquidity removal events from Algebra-based concentrated liquidity pools. Records owner address, tick range boundaries, withdrawn liquidity amount, and returned token0/token1 quantities for position burning operations.

<Accordion title="Columns">
  | Column               | Type        | Description                                                                                                                                                                          |
  | -------------------- | ----------- | ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ |
  | `block_timestamp`    | `TIMESTAMP` | Timestamp when the block was produced. UTC timezone, millisecond precision.                                                                                                          |
  | `block_number`       | `INT64`     | Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block's position in the blockchain.                                 |
  | `transaction_hash`   | `STRING`    | Unique identifier for the transaction. 66-character hex string including 0x prefix.                                                                                                  |
  | `log_index`          | `INT64`     | Position of the event within the block's transaction logs. Zero-indexed integer representing the sequential order of log emission.                                                   |
  | `address`            | `STRING`    | Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.                                                                                              |
  | `removed`            | `BOOL`      | Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.                                                                         |
  | `in_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    |
  | ------------------------------------------ | ------- | ------------------------------------------ | ---------- | --------------------- | --------------------- | ----------- | ------------- | -------------- | ------------------------ | ------------------------------------------------------------------ | ---------------------- |
  | 0x8e3ae967604dc4b4ba676e6d34ac603fb07fc921 | false   | 0x05f3abd2b008e8b36a410f3c42e703cb776cecd0 | 324        | 284540942553409006115 | 317284497880175021759 | 8100        | 30346132      | -2100          | 2023-07-28T02:52:22.000Z | 0x84dba3085bc4b9023664fb0634e2869c986de266d65fa36d1fcec62fc5982523 | 1339698228464189352727 |
  | 0x8e3ae967604dc4b4ba676e6d34ac603fb07fc921 | false   | 0x05f3abd2b008e8b36a410f3c42e703cb776cecd0 | 328        | 20653620996226909613  | 304160689546331648806 | 2940        | 30346132      | -2100          | 2023-07-28T02:52:22.000Z | 0x84dba3085bc4b9023664fb0634e2869c986de266d65fa36d1fcec62fc5982523 | 1284284418798034500726 |
  | 0x8e3ae967604dc4b4ba676e6d34ac603fb07fc921 | false   | 0x05f3abd2b008e8b36a410f3c42e703cb776cecd0 | 316        | 0                     | 0                     | 2940        | 30346132      | -2100          | 2023-07-28T02:52:22.000Z | 0x84dba3085bc4b9023664fb0634e2869c986de266d65fa36d1fcec62fc5982523 | 0                      |
</Accordion>

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

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

***

### AlgebraPool\_Collect\_event

Concentrated liquidity position fee collection events from Algebra protocol pools. Records token amounts withdrawn by position owners from specific tick ranges, including owner address, recipient address, and collected quantities of both token0 and token1.

<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                                                  |
  | ------------------------------------------ | ------- | ------------------------------------------ | ---------- | --------------------- | ------------------- | ----------- | ------------- | ------------------------------------------ | -------------- | ------------------------ | ------------------------------------------------------------------ |
  | 0x1b9a1120a17617d8ec4dc80b921a9a1c50caef7d | false   | 0x6ca28c08daef2cf1c98741c1542cc9604926f05d | 415        | 1016815065792088813   | 1198402738918865973 | 60          | 58140997      | 0x6ca28c08daef2cf1c98741c1542cc9604926f05d | -60            | 2025-08-19T11:45:08.000Z | 0xa3b4d63d159fc475ad6bbeb655b860df4c7e0b7958311d259b633f2535b45a4e |
  | 0xd405b976ac01023c9064024880999fc450a8668b | false   | 0x015eb9b9ce3ab0ddacdab35880171b0078edc02e | 212        | 872230668920600736166 | 152244547245345089  | -67020      | 58087458      | 0x015eb9b9ce3ab0ddacdab35880171b0078edc02e | -67440         | 2025-08-19T00:35:49.000Z | 0xc5d92153a17c5d068b4ae18c4032286ca9b9aee693ba66d4ec73c19bc5da1c9a |
  | 0xd405b976ac01023c9064024880999fc450a8668b | false   | 0x015eb9b9ce3ab0ddacdab35880171b0078edc02e | 207        | 3221415328995448      | 3271045087151590934 | -67440      | 58087458      | 0x015eb9b9ce3ab0ddacdab35880171b0078edc02e | -887220        | 2025-08-19T00:35:49.000Z | 0xc5d92153a17c5d068b4ae18c4032286ca9b9aee693ba66d4ec73c19bc5da1c9a |
</Accordion>

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

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

***

### AlgebraPool\_CommunityFee\_event

Community fee configuration change events from Algebra DEX (Decentralized Exchange) liquidity pools. Records protocol fee adjustments for token0 and token1, used for tracking fee policy changes across pool contracts.

<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_communityFee0New` | `STRING`    | Updated community fee rate for token0 in basis points. Integer value representing the fee percentage allocated to the community, where 100 equals 1%. |
  | `in_communityFee1New` | `STRING`    | Updated community fee rate for token1 in basis points. Integer value representing the fee percentage allocated to the community, where 100 equals 1%. |
</Accordion>

<Accordion title="Sample Data">
  | address                                    | removed | log\_index | block\_number | block\_timestamp         | transaction\_hash                                                  | in\_communityFee0New | in\_communityFee1New |
  | ------------------------------------------ | ------- | ---------- | ------------- | ------------------------ | ------------------------------------------------------------------ | -------------------- | -------------------- |
  | 0xc93643c85fb216e459406d524d0aa0fd2045bf7d | false   | 120        | 32919502      | 2023-10-25T18:53:43.000Z | 0x9726d2d7a665d95f32e0534764981b2e1da2a8904464f58627d60ca978e9eae4 | 0                    | 0                    |
  | 0x7b879963ae083732f4514d564f4e4613e24e1f67 | false   | 207        | 30669041      | 2023-08-08T08:55:01.000Z | 0x036415e92ee554a07d34fd5d17de7810ac83a300ba3e6bc142a389fb62bf3599 | 0                    | 0                    |
  | 0xda6419a82c4fd30927f54796d7f053f05acd66bc | false   | 168        | 27609799      | 2023-04-23T21:16:15.000Z | 0xbf522fb734be276ae82acb4245151095997be129f3c2dd468a85d55d2524d5a0 | 30                   | 30                   |
</Accordion>

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

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

***

### AlgebraPool\_Fee\_event

Fee change events emitted by Algebra-based liquidity pools when the pool's fee tier is updated. Records the new fee amount in basis points, used for tracking dynamic fee adjustments in concentrated liquidity protocols.

<Accordion title="Columns">
  | Column             | Type        | Description                                                                                                                                                    |
  | ------------------ | ----------- | -------------------------------------------------------------------------------------------------------------------------------------------------------------- |
  | `block_timestamp`  | `TIMESTAMP` | Timestamp when the block was produced. UTC timezone, millisecond precision.                                                                                    |
  | `block_number`     | `INT64`     | Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block's position in the blockchain.           |
  | `transaction_hash` | `STRING`    | Unique identifier for the transaction. 66-character hex string including 0x prefix.                                                                            |
  | `log_index`        | `INT64`     | Position of the event within the block's transaction logs. Zero-indexed integer representing the sequential order of log emission.                             |
  | `address`          | `STRING`    | Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.                                                                        |
  | `removed`          | `BOOL`      | Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.                                                   |
  | `in_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                                                  |
  | ------- | ------------------------------------------ | ------- | ---------- | ------------- | ------------------------ | ------------------------------------------------------------------ |
  | 2750    | 0x055557c6606f7b0d34e617653c447f079b0b0a73 | false   | 276        | 29103858      | 2023-06-14T20:33:40.000Z | 0x3b218924b0dc75ff4113f757b36735e4257f1545cc4adf5e10c9a4946851d9ee |
  | 2750    | 0x055557c6606f7b0d34e617653c447f079b0b0a73 | false   | 152        | 29103326      | 2023-06-14T20:07:03.000Z | 0x398d71b830b6c47ab03ec561ebfadcc311c5e1ea9b192875fc1f7e5df578d010 |
  | 2750    | 0x055557c6606f7b0d34e617653c447f079b0b0a73 | false   | 43         | 29106575      | 2023-06-14T22:50:16.000Z | 0x0e972fed19766370bb89eeb0fddd86e4c4c6c23a72bb6e7dc251b0bee1315e53 |
</Accordion>

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

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

***

### AlgebraPool\_Mint\_event

Liquidity addition events from Algebra-based concentrated liquidity pools containing sender, owner, token amounts, tick range boundaries, and liquidity units. Used for tracking liquidity provider positions and pool depth changes across Algebra DEX deployments.

<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       |
  | ------------------------------------------ | ------- | ------------------------------------------ | ------------------------------------------ | ---------- | ------------------- | ---------------------- | ----------- | ------------- | -------------- | ------------------------ | ------------------------------------------------------------------ | ------------------------- |
  | 0x1335ffc90516b022425dbcfe4ea3610aa45f6c3e | false   | 0x818c686536f8b86dade0841fcc2416cb89201a05 | 0x818c686536f8b86dade0841fcc2416cb89201a05 | 28         | 1                   | 6                      | 75720       | 29821164      | 69720          | 2023-07-09T20:07:48.000Z | 0x846b7ab13f1ee89785d926e22ff8c5257eb9fafc34c99f8bdf2b6d24634ebee1 | 15                        |
  | 0x1335ffc90516b022425dbcfe4ea3610aa45f6c3e | false   | 0x818c686536f8b86dade0841fcc2416cb89201a05 | 0x818c686536f8b86dade0841fcc2416cb89201a05 | 25         | 3706200377958682631 | 4395906843184321499074 | 75720       | 29821164      | 63600          | 2023-07-09T20:07:48.000Z | 0x846b7ab13f1ee89785d926e22ff8c5257eb9fafc34c99f8bdf2b6d24634ebee1 | 488888727287322280756     |
  | 0x1c2d4f310aea872c5bd55790d2d78ca7b31992a3 | false   | 0xac7042fed4e724107fd5778f4a9cad894a5e18ab | 0xac7042fed4e724107fd5778f4a9cad894a5e18ab | 19         | 0                   | 6345213431979255236647 | -420        | 29821759      | -480           | 2023-07-09T20:37:34.000Z | 0x89fa44df2244190125aeb8fb9d0f27538e75fc91ab1cb41e3a45f6bd130f14db | 2163304573599431174830875 |
</Accordion>

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

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

***

### AlgebraPool\_Swap\_event

Swap events from Algebra Protocol concentrated liquidity pools containing sender, recipient, token amounts exchanged, post-swap price and tick, and liquidity depth. Used for DEX trade analysis and liquidity tracking.

<Accordion title="Columns">
  | Column             | Type        | Description                                                                                                                                                    |
  | ------------------ | ----------- | -------------------------------------------------------------------------------------------------------------------------------------------------------------- |
  | `block_timestamp`  | `TIMESTAMP` | Timestamp when the block was produced. UTC timezone, millisecond precision.                                                                                    |
  | `block_number`     | `INT64`     | Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block's position in the blockchain.           |
  | `transaction_hash` | `STRING`    | Unique identifier for the transaction. 66-character hex string including 0x prefix.                                                                            |
  | `log_index`        | `INT64`     | Position of the event within the block's transaction logs. Zero-indexed integer representing the sequential order of log emission.                             |
  | `address`          | `STRING`    | Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.                                                                        |
  | `removed`          | `BOOL`      | Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.                                                   |
  | `in_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                                                  |
  | ------------------------------------------ | -------- | ------- | ------------------------------- | ------------------------------------------ | ---------- | ----------------------- | ----------------------- | ------------- | ------------------------ | ------------------------------------------ | ------------------------ | ------------------------------------------------------------------ |
  | 0x1335ffc90516b022425dbcfe4ea3610aa45f6c3e | 69607    | false   | 2572230748465381679826660545866 | 0x00000000000e8716b4e2d12400a01474cdfad760 | 371        | 1144766005465000122     | -1200814972963038463526 | 29750920      | 18209876103669538647801  | 0x00000000000e8716b4e2d12400a01474cdfad760 | 2023-07-07T09:26:47.000Z | 0xeec773019bc88973414e3c4cd64da9d35f44f16f124272138eb4a623075d7867 |
  | 0x8e3ae967604dc4b4ba676e6d34ac603fb07fc921 | 770      | false   | 82340398972765521498041839101   | 0x00000000000e8716b4e2d12400a01474cdfad760 | 105        | -447817232327099261648  | 486576536907890584255   | 29766615      | 190418573031130748764461 | 0x00000000000e8716b4e2d12400a01474cdfad760 | 2023-07-07T22:33:23.000Z | 0x60f8d8bfdfb3b401e71a18e6e8d560160293f0b41e6c898c254eb1fcbe842f91 |
  | 0xf6814792050ccd1c603d8a95468d6d9587ecbdaf | -67786   | false   | 2673013714129407994485449416    | 0x00000000000e8716b4e2d12400a01474cdfad760 | 279        | -1574559884932405004167 | 1798000000000000000     | 29744532      | 227483750113588565077457 | 0x00000000000e8716b4e2d12400a01474cdfad760 | 2023-07-07T04:06:19.000Z | 0x03c0472776c489eb2847c6f5363ff2648669073b76785af79826d70fcca9f633 |
</Accordion>

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

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

***

### Gauge\_Harvest\_event

Reward claim events from Thena V2 liquidity gauge contracts on BSC, tracking token amounts harvested by users from their staked positions. Used for analyzing yield farming behavior and protocol reward distribution patterns.

<Accordion title="Columns">
  | Column             | Type        | Description                                                                                                                                          |
  | ------------------ | ----------- | ---------------------------------------------------------------------------------------------------------------------------------------------------- |
  | `block_timestamp`  | `TIMESTAMP` | Timestamp when the block was produced. UTC timezone, millisecond precision.                                                                          |
  | `block_number`     | `INT64`     | Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block's position in the blockchain. |
  | `transaction_hash` | `STRING`    | Unique identifier for the transaction. 66-character hex string including 0x prefix.                                                                  |
  | `log_index`        | `INT64`     | Position of the event within the block's transaction logs. Zero-indexed integer representing the sequential order of log emission.                   |
  | `address`          | `STRING`    | Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.                                                              |
  | `removed`          | `BOOL`      | Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.                                         |
  | `in_user`          | `STRING`    | Address of the user account associated with the transaction or protocol operation. Hex-encoded, 0x-prefixed, 42-character string.                    |
  | `in_reward`        | `STRING`    | Contract address of the reward token being distributed or claimed. Hex-encoded, 0x-prefixed, 42-character string.                                    |
</Accordion>

<Accordion title="Sample Data">
  | address                                    | in\_user                                   | removed | in\_reward            | log\_index | block\_number | block\_timestamp         | transaction\_hash                                                  |
  | ------------------------------------------ | ------------------------------------------ | ------- | --------------------- | ---------- | ------------- | ------------------------ | ------------------------------------------------------------------ |
  | 0xb00894e7c895dde3707e2c6fb6abe08156ac4231 | 0x01ed0c5f8b9e8845236e2fa87245dad888337202 | false   | 130480015041855161423 | 107        | 28780021      | 2023-06-03T14:04:15.000Z | 0x7bfcaf9f1e0c6d511ddbdae2e7e08573c30593faa078361fd9e509cd5ed3c2ad |
  | 0xbc97db24644c12734bbfcc9d429710e448e055cc | 0x048ffae5c45985805e5bed87e5d4ba24198f7bee | false   | 292792279433113       | 224        | 28789991      | 2023-06-03T22:23:24.000Z | 0x5b74586c314aeb8dbc6a7e09c4f510afd5709cf76b14a4a3c9a926a9b7c1f080 |
  | 0xcc51cf273d7bf3a9318c2db35becac9eb2ef7d0a | 0x048ffae5c45985805e5bed87e5d4ba24198f7bee | false   | 8649466086705458191   | 222        | 28789991      | 2023-06-03T22:23:24.000Z | 0x5b74586c314aeb8dbc6a7e09c4f510afd5709cf76b14a4a3c9a926a9b7c1f080 |
</Accordion>

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

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

***

### ReferralRewards\_Claim\_event

Referral reward claim events from Thena V2 DEX (decentralized exchange) on BNB Smart Chain, capturing token payouts to users and their recipients. Useful for tracking referral program participation and reward distribution across various BEP-20 tokens.

<Accordion title="Columns">
  | Column             | Type        | Description                                                                                                                                                   |
  | ------------------ | ----------- | ------------------------------------------------------------------------------------------------------------------------------------------------------------- |
  | `block_timestamp`  | `TIMESTAMP` | Timestamp when the block was produced. UTC timezone, millisecond precision.                                                                                   |
  | `block_number`     | `INT64`     | Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block's position in the blockchain.          |
  | `transaction_hash` | `STRING`    | Unique identifier for the transaction. 66-character hex string including 0x prefix.                                                                           |
  | `log_index`        | `INT64`     | Position of the event within the block's transaction logs. Zero-indexed integer representing the sequential order of log emission.                            |
  | `address`          | `STRING`    | Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.                                                                       |
  | `removed`          | `BOOL`      | Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.                                                  |
  | `in__user`         | `STRING`    | Address of the user account involved in the transaction. Hex-encoded, 0x-prefixed, 42-character string.                                                       |
  | `in__amount`       | `STRING`    | Amount of tokens involved in the transaction. String-encoded integer representing token quantity in smallest unit (wei for ETH, base units for ERC20 tokens). |
  | `in__to`           | `STRING`    | Destination address for the transaction or transfer. Hex-encoded, 0x-prefixed, 42-character string.                                                           |
  | `in__token`        | `STRING`    | Contract address of the token. Hex-encoded, 0x-prefixed, 42-character string.                                                                                 |
</Accordion>

<Accordion title="Sample Data">
  | in\_\_to                                   | address                                    | removed | in\_\_user                                 | in\_\_token                                | log\_index | in\_\_amount         | block\_number | block\_timestamp         | transaction\_hash                                                  |
  | ------------------------------------------ | ------------------------------------------ | ------- | ------------------------------------------ | ------------------------------------------ | ---------- | -------------------- | ------------- | ------------------------ | ------------------------------------------------------------------ |
  | 0xef559bb92b20744749d5faf497de2aa92b0b60d1 | 0x664ce330511653cb2744b8ed50dba31c6c4c08ca | false   | 0xef559bb92b20744749d5faf497de2aa92b0b60d1 | 0x2952beb1326accbb5243725bd4da2fc937bca087 | 199        | 13534728518          | 26421494      | 2023-03-13T05:52:15.000Z | 0x709aa5f65ca1c9d363332c3b39cc4c7501595adf50424f4c84ea6c9efb443576 |
  | 0xef559bb92b20744749d5faf497de2aa92b0b60d1 | 0x664ce330511653cb2744b8ed50dba31c6c4c08ca | false   | 0xef559bb92b20744749d5faf497de2aa92b0b60d1 | 0x8ac76a51cc950d9822d68b83fe1ad97b32cd580d | 225        | 7062875135016100443  | 26421504      | 2023-03-13T05:52:45.000Z | 0xae56c86964143be1299ab10229a958f429b90b475e178d3cbe00d6b921d08ec5 |
  | 0x8f0b0254f4058847676c4e52aa1f1e3c40bed61d | 0x664ce330511653cb2744b8ed50dba31c6c4c08ca | false   | 0x8f0b0254f4058847676c4e52aa1f1e3c40bed61d | 0x4d2d32d8652058bf98c772953e1df5c5c85d9f45 | 219        | 11371557232000000000 | 31275599      | 2023-08-29T12:20:06.000Z | 0xea734b0d9523c71ce41b251dbba28cfeae748dbd396c7737a0f64a5c464c60f0 |
</Accordion>

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

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

***

### Voter\_GaugeCreated\_event

Gauge creation events emitted when new liquidity mining gauges are deployed for liquidity pools in vote-escrowed token (veToken) protocols. Links pool addresses to their corresponding gauge contracts and associated reward distribution mechanisms for governance-driven liquidity incentives.

<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_gauge`          | `STRING`    | Contract address of the gauge contract. Hex-encoded, 0x-prefixed, 42-character string.                                                               |
  | `in_creator`        | `STRING`    | Address of the account that initiated the creation event. Hex-encoded, 0x-prefixed, 42-character string.                                             |
  | `in_internal_bribe` | `STRING`    | Contract address of the internal bribe contract associated with the gauge. Hex-encoded, 0x-prefixed, 42-character string.                            |
  | `in_external_bribe` | `STRING`    | Contract address of the external bribe contract associated with the gauge. 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\_gauge                                  | log\_index | in\_creator                                | block\_number | block\_timestamp         | transaction\_hash                                                  | in\_external\_bribe                        | in\_internal\_bribe                        |
  | ------------------------------------------ | ------------------------------------------ | ------- | ------------------------------------------ | ---------- | ------------------------------------------ | ------------- | ------------------------ | ------------------------------------------------------------------ | ------------------------------------------ | ------------------------------------------ |
  | 0x3a1d0952809f4948d15ebce8d345962a282c4fcb | 0x9c95ee2db6b6d167ad26b65e85d3e642ffe85587 | false   | 0x6cc6eaab8d850991f9c4c88fb8898e7b68f8afa9 | 138        | 0x993ae2b514677c7ac52baecd8871d2b362a9d693 | 31307674      | 2023-08-30T15:09:53.000Z | 0x0fc6fee0110d7e76d8087e6f5d8abeebbecb2264af90b8925d77f77b0c9659d7 | 0xafdf574241eaecaf561cc8912820138af94ee1b6 | 0xa3d0b523c190c3176f0aecfc6d9998a6a9d3bd4f |
  | 0x3a1d0952809f4948d15ebce8d345962a282c4fcb | 0x60e0ca8b53741d7e29a757408bd1d8b1eaf6dbe6 | false   | 0x6aec3024508609bd643edddd3411cded2496471b | 108        | 0x993ae2b514677c7ac52baecd8871d2b362a9d693 | 35693745      | 2024-01-30T09:44:48.000Z | 0xe3cac46e44d6c768193885d7062fd3758c49ac012a184924220c48d2d2391f0a | 0x0707e8e5e6165897ee9403acb0c7c4b24ae87ee8 | 0x110b46f405d933715079cd4624c8bdeb06e1b92f |
  | 0x3a1d0952809f4948d15ebce8d345962a282c4fcb | 0xcbfb2d1487a8a69a8b0ee8e7fb3ca5e0c338b508 | false   | 0x4ea3ddb7425a78113bef43656ba2f5fcbc9bad0f | 200        | 0x993ae2b514677c7ac52baecd8871d2b362a9d693 | 32541402      | 2023-10-12T14:44:24.000Z | 0x7c0dbcfd8626296b7fc8a4e6c5dae447b0b67bd31548c5f9a9fb4b8f7c5a9681 | 0x59283ab0a8ec8b86d1f050b07348af5992e5a6c6 | 0xca24d3db4ad86f692457d563d7f88d627aff3e9e |
</Accordion>

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

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

***

### VoterV3\_DistributeReward\_event

Reward distribution events from Thena v2 DEX (Decentralized Exchange) VoterV3 contract on BNB Smart Chain, tracking token amounts sent to liquidity pool gauges. Used for analyzing protocol emissions and liquidity mining incentive allocations across pools.

<Accordion title="Columns">
  | Column             | Type        | Description                                                                                                                                          |
  | ------------------ | ----------- | ---------------------------------------------------------------------------------------------------------------------------------------------------- |
  | `block_timestamp`  | `TIMESTAMP` | Timestamp when the block was produced. UTC timezone, millisecond precision.                                                                          |
  | `block_number`     | `INT64`     | Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block's position in the blockchain. |
  | `transaction_hash` | `STRING`    | Unique identifier for the transaction. 66-character hex string including 0x prefix.                                                                  |
  | `log_index`        | `INT64`     | Position of the event within the block's transaction logs. Zero-indexed integer representing the sequential order of log emission.                   |
  | `address`          | `STRING`    | Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.                                                              |
  | `removed`          | `BOOL`      | Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.                                         |
  | `in_sender`        | `STRING`    | Address that initiated the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string.                                                  |
  | `in_gauge`         | `STRING`    | Contract address of the gauge contract. Hex-encoded, 0x-prefixed, 42-character string.                                                               |
  | `in_amount`        | `STRING`    | Input amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination.                      |
</Accordion>

<Accordion title="Sample Data">
  | address                                    | removed | in\_gauge                                  | in\_amount              | in\_sender                                 | log\_index | block\_number | block\_timestamp         | transaction\_hash                                                  |
  | ------------------------------------------ | ------- | ------------------------------------------ | ----------------------- | ------------------------------------------ | ---------- | ------------- | ------------------------ | ------------------------------------------------------------------ |
  | 0x3a1d0952809f4948d15ebce8d345962a282c4fcb | false   | 0x1560d23c5db98d78537253332b067a6b8981e432 | 14396114643188242676914 | 0x8635ff9587decbcb28856b0e641e2465245e15aa | 242        | 31934747      | 2023-09-21T11:27:54.000Z | 0xb3feb6c7840dcf1eb4675732fd2ace693d5decd510d15faffa74d60f9200bcc8 |
  | 0x3a1d0952809f4948d15ebce8d345962a282c4fcb | false   | 0x36e56f65b9f5c756289811a4c55923afbff31bbe | 62939148787621618       | 0x8635ff9587decbcb28856b0e641e2465245e15aa | 215        | 31934747      | 2023-09-21T11:27:54.000Z | 0xb3feb6c7840dcf1eb4675732fd2ace693d5decd510d15faffa74d60f9200bcc8 |
  | 0x3a1d0952809f4948d15ebce8d345962a282c4fcb | false   | 0xbe4d4fa65fc80593b0b06a2b155ffe93f1419358 | 2139589904712629096422  | 0x8635ff9587decbcb28856b0e641e2465245e15aa | 233        | 31934747      | 2023-09-21T11:27:54.000Z | 0xb3feb6c7840dcf1eb4675732fd2ace693d5decd510d15faffa74d60f9200bcc8 |
</Accordion>

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

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

***

### VoterV3\_GaugeCreated\_event

Gauge creation events from Thena V2 (Binance Smart Chain) decentralized exchange, capturing when new liquidity pool gauges are initialized with their associated bribe contracts and creator addresses. Used for tracking DEX governance infrastructure deployment and incentive mechanism setup.

<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_gauge`          | `STRING`    | Contract address of the gauge contract. Hex-encoded, 0x-prefixed, 42-character string.                                                               |
  | `in_creator`        | `STRING`    | Address of the account that initiated the creation event. Hex-encoded, 0x-prefixed, 42-character string.                                             |
  | `in_internal_bribe` | `STRING`    | Contract address of the internal bribe contract associated with the gauge. Hex-encoded, 0x-prefixed, 42-character string.                            |
  | `in_external_bribe` | `STRING`    | Contract address of the external bribe contract associated with the gauge. 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\_gauge                                  | log\_index | in\_creator                                | block\_number | block\_timestamp         | transaction\_hash                                                  | in\_external\_bribe                        | in\_internal\_bribe                        |
  | ------------------------------------------ | ------------------------------------------ | ------- | ------------------------------------------ | ---------- | ------------------------------------------ | ------------- | ------------------------ | ------------------------------------------------------------------ | ------------------------------------------ | ------------------------------------------ |
  | 0x3a1d0952809f4948d15ebce8d345962a282c4fcb | 0xa9c1fe3b78a5d613b2dbc5764c893d4e9593a833 | false   | 0xc01f5fe48c2b9716657b8ca7c2fd24915090b9d6 | 122        | 0xf3d66f36af3d43ee9af590278ee4017f049fd54f | 31729033      | 2023-09-14T07:32:31.000Z | 0xd8e15c78b12d237bd7be98f34c9b5dd94e392959d3721b891d75ed15ce22d550 | 0x2bcf89d48b432dd901c6ab879624b1563cad4278 | 0x5da966f6b6b17119a9865dc8816805fa8633b3d5 |
  | 0x3a1d0952809f4948d15ebce8d345962a282c4fcb | 0x9938256dd2c6a436233685e910efaa44f6d8e81c | false   | 0x872d5c17ab31b15554fadda7c89c68b54b84f44b | 107        | 0x34922627b7244d47729f03b33eb45d8d263d116b | 28032625      | 2023-05-08T14:09:36.000Z | 0xd35a44836f979a99d1169ad802570ab3710d8c92b9a4b71a68a54b7a4cef362c | 0x1d114bff05cfba0365944a94a757d1332ef8c64b | 0xd24f6d7ac086e409305fa222069e422d1a506f0c |
  | 0x3a1d0952809f4948d15ebce8d345962a282c4fcb | 0x5a797d22b27c13a98df8147acf95771f7b43ac66 | false   | 0x30c69104d4f305b7403f7ae6e68a8ecd39884cda | 82         | 0x34922627b7244d47729f03b33eb45d8d263d116b | 28032619      | 2023-05-08T14:09:18.000Z | 0xd61f5b9031f52e133ab1f45381d5e92f5400aaca771e10d8b5256f1309ad8d88 | 0x4d332410afddcc288f6cd62c96119a651f9c8bfe | 0xbbf2e43a7c61ca1e818d7aba0e398d2fdd47edb5 |
</Accordion>

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

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

***