uniswap_v4_arbitrum

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
0x684df001321105149104891d64d4ecce9dfe42aa88f8367b26141faa70f1cc4b	3000	0x360e68faccca8ca495c1b759fd9eee466db9fb32	-115136	false	0x0000000000000000000000000000000000000000	0	299588207	0x912ce59144191c1204e64559fe8253a0e49e6548	0xfa7f8980b0f1e64a2062791cc3b0871572f1f7f0	60	2025-01-26T20:45:32.000Z	250529060232794967902094762	0xc31e605b62f89469c658e91e0d61b6416d8164ff3be677b556dd27dafed9b0db
0x6b6da10809033b2b952211f1a42f142d046871300d4872994e6f6d147b3f61eb	1	0x360e68faccca8ca495c1b759fd9eee466db9fb32	-196665	false	0x0000000000000000000000000000000000000000	4	302366505	0x0000000000000000000000000000000000000000	0xaf88d065e77c8cc2239327c5edb3a432268e5831	1	2025-02-03T23:56:06.000Z	4251741788740169635378073	0x7d8f7370a279561b6a844b21cfc73f9ab834df2b034403bc2051218d22373e4f
0xff1cd21e76adba320e4123b3d7167e89c58f744b8dcd81ac13b02cc67d9bee7e	100	0x360e68faccca8ca495c1b759fd9eee466db9fb32	-284626	false	0x0000000000000000000000000000000000000000	2	302195543	0x912ce59144191c1204e64559fe8253a0e49e6548	0xfd086bc7cd5c481dcc9c85ebe478a1c0b69fcbb9	1	2025-02-03T12:02:59.000Z	52313470416128253645042	0x312f58fa74ea3e495430ce61ff65d8621f9b29a3d5a29954d91f5daadfcaafeb

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.uniswap_v4_arbitrum.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
0xa6a4d6573cb3baadccd400deb4b021e70f42bd628866a9443433d9533dd1d118	0x360e68faccca8ca495c1b759fd9eee466db9fb32	0x0000000000000000000000000000000000000000000000000000000000000e8a	false	0xd88f38f930b7952f2db2432cb002e7abbf3dd869	1	304317321	-887272	887272	2025-02-09T16:21:32.000Z	0x2ec216e04d16b9746053599ec5ead6cc59bf27c7b066fe852ebd5bd3b1ba4d73	99999999999999
0x20354cf3a44f2980f9fd205b7ed4418fee7ebf82a925c7d3c5d1565eb9831484	0x360e68faccca8ca495c1b759fd9eee466db9fb32	0x0000000000000000000000000000000000000000000000000000000000000da6	false	0xd88f38f930b7952f2db2432cb002e7abbf3dd869	0	304307158	-887272	887272	2025-02-09T15:38:48.000Z	0x913fb538c71c2484210a61a25cd0300a48be01d71dcce6c94de3a6b60dee9d66	-2499905
0x56d3418f0abe97924663a500d98897038d9b0d3c40b1434762333ce819741d8a	0x360e68faccca8ca495c1b759fd9eee466db9fb32	0x0000000000000000000000000000000000000000000000000000000000000ece	false	0xd88f38f930b7952f2db2432cb002e7abbf3dd869	2	304380679	-887272	887272	2025-02-09T20:49:47.000Z	0x19cad7ca52bbf2726611718a54f9993875029773e4da0d0d13077a6e40f17ea6	999998678

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.uniswap_v4_arbitrum.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
0x360e68faccca8ca495c1b759fd9eee466db9fb32	0x0000000000000000000000000000000000000000	false	0	0x2bad8182c09f50c8318d769245bea52c32be46cd	297842872	2025-01-21T19:22:01.000Z	0x6ef4f5c15ee3cf594b68c447e3c24e39ca896c438a2cf4c3bca7f10df2f2e1ad

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.uniswap_v4_arbitrum.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
0xfc7b3ad139daaf1e9c3637ed921c154d1b04286f8a82b805a6c352da57028653	500	0x360e68faccca8ca495c1b759fd9eee466db9fb32	-195535	false	0x689368aae04fe7d961d1e545b28266c4f179151c	11	295154597409582	-933885	300042763	853751609714	2025-01-28T04:37:19.000Z	4498984636457520308959903	0x551658a6cdcb053ab57d0535470438f1249e4955e05095e968365a01831da76e
0xfc7b3ad139daaf1e9c3637ed921c154d1b04286f8a82b805a6c352da57028653	500	0x360e68faccca8ca495c1b759fd9eee466db9fb32	-195863	false	0x689368aae04fe7d961d1e545b28266c4f179151c	9	-249015009161283	789491	300250067	853751609714	2025-01-28T19:07:33.000Z	4425719792715580274134426	0xe2bec1cf614027ba8778199fe6b4deec836eaed16f1e09fc1c2b2a2405cdbaad
0xd490067882c168d16f4f495b25e5843f4935697fa12c1469caab4206c096ad6f	500	0x360e68faccca8ca495c1b759fd9eee466db9fb32	-195727	false	0x689368aae04fe7d961d1e545b28266c4f179151c	16	-92462653200611	295008	300263939	574433231302	2025-01-28T20:06:22.000Z	4456034541346976512433473	0x9c3ca341891e1ec8fa79869d41795b577632ee64de54bcf9c5309978fc4fa42d

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.uniswap_v4_arbitrum.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`	`STRING`	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
334239	{“fee”:“100”,“hooks”:“0x0000000000000000000000000000000000000000”,“currency0”:“0x2f2a2543b76a4166549f7aab2e75bef0aefc5b0f”,“currency1”:“0xcbb7c0000ab88b473b1f5afd9ef808440eed33bf”,“tickSpacing”:1}	true	27615	{“zeroForOne”:false,“amountSpecified”:“-70044”,“sqrtPriceLimitX96”:“1461446703485210103287273052203988822378723970341”}	0xf3cd914c	0x360e68faccca8ca495c1b759fd9eee466db9fb32	0x	327346335	0xa51afafe0263b40edaef0df8781ea9aa03e381a3	23845627144351683765659438990388589185920612	0,0,0	2025-04-17T14:56:18.000Z	0x8714421b24280651a41860439acb2d8bfb2acb0628f00fbf74a5b2d89c01acde
515202	{“fee”:“3000”,“hooks”:“0x0000000000000000000000000000000000000000”,“currency0”:“0x0c880f6761f1af8d9aa9c466984b80dab9a8c9e8”,“currency1”:“0xfd086bc7cd5c481dcc9c85ebe478a1c0b69fcbb9”,“tickSpacing”:60}	true	27714	{“zeroForOne”:false,“amountSpecified”:“-98840481”,“sqrtPriceLimitX96”:“1461446703485210103287273052203988822378723970341”}	0xf3cd914c	0x360e68faccca8ca495c1b759fd9eee466db9fb32	0x	327422930	0xa51afafe0263b40edaef0df8781ea9aa03e381a3	10816443246225710101946291707447362429788290565872633499743	0,0,0	2025-04-17T20:14:49.000Z	0x21bb891c8bdf1290bdd6819061e7bdc722f138d9b8b05e7dd9afab21fde77d14
265152	{“fee”:“3000”,“hooks”:“0x0000000000000000000000000000000000000000”,“currency0”:“0x0c880f6761f1af8d9aa9c466984b80dab9a8c9e8”,“currency1”:“0xfd086bc7cd5c481dcc9c85ebe478a1c0b69fcbb9”,“tickSpacing”:60}	true	27714	{“zeroForOne”:false,“amountSpecified”:“-79304334”,“sqrtPriceLimitX96”:“1461446703485210103287273052203988822378723970341”}	0xf3cd914c	0x360e68faccca8ca495c1b759fd9eee466db9fb32	0x	327466423	0xa51afafe0263b40edaef0df8781ea9aa03e381a3	8677610161822765203176496599668806240637923111916710259058	0,0,0	2025-04-17T23:17:47.000Z	0x20765d153c3054a7ebec804bd04e202b152614c428bbc0cdcbaf258555b55dfd

Example Query

Query with partition filter

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