uniswap_v4_unichain

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	block_number	in_currency0	in_currency1	in_tickSpacing	block_timestamp	in_sqrtPriceX96	transaction_hash
0xdda80b253206bdeb302e12ce9ce4499da6f64b88ce6c0462231c29c1c216e348	10000	0x1f98400000000000000000000000000000000004	57298	false	0x0000000000000000000000000000000000000000	9504697	0x0000000000000000000000000000000000000000	0x8f187aa05619a017077f5308904739877ce9ea21	200	2025-02-22T19:37:36.000Z	1390041090869571302952290302029	0x576b6a8c84b41933598eeb60cd14b15c539308a68405ed0c45fb2981d71930e0
0x89abfb3f59795a58373711f757c1dbdf597f44d474cf823d6e523be83575449b	3000	0x1f98400000000000000000000000000000000004	188270	false	0x0000000000000000000000000000000000000000	9511719	0x0000000000000000000000000000000000000000	0xea29e6e01d8fbb2e53a3056acda65ec24690087d	60	2025-02-22T21:34:38.000Z	970300580509419469652885692953063	0x18ae4b0d92eb3901ac88b48774b25f36fa2d8beaa8c2d3119cd8d27e156fdd0d
0x837dada2f2535a8a262f3214c9877c9c91ed5c4c816b04f1a5f4ac6ee1b40fe3	3000	0x1f98400000000000000000000000000000000004	6931	false	0x0000000000000000000000000000000000000000	9493606	0x5a53b6d19d8edcb7923f0d840eebb3f09bbeefb7	0x8f187aa05619a017077f5308904739877ce9ea21	60	2025-02-22T16:32:45.000Z	112040957517951813098925484553	0x81b9bca856c8a83c3b29cbc15d63a2472d048eb680cafdd57b719bd7fc3d8b37

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.uniswap_v4_unichain.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
0x25939956ef14a098d95051d86c75890cfd623a9eeba055e46d8dd9135980b37c	0x1f98400000000000000000000000000000000004	0x00000000000000000000000000000000000000000000000000000000000025ea	false	0x4529a01c7a0410167c5740c487a8de60232617bf	0	10151394	-887220	-276300	2025-03-02T07:15:53.000Z	0xddb72fbe5a39ef6dc7ce6eb37f6c981748d0b766cc6972b4a91d80be75743180	-187274898620
0x9bdd72519ad7e2b5f0d5441d7af389771cc04a8406cd577fac0c68a8b6b396bd	0x1f98400000000000000000000000000000000004	0x0000000000000000000000000000000000000000000000000000000000004baf	false	0x4529a01c7a0410167c5740c487a8de60232617bf	2	10196947	-276325	-269393	2025-03-02T19:55:06.000Z	0x5b0d3ebdd3f26a4ed5aac4032ba838a41d66f2aadbeb4b22cd3ed56ba5cbee55	24142562264
0x157eb602201b74835a3d91fb36d5d376a56174a1207d919331b5243d998c7fbf	0x1f98400000000000000000000000000000000004	0x0000000000000000000000000000000000000000000000000000000000004a1f	false	0x4529a01c7a0410167c5740c487a8de60232617bf	2	10136546	-266820	-265680	2025-03-02T03:08:25.000Z	0xd8ca0286808e43716d86cdedb3c9a70f9213009a6ee60e2e40dd8d3e7e8ee783	29028984310

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.uniswap_v4_unichain.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

address	removed	in_owner	log_index	in_approved	in_operator	block_number	block_timestamp	transaction_hash
0x1f98400000000000000000000000000000000004	false	0x0000fe59823933ac763611a69c88f91d45f81888	9	true	0xa8b403c81397b2978acc985c0633a383b7f0e7fc	12664063	2025-03-31T09:13:42.000Z	0xa8e494aec7c5a51eaa94208f45088e37906899c5d6062569e079cbd306cb9fb8
0x1f98400000000000000000000000000000000004	false	0x0000fe59823933ac763611a69c88f91d45f81888	1	true	0x000000dceb71f3107909b1b748424349bfde5493	11682835	2025-03-20T00:39:54.000Z	0xb68586b4898757e49e013b7b8d3d0cf4a993d83a15d341c52f4d4dfd63ea4c3d
0x1f98400000000000000000000000000000000004	false	0x0000fe59823933ac763611a69c88f91d45f81888	9	true	0xdceee1e3f02fda02e8e2fac00d2dd9e14f971d78	14337448	2025-04-19T18:03:27.000Z	0xd75974ae2524f2b148f41a08feb9ae6e6614dd9d075060a799f98424bbb05ee7

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.uniswap_v4_unichain.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

