uniswap_v4_base

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	address	in_tick	removed	in_hooks	log_index	block_number	in_currency0	in_currency1	in_tickSpacing	block_timestamp	in_sqrtPriceX96	transaction_hash
0x7af84d60777413f90cc511a83cf702b128bc885f84d6ca8be4b60063328d907a	0x498581ff718922c3f8e6a244956af099b2652b2b	0	false	0x9e433f32bb5481a9ca7dff5b3af74a7ed041a888	306	25352561	0x0000000000000000000000000000000000000000	0x000000000d564d5be76f7f0d28fe52605afc7cf8	60	2025-01-21T21:21:09.000Z	79228162514264337593543950336	0x4553d64b518439bdda2d2f1eafb7d4dd5b76efef6769320f0672b93e488f81a8
0x037fdf1d5fff3a80e2bbc6855ce5a3741c09e10d0adc5b32bcbd19a5bd25763a	0x498581ff718922c3f8e6a244956af099b2652b2b	0	false	0x0010d0d5db05933fa0d9f7038d365e1541a41888	278	25789326	0xcbb7c0000ab88b473b1f5afd9ef808440eed33bf	0xecac9c5f704e954931349da37f60e39f515c11c1	10	2025-01-31T23:59:59.000Z	79228162514264337593543950336	0x3c35254df392851fe8d4eda7859ef7aa0f3e384d9ef8d013bd9fab65f24ca05d
0xd78079fa746613d4154355b89a654e97270535291d779ae3faac0a2b4a9a4dc9	0x498581ff718922c3f8e6a244956af099b2652b2b	231191	false	0x51bba15255406cfe7099a42183302640ba7dafdc	306	25789317	0x000000000d564d5be76f7f0d28fe52605afc7cf8	0x1ab6ca98f8f81069eed31c91a03f2d7f4328f742	60	2025-01-31T23:59:41.000Z	8296318058019332222734459715067637	0x74622474c0c249c59cdfcedd9aa27ed8cf200b26a6cf263c07e8946856f422f4

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.uniswap_v4_base.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
0x74b1eb0eb9068ed54b6b9d55673f7de8fac3299ce7e3df916e0172676d225a1a	0x498581ff718922c3f8e6a244956af099b2652b2b	0x0000000000000000000000000000000000000000000000000000000000000022	false	0x7c5f5a4bbd8fd63184577525326123b519429bdc	366	25569764	-600	600	2025-01-26T22:01:15.000Z	0x0297e602ac3d3023de0e1929bcfa0853cb4eea5cf8b89946a0324b9e71fd8155	3383749980973837142785
0x7c3b3d614ab8ce19805078038fac4b0429037eccc4915c6844ffe1fd879acb0b	0x498581ff718922c3f8e6a244956af099b2652b2b	0x0000000000000000000000000000000000000000000000000000000000000bc8	false	0x7c5f5a4bbd8fd63184577525326123b519429bdc	356	25907869	-887272	887272	2025-02-03T17:51:25.000Z	0x80367799ef2e747eece61e8f8a2abd67a15c82afdfbe0624cd65deb8c76c0d83	8
0xaf94f2bb73352582e00dbdf6d8f914d93ad3d81183716f5533cbdcbafcce1454	0x498581ff718922c3f8e6a244956af099b2652b2b	0x0000000000000000000000000000000000000000000000000000000000000bc1	false	0x7c5f5a4bbd8fd63184577525326123b519429bdc	348	25907741	-887272	887272	2025-02-03T17:47:09.000Z	0x896cdd1d4033ea3d21b797f30e8f44f362cd1e06c923132cfec2014c3d55b12c	9

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.uniswap_v4_base.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
0x498581ff718922c3f8e6a244956af099b2652b2b	false	0x0010d0d5db05933fa0d9f7038d365e1541a41888	541	true	0x000000dceb71f3107909b1b748424349bfde5493	25786940	2025-01-31T22:40:27.000Z	0x0ea858a582f9715149cf34c4a7abaf1fd47045f633478dc9589254b625544dcb
0x498581ff718922c3f8e6a244956af099b2652b2b	false	0x00001f3b9712708127b1fcad61cb892535951888	641	true	0x00000059923c01c79958099f9e488cdd4708a6c0	25721388	2025-01-30T10:15:23.000Z	0xfbdbb2bd65c00a554b6724348099fb7a192c89e57e423316d41b6f0e12825b63
0x498581ff718922c3f8e6a244956af099b2652b2b	false	0x00036f339ec3e61a21287b7cb5ea554d2da61888	307	true	0x000000000feca5b8afe8e464c9353d433cfa85a5	25672596	2025-01-29T07:08:59.000Z	0x6e238f0effdd9de760af5a5b6e9f3847a96b7757be3421927e944014665bc889

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.uniswap_v4_base.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
0x498581ff718922c3f8e6a244956af099b2652b2b	0x0000000000000000000000000000000000000000	false	355	0x31fafd4889fa1269f7a13a66ee0fb458f27d72a9	25350988	2025-01-21T20:28:43.000Z	0x25f482fbd94cdea11b018732e455b8e9a940b933cabde3c0c5dd63ea65e85349

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.uniswap_v4_base.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
0x34eb2ba72bebe070fd9d0144b4d547378d67fb9751ac1146e87a4994d70a6d62	3000	0x498581ff718922c3f8e6a244956af099b2652b2b	226633	false	0x0000000000e6a41ae0e9b9369378dedc44b46022	96	-379680011944	2632279560823297816180	26063497	100000000000000000000	2025-02-07T08:19:01.000Z	6605726644762669773130225304545228	0x5eff68c735de836d1d6707591e6abd46959df3f781f3065819da5bc99e8e19a6
0x179492f1f9c7b2e2518a01eda215baab8adf0b02dd3a90fe68059c0cac5686f5	3000	0x498581ff718922c3f8e6a244956af099b2652b2b	-68717	false	0x0000000000e6a41ae0e9b9369378dedc44b46022	84	15210140	-15815	26085457	1004753535	2025-02-07T20:31:01.000Z	2551486857092896079358174853	0x5f8fa47e0ff5dac3bb0db99d83ab64f0812e6c4bd8931ed81bb4d0bd6f54c75e
0x179492f1f9c7b2e2518a01eda215baab8adf0b02dd3a90fe68059c0cac5686f5	3000	0x498581ff718922c3f8e6a244956af099b2652b2b	-68702	false	0x0000000000e6a41ae0e9b9369378dedc44b46022	230	13806978	-14379	26085673	1004753535	2025-02-07T20:38:13.000Z	2553437609634851938660254027	0x1b564ceaaebedb273abe90b2eb31b940dfd4b5f80d7802dc59b73f4aad0598d3

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.uniswap_v4_base.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	status	gas_used	signature	to_address	block_number	from_address	trace_address	block_timestamp	transaction_hash
331811	false	1799	0xf3cd914c	0x498581ff718922c3f8e6a244956af099b2652b2b	31489734	0xcc0a6b5343eac7b48153dd660c0644d8d927c684	2,0,0	2025-06-12T22:53:35.000Z	0x6075f3f15ebc0e75db8d22f54a7da88308476c08dd384575371e5244872994a3
331870	false	1799	0xf3cd914c	0x498581ff718922c3f8e6a244956af099b2652b2b	31474217	0xcc0a6b5343eac7b48153dd660c0644d8d927c684	2,0,0	2025-06-12T14:16:21.000Z	0x7bcbd293251a37b3bd296785f56fdee10435846b64c7474051146308b3f9f28f
331800	false	1799	0xf3cd914c	0x498581ff718922c3f8e6a244956af099b2652b2b	31476285	0xb7b8f759e8bd293b91632100f53a45859832f463	2,0,0	2025-06-12T15:25:17.000Z	0x90441818a4a09078e8fd3dd1d112bf6edfb79124bb54b36199840f42742a337e

Example Query

Query with partition filter

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