uniswap_v4_optimism

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
0x5b9c4f4050eeaa4885e15a8d2ddce8a628706445f347be5ff9107aecc9bb4582	3000	0x9a13f98cb987694c9f086b1f5eb990eea8264ec3	-322379	false	0xf8c3f4243c4d8c02831a718a7978fd869f094300	9	131675733	0x4200000000000000000000000000000000000042	0x68f180fcce6836688e9084f035309e29bf0a2095	60	2025-02-07T17:44:03.000Z	7922432358546634479092	0x37510ac2f4738819af06548974ae1ae6363be2cc30d315f08de6c9cde3890f7a
0x18c5069902cd51c85b96d26c5722bfa941fcff3a8e02d324d279c649e14a9d7c	3000	0x9a13f98cb987694c9f086b1f5eb990eea8264ec3	-322379	false	0x0000000000000000000000000000000000000000	0	131658748	0x50bce64397c75488465253c0a034b8097fea6578	0x68f180fcce6836688e9084f035309e29bf0a2095	60	2025-02-07T08:17:53.000Z	7922432358546634479092	0xfd9220075d752b80382da62ae5ab992d20a33e6e333c54db7044e40689832a7b
0x659eb0671c546731afec991347f0d974b24eb2c2b7902654f6be6954f5fec4d8	500	0x9a13f98cb987694c9f086b1f5eb990eea8264ec3	-276325	false	0xf8c3f4243c4d8c02831a718a7978fd869f094300	5	131672842	0x0000000000000000000000000000000000000000	0x0b2c639c533813f4aa9d7837caf62653d097ff85	10	2025-02-07T16:07:41.000Z	79224306130848112672356	0x6475b84fa66fd3caf18163a74e8da75ff1239d37893daef53acda95341c0e3e1

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.uniswap_v4_optimism.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
0x00101611951ec1583981bb0068d336e81d7d293db35684efda82f7a938e84461	0x9a13f98cb987694c9f086b1f5eb990eea8264ec3	0x00000000000000000000000000000000000000000000000000000000000000ab	false	0x3c3ea4b57a46241e54610e5f022e5c45859a1017	211	131457603	270400	272200	2025-02-02T16:33:03.000Z	0x861b5261c2bfc432bd931a91c84fb2fd7a60260beafbdba1d6b2162173d48785	-919446639832495
0x00101611951ec1583981bb0068d336e81d7d293db35684efda82f7a938e84461	0x9a13f98cb987694c9f086b1f5eb990eea8264ec3	0x00000000000000000000000000000000000000000000000000000000000000ab	false	0x3c3ea4b57a46241e54610e5f022e5c45859a1017	13	131454893	270400	272200	2025-02-02T15:02:43.000Z	0x23ec7e3b532d915e06985645b747e905b307825753f0e9990bd3388dbe6b7a89	919446639832495
0x00101611951ec1583981bb0068d336e81d7d293db35684efda82f7a938e84461	0x9a13f98cb987694c9f086b1f5eb990eea8264ec3	0x00000000000000000000000000000000000000000000000000000000000000a1	false	0x3c3ea4b57a46241e54610e5f022e5c45859a1017	18	131451181	272000	277800	2025-02-02T12:58:59.000Z	0x4c463de2c674d82c765f937fc32cba5e60a130f7d4788c82a961ee078fd03805	35648897084110993

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.uniswap_v4_optimism.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
0x9a13f98cb987694c9f086b1f5eb990eea8264ec3	0x0000000000000000000000000000000000000000	false	24	0xa1dd330d602c32622aa270ea73d078b803cb3518	130947675	2025-01-21T21:15:27.000Z	0xe3de31b8dbc3ae4d05b352c54a29883d82d5a77c967a5b849ccad84ad1606152

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.uniswap_v4_optimism.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
0x8b5e15f099a9e9fd6d42980d64512d86350146da397bccf68cc9ef4288875424	3000	0x9a13f98cb987694c9f086b1f5eb990eea8264ec3	195889	false	0x0000000000c0b5a44b671a99d8e75c26d3796d4d	9	442128	-79491073742361	131713093	10000001187	2025-02-08T14:29:23.000Z	1420184643768776031045558969979114	0x3abce9ba4aa757c9ac6c18ce98510958b5a85b14c2637cfe139c8c0067c884fd
0xc7acd7abc07d744e5ec902d14ed932e455b29892943bbec2e551a6d424c12035	3000	0x9a13f98cb987694c9f086b1f5eb990eea8264ec3	665	false	0x402867b638339ad8bec6e5373cfa95da0b462c85	79	24934799646434544	-26062028893241961	131729197	1004365975846347693	2025-02-08T23:26:11.000Z	81908958945478620430758313035	0xa321cf5acacd1795b261a3cccf743ef6401cfbc2f4191d53e957b3eb689fe479
0x51ffbeac307aae5ce3431da483e496e14e9f25b6c6bdf5cbc51af6622308c294	100	0x9a13f98cb987694c9f086b1f5eb990eea8264ec3	-197497	false	0x402867b638339ad8bec6e5373cfa95da0b462c85	28	-150052621428600	397904	131693031	10395701707275	2025-02-08T03:20:39.000Z	4078565436506854996599856	0x55ca0d604cb079a63ddaa6e17384041a637ece6fb495f6d6c0bdf0e34e75b2a5

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.uniswap_v4_optimism.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
144587	{“fee”:“10000”,“hooks”:“0x0000000000000000000000000000000000000000”,“currency0”:“0x0000000000000000000000000000000000000000”,“currency1”:“0x0994206dfe8de6ec6920ff4d779b0d950605fb53”,“tickSpacing”:200}	true	24670	{“zeroForOne”:true,“amountSpecified”:“-3954825342048”,“sqrtPriceLimitX96”:“4295128740”}	0xf3cd914c	0x9a13f98cb987694c9f086b1f5eb990eea8264ec3	0x	133301449	0x0000000000c0b5a44b671a99d8e75c26d3796d4d	-1345757328151003499339700032556700421053618778873574	5,0,0	2025-03-17T08:54:35.000Z	0xf7595599bab437fe16cb83c3188fa988d428c0333f99522cc227f370135874eb
3975591	{“fee”:“500”,“hooks”:“0x0000000000000000000000000000000000000000”,“currency0”:“0x0000000000000000000000000000000000000000”,“currency1”:“0x0b2c639c533813f4aa9d7837caf62653d097ff85”,“tickSpacing”:10}	false	14303	{“zeroForOne”:false,“amountSpecified”:“-300000000”,“sqrtPriceLimitX96”:“1461446703485210103287273052203988822378723970341”}	0xf3cd914c	0x9a13f98cb987694c9f086b1f5eb990eea8264ec3	0x	133304986	0x851116d9223fabed8e56c0e6b8ad0c31d98b3507	53035015969002769671982315805254366625251020892425575680	4,7,3,0,0,0	2025-03-17T10:52:29.000Z	0xbbd1449fd72a07353b41bb3abab8eb7497f0d2592a3aa5d0b59cdb56a83b9264
4468899	{“fee”:“500”,“hooks”:“0x0000000000000000000000000000000000000000”,“currency0”:“0x0000000000000000000000000000000000000000”,“currency1”:“0x0b2c639c533813f4aa9d7837caf62653d097ff85”,“tickSpacing”:10}	true	15004	{“zeroForOne”:false,“amountSpecified”:“-2048706”,“sqrtPriceLimitX96”:“1461446703485210103287273052203988822378723970341”}	0xf3cd914c	0x9a13f98cb987694c9f086b1f5eb990eea8264ec3	0x	133310366	0x851116d9223fabed8e56c0e6b8ad0c31d98b3507	367246292793954782588025161640328658231497353668377918	0,4,1,47,0,2,2,1,14,0,14,1,0,0,0,0,0	2025-03-17T13:51:49.000Z	0xbc76ce8e0c855b29c57e51dbdf5d54c70aafb76ab2c71d0bc906f108fbb6b149

Example Query

Query with partition filter

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