> ## 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_v3_bsc
> Tables in tt-contracts.thena_v3_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.
| 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. |
| address | in\_pool | removed | in\_token0 | in\_token1 | log\_index | block\_number | block\_timestamp | transaction\_hash |
| ------------------------------------------ | ------------------------------------------ | ------- | ------------------------------------------ | ------------------------------------------ | ---------- | ------------- | ------------------------ | ------------------------------------------------------------------ |
| 0x306f06c147f064a010530292a1eb6737c3e378e4 | 0xb57f746daed4202fb2774d082522e439cca94f03 | false | 0xafbe3b8b0939a5538de32f7752a78e08c8492295 | 0xf4c8e32eadec4bfe97e0f595add0f4450a863a11 | 181 | 36435411 | 2024-02-25T04:58:14.000Z | 0x8d2ed54683f3188d39129ad1dbfe09183c1bc9d71d975ae25bd84515e999dcb6 |
| 0x306f06c147f064a010530292a1eb6737c3e378e4 | 0x733a0b28e4d7f2cb421730c4e4e26f2adce3d240 | false | 0x1bdd3cf7f79cfb8edbb955f20ad99211551ba275 | 0x64048a7eecf3a2f1ba9e144aac3d7db6e58f555e | 433 | 28058652 | 2023-05-09T11:53:32.000Z | 0xbbeb49630c6c1325f4c68d765248e1c0e4388a9e3de3c49b84c3070d04b7f907 |
| 0x306f06c147f064a010530292a1eb6737c3e378e4 | 0xbff0a89c458ec68854fc0ff36793b51db1d07c05 | false | 0x55d398326f99059ff775485246999027b3197955 | 0x6985884c4392d348587b19cb9eaaf157f13271cd | 56 | 39814443 | 2024-06-21T19:40:13.000Z | 0x1ca4ee922067b868549378210c1ee61d2e0d51238a821d8a738ccce5d241f3f2 |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.thena_v3_bsc.AlgebraFactory_Pool_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### AlgebraFactoryV2\_CustomPool\_event
Custom liquidity pool deployment events from Thena V3 (Algebra-based) DEX on BNB Smart Chain. Tracks pool creation with token pair addresses, deployer addresses, and pool contract addresses for monitoring new trading pair launches.
| 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_deployer` | `STRING` | Address of the account that initiated the deployment or creation action. Hex-encoded, 0x-prefixed, 42-character string. |
| `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. |
| address | in\_pool | removed | in\_token0 | in\_token1 | log\_index | in\_deployer | block\_number | block\_timestamp | transaction\_hash |
| ------------------------------------------ | ------------------------------------------ | ------- | ------------------------------------------ | ------------------------------------------ | ---------- | ------------------------------------------ | ------------- | ------------------------ | ------------------------------------------------------------------ |
| 0x30055f87716d3dfd0e5198c27024481099fb4a98 | 0x070cec06718ac590ba325ade0dfadd19bf5a1349 | false | 0x8ac76a51cc950d9822d68b83fe1ad97b32cd580d | 0x8dedf84656fa932157e27c060d8613824e7979e3 | 540 | 0xf807462b5ce54a89e2f5b847d8281030eafe241b | 61456551 | 2025-09-17T06:40:24.000Z | 0x637902a08765dc68b86bebbd0acf5495d9aa3d0ff13d66a1126f347894497ed1 |
| 0x30055f87716d3dfd0e5198c27024481099fb4a98 | 0x72fb92b9945a7cc24c0758ad9764c59e827b5b67 | false | 0x18ea4df6a9cde2472f2321a4ec77da106498a66e | 0xf4c8e32eadec4bfe97e0f595add0f4450a863a11 | 2 | 0xf807462b5ce54a89e2f5b847d8281030eafe241b | 57769224 | 2025-08-16T06:17:23.000Z | 0xd2e4e7c51295df64ff179dbc4184a3bd06262aad3f5736bb322083a948695caf |
| 0x30055f87716d3dfd0e5198c27024481099fb4a98 | 0xba33814784f190063686abdbb46e3f9ab7628472 | false | 0x0df0587216a4a1bb7d5082fdc491d93d2dd4b413 | 0xf5d8a096cccb31b9d7bce5afe812be23e3d4690d | 63 | 0xf807462b5ce54a89e2f5b847d8281030eafe241b | 54710574 | 2025-07-20T17:00:49.000Z | 0x27a5c4a09c7997bab9845cc5683d9e5bc4250902a500eb20163a0ede3f6cbf1c |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.thena_v3_bsc.AlgebraFactoryV2_CustomPool_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### AlgebraFactoryV2\_Pool\_event
Pool creation events from Thena V3 (Algebra-based) decentralized exchange factory contract on BNB Smart Chain. Tracks new liquidity pool deployments with token pair addresses for analyzing protocol growth and market coverage.
| 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. |
| address | in\_pool | removed | in\_token0 | in\_token1 | log\_index | block\_number | block\_timestamp | transaction\_hash |
| ------------------------------------------ | ------------------------------------------ | ------- | ------------------------------------------ | ------------------------------------------ | ---------- | ------------- | ------------------------ | ------------------------------------------------------------------ |
| 0x30055f87716d3dfd0e5198c27024481099fb4a98 | 0x5b090adf404dba1cf71cd8ca4a56a08a231ed363 | false | 0x7b4bf9feccff207ef2cb7101ceb15b8516021acd | 0xbb4cdb9cbd36b01bd1cbaebf2de08d9173bc095c | 2 | 50404602 | 2025-05-27T12:54:46.000Z | 0x0da41526979f56dcde551f7934a4a47c64bf9aee2002791c3e9c99cfb2516c58 |
| 0x30055f87716d3dfd0e5198c27024481099fb4a98 | 0x0971fe76c5bebc1f14ab1ad8d2f293e3d0e70086 | false | 0xb994882a1b9bd98a71dd6ea5f61577c42848b0e8 | 0xbb4cdb9cbd36b01bd1cbaebf2de08d9173bc095c | 2 | 50396616 | 2025-05-27T09:34:46.000Z | 0x511eaea7b898b217eec0705954ea1d7765c461f99e956ed6460ecc9607e2e9f8 |
| 0x30055f87716d3dfd0e5198c27024481099fb4a98 | 0x8b293f31a04beb4bef06e4e9a64d90f051c416a6 | false | 0x5bff88ca1442c2496f7e475e9e7786383bc070c0 | 0x80eede496655fb9047dd39d9f418d5483ed600df | 5 | 50411791 | 2025-05-27T15:54:32.000Z | 0xc57d698d1c310880bfadcc22ea6c3bea69fa0e02a5a0695a7984bff0f028cb49 |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.thena_v3_bsc.AlgebraFactoryV2_Pool_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### 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.
| 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. |
| address | removed | in\_owner | log\_index | in\_amount0 | in\_amount1 | in\_topTick | block\_number | in\_bottomTick | block\_timestamp | transaction\_hash | in\_liquidityAmount |
| ------------------------------------------ | ------- | ------------------------------------------ | ---------- | --------------------- | -------------------- | ----------- | ------------- | -------------- | ------------------------ | ------------------------------------------------------------------ | --------------------- |
| 0xab3790c5fab8aff0a41640eb2c7b280289c657e5 | false | 0xbed76f58edd506a0080b413ca45b2da29b8e638a | 325 | 1395809963 | 11310294612126109661 | 216540 | 36573761 | 215760 | 2024-03-01T00:31:15.000Z | 0xe65c945a7180e3ffe10c9212878dfd67fd649a00c862e60ea01859aa205b0eb5 | 7695223398317033 |
| 0xab3790c5fab8aff0a41640eb2c7b280289c657e5 | false | 0xbed76f58edd506a0080b413ca45b2da29b8e638a | 329 | 10571167723 | 23967097140318757401 | 220680 | 36573761 | 212460 | 2024-03-01T00:31:15.000Z | 0xe65c945a7180e3ffe10c9212878dfd67fd649a00c862e60ea01859aa205b0eb5 | 2713389188662039 |
| 0xd405b976ac01023c9064024880999fc450a8668b | false | 0xdaa7d60733577453481ed790330617384b876613 | 85 | 897096837950761269039 | 1985160261199603159 | -56460 | 36576458 | -63240 | 2024-03-01T02:46:18.000Z | 0x87996004e0ed22631b623e0db423b280e16f578ba7aa32d67071aba8d919aca1 | 271152625053613951346 |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.thena_v3_bsc.AlgebraPool_Burn_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### 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.
| 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. |
| address | removed | in\_owner | log\_index | in\_amount0 | in\_amount1 | in\_topTick | block\_number | in\_recipient | in\_bottomTick | block\_timestamp | transaction\_hash |
| ------------------------------------------ | ------- | ------------------------------------------ | ---------- | --------------------- | ------------------- | ----------- | ------------- | ------------------------------------------ | -------------- | ------------------------ | ------------------------------------------------------------------ |
| 0xd405b976ac01023c9064024880999fc450a8668b | false | 0x015eb9b9ce3ab0ddacdab35880171b0078edc02e | 725 | 199561211106232599153 | 3275696445607198288 | -70140 | 65299811 | 0x015eb9b9ce3ab0ddacdab35880171b0078edc02e | -70860 | 2025-10-20T15:53:55.000Z | 0x494d63c037ac9a773712b22ff6104ca6fbf5430f8e4376c6f5185a4b280baee4 |
| 0xd405b976ac01023c9064024880999fc450a8668b | false | 0x015eb9b9ce3ab0ddacdab35880171b0078edc02e | 720 | 220512020752237592241 | 2369707322692 | 887220 | 65299811 | 0x015eb9b9ce3ab0ddacdab35880171b0078edc02e | -70140 | 2025-10-20T15:53:55.000Z | 0x494d63c037ac9a773712b22ff6104ca6fbf5430f8e4376c6f5185a4b280baee4 |
| 0xd405b976ac01023c9064024880999fc450a8668b | false | 0x015eb9b9ce3ab0ddacdab35880171b0078edc02e | 1085 | 1409120772440012 | 2599522025322746243 | -70380 | 65264289 | 0x015eb9b9ce3ab0ddacdab35880171b0078edc02e | -887220 | 2025-10-20T08:29:46.000Z | 0x63a0c160f696f2639a6b088635b06cc0f65594e49b344de9c8c7bb6aeeaba755 |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.thena_v3_bsc.AlgebraPool_Collect_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### 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.
| 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%. |
| address | removed | log\_index | block\_number | block\_timestamp | transaction\_hash | in\_communityFee0New | in\_communityFee1New |
| ------------------------------------------ | ------- | ---------- | ------------- | ------------------------ | ------------------------------------------------------------------ | -------------------- | -------------------- |
| 0x3401cf94c6f81347b426df1d0f6269b7a24feb2e | false | 97 | 29844481 | 2023-07-10T15:38:28.000Z | 0x9ae0fd1a8152ccb3510927eb09d53769a0c82002fa1e79f0cd8544b1429cd794 | 0 | 0 |
| 0xb48fdf4d9897973f677f8c5e5d12280f6074d310 | false | 241 | 29844840 | 2023-07-10T15:56:28.000Z | 0xe9dab6865cfd977bfb2321c5c2333dd7d9326edc2648fdd12ca028840c1e4d02 | 30 | 30 |
| 0x70efad801f5e254a0a650fec28f814ed9e3c98f5 | false | 247 | 29844816 | 2023-07-10T15:55:16.000Z | 0x35ebf6a19cd43ffc58fc6eee3efe6f23b161dc00f101d5572e67585e70a91576 | 30 | 30 |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.thena_v3_bsc.AlgebraPool_CommunityFee_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### 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.
| 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. |
| in\_fee | address | removed | log\_index | block\_number | block\_timestamp | transaction\_hash |
| ------- | ------------------------------------------ | ------- | ---------- | ------------- | ------------------------ | ------------------------------------------------------------------ |
| 6287 | 0x011077b8199cab999e895aed7f8a78755a678106 | false | 742 | 35987213 | 2024-02-09T14:44:36.000Z | 0x30781be362132a30a4a20ae1448039c0ed455b97e584078cace5f70f94b1e0f7 |
| 6299 | 0x011077b8199cab999e895aed7f8a78755a678106 | false | 315 | 35980176 | 2024-02-09T08:52:14.000Z | 0x8c44e7067c4e0549dd6fc32f63a954106183941be52e62dd90507d199a06285a |
| 6299 | 0x011077b8199cab999e895aed7f8a78755a678106 | false | 266 | 35982206 | 2024-02-09T10:34:05.000Z | 0xc6d7943e9d878649753ccfa4890a71e15ea1e06dde9108cd3e608a8a33de513d |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.thena_v3_bsc.AlgebraPool_Fee_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### AlgebraPool\_Flash\_event
Flash loan events from Thena V3 Algebra-based liquidity pools on BNB Smart Chain, recording borrowed amounts (amount0/amount1) and repayment fees (paid0/paid1) for arbitrage and liquidation analysis.
| 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. |
| address | removed | in\_paid0 | in\_paid1 | in\_sender | log\_index | in\_amount0 | in\_amount1 | block\_number | in\_recipient | block\_timestamp | transaction\_hash |
| ------------------------------------------ | ------- | -------------------- | ----------------------- | ------------------------------------------ | ---------- | ------------------------- | -------------------------- | ------------- | ------------------------------------------ | ------------------------ | ------------------------------------------------------------------ |
| 0x1b9a1120a17617d8ec4dc80b921a9a1c50caef7d | false | 26504716012621643710 | 0 | 0x59145855a30c473f2c8936584d55143e49ec1da5 | 61 | 2650471601262164370960839 | 0 | 30043561 | 0x59145855a30c473f2c8936584d55143e49ec1da5 | 2023-07-17T13:59:40.000Z | 0x1ad93cc27e39fd176cfa0f9fc7c4d46a260853bdf510a2226996c0c70992b0b3 |
| 0xc8cbf9b12552c0b85fc368aa530cc31e00526e2f | false | 0 | 85303500063513317953893 | 0xc40119c7269a5fa813d878bf83d14e3462fc8fde | 225 | 0 | 30751081493696221324402444 | 29185769 | 0xd2094b870d80cfb7dada4893ad0030d642ca9f72 | 2023-06-17T17:01:43.000Z | 0x4a304ff08851106691f626045b0f55d403e3a0958363bdf82b96e8ce7209c3a6 |
| 0x5b0baf66718caabda49a4af32eb455c3b99b5821 | false | 200000000000000 | 0 | 0xf0796b0a1f7f5fc1f09e5473b88eec0b85b14725 | 67 | 2000000000000000000 | 0 | 35909630 | 0xf0796b0a1f7f5fc1f09e5473b88eec0b85b14725 | 2024-02-06T21:58:56.000Z | 0x9697166593bdecf4d0263f789ee252dd72a7c715e9b6098c37cc3cf55ef8f079 |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.thena_v3_bsc.AlgebraPool_Flash_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### 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.
| 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. |
| address | removed | in\_owner | in\_sender | log\_index | in\_amount0 | in\_amount1 | in\_topTick | block\_number | in\_bottomTick | block\_timestamp | transaction\_hash | in\_liquidityAmount |
| ------------------------------------------ | ------- | ------------------------------------------ | ------------------------------------------ | ---------- | --------------------------- | -------------------- | ----------- | ------------- | -------------- | ------------------------ | ------------------------------------------------------------------ | ------------------------ |
| 0x01e0d483ac9e04c443ad1b82f0e967813962d568 | false | 0xfd91d0bced526771ade0ccdee53f4f17b22551cc | 0xfd91d0bced526771ade0ccdee53f4f17b22551cc | 249 | 952286100330153595590597991 | 32761332263866298735 | -160800 | 43537403 | -170100 | 2024-10-29T08:56:18.000Z | 0xae7dffde277f50a435b41f8571a27fe73f4ea15190cbd252b5863be15ca23524 | 886567631856869412265032 |
| 0x01e0d483ac9e04c443ad1b82f0e967813962d568 | false | 0xfd91d0bced526771ade0ccdee53f4f17b22551cc | 0xfd91d0bced526771ade0ccdee53f4f17b22551cc | 251 | 325346425230600593462760685 | 0 | -165000 | 43537403 | -166740 | 2024-10-29T08:56:18.000Z | 0xae7dffde277f50a435b41f8571a27fe73f4ea15190cbd252b5863be15ca23524 | 935557211047593151618630 |
| 0x1123e75b71019962cd4d21b0f3018a6412edb63c | false | 0x10bf6e7b28b1cffb1c047d7f815953931e5ee947 | 0x10bf6e7b28b1cffb1c047d7f815953931e5ee947 | 18 | 3847772176721786874 | 22907906285126810010 | 15240 | 43542318 | 13860 | 2024-10-29T13:02:03.000Z | 0x49e311a5bfda53f80dca6c0e61b3c9167a89e2a4cd3b6dca23677447cf7b731e | 280495328820891352547 |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.thena_v3_bsc.AlgebraPool_Mint_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### 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.
| 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. |
| address | in\_tick | removed | in\_price | in\_sender | log\_index | in\_amount0 | in\_amount1 | block\_number | in\_liquidity | in\_recipient | block\_timestamp | transaction\_hash |
| ------------------------------------------ | -------- | ------- | ---------------------------- | ------------------------------------------ | ---------- | ------------------------ | --------------------- | ------------- | ------------------------ | ------------------------------------------ | ------------------------ | ------------------------------------------------------------------ |
| 0xf6814792050ccd1c603d8a95468d6d9587ecbdaf | -64020 | false | 3226877801004988143950392724 | 0x0000000000016a723d0d576df7dc79ec149ac760 | 104 | 33069794956602223727486 | -55041171997864435077 | 34232994 | 197755655391208188892984 | 0x0000000000016a723d0d576df7dc79ec149ac760 | 2023-12-10T13:14:01.000Z | 0x9629fe93b8e45c314b2dc1ba94b4a27cc53fb956e3cd88aa00c8a6771ae44cb9 |
| 0xf6814792050ccd1c603d8a95468d6d9587ecbdaf | -63989 | false | 3231860011208729558521034226 | 0x0000000000016a723d0d576df7dc79ec149ac760 | 11 | -33069794956602223727486 | 54844414999999995904 | 34232994 | 197755655391208188892984 | 0x0000000000016a723d0d576df7dc79ec149ac760 | 2023-12-10T13:14:01.000Z | 0xfffd3dbd949578229fe3a26af2486493f0466ae5d5fb132f1fbb338ba0671ff4 |
| 0xf6814792050ccd1c603d8a95468d6d9587ecbdaf | -63977 | false | 3233878462401815111433405892 | 0x000000000003a3c2878a1df56a486c9683220456 | 513 | -657487950172072636529 | 1099082250779224558 | 34228794 | 197755655391208188892984 | 0x000000000003a3c2878a1df56a486c9683220456 | 2023-12-10T09:43:40.000Z | 0x7a120ee9e76e1008cea92249819b05d700e2e8ab99f0796edb80dbdfe3ee970b |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.thena_v3_bsc.AlgebraPool_Swap_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### AlgebraPoolV2\_Burn\_event
Liquidity removal events from Thena V3 (Algebra-based) automated market maker pools on BNB Smart Chain. Tracks position burns with withdrawn token amounts, tick ranges, and liquidity deltas for analyzing LP activity and pool depth changes.
| 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. |
| `in_pluginFee` | `STRING` | Fee charged by the plugin module on the liquidity pool operation. Numeric string representation in smallest denomination. |
| address | removed | in\_owner | log\_index | in\_amount0 | in\_amount1 | in\_topTick | block\_number | in\_pluginFee | in\_bottomTick | block\_timestamp | transaction\_hash | in\_liquidityAmount |
| ------------------------------------------ | ------- | ------------------------------------------ | ---------- | ------------------ | -------------------- | ----------- | ------------- | ------------- | -------------- | ------------------------ | ------------------------------------------------------------------ | ---------------------- |
| 0x90a420de9894f48ecb05a50ef67aaa89a9049e16 | false | 0x643b68bf3f855b8475c0a700b6d1020bfc21d02e | 148 | 0 | 999999999999999999 | -78300 | 54273468 | 0 | -79080 | 2025-07-16T21:56:18.000Z | 0x2f63641dec661485bcd7a5d44679e917c18306fcfafab95ca0791df014bcf01e | 1310918808691582790690 |
| 0xca1574c79735182db0468daa2751b7ec5549c609 | false | 0x643b68bf3f855b8475c0a700b6d1020bfc21d02e | 312 | 0 | 86348280199528007745 | 73200 | 54222847 | 0 | 69180 | 2025-07-16T11:23:23.000Z | 0x89d20c615d371a8e1bca8550211dee51bd0c5e3ff9c53c0c61ff01ad9114a1a0 | 12205474484666651691 |
| 0xca1574c79735182db0468daa2751b7ec5549c609 | false | 0x643b68bf3f855b8475c0a700b6d1020bfc21d02e | 285 | 307785644576270832 | 0 | 80640 | 54258144 | 0 | 76980 | 2025-07-16T18:44:43.000Z | 0x182139581a9b62c627e44190ef41be00ab12319d05962ecc8a72d54bbb9822ef | 86390314460735348963 |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.thena_v3_bsc.AlgebraPoolV2_Burn_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### AlgebraPoolV2\_Collect\_event
Fee collection events from Thena v3 concentrated liquidity pools on BNB Smart Chain using Algebra protocol. Records liquidity provider withdrawals of accumulated token0 and token1 fees within specified tick ranges.
| 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. |
| address | removed | in\_owner | log\_index | in\_amount0 | in\_amount1 | in\_topTick | block\_number | in\_recipient | in\_bottomTick | block\_timestamp | transaction\_hash |
| ------------------------------------------ | ------- | ------------------------------------------ | ---------- | --------------- | -------------- | ----------- | ------------- | ------------------------------------------ | -------------- | ------------------------ | ------------------------------------------------------------------ |
| 0x1796b29414933826149b5b51f1a99d0d3bd0f4f6 | false | 0x643b68bf3f855b8475c0a700b6d1020bfc21d02e | 146 | 985956544427068 | 35494356628948 | 887220 | 49358607 | 0x993ae2b514677c7ac52baecd8871d2b362a9d693 | -887220 | 2025-05-09T08:58:07.000Z | 0x26b5b83390fd93e5285836d5aee0aabb099979cdcb3ed9e52bdd683a165944f2 |
| 0x2c950a64b03565eaeddb6c33d8f8c749aa3b89bf | false | 0x643b68bf3f855b8475c0a700b6d1020bfc21d02e | 76 | 3234588750 | 0 | 887220 | 49358612 | 0x993ae2b514677c7ac52baecd8871d2b362a9d693 | -887220 | 2025-05-09T08:58:14.000Z | 0xc36042aa8359b933d39cf42079506900b2369cb430bfbb1255fa4b44a5c6bd0e |
| 0x27a3b3d61830efe5ca13ad59dc8efaa73833d691 | false | 0x643b68bf3f855b8475c0a700b6d1020bfc21d02e | 99 | 16745635665937 | 5270022009917 | 60 | 49358596 | 0x993ae2b514677c7ac52baecd8871d2b362a9d693 | -60 | 2025-05-09T08:57:50.000Z | 0x36d9909496fc00acc58a255dbbf987d78230a47d02b7e129fec6361fff723292 |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.thena_v3_bsc.AlgebraPoolV2_Collect_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### AlgebraPoolV2\_CommunityFee\_event
Community fee parameter changes for Thena V3 liquidity pools on BNB Smart Chain using Algebra protocol. Tracks fee adjustments at the pool level with typical values of 125 and 1000 basis points for protocol revenue allocation.
| 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` | New community fee rate for the Thena Algebra V3 pool, expressed in basis points. Common values include 125 (1.25%) and 1000 (10%), representing the protocol's fee share allocation. |
| address | removed | log\_index | block\_number | block\_timestamp | transaction\_hash | in\_communityFeeNew |
| ------------------------------------------ | ------- | ---------- | ------------- | ------------------------ | ------------------------------------------------------------------ | ------------------- |
| 0x5c00011065740c8f8a1da551741e9dc679b84570 | false | 434 | 56512453 | 2025-08-05T08:26:24.000Z | 0xe0788448a695c4e47aaf042bd3713cd95aec8b0367eae1218e4a562cc6672cd9 | 1000 |
| 0x5c00011065740c8f8a1da551741e9dc679b84570 | false | 436 | 56512453 | 2025-08-05T08:26:24.000Z | 0xe0788448a695c4e47aaf042bd3713cd95aec8b0367eae1218e4a562cc6672cd9 | 125 |
| 0xb641cccda9faa3e9ccf1b4c63a85982bd86e644c | false | 66 | 57731790 | 2025-08-15T22:29:25.000Z | 0x3095060f6234a1a11d191c37a1b861e9ba7c5358137d5da8f8335995d0de84a9 | 125 |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.thena_v3_bsc.AlgebraPoolV2_CommunityFee_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### AlgebraPoolV2\_Fee\_event
Fee tier update events from Thena V3 Algebra-based liquidity pools on BNB Smart Chain. Captures dynamic fee adjustments (measured in basis points) for analyzing fee tier changes and pool economics across DEX (decentralized exchange) trading pairs.
| 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. |
| in\_fee | address | removed | log\_index | block\_number | block\_timestamp | transaction\_hash |
| ------- | ------------------------------------------ | ------- | ---------- | ------------- | ------------------------ | ------------------------------------------------------------------ |
| 3409 | 0x03bdad39d368b1eccdd0a613c87e5e64cbebf2de | false | 10 | 52411597 | 2025-06-30T18:01:22.000Z | 0xdb48ad3936b0979bfa479778032c0886be9c206b99990a9cb66a07a517fa0e16 |
| 3411 | 0x03bdad39d368b1eccdd0a613c87e5e64cbebf2de | false | 183 | 52423329 | 2025-06-30T20:28:01.000Z | 0xa86506fe1bb4f5eef81ad4e1b61ff2454164b98e30ed5d2140055eb40c0dfb1e |
| 3411 | 0x03bdad39d368b1eccdd0a613c87e5e64cbebf2de | false | 1424 | 52392305 | 2025-06-30T14:00:13.000Z | 0x24d5de3a70a8435f63ca00701e4d663bfba7293bcdd418323edefd7c4ec95497 |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.thena_v3_bsc.AlgebraPoolV2_Fee_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### AlgebraPoolV2\_Mint\_event
Liquidity provision events from Thena V3 Algebra pools on BSC, capturing mints with tick ranges, token amounts, and liquidity changes. Used to analyze concentrated liquidity positions and liquidity provider behavior across AMM pools.
| 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. |
| address | removed | in\_owner | in\_sender | log\_index | in\_amount0 | in\_amount1 | in\_topTick | block\_number | in\_bottomTick | block\_timestamp | transaction\_hash | in\_liquidityAmount |
| ------------------------------------------ | ------- | ------------------------------------------ | ------------------------------------------ | ---------- | --------------------- | ------------------- | ----------- | ------------- | -------------- | ------------------------ | ------------------------------------------------------------------ | --------------------- |
| 0x03bdad39d368b1eccdd0a613c87e5e64cbebf2de | false | 0x643b68bf3f855b8475c0a700b6d1020bfc21d02e | 0x643b68bf3f855b8475c0a700b6d1020bfc21d02e | 584 | 55056077994204954967 | 83024787064052506 | -52080 | 50211961 | -58320 | 2025-05-24T04:36:59.000Z | 0xe3db0d47a60ef27ac1814c1737669ea59d5fc180b2b447516837d7cbd4438c6a | 16355363382808127836 |
| 0xa4f0ecc42df9a82db3bfc645f4b5a80a6bb56e24 | false | 0x643b68bf3f855b8475c0a700b6d1020bfc21d02e | 0x643b68bf3f855b8475c0a700b6d1020bfc21d02e | 10 | 965686402380476569561 | 1212049554930432814 | -52020 | 50233560 | -56040 | 2025-05-24T13:37:06.000Z | 0x66e218e469c3ee65c25b74b442d2327653cce60fbcee98b342f2c948df3a38e7 | 426684323767792088666 |
| 0xa4f0ecc42df9a82db3bfc645f4b5a80a6bb56e24 | false | 0x643b68bf3f855b8475c0a700b6d1020bfc21d02e | 0x643b68bf3f855b8475c0a700b6d1020bfc21d02e | 198 | 271024945285934284171 | 181579848641903934 | -52560 | 50252986 | -55620 | 2025-05-24T21:42:49.000Z | 0xc5bd6b83256d6dd4351451e790568af1b518355a77ae94deb550daa69eb4c594 | 138642274718653018782 |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.thena_v3_bsc.AlgebraPoolV2_Mint_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### AlgebraPoolV2\_Swap\_event
Swap events from Thena V3 (Algebra protocol fork) liquidity pools on BNB Smart Chain, capturing token exchange amounts, execution price, tick position, and fee parameters. Used for analyzing DEX trading volume, price impact, and liquidity utilization across concentrated liquidity positions.
| 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. |
| `in_overrideFee` | `STRING` | Custom fee override value in basis points applied to this specific swap transaction. Typically ranges from 500-1000 (0.5%-1.0%), allowing dynamic fee adjustments per swap on Thena's Algebra-based pools. |
| `in_pluginFee` | `STRING` | Fee charged by the plugin module on the liquidity pool operation. Numeric string representation in smallest denomination. |
| address | in\_tick | removed | in\_price | in\_sender | log\_index | in\_amount0 | in\_amount1 | block\_number | in\_liquidity | in\_pluginFee | in\_recipient | in\_overrideFee | block\_timestamp | transaction\_hash |
| ------------------------------------------ | -------- | ------- | ---------------------------- | ------------------------------------------ | ---------- | -------------------- | ----------------- | ------------- | -------------------- | ------------- | ------------------------------------------ | --------------- | ------------------------ | ------------------------------------------------------------------ |
| 0x9ea0f51fd2133d995cf00229bc523737415ad318 | -63228 | false | 3357308239540069675164260446 | 0xb5cb0555a1d28c9dfdbc14017dae131d5c1cc19c | 1356 | -3462153841720315259 | 6191275596608590 | 48127217 | 28631658705017199911 | 0 | 0xb5cb0555a1d28c9dfdbc14017dae131d5c1cc19c | 990 | 2025-04-06T18:17:52.000Z | 0xb9b9639b5680dbc3c02490c53655247b4517d9c376167f8402f0a0652ed3742d |
| 0x9ea0f51fd2133d995cf00229bc523737415ad318 | -63330 | false | 3340192997421820119649725577 | 0xb5cb0555a1d28c9dfdbc14017dae131d5c1cc19c | 638 | -2909641366185801592 | 5154632209929677 | 48127134 | 28631658705017199911 | 0 | 0xb5cb0555a1d28c9dfdbc14017dae131d5c1cc19c | 990 | 2025-04-06T18:13:43.000Z | 0x3be7311aba9d043cdcb226659c3382eb87448d0498995cc62df7347678961872 |
| 0x9ea0f51fd2133d995cf00229bc523737415ad318 | -63261 | false | 3351690157988668056871237897 | 0xb5cb0555a1d28c9dfdbc14017dae131d5c1cc19c | 1764 | 1133763413613577322 | -2030430671036716 | 48127515 | 28635235871772899919 | 0 | 0xb5cb0555a1d28c9dfdbc14017dae131d5c1cc19c | 990 | 2025-04-06T18:32:46.000Z | 0x50ed54d9804a39c262208382e20d014488268bba64c0db56542cd9031a20f977 |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.thena_v3_bsc.AlgebraPoolV2_Swap_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### Gauge\_Harvest\_event
Harvest event records from Thena V3 gauge contracts on BNB Smart Chain, capturing reward claims by liquidity providers with user addresses and reward amounts. Used for analyzing gauge incentive distribution patterns and LP reward claiming behavior.
| 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. |
| address | in\_user | removed | in\_reward | log\_index | block\_number | block\_timestamp | transaction\_hash |
| ------------------------------------------ | ------------------------------------------ | ------- | --------------------- | ---------- | ------------- | ------------------------ | ------------------------------------------------------------------ |
| 0xe2c96a636c64322d444c58de20e599b3ce9c6116 | 0x0231487c02af8a878ac03382a839dce84d80aa76 | false | 311063187672212451626 | 271 | 36646128 | 2024-03-03T12:55:29.000Z | 0xd1fd6ec66ecda566ed0d5aefd6b1e914fa65a88f2bb32b94fab2fe02769cd00f |
| 0xd777e84b0d29128351a35045d7ae728780def54d | 0x03762abbf8c766663a643aa3e6548e35524c2f9e | false | 350580423689427935993 | 126 | 36649586 | 2024-03-03T15:48:51.000Z | 0x90f91fe2f2bccb5c16444de42c7728234bcb89cb4b2ef874a1cc9864f992142b |
| 0xd777e84b0d29128351a35045d7ae728780def54d | 0x03762abbf8c766663a643aa3e6548e35524c2f9e | false | 316730583084436291761 | 254 | 36657979 | 2024-03-03T22:49:00.000Z | 0xc8fbe9c00d734745408a51dd71b1851dbf1803f551dc53c3d73b399bcdf8910c |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.thena_v3_bsc.Gauge_Harvest_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### GaugeFactoryV2\_CreateGauge\_event
Gauge creation events from Thena V3 decentralized exchange on BNB Smart Chain, recording when new liquidity mining gauges are deployed with their associated strategy contracts. Used for tracking gauge deployment activity and analyzing Thena's incentive structure expansion.
| 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_strategy` | `STRING` | Contract address of the strategy or strategy contract being referenced. Hex-encoded, 0x-prefixed, 42-character string. |
| `in_gauge` | `STRING` | Contract address of the gauge contract. Hex-encoded, 0x-prefixed, 42-character string. |
| address | removed | in\_gauge | log\_index | in\_strategy | block\_number | block\_timestamp | transaction\_hash |
| ------------------------------------------ | ------- | ------------------------------------------ | ---------- | ------------------------------------------ | ------------- | ------------------------ | ------------------------------------------------------------------ |
| 0x479ce658dd4195556c60ea9fde92cf0f42ea8692 | false | 0x0c59f754977a3a170f3df68682f05200c26b2036 | 39 | 0xbd227b908697225e516a1110f81aa87b59960e5b | 50476979 | 2025-05-28T19:06:08.000Z | 0xd377e6e8e55a580beb0d56338e68bcae4b3eb4e4d19dd5bd444fe2d06f85c5a2 |
| 0x479ce658dd4195556c60ea9fde92cf0f42ea8692 | false | 0xfe7406dc5acd57612934c5451f2ef920eb0a17b9 | 29 | 0x4b5eae4fbcf8df12b408dca84f0ecda5b940db70 | 50477145 | 2025-05-28T19:10:17.000Z | 0x951601cbbd6874e3fd9be7b3972ef786faa05cb6af99d357e46aaafce8c7561a |
| 0x479ce658dd4195556c60ea9fde92cf0f42ea8692 | false | 0x2f5f85d1b709bf732becdda41a00b3965ff9c1b3 | 28 | 0x02dbbc330e6b71b822f3787142b6c5199dfa1cef | 50446743 | 2025-05-28T06:29:02.000Z | 0x34f3c33ad6750585770c65275783040c367414714e7163a5ec13b16507ef0978 |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.thena_v3_bsc.GaugeFactoryV2_CreateGauge_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### GaugeV2\_Harvest\_event
Reward claim events from Thena v3 liquidity mining gauges on BNB Smart Chain, capturing when users harvest tokens from staking positions. Records user addresses, reward token amounts, and gauge contract addresses for tracking incentive distributions and farming activity.
| 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_token` | `STRING` | Token address involved in the transaction or 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. |
| address | in\_user | removed | in\_token | in\_reward | log\_index | block\_number | block\_timestamp | transaction\_hash |
| ------------------------------------------ | ------------------------------------------ | ------- | ------------------------------------------ | ---------------------- | ---------- | ------------- | ------------------------ | ------------------------------------------------------------------ |
| 0xb53d64d4af104e00b781b8280127339e134f3b0f | 0x04e0e61845b0fdd58fc49591534bffaf26b5bd2e | false | 0xf4c8e32eadec4bfe97e0f595add0f4450a863a11 | 1914478040140835594505 | 489 | 60681101 | 2025-09-10T13:03:22.000Z | 0x62141cf0edc320de3293225ab96620bcdce2101819e037bdfda1421a225551b4 |
| 0x96a658dcea13c6c8e09bd8174c7a74b2211c7a07 | 0x14a0567b9096e08ac7d7440ee5ce6e8c4ae7fd4f | false | 0xf4c8e32eadec4bfe97e0f595add0f4450a863a11 | 15947597996366696196 | 764 | 60674421 | 2025-09-10T11:39:52.000Z | 0x7f5ca09cf5156b93f681a860ec178ae70a7e9a8631c5e19590068984e00148c2 |
| 0x6b01c724ebb8fca2683e6c0e9fd2c0ed339e725b | 0x16ce1b15ed1278921d7cae34bf60a81227cfc295 | false | 0xf4c8e32eadec4bfe97e0f595add0f4450a863a11 | 326566258544554658511 | 297 | 60723381 | 2025-09-10T21:51:57.000Z | 0xecea20d973df6b855bceb63e2b68e0807ae3a849d32cd6aba9ed0193c223ca30 |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.thena_v3_bsc.GaugeV2_Harvest_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### ReferralRewards\_Claim\_event
Referral reward claim events from Thena V3 DEX (decentralized exchange) on BNB Smart Chain, recording token payouts to referrers with user address, token contract, and claim amount. Used to analyze referral program economics and reward distribution patterns across different tokens.
| 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. |
| in\_\_to | address | removed | in\_\_user | in\_\_token | log\_index | in\_\_amount | block\_number | block\_timestamp | transaction\_hash |
| ------------------------------------------ | ------------------------------------------ | ------- | ------------------------------------------ | ------------------------------------------ | ---------- | --------------------- | ------------- | ------------------------ | ------------------------------------------------------------------ |
| 0x637b935cba030aeb876eae07aa7ff637166de4d6 | 0x664ce330511653cb2744b8ed50dba31c6c4c08ca | false | 0x637b935cba030aeb876eae07aa7ff637166de4d6 | 0x8ac76a51cc950d9822d68b83fe1ad97b32cd580d | 212 | 143885934550075445860 | 26570619 | 2023-03-18T11:48:24.000Z | 0x0f26c236d9e0e35d7199de94beb65d1fab3e12b31475b58699485fd838e53fb9 |
| 0x06f9e5f8f5c170b9eece58676d932bcc398f52e5 | 0x664ce330511653cb2744b8ed50dba31c6c4c08ca | false | 0x06f9e5f8f5c170b9eece58676d932bcc398f52e5 | 0xbb4cdb9cbd36b01bd1cbaebf2de08d9173bc095c | 78 | 1187333175859420 | 27979504 | 2023-05-06T17:50:09.000Z | 0xb2fb1b69a5f93ea7e1cde275182851e90c94f162bbe636fd9cd52738166ad8cc |
| 0xf91328ec49725c8bcef2df037ee76ab0b1fc5cb5 | 0x664ce330511653cb2744b8ed50dba31c6c4c08ca | false | 0xf91328ec49725c8bcef2df037ee76ab0b1fc5cb5 | 0xfa4ba88cf97e282c505bea095297786c16070129 | 304 | 5740300564379301799 | 29469014 | 2023-06-27T13:44:57.000Z | 0x5a14afeeb824c4f2f25831aa76f3c37886d47352738506dde921b08160f0805a |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.thena_v3_bsc.ReferralRewards_Claim_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### Voter\_Vote\_event
Voting actions from Thena V3 decentralized exchange (DEX) on BNB Smart Chain, capturing when veNFT token holders cast votes using their tokenIds. Used for analyzing governance participation and vote-escrowed token (veToken) holder behavior in liquidity gauge voting.
| 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_voter` | `STRING` | Address of the account casting the vote or participating in governance. Hex-encoded, 0x-prefixed, 42-character string. |
| `in_tokenId` | `STRING` | Unique identifier for a non-fungible token within its contract. Numeric string representation of the token's ID. |
| `in_timestamp` | `STRING` | Unix timestamp when the event or operation occurred. Numeric string representation of seconds since epoch. |
| address | removed | in\_voter | log\_index | in\_tokenId | block\_number | in\_timestamp | block\_timestamp | transaction\_hash |
| ------------------------------------------ | ------- | ------------------------------------------ | ---------- | ----------- | ------------- | ------------- | ------------------------ | ------------------------------------------------------------------ |
| 0x8fbb1ecebb9e9839bc0de00b9c4c585cabdd0462 | false | 0x19f30627d73de2bbc3b993e8c070bf9d8f37e433 | 196 | 18357 | 52440294 | 1750896000 | 2025-07-01T00:00:05.000Z | 0x1ad2743a2babdd6584853a8cbaa972285b502f879ef134293f5319e5d4a3a5d1 |
| 0x8fbb1ecebb9e9839bc0de00b9c4c585cabdd0462 | false | 0x43949c0660ac8252575303e22849ca7211c8e824 | 187 | 11940 | 52440294 | 1750896000 | 2025-07-01T00:00:05.000Z | 0x1ad2743a2babdd6584853a8cbaa972285b502f879ef134293f5319e5d4a3a5d1 |
| 0x8fbb1ecebb9e9839bc0de00b9c4c585cabdd0462 | false | 0xb55e8288309789d5f3158600f1ae0d549508b7c4 | 171 | 20604 | 52440294 | 1750896000 | 2025-07-01T00:00:05.000Z | 0xe1569854adcafe3716be6942af6dab13d74354357543c3881a4472cd36bd9db9 |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.thena_v3_bsc.Voter_Vote_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### VoterV3\_GaugeCreated\_event
Gauge creation events from Thena V3 DEX (decentralized exchange) on BNB Smart Chain, recording when new liquidity pool gauges are deployed with associated internal and external bribe contracts. Used for tracking the expansion of Thena's vote-escrowed tokenomics system and analyzing incentive structures across pools.
| 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. |
| address | in\_pool | removed | in\_gauge | log\_index | in\_creator | block\_number | block\_timestamp | transaction\_hash | in\_external\_bribe | in\_internal\_bribe |
| ------------------------------------------ | ------------------------------------------ | ------- | ------------------------------------------ | ---------- | ------------------------------------------ | ------------- | ------------------------ | ------------------------------------------------------------------ | ------------------------------------------ | ------------------------------------------ |
| 0x3a1d0952809f4948d15ebce8d345962a282c4fcb | 0xf937145b516cff1ea501cf1210832a5b7ea42c3a | false | 0x9632caa7800427b582e66f0784a00e4156a430cd | 193 | 0x993ae2b514677c7ac52baecd8871d2b362a9d693 | 28089722 | 2023-05-10T13:49:06.000Z | 0x00baf462724a74bbd39b9da7780e173fb0effe2e8ff119829895c0b8870fb342 | 0x6343ef6495b6f6b9c624076f09d23e67b19c1976 | 0x8af4e70dd6d481f57c5776b82288f06d2b81f31a |
| 0x3a1d0952809f4948d15ebce8d345962a282c4fcb | 0xb33d77159ea381176ab1eb11475fd65912d83728 | false | 0x62c4527398f92f798f8d8bb5cdd176239761db95 | 66 | 0xb7ee483080b3b1a82e24b3c80d94c5c1f536fdb7 | 28093115 | 2023-05-10T16:38:47.000Z | 0x38a0137a52e41045802050750c4071061fd908d0b313561e0e1ea65c262ed080 | 0xe05205f4affce5c5b7b81241adc4b1e6fb1ec90b | 0xb454b8628ea2e701366ff97952122a7808cd3b9f |
| 0x3a1d0952809f4948d15ebce8d345962a282c4fcb | 0x1d6c1de20424831fd6f843f1d39bf96265b3899d | false | 0xab75b2d521e698794a85ec92cb34c771d8f48c5f | 43 | 0xb7ee483080b3b1a82e24b3c80d94c5c1f536fdb7 | 28093241 | 2023-05-10T16:45:05.000Z | 0x4cc3f4f840cd40b2ea83dc380f6455a9a3014b2c99a54dd2ed823425da5bd6bc | 0x39693783992446fa818ff8284df4eb1bf8c713d4 | 0xe3c19d7586d8c073831942233e8e62d85ea3cb2e |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.thena_v3_bsc.VoterV3_GaugeCreated_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### VotingIncentives\_RewardPaid\_event
Voting incentive reward distributions from Thena V3 DEX (Decentralized Exchange) on BNB Smart Chain, recording individual user reward claims with token addresses and amounts. Useful for analyzing voter incentive programs, reward token distributions, and governance participation patterns.
| 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_rewardsToken` | `STRING` | Contract address of the reward token being distributed. 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. |
| address | in\_user | removed | in\_reward | log\_index | block\_number | block\_timestamp | in\_rewardsToken | transaction\_hash |
| ------------------------------------------ | ------------------------------------------ | ------- | ---------------- | ---------- | ------------- | ------------------------ | ------------------------------------------ | ------------------------------------------------------------------ |
| 0x04e5cd31cda647cf897935e8704d2f933402b6fa | 0x9675fecd8b2ed8e7cae2880ef300a2122dcfffe7 | false | 4119456586965168 | 599 | 56245254 | 2025-08-03T00:46:12.000Z | 0xbb4cdb9cbd36b01bd1cbaebf2de08d9173bc095c | 0x7ce6435ed6d658f2bba5c98c868da2ca6dcc8d90c653613e5fd99486f609c2a1 |
| 0x04e5cd31cda647cf897935e8704d2f933402b6fa | 0x9675fecd8b2ed8e7cae2880ef300a2122dcfffe7 | false | 961042352475339 | 597 | 56245254 | 2025-08-03T00:46:12.000Z | 0x2170ed0880ac9a755fd29b2688956bd959f933f8 | 0x7ce6435ed6d658f2bba5c98c868da2ca6dcc8d90c653613e5fd99486f609c2a1 |
| 0xdc64daef04f95978f63ad3d8855c2b154cf14054 | 0xe9f6b6bb8ca582e0e5dcbb03e95b247843fdcf2f | false | 71755766130425 | 292 | 56245546 | 2025-08-03T00:49:51.000Z | 0xbb4cdb9cbd36b01bd1cbaebf2de08d9173bc095c | 0x4258b5431adf5ff3c419610e536e585750fa94210f54f47929ea7c74a41a6d27 |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.thena_v3_bsc.VotingIncentives_RewardPaid_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### VotingIncentivesFactory\_CreateVotingIncentives\_event
Factory deployment events for voting incentive contracts on Thena v3 DEX (BSC), linking gauge addresses to their corresponding incentive contract addresses. Used to track the creation of incentive mechanisms for liquidity pool governance voting.
| 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_votingIncentives` | `STRING` | Contract address of the voting incentives contract created by this factory event. Links to the specific incentive distribution contract associated with the gauge in the Thena v3 protocol on BSC. |
| address | removed | in\_gauge | log\_index | block\_number | block\_timestamp | transaction\_hash | in\_votingIncentives |
| ------------------------------------------ | ------- | ------------------------------------------ | ---------- | ------------- | ------------------------ | ------------------------------------------------------------------ | ------------------------------------------ |
| 0x82f144accf4779ca8c49928be28fac5fa157d218 | false | 0x4b8ee910bdc98f5b48ba13c7635ca3a69d064055 | 132 | 55661861 | 2025-07-28T23:13:00.000Z | 0x255d26ecbece5432350812c189c92170783a31d14b262f01b2a6e9586fa709ce | 0x2107d6efc387c502972d3136e397ce1fd6c2aed4 |
| 0x82f144accf4779ca8c49928be28fac5fa157d218 | false | 0xc3c8816b73b0f51c1fad934dfa633e7052a09ac6 | 352 | 54180242 | 2025-07-16T02:30:47.000Z | 0x26091729dee60b785f2a21e3098c5299ec7c31e3f42fdb791f26abd15e8e3134 | 0x6caf50a5f1132f496a2d1ef917a60408726eab82 |
| 0x82f144accf4779ca8c49928be28fac5fa157d218 | false | 0x3e3ef982a6662c7ab94e4d086a0ed8c652bdaa2c | 349 | 52828999 | 2025-07-04T08:59:12.000Z | 0x5fe2754fe2adaa93af2cfc00175dcbdfc3b6a0fb087225708970dd255d3a6190 | 0xe7fd074d0259aa0b790a6809f07c4ba976f5ae09 |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.thena_v3_bsc.VotingIncentivesFactory_CreateVotingIncentives_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***