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.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_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.

Sample Data

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

Example Query

Query with partition filter

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.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_owner`	`STRING`	Address that owns or controls the shares or position being deposited or withdrawn. Hex-encoded, 0x-prefixed, 42-character string.
`in_bottomTick`	`INT64`	Lower bound of the tick range for a concentrated liquidity position. Signed integer value representing the price interval boundary in Uniswap V3-style concentrated liquidity pools.
`in_topTick`	`INT64`	Upper bound of the tick range for a concentrated liquidity position. Signed integer value representing the price interval boundary in Uniswap V3-style concentrated liquidity pools.
`in_liquidityAmount`	`STRING`	Amount of liquidity added to or removed from a concentrated liquidity position. Numeric string representation of liquidity units in the position’s tick range.
`in_amount0`	`STRING`	Amount of token0 involved in the liquidity pool operation. Numeric string representation of token quantity in smallest denomination.
`in_amount1`	`STRING`	Amount of token1 involved in the liquidity pool operation. Numeric string representation of token quantity in smallest denomination.

Sample Data

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

Example Query

Query with partition filter

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.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_owner`	`STRING`	Address that owns or controls the shares or position being deposited or withdrawn. Hex-encoded, 0x-prefixed, 42-character string.
`in_pluginFee`	`STRING`	Fee charged by the plugin module on the liquidity pool operation. Numeric string representation in smallest denomination.

Sample Data

address	removed	in_owner	log_index	block_number	block_timestamp	transaction_hash
0x000d436a430cf25c4eaaa3eff031d2cefdfaf4b1	false	0x3fed017ec0f5517cdf2e8a9a4156c64d74252146	0	67282289	2025-08-18T23:19:14.000Z	0xf026aca001d6cc6fa0e06343d00f34af7bcc715f2037a77e61896e13e255fa28
0x000d436a430cf25c4eaaa3eff031d2cefdfaf4b1	false	0x3fed017ec0f5517cdf2e8a9a4156c64d74252146	1	67234247	2025-08-18T01:49:27.000Z	0xdc39cae54009f7d792906d8ddcde58375be4d6599ed174c1e29d899328fd5794
0x000d436a430cf25c4eaaa3eff031d2cefdfaf4b1	false	0x3fed017ec0f5517cdf2e8a9a4156c64d74252146	1	67232869	2025-08-18T01:11:02.000Z	0x828f4529d19d00f8e44fc9bb884ac654710bc9b08947c7b110a6c25a99852746

Example Query

Query with partition filter

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.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_owner`	`STRING`	Address that owns or controls the shares or position being deposited or withdrawn. Hex-encoded, 0x-prefixed, 42-character string.
`in_recipient`	`STRING`	Address designated to receive the output tokens from a swap or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_bottomTick`	`INT64`	Lower bound of the tick range for a concentrated liquidity position. Signed integer value representing the price interval boundary in Uniswap V3-style concentrated liquidity pools.
`in_topTick`	`INT64`	Upper bound of the tick range for a concentrated liquidity position. Signed integer value representing the price interval boundary in Uniswap V3-style concentrated liquidity pools.
`in_amount0`	`STRING`	Amount of token0 involved in the liquidity pool operation. Numeric string representation of token quantity in smallest denomination.
`in_amount1`	`STRING`	Amount of token1 involved in the liquidity pool operation. Numeric string representation of token quantity in smallest denomination.

Sample Data

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

Example Query

Query with partition filter

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.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_communityFeeNew`	`STRING`	The 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.

Sample Data

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

Example Query

Query with partition filter

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.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_fee`	`STRING`	Fee amount charged for the transaction or operation. String-encoded integer value representing the fee in the smallest unit of the relevant token or currency.

Sample Data

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

Example Query

