blackhole_v2_avalanche

Tables

Pair_Burn_event

Liquidity removal events from DEX (Decentralized Exchange) trading pairs recording amounts of both tokens withdrawn when liquidity providers burn LP tokens. Used for tracking liquidity provision activity and calculating total value locked (TVL) changes in automated market maker (AMM) 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_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_to`	`STRING`	Destination address receiving tokens or assets in the operation. Hex-encoded, 0x-prefixed, 42-character string.

Sample Data

in_to	address	removed	in_sender	log_index	in_amount0	in_amount1	block_number	block_timestamp	transaction_hash
0xa8a8a16761a6ae2c451c69d2ec735841f950a29b	0x4f905251040d1b31cd7eff74ef0c91bbf08022c0	false	0x04e1dee021cd12bba022a72806441b43d8212fec	47	74793757751258949431241254	352730462295066084152	68152611	2025-09-04T02:27:59.000Z	0xd96e7247e57bdbe7bf1e1fff5ae9738da8759a7d9d9302125f02d0b43699ae9a
0x2fe09e93acbb8b0da86c394335b8a92d3f5e273e	0x612a0664a2c2b6d0b8e85c291181d9cff0b5dc60	false	0x04e1dee021cd12bba022a72806441b43d8212fec	19	202755244572818949839103370	93636369468052673030808	68151113	2025-09-04T01:47:26.000Z	0xb60d9ee972759dc71a8d391f0a0eb43523e8300384f389e3bf43acf18af2c2c6
0x6dc358b652e9f465ee6118fbe20ab089732145e7	0x15c79629b9e2508726385b013dd5f550db0d49d9	false	0x04e1dee021cd12bba022a72806441b43d8212fec	6	1895877967923982484	32981825350076190465	68177919	2025-09-04T14:09:58.000Z	0xea05884bbff64aa27b81c5e7dac77b98d198ecdde75706418c0b583bbc2340cc

Example Query

Query with partition filter

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

Pair_Mint_event

Liquidity provision events emitted when users add tokens to a DEX pair contract. Records sender address and token amounts deposited for liquidity pool 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_sender`	`STRING`	Address that initiated the transaction 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.

Sample Data

address	removed	in_sender	log_index	in_amount0	in_amount1	block_number	block_timestamp	transaction_hash
0x03eb46b34129a77ac7a115e87da19ae91d66019c	false	0x04e1dee021cd12bba022a72806441b43d8212fec	4	225630000000000000000	29425472	67271385	2025-08-18T18:26:29.000Z	0xeb641cda2a57fa2f43982ae97e943c267b11cee53b6c4619615a18a07029e8f7
0x03eb46b34129a77ac7a115e87da19ae91d66019c	false	0x04e1dee021cd12bba022a72806441b43d8212fec	7	245223021481481481481	32567884	67257914	2025-08-18T12:28:29.000Z	0xfa325a29c8c506458c69746438175a1dce4f94738b9e9d57133b909b76ab77f5
0x03eb46b34129a77ac7a115e87da19ae91d66019c	false	0x04e1dee021cd12bba022a72806441b43d8212fec	9	594360000000000000000	82522765	67249128	2025-08-18T08:38:19.000Z	0x3149ea407177dd1efb26632cc5b0edd12caa44fd6151b896a46d54c0a399f138

Example Query

Query with partition filter

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

Pair_Swap_event

