uniswap_v4_blast

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
0x83e7c9f12348a95a5fe02c8af7074dd52defd1e108e19e51234c49da56d7c635	500	0x1631559198a9e474033433b2958dabc135ab6446	-81021	false	0x0000000000000000000000000000000000000000	0	14465585	0x4300000000000000000000000000000000000003	0x4300000000000000000000000000000000000004	10	2025-01-24T17:49:45.000Z	1379173438223306548481122833	0x96ecf330532a794388405835ba7cc6687f281d3e44dee502fb89dc8d789fdf33
0x60b5b86906dfc355df923b91181f3d5fbaeb68fb569f9b89c30c5e98eee73583	3000	0x1631559198a9e474033433b2958dabc135ab6446	0	false	0x0000000000000000000000000000000000000000	6	15067827	0x4300000000000000000000000000000000000003	0xb1a5700fa2358173fe465e6ea4ff52e36e88e2ad	60	2025-02-07T16:24:29.000Z	79228162514264337593543950336	0x22be8918db84fffd35143116c5f57bfe29da8461aeb47f236e27167b230847a0
0x03514ea0c2eee0ef3882a4b162917413e0683a7a6a6008d38ae348728100e4fc	3000	0x1631559198a9e474033433b2958dabc135ab6446	0	false	0x0000000000000000000000000000000000000000	5	15065494	0x0000000000000000000000000000000000000000	0xb1a5700fa2358173fe465e6ea4ff52e36e88e2ad	60	2025-02-07T15:06:43.000Z	79228162514264337593543950336	0xd59e06282b24906b83385132b3895e6c450a98ba5ab4f019e1621fc6e8236af4

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.uniswap_v4_blast.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
0x7660161ab15b8fb9f2b9d1eeea089ca5f67aaac66bbad2ed9a96b57e135fa0d0	0x1631559198a9e474033433b2958dabc135ab6446	0x0000000000000000000000000000000000000000000000000000000000000003	false	0x4ad2f4cca2682cbb5b950d660dd458a1d3f1baad	3	14578781	-887272	887272	2025-01-27T08:42:57.000Z	0x319bcd7706bdbc0c6e26f955fcf8c61a7448f37dd9d237ca5bbd992023d6ff33	9999999999999
0x7660161ab15b8fb9f2b9d1eeea089ca5f67aaac66bbad2ed9a96b57e135fa0d0	0x1631559198a9e474033433b2958dabc135ab6446	0x0000000000000000000000000000000000000000000000000000000000000005	false	0x4ad2f4cca2682cbb5b950d660dd458a1d3f1baad	1	14583899	-887272	887272	2025-01-27T11:33:33.000Z	0xf283934aafe6ba9e02d1dfe78d2ea00c585f81d94743260b58144c3c5f4d8bfc	9999999999999
0x83e7c9f12348a95a5fe02c8af7074dd52defd1e108e19e51234c49da56d7c635	0x1631559198a9e474033433b2958dabc135ab6446	0x0000000000000000000000000000000000000000000000000000000000000002	false	0x4ad2f4cca2682cbb5b950d660dd458a1d3f1baad	39	14565809	-887270	887270	2025-01-27T01:30:33.000Z	0x970a90f3380d8c263636116fe226a48bdfbc6b403012b5ea597ee4afad2ca825	55937981569063

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.uniswap_v4_blast.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
0x1631559198a9e474033433b2958dabc135ab6446	0x0000000000000000000000000000000000000000	false	27	0x2339c0d23b60739b3e5abf201f05903d24a26c77	14377311	2025-01-22T16:47:17.000Z	0x858e71e5e3e23c717ed95db9be8c6beba5f0b2a6eac4147dffc2e4c269e1216b

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.uniswap_v4_blast.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
0x83e7c9f12348a95a5fe02c8af7074dd52defd1e108e19e51234c49da56d7c635	500	0x1631559198a9e474033433b2958dabc135ab6446	-79779	false	0x02828245c531074b6bc8382ca0d97b0f2dd82677	264	-80422978860051873	27652625631462	14861041	566445953663588011	2025-02-02T21:31:37.000Z	1467556247438677465611246482	0x067ec0d694de571617c2130261bdea8f1c144de5f3a3a3d38a9703b5539c2a7b
0x83e7c9f12348a95a5fe02c8af7074dd52defd1e108e19e51234c49da56d7c635	500	0x1631559198a9e474033433b2958dabc135ab6446	-80852	false	0x02828245c531074b6bc8382ca0d97b0f2dd82677	6	224352956166974336	-68705728952162	14849668	566445953663588011	2025-02-02T15:12:31.000Z	1390933146232069803627518452	0x7c8325c718be231e215a66e569b92f8f85c167d059792bce68c4240ef67cc031
0x83e7c9f12348a95a5fe02c8af7074dd52defd1e108e19e51234c49da56d7c635	500	0x1631559198a9e474033433b2958dabc135ab6446	-79897	false	0x02828245c531074b6bc8382ca0d97b0f2dd82677	71	-181061749846492253	61727306582698	14861043	566445953663588011	2025-02-02T21:31:41.000Z	1458922518049542636200861692	0x2f3e9ed54f02663948848435ebf881ac834a1a016f1263aa488ce68960d5c46f

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.uniswap_v4_blast.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`	`NUMERIC`	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
316519	{“fee”:“500”,“hooks”:“0x0000000000000000000000000000000000000000”,“currency0”:“0x4300000000000000000000000000000000000003”,“currency1”:“0x4300000000000000000000000000000000000004”,“tickSpacing”:10}	true	27680	{“zeroForOne”:false,“amountSpecified”:“-6805746461686”,“sqrtPriceLimitX96”:“1461446703485210103287273052203988822378723970341”}	0xf3cd914c	0x1631559198a9e474033433b2958dabc135ab6446	0x	15612741	0x02828245c531074b6bc8382ca0d97b0f2dd82677	6359425100790169328978417022168396869431541752440181770	0,0,0,1,1,0,1	2025-02-20T07:08:17.000Z	0xf1b0226610547cf41f74ac330912a564f204c5b44b4f30f8b3a042925a6df5ae
1898741	{“fee”:“500”,“hooks”:“0x0000000000000000000000000000000000000000”,“currency0”:“0x4300000000000000000000000000000000000003”,“currency1”:“0x4300000000000000000000000000000000000004”,“tickSpacing”:10}	true	28481	{“zeroForOne”:false,“amountSpecified”:“-79743795765636”,“sqrtPriceLimitX96”:“1461446703485210103287273052203988822378723970341”}	0xf3cd914c	0x1631559198a9e474033433b2958dabc135ab6446	0x	15600430	0x02828245c531074b6bc8382ca0d97b0f2dd82677	73727263251378492148149390660249312415254635890566323836	0,2,1,1,0,1	2025-02-20T00:17:55.000Z	0xf5ffcb40b9dfcdd3adec9ecc6f8bd8b94615f0d18b3de5418c3ba4069ef43557
244463	{“fee”:“500”,“hooks”:“0x0000000000000000000000000000000000000000”,“currency0”:“0x0000000000000000000000000000000000000000”,“currency1”:“0x4300000000000000000000000000000000000003”,“tickSpacing”:10}	true	28794	{“zeroForOne”:false,“amountSpecified”:“-5406813556838692”,“sqrtPriceLimitX96”:“1461446703485210103287273052203988822378723970341”}	0xf3cd914c	0x1631559198a9e474033433b2958dabc135ab6446	0x	15626214	0x02828245c531074b6bc8382ca0d97b0f2dd82677	672056693882174913026096947706622326033928305241820	0,2,1,5,0,1	2025-02-20T14:37:23.000Z	0x88e4b355bb2d6450f4612830654d9394f871bb017f411352a25e3be879ac42d1

Example Query

Query with partition filter

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