uniswap_v4_avalanche

Tables

PoolManager_Initialize_event

Uniswap v4 pool initialization events emitted when new liquidity pools are created. Contains pool parameters including currency pair addresses, fee tier, tick spacing, initial price (sqrtPriceX96), and optional hooks contract address for customized pool behavior.

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_id`	`STRING`	Unique identifier for the position, record, or entity within the protocol. Numeric string representation.
`in_currency0`	`STRING`	Contract address of the first token in the pair. Hex-encoded, 0x-prefixed, 42-character string.
`in_currency1`	`STRING`	Contract address of the second token in the pair. Hex-encoded, 0x-prefixed, 42-character string.
`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_tickSpacing`	`INT64`	Minimum price movement increment between adjacent ticks in a concentrated liquidity pool.
`in_hooks`	`STRING`	Contract address of the hooks contract for the pool. Hex-encoded, 0x-prefixed, 42-character string where 0x0000000000000000000000000000000000000000 indicates no hooks are enabled.
`in_sqrtPriceX96`	`STRING`	Square root of the price ratio between token1 and token0 encoded as a Q64.96 fixed-point number. Numeric string representation used in concentrated liquidity automated market makers.
`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

in_id	in_fee	address	in_tick	removed	in_hooks	log_index	block_number	in_currency0	in_currency1	in_tickSpacing	block_timestamp	in_sqrtPriceX96	transaction_hash
0x645a719ace2c4caec69936e1b4bcb84ea42d92cde3c6f4bf5a0c935341704376	10000	0x06380c0e0912312b5150364b9dc4542ba0dbbc85	-276325	false	0x0000000000000000000000000000000000000000	30	56254201	0x0000000000000000000000000000000000000000	0xb97ef9ef8734c71904d8002f8b6bc66dd9c48a6e	200	2025-01-23T20:18:17.000Z	79224306130848112672356	0x89b42d76a9cf27e233387f035086c2eca23a89f57c2a8ae83c65d74ebab86317
0xe53360aef410555f2e2944b26f06aa1438dcd103882f5264cd488265eced2192	3000	0x06380c0e0912312b5150364b9dc4542ba0dbbc85	-322379	false	0x0000000000000000000000000000000000000000	22	56679220	0x0000000000000000000000000000000000000000	0x9702230a8ea53601f5cd2dc00fdbc13d4df4a8c7	60	2025-02-01T21:13:04.000Z	7922432358546634479092	0xda532be927a51db80e6de29548807186eba854bceb777364174cebaa84a30bbc
0x6874d3d2b99e6b75ed2fae390907e1d921d4b06b7f48fc6d3fe9c547507e369c	500	0x06380c0e0912312b5150364b9dc4542ba0dbbc85	-241059	false	0x0000000000000000000000000000000000000000	0	56575611	0x0000000000000000000000000000000000000000	0xb97ef9ef8734c71904d8002f8b6bc66dd9c48a6e	10	2025-01-30T15:34:55.000Z	461967706000283662496685	0xf60a94e849375e02abb2ed2ef75472bba9387a9c70293e761d3ea0e9deccbb54

Example Query

Query with partition filter

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

PoolManager_ModifyLiquidity_event

Uniswap V4 liquidity modification events emitted when positions are added or removed from concentrated liquidity pools. Contains pool identifier, sender address, tick range boundaries (tickLower, tickUpper), and signed liquidityDelta indicating the amount of liquidity added (positive) or removed (negative).

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_id`	`STRING`	Unique identifier for the position, record, or entity within the protocol. Numeric string representation.
`in_sender`	`STRING`	Address that initiated the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_tickLower`	`INT64`	Lower tick boundary of a concentrated liquidity position in a Uniswap V3-style pool. Signed integer representing a discrete price point on the logarithmic tick scale.
`in_tickUpper`	`INT64`	Upper tick boundary of a concentrated liquidity position in a Uniswap V3-style pool. Signed integer representing a discrete price point on the logarithmic tick scale.
`in_liquidityDelta`	`STRING`	Change in liquidity for a concentrated liquidity position. Numeric string representation of the signed delta value, where positive values indicate liquidity additions and negative values indicate liquidity removals.
`in_salt`	`STRING`	Cryptographic salt value used for deterministic address generation in contract deployment. 66-character hex string including 0x prefix.