Token swap events from decentralized exchange (DEX) liquidity pairs recording input and output amounts for both tokens. Primary source for tracking DEX trading activity and price discovery.

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_amount0In`	`STRING`	Amount of token0 transferred into the liquidity pool during a swap operation. Stored as decimal string representing the smallest unit of the token.
`in_amount1In`	`STRING`	Amount of token1 transferred into the liquidity pool during a swap operation. Stored as decimal string representing the smallest unit of the token.
`in_amount0Out`	`STRING`	Amount of token0 transferred out of the liquidity pool during a swap operation. Stored as decimal string representing the smallest unit of the token.
`in_amount1Out`	`STRING`	Amount of token1 transferred out of the liquidity pool during a swap operation. Stored as decimal string representing the smallest unit of the token.
`in_to`	`STRING`	Destination address receiving tokens or assets in the operation. Hex-encoded, 0x-prefixed, 42-character string.

Sample Data

in_to	address	removed	in_sender	log_index	block_number	in_amount1In	in_amount0Out	block_timestamp	transaction_hash
0x0095c242a2866ffb7bf8aa3f51e386aca2de892b	0x03eb46b34129a77ac7a115e87da19ae91d66019c	false	0x123577a1560004d4432dc5e31f97363d0cd8a651	38	67913251	3208106	25473653994797026896	2025-08-31T02:11:00.000Z	0xb675403dbd9e0d7e4e8c39214fd93722901e12796fcd7927a5c9fe11dee7d80b
0x0095c242a2866ffb7bf8aa3f51e386aca2de892b	0x03eb46b34129a77ac7a115e87da19ae91d66019c	false	0x123577a1560004d4432dc5e31f97363d0cd8a651	59	67917422	2766153	21917969755098094043	2025-08-31T04:12:06.000Z	0xd31476ed43968b029005b6312c2ceeadd24d4620bceef81aa6474300723619eb
0x0095c242a2866ffb7bf8aa3f51e386aca2de892b	0x03eb46b34129a77ac7a115e87da19ae91d66019c	false	0x123577a1560004d4432dc5e31f97363d0cd8a651	56	67921700	2757241	21820821318833832725	2025-08-31T06:13:37.000Z	0x29f4fb3bf63110d5290e0ce5fc9ce785994f3e1543900a3fff824debcd790842

Example Query

Query with partition filter

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

Pair_Sync_event

Liquidity pair reserve synchronization events emitted after each swap, mint, or burn operation. Contains updated reserve balances for both tokens in AMM (Automated Market Maker) pools, enabling real-time price calculation 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_reserve0`	`STRING`	Reserve amount of the first token in a liquidity pool after a state-changing operation. Stored as decimal string representing the smallest unit of the token.
`in_reserve1`	`STRING`	Reserve amount of the second token in a liquidity pool after a state-changing operation. Stored as decimal string representing the smallest unit of the token.

Sample Data

address	removed	log_index	in_reserve0	in_reserve1	block_number	block_timestamp	transaction_hash
0x04a954bc8af9a1fdc2ce5f3192bdca369a4512cc	false	3	29229925208355439973	2712987271219576677643	65454182	2025-07-14T21:08:01.000Z	0xa4a4f6d53bf040f6e1bdc5f8ea02a37ba14d6dad6583d7b0252e247903fd7248
0x04a954bc8af9a1fdc2ce5f3192bdca369a4512cc	false	4	29226227736673596251	2689466679508016460110	65432324	2025-07-14T11:14:03.000Z	0x7eb3ec216889e09953e8b3491bb6c3dea503a7324d52fa86f71bc83ead3791e2
0x04a954bc8af9a1fdc2ce5f3192bdca369a4512cc	false	4	29226227839559890731	2689466670040176056681	65432382	2025-07-14T11:15:48.000Z	0x3ea9bd5c0a4ab92a74a7aeed313aed7901dd6bb65927d751af4329e51cc3f11e

Example Query

Query with partition filter

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

Pair_Transfer_event

