uniswap_v4_ethereum

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
0xf704a91b641319b97542e3b1641ed3f528f34b51619fc21bca3d52b677b1f771	0	0x000000000004444c5dc75cb358380d2e3de08a90	-69348	false	0x0010d0d5db05933fa0d9f7038d365e1541a41888	67	21748025	0xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb48	0xcbb7c0000ab88b473b1f5afd9ef808440eed33bf	100	2025-02-01T00:15:35.000Z	2472261250699548632884516460	0x41a02e32796a792ca5efd00f7f35e72aec20cae14ee94d71b14376d453be6c65
0x6e05391c0a1eb70629c12602c3fc02d849a6b0e130eaf4fb59e48a94f8796332	0	0x000000000004444c5dc75cb358380d2e3de08a90	-276325	false	0x0010d0d5db05933fa0d9f7038d365e1541a41888	337	21748607	0x4c9edd5852cd905f086c759e8383e09bff1e68b3	0xdac17f958d2ee523a2206206994597c13d831ec7	10	2025-02-01T02:12:35.000Z	79228162514264337593543	0x5d292f810bc003d8c3caddcf63016313c2189468eba4b5b97a61f481d5de5c1c
0xc782dad2936f7dfc3907ecf2386ca7a64a40c9eba345253944913ac26efd0ec4	100	0x000000000004444c5dc75cb358380d2e3de08a90	-103095	false	0x0000000000000000000000000000000000000000	41	21751457	0x0000000000000000000000000000000000000000	0xc37ce82299df46ab7f5264d1729322006f024e3d	1	2025-02-01T11:45:47.000Z	457416713988505886859072388	0x590336c32a1bfa52650f2402bcda79f7f0d5f318a5558a9d275a36071042c4ef

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.uniswap_v4_ethereum.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
0x97e8d38e2c5b762f7aa047784fcbd0fb8602cf35bad3e8d90222b5f560be5288	0x000000000004444c5dc75cb358380d2e3de08a90	0x0000000000000000000000000000000000000000000000000000000000000545	false	0xbd216513d74c8cf14cf4747e6aaa6420ff64ee9e	56	21800488	-322380	-322370	2025-02-08T08:05:35.000Z	0x1e3c1913f153ca0bc55215332432b0d8781e6f1bba036b36b5c93e83374358be	64489013221530314448
0xae467e914d3826a42eba86eba04cf33b5d6752b39d0b8f33ca84fe27285054c7	0x000000000004444c5dc75cb358380d2e3de08a90	0x00000000000000000000000000000000000000000000000000000000000005fc	false	0xbd216513d74c8cf14cf4747e6aaa6420ff64ee9e	283	21800582	-308800	-308600	2025-02-08T08:24:23.000Z	0x8b1adf33aa170e3f415f4675303491292e64a36202a75f33434954b7835dd254	50468464109931900
0xae467e914d3826a42eba86eba04cf33b5d6752b39d0b8f33ca84fe27285054c7	0x000000000004444c5dc75cb358380d2e3de08a90	0x00000000000000000000000000000000000000000000000000000000000005fc	false	0xbd216513d74c8cf14cf4747e6aaa6420ff64ee9e	441	21800595	-308800	-308600	2025-02-08T08:26:59.000Z	0x18936ce42d1bd8ebba183e3037f026b4b75a7ab02590cf151381a08014f9c12b	454216176989387102

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.uniswap_v4_ethereum.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
0x000000000004444c5dc75cb358380d2e3de08a90	false	0x00001f3b9712708127b1fcad61cb892535951888	514	true	0xda3674b2fd41239c0a9b32bd3c8e18679342da36	21746615	2025-01-31T19:32:23.000Z	0x322e324ca00582027ca361c720757ab09b87a9f4b148c5a13b95fc85326c4537
0x000000000004444c5dc75cb358380d2e3de08a90	false	0x00001f3b9712708127b1fcad61cb892535951888	26	true	0x3c85fe92689cf534c28135248b36f314793f31fd	21746464	2025-01-31T19:01:47.000Z	0x916dcfdb9df0199cbc41a198f27c8fa842186d7ea4bb3274d45a7d67cda98c9b
0x000000000004444c5dc75cb358380d2e3de08a90	false	0x00001f3b9712708127b1fcad61cb892535951888	62	true	0x6ec42ab736c259827ff0b06acf3fd6afc4231676	21746803	2025-01-31T20:09:59.000Z	0x1e10796caacb143781f50fd4e2d31f750d3b097ef66632b66a60d29365f384ea

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.uniswap_v4_ethereum.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
0x000000000004444c5dc75cb358380d2e3de08a90	0x0000000000000000000000000000000000000000	false	349	0x1a9c8182c09f50c8318d769245bea52c32be35bc	21688329	2025-01-23T16:16:47.000Z	0x747e0e02b7590eed32cface28e83260884e0b80675f5ae223c6888053aa68528

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.uniswap_v4_ethereum.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
0x21c67e77068de97969ba93d4aab21826d33ca12bb9f565d8496e8fda8a82ca27	500	0x000000000004444c5dc75cb358380d2e3de08a90	-196346	false	0x000000000091b65cab49b4f796c2ab89fd4d0adc	542	940451752237581516	-2784842574	21760605	11005648782037372	2025-02-02T18:26:23.000Z	4320286311197699756513059	0x5402902c52e0eeebe723a4682dca1ff03bce653dda01aed818d02afa9df4eb7c
0x21c67e77068de97969ba93d4aab21826d33ca12bb9f565d8496e8fda8a82ca27	500	0x000000000004444c5dc75cb358380d2e3de08a90	-196785	false	0x000000000091b65cab49b4f796c2ab89fd4d0adc	419	-958604345138101760	2739113391	21761932	11185547924523032	2025-02-02T22:53:35.000Z	4226481528129315099533610	0xe9a5384cb50400003de3e5f4916664c2257721f1f47eb70a37ce5e68951944de
0x72331fcb696b0151904c03584b66dc8365bc63f8a144d89a773384e3a579ca73	500	0x000000000004444c5dc75cb358380d2e3de08a90	-195916	false	0x000000000091b65cab49b4f796c2ab89fd4d0adc	294	613993921407152076	-1902151593	21756424	14061442260018730	2025-02-02T04:23:35.000Z	4414069111731138498782132	0xde35d30b31d6f2d424dfb7699d38e54589ee9b2f5e8b0841f7205fab6069e2b6

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.uniswap_v4_ethereum.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
156535	false	1799	0xf3cd914c	0x000000000004444c5dc75cb358380d2e3de08a90	21932350	0x66a9893cc07d91d95644aedd05d03f95e1dba8af	1,0,1,1,2,0,0,1	2025-02-26T18:38:47.000Z	0x7c41978cd0e4887ee00eb74cf4ce63670936b8aea1442cce2ed09c1143309600
92938	false	90562	0xf3cd914c	0x000000000004444c5dc75cb358380d2e3de08a90	21930661	0x0d0e364aa7852291883c162b22d6d81f6355428f	1,3,0,0	2025-02-26T12:59:23.000Z	0x4aca52e847007434890d221b6d45db83c6e59a554dc84537f8792de0951727b5
113262	false	110440	0xf3cd914c	0x000000000004444c5dc75cb358380d2e3de08a90	21932578	0x0d0e364aa7852291883c162b22d6d81f6355428f	1,3,0,0	2025-02-26T19:24:35.000Z	0x9e5ee4c6ff971abc62a44b8a6bd0230095395241e6112bb3241da967fb910fb8

Example Query

Query with partition filter

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