Sample Data

in_id	address	in_salt	removed	in_sender	log_index	block_number	in_tickLower	in_tickUpper	block_timestamp	transaction_hash	in_liquidityDelta
0x645a719ace2c4caec69936e1b4bcb84ea42d92cde3c6f4bf5a0c935341704376	0x06380c0e0912312b5150364b9dc4542ba0dbbc85	0x0000000000000000000000000000000000000000000000000000000000000002	false	0xb74b1f14d2754acfcbbe1a221023a5cf50ab8acd	4	56254236	-887200	887200	2025-01-23T20:18:58.000Z	0x2cac935ea7890cfbc87c0f8039fef4b35f77fbb789bb881311188640a321f341	0
0x645a719ace2c4caec69936e1b4bcb84ea42d92cde3c6f4bf5a0c935341704376	0x06380c0e0912312b5150364b9dc4542ba0dbbc85	0x0000000000000000000000000000000000000000000000000000000000000002	false	0xb74b1f14d2754acfcbbe1a221023a5cf50ab8acd	33	56254201	-887200	887200	2025-01-23T20:18:17.000Z	0x89b42d76a9cf27e233387f035086c2eca23a89f57c2a8ae83c65d74ebab86317	1000048676770
0xd7a8035ddd9ec1dba25e3b27b685927fe63d65281f21c1c1d21d122fc48caeb7	0x06380c0e0912312b5150364b9dc4542ba0dbbc85	0x0000000000000000000000000000000000000000000000000000000000000003	false	0xb74b1f14d2754acfcbbe1a221023a5cf50ab8acd	13	56254599	-887270	887270	2025-01-23T20:26:23.000Z	0xebb619d00d76b6c1166d3aa25c0e415d13fbe8483682237ee6f07ae65b81e5fb	318816608462

Example Query

Query with partition filter

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

PoolManager_OperatorSet_event