ERC20 Transfer events emitted by liquidity pair contracts in automated market maker (AMM) decentralized exchanges (DEXs). Records minting, burning, and transfer of LP (liquidity provider) tokens representing ownership shares in trading pairs.

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_from`	`STRING`	Address originating the transfer or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_to`	`STRING`	Destination address receiving tokens or assets in the operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_amount`	`STRING`	Input amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination.

Sample Data

in_to	address	in_from	removed	in_amount	log_index	block_number	block_timestamp	transaction_hash
0xb126d152bb7c5e1d2f0536b2fd12d95fa52bf43c	0x03eb46b34129a77ac7a115e87da19ae91d66019c	0x5fdab5c59529a7fd091ecca3dc74a91abc358eec	false	101466306322690	69	67721744	2025-08-27T11:02:05.000Z	0xf5b05a9476449449b1d063a1ee156dfd5668aeaa5ee05eb1e5bc54f0cc4c7c4f
0x5fdab5c59529a7fd091ecca3dc74a91abc358eec	0x03eb46b34129a77ac7a115e87da19ae91d66019c	0x0000000000000000000000000000000000000000	false	101466306322690	64	67721744	2025-08-27T11:02:05.000Z	0xf5b05a9476449449b1d063a1ee156dfd5668aeaa5ee05eb1e5bc54f0cc4c7c4f
0xb126d152bb7c5e1d2f0536b2fd12d95fa52bf43c	0x03eb46b34129a77ac7a115e87da19ae91d66019c	0x5fdab5c59529a7fd091ecca3dc74a91abc358eec	false	128072162383169	88	67708329	2025-08-27T04:38:47.000Z	0x6981604008feaf2ac68e3bf544f1bfb73819b76e1fd38efc9a6bb4fd935bb99b

Example Query

Query with partition filter

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

PairGenerator_PairCreated_event

Liquidity pool creation events from Blackhole v2 DEX on Avalanche, capturing new trading pair deployments with token addresses and stability flag. Used to track DEX pair launches and identify available trading pairs across standard and stable swap 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_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_stable`	`BOOL`	Boolean flag indicating whether the liquidity pool uses a stable swap curve designed for assets with similar values.
`in_pair`	`STRING`	Contract address of the liquidity pool pair created for trading between two tokens. Hex-encoded, 0x-prefixed, 42-character string.

Sample Data

address	in_pair	removed	in_stable	in_token0	in_token1	log_index	block_number	block_timestamp	transaction_hash
0x34098b39ec2e2c1a8f815bb8fa840d0d389afe1c	0x78f5a53731564894a7e4fff827a88e5fbf9cfcb6	false	false	0x02d159a0c393b3a982c4acb3d03816a42d94f1ab	0xb31f66aa3c1e785363f0875a1b74e27b85fd66c7	2	66761991	2025-08-08T16:00:06.000Z	0xca8e2ff87927bb460f623a11801e329fc59367c3a292c228cd17b1df8760430d
0x34098b39ec2e2c1a8f815bb8fa840d0d389afe1c	0x921ca54e1d32008c25b352bb75aa00593288f1b3	false	false	0x49d5c2bdffac6ce2bfdb6640f4f80f226bc10bab	0x5c09a9ce08c4b332ef1cc5f7cadb1158c32767ce	22	65214859	2025-07-10T04:29:31.000Z	0x444391c35ff9185b0b2bfc7a1da0fcdfca367db0a56802f9b617ab047465e12b
0x34098b39ec2e2c1a8f815bb8fa840d0d389afe1c	0xfb1fa67315e484717ff3cb653edc7d608f6f7b2f	false	false	0x2b2c81e08f1af8835a78bb2a90ae924ace0ea4be	0x8729438eb15e2c8b576fcc6aecda6a148776c0f5	0	65217668	2025-07-10T05:54:39.000Z	0x1339d05a1710ea4d64c644c26199eb36bee32a3d51a699123ced3cadebd13f36

Example Query

Query with partition filter

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

Metrics

Primitives

Contracts

Blockchain

Tables

Pair_Burn_event

Pair_Mint_event

Pair_Swap_event

Pair_Sync_event

Pair_Transfer_event

PairGenerator_PairCreated_event

Metrics

Primitives

Contracts

Blockchain

​Tables

​Pair_Burn_event

​Pair_Mint_event

​Pair_Swap_event

​Pair_Sync_event

​Pair_Transfer_event

​PairGenerator_PairCreated_event

Tables

Pair_Burn_event

Pair_Mint_event

Pair_Swap_event

Pair_Sync_event

Pair_Transfer_event

PairGenerator_PairCreated_event