uniswap_v4_polygon

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
0x445f1cfba9c94c997949bccfcdf5803c5dd52ceebf7b6b91be4a35554c34dc03	100	0x67366782805870060151383f4bbff9dab53e5cd6	-207244	false	0x0000000000000000000000000000000000000000	52	77315288	0x1ac39bb75fcd79f642ebf4dbe70aaa70f010f957	0x3c499c542cef5e3811e1192ce70d8cc03d5c3359	1	2025-10-06T03:37:59.000Z	2505291706254206075074035	0x86e2cf55aeab3ee84899070e1421f83d03eb4b16e3b42eb531d30da828489432
0x7b61627e41a435b668b2ca1ed4922c558d751e74d769c71e6a8202bce3b7a92a	100	0x67366782805870060151383f4bbff9dab53e5cd6	-187295	false	0x0000000000000000000000000000000000000000	48	77337169	0x78c616e20cf36bf52d976e6cda9aab72230d591f	0x8349314651ede274f8c5fef01aa65ff8da75e57c	1	2025-10-06T16:33:20.000Z	6792406575685900654391310	0x852201f3dcb706beab625804d94f8c9472ef467f4ed06bf0d793353e456f8c83
0xc19b875c36a8896521c48d093d5593a7f368170e3c9f90ac5c7a76352be23cd0	100	0x67366782805870060151383f4bbff9dab53e5cd6	115135	false	0x0000000000000000000000000000000000000000	397	77329965	0x3c499c542cef5e3811e1192ce70d8cc03d5c3359	0x9258b9423f45358b6cccd4021beab9b8d8e8bb5f	1	2025-10-06T12:17:47.000Z	25054131037751093162929900172930	0x0ca97aa16e141fe1fd8a678e4ba7c4b111bed8b918a2391219093b54edbd545f

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.uniswap_v4_polygon.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
0x1b67b409a82d0929b846066db3bac169348be2d7a90d0ca154412270f1b89608	0x67366782805870060151383f4bbff9dab53e5cd6	0x0000000000000000000000000000000000000000000000000000000000009334	false	0x1ec2ebf4f37e7363fdfe3551602425af0b3ceef9	840	75161440	-887272	-10987	2025-08-13T16:44:16.000Z	0x60706f4c6b313e6231e3bf04bb7dab9c4f575c456ca105d6441e271cedad0b39	5477409050632300
0xba0c112426423431867d2803c6df4e894ef5875a985e99e85eb5c9dad82ba9af	0x67366782805870060151383f4bbff9dab53e5cd6	0x00000000000000000000000000000000000000000000000000000000000092d4	false	0x1ec2ebf4f37e7363fdfe3551602425af0b3ceef9	563	75146840	-887272	887272	2025-08-13T08:06:51.000Z	0x4c0a71548f41048577f9528652d3f6e1fc54dc38f950a44cc5a42c0b30084265	86772170
0xa37d3e6da98dfeb7dc8103a6614f586916a6e04d41ea0a929bc19a029de1a399	0x67366782805870060151383f4bbff9dab53e5cd6	0x0000000000000000000000000000000000000000000000000000000000009353	false	0x1ec2ebf4f37e7363fdfe3551602425af0b3ceef9	234	75164063	-887272	887272	2025-08-13T18:17:08.000Z	0xae37272e1e1049bc9c15019efe89d937de962149765a5f69502942dbdfe40662	584961819

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.uniswap_v4_polygon.PoolManager_ModifyLiquidity_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
0x67366782805870060151383f4bbff9dab53e5cd6	0x0000000000000000000000000000000000000000	false	209	0x8a1b966ac46f42275860f905dbc75efbfdc12374	66980384	2025-01-21T20:40:11.000Z	0xe8dc102ac89f959786f4e8bf3d1b58c35749eb1434c83e5a9f0924ba3b092b01

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.uniswap_v4_polygon.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
0xdb26d6f2af41f431d447f292d9d96950f3d3a86cdfc321673301d029412502a1	500	0x67366782805870060151383f4bbff9dab53e5cd6	200354	false	0x00000000000ba9cd9f5175108141a82b6c24d727	1	-103085144	51749753691098839	69382770	12526467657790530	2025-03-23T01:24:38.000Z	1775432884012324034761716528224018	0xc185e1c8814242de87412078246e7580f906046b557aa4b6aba0fad15f81d178
0x71aa4532365075474994cbf9638f0239895d8ed9fdcbb4cb31abe7dffaa8f021	3000	0x67366782805870060151383f4bbff9dab53e5cd6	23936	false	0x00000000000ba9cd9f5175108141a82b6c24d727	31	61725660137890808	-677989335443235676	69408417	1444991002493268255691	2025-03-23T16:34:54.000Z	262202252648960111461662346348	0x7bc4822aca6490c7d696f7f3a28d83374b11adfb026db5b47267c3dfa30d89ae
0xe4300c2d5861190bc83d212e05359b617071d3afdb3cc0726920eb39cbd1ba85	500	0x67366782805870060151383f4bbff9dab53e5cd6	200310	false	0x00000000000ba9cd9f5175108141a82b6c24d727	4	-149099802	74521704965802760	69404881	17216797167293939	2025-03-23T14:29:31.000Z	1771532039099459544597677577809499	0x98d846b7e4a41470bc724e2fe883eda3a72401df4e4c65449f88d6ca0a97549b

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.uniswap_v4_polygon.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`	`NUMERIC`	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
1156711	false	1799	0xf3cd914c	0x67366782805870060151383f4bbff9dab53e5cd6	78416625	0xe39e7ed13b7748a9171a89fafc72a2173cafe43f	5,1,1,0,0,2,0,0,0	2025-10-31T19:14:50.000Z	0x04bd9e613e21d9822b26a46196267b2bbec7a530c233c403365ce771deb3cc8d
1182554	false	1799	0xf3cd914c	0x67366782805870060151383f4bbff9dab53e5cd6	78417326	0xe39e7ed13b7748a9171a89fafc72a2173cafe43f	3,1,1,0,0,2,0,0,0	2025-10-31T19:38:12.000Z	0x0a3c98e625e9ce5fa5813dd9cf70f58eccf434476d6f5387d2384eb35e447273
1156056	false	1799	0xf3cd914c	0x67366782805870060151383f4bbff9dab53e5cd6	78417216	0xe39e7ed13b7748a9171a89fafc72a2173cafe43f	5,1,1,0,0,2,0,0,0	2025-10-31T19:34:32.000Z	0x289d43b82cd1aa23fecf0a5bd774743663a39bb91ff6bd7bd94e19aeda6fa38c

Example Query

Query with partition filter

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

PoolManager_Swap_event

PoolManager_swap_function

Metrics

Primitives

Contracts

Blockchain

​Tables

​PoolManager_Initialize_event

​PoolManager_ModifyLiquidity_event

​PoolManager_OwnershipTransferred_event

​PoolManager_Swap_event

​PoolManager_swap_function

Tables

PoolManager_Initialize_event

PoolManager_ModifyLiquidity_event

PoolManager_OwnershipTransferred_event

PoolManager_Swap_event

PoolManager_swap_function