uniswap_v4_bsc

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
0x64f507e94fcb0f7d0e0a78cd58336d3d9ec7d25a5e76f19187c3c3a0b6f56e68	100	0x28e2ea090877bf75740558f6bfb36a5ffee9e9df	68127	false	0x0000000000000000000000000000000000000000	116	46350899	0x2170ed0880ac9a755fd29b2688956bd959f933f8	0xb3ed0a426155b79b898849803e3b36552f7ed507	1	2025-02-04T01:54:03.000Z	2388716608409958921053806961366	0x8de1eb246648f443f99c2a5699f8ed5d19ab51ef33482a9e2f924b0ca2f3d04b
0xa726b3ead782149021c1eaf3c6655af07765b05d141f2e1e82ddb8ce2f2ecd15	10000	0x28e2ea090877bf75740558f6bfb36a5ffee9e9df	0	false	0x0000000000000000000000000000000000000000	14	46374450	0x23e8a70534308a4aaf76fb8c32ec13d17a3bd89e	0x8ac76a51cc950d9822d68b83fe1ad97b32cd580d	200	2025-02-04T21:31:38.000Z	79228162514264337593543950336	0x5b929b304e1959a66c9757d648c752bd1fc48d5b51f44523283fadcb2f3179fc
0x83b31f1714670095e39f01385499b29af173372c745ee8970ce3c2742172f362	10000	0x28e2ea090877bf75740558f6bfb36a5ffee9e9df	-409378	false	0x0000000000000000000000000000000000000000	62	46360153	0x0df0587216a4a1bb7d5082fdc491d93d2dd4b413	0x5de3939b2f811a61d830e6f52d13b066881412ab	200	2025-02-04T09:36:45.000Z	102280704324433041804	0xa20063e409e304d335934037d67de97a5a9ada6e2fcd0d230ec78b5e2bd5aa0d

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.uniswap_v4_bsc.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
0x4c9dff5169d88f7fbf5e43fc8e2eb56bf9791785729b9fc8c22064a47af12052	0x28e2ea090877bf75740558f6bfb36a5ffee9e9df	0x0000000000000000000000000000000000000000000000000000000000000001	false	0x7a4a5c919ae2541aed11041a1aeee68f1287f95b	76	46001486	-887270	887270	2025-01-22T22:42:36.000Z	0x36c1e4c7b4105a0be337addc32b5564dd3494fccfe331bf9fe7c647163d27d05	1247225317527338626
0xd936b13bddb8bbf125c57c8d0993abef2063223ccfa0d276e3cda40b8a994d45	0x28e2ea090877bf75740558f6bfb36a5ffee9e9df	0x0000000000000000000000000000000000000000000000000000000000000002	false	0x7a4a5c919ae2541aed11041a1aeee68f1287f95b	77	46027659	-887220	887220	2025-01-23T20:31:15.000Z	0xb71139517dfadee9e90b70bec378992e046d16ddbc2db8d3b985d82140bd6eaa	74785352669326804
0x04a35e28add7e8750ce50c4e32e3e293d410fba3c776077b1585c515d03854b5	0x28e2ea090877bf75740558f6bfb36a5ffee9e9df	0x00000000000000000000000000000000000000000000000000000000000000d5	false	0x7a4a5c919ae2541aed11041a1aeee68f1287f95b	110	46280526	-11664	-10785	2025-02-01T15:15:18.000Z	0xe7c760e72bc6bff7967eb0187f8c3f62c1c8f91b719f2e8aa13e0bedb5978ee8	-4707585907580703284647

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.uniswap_v4_bsc.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
0x28e2ea090877bf75740558f6bfb36a5ffee9e9df	0x0000000000000000000000000000000000000000	false	134	0x341c1511141022cf8ee20824ae0ffa3491f1302b	45970610	2025-01-21T20:58:44.000Z	0x64b395f1b0b3c734a477c802bc8cc3ce394f328c651290d0d166946048487bbe

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.uniswap_v4_bsc.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
0xd936b13bddb8bbf125c57c8d0993abef2063223ccfa0d276e3cda40b8a994d45	3000	0x28e2ea090877bf75740558f6bfb36a5ffee9e9df	-65320	false	0x000000000008d5760657dd664c7096897e1ae801	324	-87218382572329200	132549103677866	46039688	74785352669326804	2025-01-24T06:32:42.000Z	3023844716654503974878613094	0xdbb51d47a7e743db852023a016f73c9e24b1f5638943bf8d5f5517e89d1a310c
0xd936b13bddb8bbf125c57c8d0993abef2063223ccfa0d276e3cda40b8a994d45	3000	0x28e2ea090877bf75740558f6bfb36a5ffee9e9df	-69900	false	0x1906c1d672b88cd1b9ac7593301ca990f94eae07	44	-500000000000000000	575839986170859	46039687	74785352669326804	2025-01-24T06:32:39.000Z	2404957922709528994400768855	0xa7046cf7c0539fd9146f64185074adf1df5131fc68e989e8f5efcdd8f560304b
0xd936b13bddb8bbf125c57c8d0993abef2063223ccfa0d276e3cda40b8a994d45	3000	0x28e2ea090877bf75740558f6bfb36a5ffee9e9df	-64412	false	0x27f9f6fda8f78bc50c8f51289114f727b8c0a8b8	54	591200307965016177	-718887776013512	46039687	74785352669326804	2025-01-24T06:32:39.000Z	3164268229447769144407865232	0x8811333e69b0c8897fe5da56dec83bf7b229ac2cf57de2a35e9eab5dd101df3f

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.uniswap_v4_bsc.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
153232	false	1799	0xf3cd914c	0x28e2ea090877bf75740558f6bfb36a5ffee9e9df	51073420	0x1906c1d672b88cd1b9ac7593301ca990f94eae07	0,0,1	2025-06-08T03:42:35.000Z	0xf8bd1e9ac82debfef432ccc62ffe7e8a0319f3309b910f1d07cf45308d5aa940
514653	false	7327	0xf3cd914c	0x28e2ea090877bf75740558f6bfb36a5ffee9e9df	51109283	0x802b65b5d9016621e66003aed0b16615093f328b	0,0,0,0,0	2025-06-08T18:39:24.000Z	0x74382e01d38b2cbabdbab2770512121d92db44186ad17a8c1291a16e034fa511
514653	false	7327	0xf3cd914c	0x28e2ea090877bf75740558f6bfb36a5ffee9e9df	51065015	0x802b65b5d9016621e66003aed0b16615093f328b	0,0,0,0,0	2025-06-08T00:12:25.000Z	0x211d231d5bf3757952f74f76e03a69ffbc8dee96c7bf58eb3fbc2d4d2f4c698d

Example Query

Query with partition filter

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