Operator authorization events from Uniswap v4 PoolManager contracts recording permission grants or revocations. Contains owner address, authorized operator address, and approval status for tracking delegated pool management rights.

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_operator`	`STRING`	Address authorized to execute the operation on behalf of the token owner. Hex-encoded, 0x-prefixed, 42-character string.
`in_approved`	`BOOL`	Boolean flag indicating whether approval was granted or revoked for the operation.

Sample Data

No sample data available.

Example Query

Query with partition filter

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

PoolManager_OwnershipTransferred_event

Ownership transfer events emitted by Uniswap v4 PoolManager contracts, recording the previous owner address and newly assigned owner address. Used for tracking administrative control changes of liquidity pool management contracts across chains.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_user`	`STRING`	Address of the user account associated with the transaction or protocol operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_newOwner`	`STRING`	Address of the newly assigned owner in an ownership transfer event. Hex-encoded, 0x-prefixed, 42-character string.

Sample Data

address	in_user	removed	log_index	in_newOwner	block_number	block_timestamp	transaction_hash
0x06380c0e0912312b5150364b9dc4542ba0dbbc85	0x0000000000000000000000000000000000000000	false	8	0xeb0bcf27d1fb4b25e708fbb815c421aeb51ea9fc	56195376	2025-01-22T15:01:16.000Z	0x516b487077dc84b85aacbcd1ef809d4aa87c43c6116327bf8a5e2a1126c77e6b

Example Query

Query with partition filter

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

PoolManager_Swap_event

Token swap events emitted by Uniswap V4 PoolManager contracts. Contains sender address, token amounts, fee tier, liquidity depth, and post-swap pool state including tick position and sqrt price ratio (Q64.96 fixed-point).

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_id`	`STRING`	Unique identifier for the position, record, or entity within the protocol. Numeric string representation.
`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_sqrtPriceX96`	`STRING`	Square root of the price ratio between token1 and token0 encoded as a Q64.96 fixed-point number. Numeric string representation used in concentrated liquidity automated market makers.
`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_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_id	in_fee	address	in_tick	removed	in_sender	log_index	in_amount0	in_amount1	block_number	in_liquidity	block_timestamp	in_sqrtPriceX96	transaction_hash
0xcfbbf4e87c31b7bf70d882c81f195b16818a9f5f708aae5a0886bb275c0d814d	3000	0x06380c0e0912312b5150364b9dc4542ba0dbbc85	319608	false	0x0000000000a9c64e40fd5b83d6135ab3a14a801e	1	96098401	-7306030131704832065692	56596017	4436944675361730890	2025-01-31T02:11:14.000Z	689843786535540364485140945266959758	0x98f374577911ab9bbd678b23c8551b939159e4bf79b04ea32c6463cbc7dc809a
0xcfbbf4e87c31b7bf70d882c81f195b16818a9f5f708aae5a0886bb275c0d814d	3000	0x06380c0e0912312b5150364b9dc4542ba0dbbc85	319693	false	0x0000000000a9c64e40fd5b83d6135ab3a14a801e	1	141513611	-10849266816534315833826	56596243	4436944675361730890	2025-01-31T02:18:17.000Z	692769567583712428102651733035049681	0xdbd774d007e93d6d6680deb5bfabf4a074b8ff62d11cf2f9f775ee76c54cab8c
0xcfbbf4e87c31b7bf70d882c81f195b16818a9f5f708aae5a0886bb275c0d814d	3000	0x06380c0e0912312b5150364b9dc4542ba0dbbc85	319698	false	0x0000000000a9c64e40fd5b83d6135ab3a14a801e	1	137573320	-10552983481779327663388	56596246	4436944675361730890	2025-01-31T02:18:23.000Z	692957441283031405002167784423770651	0x83dda9242af6ba71476b6764ae676a5d4d74e4775b488736b754f1d4b0c6418b

Example Query

Query with partition filter

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

PoolManager_swap_function

Uniswap V4 PoolManager swap function call traces containing pool identification parameters, swap direction, amount specifications, and execution deltas. Records track token exchange operations through liquidity pools with hook integration support.

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.
`trace_address`	`STRING`	Hierarchical position of the internal call within a transaction’s execution trace. Comma-separated sequence of integers representing the call path, where each number indicates the index of the call at that nesting level, with null representing top-level calls.
`status`	`BOOL`	Transaction execution outcome indicator. Boolean value where true represents successful execution and false represents failed execution.
`from_address`	`STRING`	Address that initiated the transaction or contract call. Hex-encoded, 0x-prefixed, 42-character string.
`to_address`	`STRING`	Address receiving the transaction or contract call. Hex-encoded, 0x-prefixed, 42-character string.
`value`	`STRING`	Amount of native cryptocurrency sent with the transaction. Floating-point representation in whole units (e.g., ETH, BNB, MATIC).
`gas_used`	`INT64`	Amount of gas consumed by the transaction execution. Integer representing the actual computational steps used.
`gas`	`INT64`	Gas limit allocated for the transaction execution. Integer representing the maximum computational steps allowed.
`signature`	`STRING`	Function selector identifying which contract function was called. 10-character hex string including 0x prefix.
`in_key`	`STRUCT<currency0 STRING, currency1 STRING, fee STRING, tickSpacing INT64, hooks STRING>`	Unique identifier for a specific position, swap pool, or contract state. 66-character hex string including 0x prefix.
`in_params`	`STRUCT<zeroForOne BOOL, amountSpecified STRING, sqrtPriceLimitX96 STRING>`	Additional initialization parameters encoded as bytes. Hex-encoded string used for protocol-specific configuration data during contract initialization or cross-chain operations.
`in_hookData`	`STRING`	Additional arbitrary data passed to hook contracts for custom logic execution. Hex-encoded byte string with 0x prefix.
`out_swapDelta`	`STRING`	Net token amount change from the swap operation. Decimal string representing the combined delta of both tokens in the pool, encoded as a single integer value.

Sample Data

gas	in_key	status	gas_used	in_params	signature	to_address	in_hookData	block_number	from_address	out_swapDelta	trace_address	block_timestamp	transaction_hash
159193	{“fee”:“10000”,“hooks”:“0x0000000000000000000000000000000000000000”,“currency0”:“0x0000000000000000000000000000000000000000”,“currency1”:“0xc0c5aa69dbe4d6dddfbc89c0957686ec60f24389”,“tickSpacing”:200}	true	24722	{“zeroForOne”:true,“amountSpecified”:“-320587463509306111”,“sqrtPriceLimitX96”:“4295128740”}	0xf3cd914c	0x06380c0e0912312b5150364b9dc4542ba0dbbc85	0x	65678487	0x000000000097595ea2e7b4f2266dc4e67a0fa5e7	-109090260888126672519219672100749952822607861858879061942	4,0,0	2025-07-18T16:49:07.000Z	0xc75ab7390f956500ac813b2867b992450b0df376ca143d78ab1ea9b7fd720124
182681	{“fee”:“3000”,“hooks”:“0x0000000000000000000000000000000000000000”,“currency0”:“0x0000000000000000000000000000000000000000”,“currency1”:“0x9702230a8ea53601f5cd2dc00fdbc13d4df4a8c7”,“tickSpacing”:60}	true	24764	{“zeroForOne”:false,“amountSpecified”:“-65370335”,“sqrtPriceLimitX96”:“1461446703485210103287273052203988822378723970341”}	0xf3cd914c	0x06380c0e0912312b5150364b9dc4542ba0dbbc85	0x	65686589	0x000000000097595ea2e7b4f2266dc4e67a0fa5e7	955490372346792584102880419557549223312201477161739781921	7,0,0	2025-07-18T20:23:45.000Z	0x4f8a7dff3a9f3c2d9543462f3f0234e8c5e6e7f094f5d16572ce243bc8666cd4
138128	{“fee”:“500”,“hooks”:“0x0000000000000000000000000000000000000000”,“currency0”:“0x0000000000000000000000000000000000000000”,“currency1”:“0xb97ef9ef8734c71904d8002f8b6bc66dd9c48a6e”,“tickSpacing”:10}	true	24828	{“zeroForOne”:false,“amountSpecified”:“-226196741”,“sqrtPriceLimitX96”:“1461446703485210103287273052203988822378723970341”}	0xf3cd914c	0x06380c0e0912312b5150364b9dc4542ba0dbbc85	0x	65677355	0x000000000097595ea2e7b4f2266dc4e67a0fa5e7	3243641910505828573542025685551271134266130974879345050363	4,0,0	2025-07-18T16:13:35.000Z	0xac10d6788d0ed21da45f31befb7c49ba48d346aa329ae3bbf977c81088cbd226

Example Query

Query with partition filter

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

Metrics

Primitives

Contracts

Blockchain

Tables

PoolManager_Initialize_event

PoolManager_ModifyLiquidity_event

PoolManager_OperatorSet_event

PoolManager_OwnershipTransferred_event

PoolManager_Swap_event

PoolManager_swap_function

Metrics

Primitives

Contracts

Blockchain

​Tables

​PoolManager_Initialize_event

​PoolManager_ModifyLiquidity_event

​PoolManager_OperatorSet_event

​PoolManager_OwnershipTransferred_event

​PoolManager_Swap_event

​PoolManager_swap_function

Tables

PoolManager_Initialize_event

PoolManager_ModifyLiquidity_event

PoolManager_OperatorSet_event

PoolManager_OwnershipTransferred_event

PoolManager_Swap_event

PoolManager_swap_function