Query with partition filter

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.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_sender`	`STRING`	Address that initiated the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_recipient`	`STRING`	Address designated to receive the output tokens from a swap or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_amount0`	`STRING`	Amount of token0 involved in the liquidity pool operation. Numeric string representation of token quantity in smallest denomination.
`in_amount1`	`STRING`	Amount of token1 involved in the liquidity pool operation. Numeric string representation of token quantity in smallest denomination.
`in_paid0`	`STRING`	Amount of token0 paid as flash loan fee. Numeric string representation of token quantity in smallest denomination.
`in_paid1`	`STRING`	Amount of token1 paid as flash loan fee. Numeric string representation of token quantity in smallest denomination.

Sample Data

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

Example Query

Query with partition filter

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.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_sender`	`STRING`	Address that initiated the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_owner`	`STRING`	Address that owns or controls the shares or position being deposited or withdrawn. Hex-encoded, 0x-prefixed, 42-character string.
`in_bottomTick`	`INT64`	Lower bound of the tick range for a concentrated liquidity position. Signed integer value representing the price interval boundary in Uniswap V3-style concentrated liquidity pools.
`in_topTick`	`INT64`	Upper bound of the tick range for a concentrated liquidity position. Signed integer value representing the price interval boundary in Uniswap V3-style concentrated liquidity pools.
`in_liquidityAmount`	`STRING`	Amount of liquidity added to or removed from a concentrated liquidity position. Numeric string representation of liquidity units in the position’s tick range.
`in_amount0`	`STRING`	Amount of token0 involved in the liquidity pool operation. Numeric string representation of token quantity in smallest denomination.
`in_amount1`	`STRING`	Amount of token1 involved in the liquidity pool operation. Numeric string representation of token quantity in smallest denomination.

Sample Data

address	removed	in_owner	in_sender	log_index	in_amount0	in_amount1	in_topTick	block_number	in_bottomTick	block_timestamp	transaction_hash	in_liquidityAmount
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

Example Query

Query with partition filter

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.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_sender`	`STRING`	Address that initiated the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_recipient`	`STRING`	Address designated to receive the output tokens from a swap or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_amount0`	`STRING`	Amount of token0 involved in the liquidity pool operation. Numeric string representation of token quantity in smallest denomination.
`in_amount1`	`STRING`	Amount of token1 involved in the liquidity pool operation. Numeric string representation of token quantity in smallest denomination.
`in_price`	`STRING`	Price of the asset or position in the transaction or event. Numeric string representation in smallest denomination or with extended precision.
`in_liquidity`	`STRING`	Total liquidity available in the pool at the time of the event. Numeric string representation of liquidity in smallest denomination.
`in_tick`	`INT64`	Current tick index of the concentrated liquidity pool after the swap or operation. Integer value representing the price point on the pool’s tick spacing grid.

Sample Data

address	in_tick	removed	in_price	in_sender	log_index	in_amount0	in_amount1	block_number	in_liquidity	in_recipient	block_timestamp	transaction_hash
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

Example Query

Query with partition filter

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.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_sender`	`STRING`	Address that initiated the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_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.

Sample Data

address	removed	in_sender	log_index	block_number	block_timestamp	transaction_hash
0x9a6142ef0766915db02066f791d969c22eba1dca	false	0x078727f46765704f0c6789610bb8dd45cf34f321	16	67142816	2025-08-16T04:31:11.000Z	0x48c8b6179bb7af4447112d930386c22cf893a6c9afd9044274571bb94fa522cb
0x41100c6d2c6920b10d12cd8d59c8a9aa2ef56fc7	false	0x1380f2f57553ada04b31ee7b1e039e496939db3d	37	67133887	2025-08-16T00:00:19.000Z	0x7799bd402dd782f01f08f063d6944bc5d1ad3aacd72df26ace7ddd9b1ef7b983
0x41100c6d2c6920b10d12cd8d59c8a9aa2ef56fc7	false	0x1380f2f57553ada04b31ee7b1e039e496939db3d	63	67133894	2025-08-16T00:00:28.000Z	0xf511284ae85f79e5e72cdeab049f5aa5c59e5649b7305da43ead8d39f6b72edc

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.blackhole_v3_avalanche.AlgebraPool_SwapFee_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

Metrics

Primitives

Contracts

Blockchain

Tables

AlgebraFactory_CustomPool_event

AlgebraPool_Burn_event

AlgebraPool_BurnFee_event

AlgebraPool_Collect_event

AlgebraPool_CommunityFee_event

AlgebraPool_Fee_event

AlgebraPool_Flash_event

AlgebraPool_Mint_event

AlgebraPool_Swap_event

AlgebraPool_SwapFee_event

Metrics

Primitives

Contracts

Blockchain

​Tables

​AlgebraFactory_CustomPool_event

​AlgebraPool_Burn_event

​AlgebraPool_BurnFee_event

​AlgebraPool_Collect_event

​AlgebraPool_CommunityFee_event

​AlgebraPool_Fee_event

​AlgebraPool_Flash_event

​AlgebraPool_Mint_event

​AlgebraPool_Swap_event

​AlgebraPool_SwapFee_event

Tables

AlgebraFactory_CustomPool_event

AlgebraPool_Burn_event

AlgebraPool_BurnFee_event

AlgebraPool_Collect_event

AlgebraPool_CommunityFee_event

AlgebraPool_Fee_event

AlgebraPool_Flash_event

AlgebraPool_Mint_event

AlgebraPool_Swap_event

AlgebraPool_SwapFee_event