> ## 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.
# blackhole_v3_avalanche
> Tables in tt-contracts.blackhole_v3_avalanche
## Tables
### AlgebraFactory\_CustomPool\_event
Custom liquidity pool creation events from the Algebra decentralized exchange (DEX) protocol on Avalanche. Tracks factory-deployed pools with token pair addresses and deployer information for analyzing DEX market structure and liquidity provisioning.
| 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 |
| ------------------------------------------ | ------------------------------------------ | ------- | ------------------------------------------ | ------------------------------------------ | ---------- | ------------------------------------------ | ------------- | ------------------------ | ------------------------------------------------------------------ |
| 0x512eb749541b7cf294be882d636218c84a5e9e5f | 0x8fef4fe4970a5d6bfa7c65871a2ebfd0f42aa822 | false | 0x152b9d0fdc40c096757f570a51e494bd4b943e50 | 0xb31f66aa3c1e785363f0875a1b74e27b85fd66c7 | 1 | 0x5d433a94a4a2aa8f9aa34d8d15692dc2e9960584 | 65564520 | 2025-07-16T17:44:51.000Z | 0x31e28af132ef637d992a3d3e5734e0adb4eb578e9506c247fa44bde00a6e849f |
| 0x512eb749541b7cf294be882d636218c84a5e9e5f | 0x5e128ebc09c918ddae3ca1668d4ee9527dc00d78 | false | 0x49d5c2bdffac6ce2bfdb6640f4f80f226bc10bab | 0xb31f66aa3c1e785363f0875a1b74e27b85fd66c7 | 11 | 0x5d433a94a4a2aa8f9aa34d8d15692dc2e9960584 | 65564287 | 2025-07-16T17:39:38.000Z | 0xb040ceafdf8c1ca96e3bb0857e50de64291e8d440895b0b8b80106da742ce71e |
| 0x512eb749541b7cf294be882d636218c84a5e9e5f | 0x5bfad13ba95cc71569dfd868f2e10fb5ea3a57ce | false | 0x67ea3abd5cee0b99d743155051c191b09135f93c | 0xb97ef9ef8734c71904d8002f8b6bc66dd9c48a6e | 0 | 0xdcfccf2e8c4efbba9127b80eac76c5a122125d29 | 65539588 | 2025-07-16T08:16:15.000Z | 0xa07a627e3df9def1002b44295aa6d483ea4ae675f9fe368e6cbdbe16d8e7e2d3 |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.blackhole_v3_avalanche.AlgebraFactory_CustomPool_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 |
| ------------------------------------------ | ------- | ------------------------------------------ | ---------- | ---------------------- | ----------- | ----------- | ------------- | -------------- | ------------------------ | ------------------------------------------------------------------ | ------------------- |
| 0xcfafbf365fe78ffa2ab7af8b4341e2218188f91f | false | 0x3fed017ec0f5517cdf2e8a9a4156c64d74252146 | 65 | 1457474591679215050542 | 5154735531 | -280200 | 67472904 | -281400 | 2025-08-22T15:29:08.000Z | 0x17664dd23da247a9c0e36689305509acea9e3ea1fc0e79b28ec04a46feb5365b | 127876205335983275 |
| 0xcfafbf365fe78ffa2ab7af8b4341e2218188f91f | false | 0x3fed017ec0f5517cdf2e8a9a4156c64d74252146 | 171 | 0 | 1976916276 | -281000 | 67470519 | -281400 | 2025-08-22T14:18:03.000Z | 0x28dbbeee3bb3f6d237326b7b836104d41cb0273444da1871fda31735f4e4ad43 | 126138564612479926 |
| 0xcfafbf365fe78ffa2ab7af8b4341e2218188f91f | false | 0x3fed017ec0f5517cdf2e8a9a4156c64d74252146 | 71 | 2476441614817970826868 | 0 | -281000 | 67466835 | -281200 | 2025-08-22T12:41:33.000Z | 0x94b07d83df362ef67e62c1862f3500dfc1749350b22e01161e6b5d4d82c5f6ee | 195049227585475469 |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.blackhole_v3_avalanche.AlgebraPool_Burn_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### AlgebraPool\_BurnFee\_event
Fee burning events from Algebra Protocol concentrated liquidity pools on Avalanche. Records plugin fee amounts collected and burned by liquidity position owners for analyzing fee mechanics and pool revenue distribution.
| 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_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 | block\_number | in\_pluginFee | block\_timestamp | transaction\_hash |
| ------------------------------------------ | ------- | ------------------------------------------ | ---------- | ------------- | ------------- | ------------------------ | ------------------------------------------------------------------ |
| 0x000d436a430cf25c4eaaa3eff031d2cefdfaf4b1 | false | 0x3fed017ec0f5517cdf2e8a9a4156c64d74252146 | 0 | 67282289 | 0 | 2025-08-18T23:19:14.000Z | 0xf026aca001d6cc6fa0e06343d00f34af7bcc715f2037a77e61896e13e255fa28 |
| 0x000d436a430cf25c4eaaa3eff031d2cefdfaf4b1 | false | 0x3fed017ec0f5517cdf2e8a9a4156c64d74252146 | 1 | 67234247 | 0 | 2025-08-18T01:49:27.000Z | 0xdc39cae54009f7d792906d8ddcde58375be4d6599ed174c1e29d899328fd5794 |
| 0x000d436a430cf25c4eaaa3eff031d2cefdfaf4b1 | false | 0x3fed017ec0f5517cdf2e8a9a4156c64d74252146 | 1 | 67232869 | 0 | 2025-08-18T01:11:02.000Z | 0x828f4529d19d00f8e44fc9bb884ac654710bc9b08947c7b110a6c25a99852746 |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.blackhole_v3_avalanche.AlgebraPool_BurnFee_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 |
| ------------------------------------------ | ------- | ------------------------------------------ | ---------- | ----------------- | ----------- | ----------- | ------------- | ------------------------------------------ | -------------- | ------------------------ | ------------------------------------------------------------------ |
| 0x859592a4a469610e573f96ef87a0e5565f9a94c8 | false | 0x3fed017ec0f5517cdf2e8a9a4156c64d74252146 | 65 | 49009725 | 49008810 | 887272 | 66922461 | 0x9d42b28854d0da4766bf6b63391738f26ef5d2e1 | -887272 | 2025-08-11T18:53:18.000Z | 0xa9193aa792091cd2aad1463bf5ded24c69baed3e7fd03676aa6a13054d3232e1 |
| 0xcfafbf365fe78ffa2ab7af8b4341e2218188f91f | false | 0x3fed017ec0f5517cdf2e8a9a4156c64d74252146 | 13 | 80485599215184457 | 216408 | -278200 | 66901667 | 0xe3b8b0f6716e10b4b13c54ff8aae08a0b02a0ea8 | -280200 | 2025-08-11T09:01:21.000Z | 0x63da865838053321c4f6bdee54f067e2aec64bf2ef7e3127950483147f578b15 |
| 0xcfafbf365fe78ffa2ab7af8b4341e2218188f91f | false | 0x3fed017ec0f5517cdf2e8a9a4156c64d74252146 | 22 | 88676264980 | 6154849265 | -278800 | 66896112 | 0x22b16e3f18f0a99c184baae92b6d3536c0e323f0 | -280000 | 2025-08-11T06:21:46.000Z | 0xfe368d1edaeb9f22365ec5c480d374f5a97ff4b25dbf2c50bd75df01944d151a |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.blackhole_v3_avalanche.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_communityFeeNew` | `STRING` | The new community fee rate for the Algebra pool, expressed in basis points (e.g., '1000' represents 10%). Values toggle between '0' (no fee) and '1000' (fee active) when community fee settings change. |
| address | removed | log\_index | block\_number | block\_timestamp | transaction\_hash | in\_communityFeeNew |
| ------------------------------------------ | ------- | ---------- | ------------- | ------------------------ | ------------------------------------------------------------------ | ------------------- |
| 0x7e919db48453d44f39c25af9bf64edc8318db19f | false | 8 | 65875323 | 2025-07-22T05:10:02.000Z | 0xe480cb1cdd0dc46f98c7fe4bea87b3243398d1421839d7094de277b84bec1f0d | 1000 |
| 0x9a6142ef0766915db02066f791d969c22eba1dca | false | 6 | 65879137 | 2025-07-22T06:50:07.000Z | 0x339a06358752e719f063989332158114b90a04f2d9903dca107e8f3648250157 | 0 |
| 0x9a6142ef0766915db02066f791d969c22eba1dca | false | 2 | 65879228 | 2025-07-22T06:52:27.000Z | 0xdb0b70da8d8258dda1bc46dd386a6ae333f3d92afc396b629472165a1ce84888 | 1000 |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.blackhole_v3_avalanche.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 |
| ------- | ------------------------------------------ | ------- | ---------- | ------------- | ------------------------ | ------------------------------------------------------------------ |
| 1000 | 0x1abe428146795bc754170af24cfd78663f257d29 | false | 46 | 66401815 | 2025-08-01T15:07:02.000Z | 0xaa3e4f70719ca2b3c2fc78869b80953abd2183002ce978bcfcf102aeca2c7441 |
| 600 | 0x5e128ebc09c918ddae3ca1668d4ee9527dc00d78 | false | 42 | 66401815 | 2025-08-01T15:07:02.000Z | 0xaa3e4f70719ca2b3c2fc78869b80953abd2183002ce978bcfcf102aeca2c7441 |
| 7000 | 0xa38d178a08dd88ec1517d4585929052631fcd1b8 | false | 45 | 66401815 | 2025-08-01T15:07:02.000Z | 0xaa3e4f70719ca2b3c2fc78869b80953abd2183002ce978bcfcf102aeca2c7441 |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.blackhole_v3_avalanche.AlgebraPool_Fee_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### AlgebraPool\_Flash\_event
Flash loan events from Algebra DEX pools on Avalanche, capturing borrowed amounts, repaid fees, and participant addresses. Used for analyzing flash loan arbitrage activity and fee generation across liquidity 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_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 |
| ------------------------------------------ | ------- | ---------------- | --------- | ------------------------------------------ | ---------- | -------------------- | ----------- | ------------- | ------------------------------------------ | ------------------------ | ------------------------------------------------------------------ |
| 0xee2ceda742bfb2ef566ab57642d47aba1909b653 | false | 4488127566087945 | 0 | 0x32ae1b9e46185f222438396e2ec769c44c06053e | 21 | 44881275660879446857 | 0 | 68941434 | 0x32ae1b9e46185f222438396e2ec769c44c06053e | 2025-09-18T20:05:55.000Z | 0xa807cf3c7f9f4487a3bdd0f2e70a75f194830bbe1ce1a562549f9f04f918bc93 |
| 0x859592a4a469610e573f96ef87a0e5565f9a94c8 | false | 385732 | 0 | 0xa6b9572156147e1ee9f3ccd3d1ad0b8b0c3d064b | 46 | 3857311816 | 0 | 73984829 | 0xa6b9572156147e1ee9f3ccd3d1ad0b8b0c3d064b | 2025-12-18T17:18:04.000Z | 0xc4c6d73f081f561e7cb28adb8d3529ce5f74825d1734d8df53d15f0024daaa75 |
| 0x859592a4a469610e573f96ef87a0e5565f9a94c8 | false | 0 | 290717 | 0xa6b9572156147e1ee9f3ccd3d1ad0b8b0c3d064b | 74 | 0 | 2907166485 | 73984829 | 0xa6b9572156147e1ee9f3ccd3d1ad0b8b0c3d064b | 2025-12-18T17:18:04.000Z | 0xc4c6d73f081f561e7cb28adb8d3529ce5f74825d1734d8df53d15f0024daaa75 |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.blackhole_v3_avalanche.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 |
| ------------------------------------------ | ------- | ------------------------------------------ | ------------------------------------------ | ---------- | --------------------- | ---------------------- | ----------- | ------------- | -------------- | ------------------------ | ------------------------------------------------------------------ | ---------------------- |
| 0x859592a4a469610e573f96ef87a0e5565f9a94c8 | false | 0x3fed017ec0f5517cdf2e8a9a4156c64d74252146 | 0x3fed017ec0f5517cdf2e8a9a4156c64d74252146 | 123 | 288736680 | 288759000 | 887272 | 66949262 | -887272 | 2025-08-12T08:26:07.000Z | 0x6a29c55d4369eb419280bb3e9ff6d73531bb91b7f8dd27cc1e21f53b46947110 | 288747839 |
| 0x9a6142ef0766915db02066f791d969c22eba1dca | false | 0x3fed017ec0f5517cdf2e8a9a4156c64d74252146 | 0x3fed017ec0f5517cdf2e8a9a4156c64d74252146 | 95 | 238993937923298283579 | 9024270000000000000000 | 887200 | 66936745 | -887200 | 2025-08-12T01:50:38.000Z | 0x911a62d304fe2cef85f0eb916cb32c0543e43a48bba89db72d006aca96685b06 | 1468586335284065961027 |
| 0xcfafbf365fe78ffa2ab7af8b4341e2218188f91f | false | 0x3fed017ec0f5517cdf2e8a9a4156c64d74252146 | 0x3fed017ec0f5517cdf2e8a9a4156c64d74252146 | 76 | 250122054379618031307 | 159068000 | -278400 | 66958337 | -279600 | 2025-08-12T12:50:49.000Z | 0xd173250c27a0bf1b3e62889f71830c9fab9a5b99a0c6400f96624cd05adbd9fe | 6777461081401791 |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.blackhole_v3_avalanche.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 |
| ------------------------------------------ | -------- | ------- | ------------------------------------ | ------------------------------------------ | ---------- | ----------- | ----------------------- | ------------- | -------------------- | ------------------------------------------ | ------------------------ | ------------------------------------------------------------------ |
| 0xa38d178a08dd88ec1517d4585929052631fcd1b8 | 281052 | false | 100359837162944981457337205581537072 | 0xabfc48e8bed7b26762745f3139555f320119709d | 39 | 5000000000 | -7968333585227210932381 | 66964521 | 31209872374470203925 | 0xd6e91f5f7dbe58abeb3082b08049c5139e38d4c6 | 2025-08-12T15:51:57.000Z | 0x09aceceee008dcb878c247af4368ae7003d0c8c904329d2ba29f03aa1d3b6848 |
| 0xa38d178a08dd88ec1517d4585929052631fcd1b8 | 281056 | false | 100377196052124809375508640747232607 | 0xabfc48e8bed7b26762745f3139555f320119709d | 66 | -291699829 | 471506370912268205441 | 66964009 | 15561727358474151608 | 0x2c9c3050b242df683c5db26a0c5874c938e06b8f | 2025-08-12T15:38:07.000Z | 0xe3099423a5f761f9778cb9de95019e48f90863f590ce785b6b92b7c1d8ceca77 |
| 0xa38d178a08dd88ec1517d4585929052631fcd1b8 | 281056 | false | 100377726181674078689367825306380669 | 0xabfc48e8bed7b26762745f3139555f320119709d | 58 | -64870461 | 104860272582063763955 | 66964011 | 15561727358474151608 | 0x40dc0fa2553e8a97e56f39d595b2753eacfe91f1 | 2025-08-12T15:38:11.000Z | 0xfb6194af7f55054f1267322ae6c4152536499690f96b66b92206d823dd884bf5 |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.blackhole_v3_avalanche.AlgebraPool_Swap_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### AlgebraPool\_SwapFee\_event
Fee configuration change events from Algebra DEX liquidity pools on Avalanche. Tracks plugin fee and override fee adjustments made by authorized senders, useful for monitoring fee structure changes 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_sender` | `STRING` | Address that initiated the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string. |
| `in_overrideFee` | `STRING` | Fee override value applied to the swap transaction, specified in basis points or zero if no override was set. Typically zero in standard pool operations, indicating the default fee structure was used. |
| `in_pluginFee` | `STRING` | Fee charged by the plugin module on the liquidity pool operation. Numeric string representation in smallest denomination. |
| address | removed | in\_sender | log\_index | block\_number | in\_pluginFee | in\_overrideFee | block\_timestamp | transaction\_hash |
| ------------------------------------------ | ------- | ------------------------------------------ | ---------- | ------------- | ------------- | --------------- | ------------------------ | ------------------------------------------------------------------ |
| 0x9a6142ef0766915db02066f791d969c22eba1dca | false | 0x078727f46765704f0c6789610bb8dd45cf34f321 | 16 | 67142816 | 0 | 0 | 2025-08-16T04:31:11.000Z | 0x48c8b6179bb7af4447112d930386c22cf893a6c9afd9044274571bb94fa522cb |
| 0x41100c6d2c6920b10d12cd8d59c8a9aa2ef56fc7 | false | 0x1380f2f57553ada04b31ee7b1e039e496939db3d | 37 | 67133887 | 0 | 0 | 2025-08-16T00:00:19.000Z | 0x7799bd402dd782f01f08f063d6944bc5d1ad3aacd72df26ace7ddd9b1ef7b983 |
| 0x41100c6d2c6920b10d12cd8d59c8a9aa2ef56fc7 | false | 0x1380f2f57553ada04b31ee7b1e039e496939db3d | 63 | 67133894 | 0 | 0 | 2025-08-16T00:00:28.000Z | 0xf511284ae85f79e5e72cdeab049f5aa5c59e5649b7305da43ead8d39f6b72edc |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.blackhole_v3_avalanche.AlgebraPool_SwapFee_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***