No sample data available.

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.uniswap_v4_unichain.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	address	removed	in_sender	log_index	block_number	block_timestamp	in_sqrtPriceX96	transaction_hash
0x38eeae8c6d1c205eff7c18ca631c9c65afa357e83fa130ec215aff81741d2408	0x1f98400000000000000000000000000000000004	false	0x820fc695923511c8bac28c96628bb5abfd6009a0	10	12081036	2025-03-24T15:16:35.000Z	79228162514264337593543950336	0x791a5992d73e6a0a584cc7a40015eaee9ae368417db953c1b722c989769d232d
0x38eeae8c6d1c205eff7c18ca631c9c65afa357e83fa130ec215aff81741d2408	0x1f98400000000000000000000000000000000004	false	0x606e5fbf6adbe1ca60c2748570b8ac2b6792eb2c	10	12050505	2025-03-24T06:47:44.000Z	79228162514264337593543950336	0xdd350a33e073875e5afb03ceb0e97a2c98d88d4dc3e14c0edf79253e838703c6
0x38eeae8c6d1c205eff7c18ca631c9c65afa357e83fa130ec215aff81741d2408	0x1f98400000000000000000000000000000000004	false	0x606e5fbf6adbe1ca60c2748570b8ac2b6792eb2c	20	12065934	2025-03-24T11:04:53.000Z	79228162514264337593543950336	0x9462787c59f835f0b60eb82e16a4d694cb34892ce7a319e806c977e358c6d416

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.uniswap_v4_unichain.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`	`FLOAT64`	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
23442	{“fee”:“29”,“hooks”:“0x0000000000000000000000000000000000000000”,“currency0”:“0x078d782b760474a361dda0af3839290b0ef57ad6”,“currency1”:“0x9151434b16b9763660705744891fa906f660ecc5”,“tickSpacing”:1}	false	23442	{“zeroForOne”:true,“amountSpecified”:“-2891344398”,“sqrtPriceLimitX96”:“79176683515024282907106804044”}	0xf3cd914c	0x1f98400000000000000000000000000000000004	0x	19171075	0x6e4141d33021b52c91c28608403db4a0ffb50ec6		1,11,1,0,0,0	2025-06-14T16:43:54.000Z	0x4ce12e3e4d41f5af9902642da4ccf3a9262e9da72ef168480e0a83356ac26a77
28156	{“fee”:“100”,“hooks”:“0x0000000000000000000000000000000000000000”,“currency0”:“0x078d782b760474a361dda0af3839290b0ef57ad6”,“currency1”:“0x9151434b16b9763660705744891fa906f660ecc5”,“tickSpacing”:1}	false	27896	{“zeroForOne”:true,“amountSpecified”:“-58554276”,“sqrtPriceLimitX96”:“4295128740”}	0xf3cd914c	0x1f98400000000000000000000000000000000004	0x	19183912	0xef740bf23acae26f6492b10de645d6b98dc8eaf3	-19924987630621900968650352654951407021562469038	1,0,1	2025-06-14T20:17:51.000Z	0xe593016fdeb6c9edb40ed2ad7cafac56eca6299ab69da36793b0d52d9b2f0baa
28306	{“fee”:“100”,“hooks”:“0x0000000000000000000000000000000000000000”,“currency0”:“0x078d782b760474a361dda0af3839290b0ef57ad6”,“currency1”:“0x9151434b16b9763660705744891fa906f660ecc5”,“tickSpacing”:1}	false	27896	{“zeroForOne”:true,“amountSpecified”:“-91208663”,“sqrtPriceLimitX96”:“4295128740”}	0xf3cd914c	0x1f98400000000000000000000000000000000004	0x	19163566	0xef740bf23acae26f6492b10de645d6b98dc8eaf3	-31036699729334223957768747412001442292711894469	1,0,1	2025-06-14T14:38:45.000Z	0x44fe964fb4bc07c1f04f6b82878bb56d5c8f1dc1f889ac742153e4d8f4ea458c

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.uniswap_v4_unichain.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