uniswap_v3_celol2

Tables

Factory_PoolCreated_event

Factory contract event emitted when a new liquidity pool is created, recording token pairs and pool configuration parameters. Used for tracking DEX pool deployments and liquidity market initialization.

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_token0`	`STRING`	Contract address of the first token in the trading pair. Hex-encoded, 0x-prefixed, 42-character string.
`in_token1`	`STRING`	Contract address of the second token in the trading 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_pool`	`STRING`	Contract address of the pool being referenced in the event. Hex-encoded, 0x-prefixed, 42-character string.

Sample Data

in_fee	address	in_pool	removed	in_token0	in_token1	log_index	block_number	in_tickSpacing	block_timestamp	transaction_hash
100	0xafe208a311b21f13ef87e33a90049fc17a7acdec	0xefc63a8112e7d20ffe84862dd9b4e23e93635836	false	0x4f604735c1cf31399c6e711d5962b2b3e0225ad3	0x8a567e2ae79ca692bd748ab832081c45de4041ea	13	35770630	1	2025-05-19T16:16:28.000Z	0x38bd58b91481df4edafb3d6aa315b60f55010ab17b379a370a16c2a69320f02a
100	0xafe208a311b21f13ef87e33a90049fc17a7acdec	0x2ac5baa668a8a58fd0e302b9896717484fd217b0	false	0x48065fbbe25f71c9282ddf5e1cd6d6a887483d5e	0x8a567e2ae79ca692bd748ab832081c45de4041ea	74	32363041	1	2025-04-10T05:43:19.000Z	0xcd9032045b9c09e047bcfe70c6f99923b881335ef5c851ca2f9f8f64c66dfa53
3000	0xafe208a311b21f13ef87e33a90049fc17a7acdec	0xc9083503727495569de1973c5d44eb546d31474a	false	0x2e6c05f1f7d1f4eb9a088bf12257f1647682b754	0x471ece3750da237f93b8e339c536989b8978a438	20	32426854	60	2025-04-10T23:26:52.000Z	0x3aa631b869438250ae9048abc2adb54d0edb135e7f8f4fff35c14c4e3306d3c3

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.uniswap_v3_celol2.Factory_PoolCreated_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

Pool_Burn_event

Liquidity removal events from concentrated liquidity pools recording withdrawn token amounts and position tick ranges. Contains owner address, liquidity amount burned, token amounts withdrawn (amount0/amount1), and tick boundaries for tracking position liquidations and TVL changes.

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_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_amount`	`STRING`	Input amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination.
`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.

Sample Data

address	removed	in_owner	in_amount	log_index	in_amount1	block_number	in_tickLower	in_tickUpper	block_timestamp	transaction_hash
0xc5a5caebf3bf6220a3efa222710ab488943a73f8	false	0x25513a5f10492696b7bd552441d1d099591b1a02	175123295561651	4	77407197697437773761	34788069	-887272	259995	2025-05-08T07:20:27.000Z	0x97aaed292cc9da2f6d94b36674af115762423abd9c4f2086a016c111019b64e6
0xc5a5caebf3bf6220a3efa222710ab488943a73f8	false	0x25513a5f10492696b7bd552441d1d099591b1a02	0	2	0	34788069	-887272	259995	2025-05-08T07:20:27.000Z	0x97aaed292cc9da2f6d94b36674af115762423abd9c4f2086a016c111019b64e6
0xc5a5caebf3bf6220a3efa222710ab488943a73f8	false	0x25513a5f10492696b7bd552441d1d099591b1a02	0	1	0	34818562	-887272	260126	2025-05-08T15:48:40.000Z	0x173eb31db32ab6d1310babf94f6a97963b4cbfc18df692e3e1242ef51c181f27

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.uniswap_v3_celol2.Pool_Burn_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

Pool_Collect_event

Concentrated liquidity position fee collection events from Uniswap V3 compatible decentralized exchanges. Records position owner, recipient, collected token amounts, and tick range boundaries for tracking earned trading fees and position management activity.

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_recipient`	`STRING`	Address designated to receive the output tokens from a swap 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_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.

Sample Data

address	removed	in_owner	log_index	in_amount1	block_number	in_recipient	in_tickLower	in_tickUpper	block_timestamp	transaction_hash
0xf55791afbb35ad42984f18d6fe3e1ff73d81900c	false	0x3d79edaabc0eab6f08ed885c05fc0b014290d95a	23	0	34502469	0xe01548cd36a461cf21e3b661f61cc6194bc8961f	201323	201324	2025-05-05T00:00:27.000Z	0xcc65df847ad50c63a63c5afada67c7a60c4295cc1ae73ae698a3711e6d795268
0xf55791afbb35ad42984f18d6fe3e1ff73d81900c	false	0x3d79edaabc0eab6f08ed885c05fc0b014290d95a	21	25080675846282935	34502469	0xfa1457caf448c66ce3c2e619ccd4fcfd317b61f6	201323	201324	2025-05-05T00:00:27.000Z	0xcc65df847ad50c63a63c5afada67c7a60c4295cc1ae73ae698a3711e6d795268
0xf55791afbb35ad42984f18d6fe3e1ff73d81900c	false	0x3d79edaabc0eab6f08ed885c05fc0b014290d95a	20	25054606235253216	34507870	0xfa1457caf448c66ce3c2e619ccd4fcfd317b61f6	201349	201350	2025-05-05T01:30:28.000Z	0xfcfa13cfcb4c28947f64425b9a77bbcaa82e801d9cf6978505ba3c9fbf80ad7a

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.uniswap_v3_celol2.Pool_Collect_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

Pool_Flash_event

Flash loan events from liquidity pools recording borrowed amounts and repayment fees for both tokens in the pair. Tracks sender, recipient, borrowed quantities, and actual fees paid for arbitrage and liquidation analysis.

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_sender`	`STRING`	Address that initiated the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_recipient`	`STRING`	Address designated to receive the output tokens from a swap 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_paid0`	`STRING`	Amount of token0 paid as flash loan fee. Numeric string representation of token quantity in smallest denomination.
`in_paid1`	`STRING`	Amount of token1 paid as flash loan fee. Numeric string representation of token quantity in smallest denomination.

Sample Data

No sample data available.

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.uniswap_v3_celol2.Pool_Flash_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

Pool_Mint_event

Liquidity provision events emitted when liquidity providers add tokens to concentrated liquidity pools. Records deposited token amounts, tick ranges, liquidity shares, and position owner for DEX pool analytics.

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_sender`	`STRING`	Address that initiated the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_owner`	`STRING`	Address that owns or controls the shares or position being deposited or withdrawn. 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_amount`	`STRING`	Input amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination.
`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.

Sample Data

address	removed	in_owner	in_amount	in_sender	log_index	in_amount0	in_amount1	block_number	in_tickLower	in_tickUpper	block_timestamp	transaction_hash
0xc5a5caebf3bf6220a3efa222710ab488943a73f8	false	0x25513a5f10492696b7bd552441d1d099591b1a02	386395988893806	0x25513a5f10492696b7bd552441d1d099591b1a02	15	0	171915296269094957465	34788069	-887272	260126	2025-05-08T07:20:27.000Z	0x97aaed292cc9da2f6d94b36674af115762423abd9c4f2086a016c111019b64e6
0xc5a5caebf3bf6220a3efa222710ab488943a73f8	false	0x25513a5f10492696b7bd552441d1d099591b1a02	31444743304603946	0x25513a5f10492696b7bd552441d1d099591b1a02	17	11540741332	0	34788069	260127	263693	2025-05-08T07:20:27.000Z	0x97aaed292cc9da2f6d94b36674af115762423abd9c4f2086a016c111019b64e6
0xc5a5caebf3bf6220a3efa222710ab488943a73f8	false	0x25513a5f10492696b7bd552441d1d099591b1a02	386413028164164	0x25513a5f10492696b7bd552441d1d099591b1a02	17	0	168518744827313138619	34818562	-887272	259726	2025-05-08T15:48:40.000Z	0x173eb31db32ab6d1310babf94f6a97963b4cbfc18df692e3e1242ef51c181f27

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.uniswap_v3_celol2.Pool_Mint_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

Pool_Swap_event

Decentralized exchange (DEX) swap execution events recording token exchanges within liquidity pools. Contains sender, recipient, token amounts, liquidity depth, price data (sqrtPriceX96 or tick), and transaction metadata for tracking trading activity and price movements.

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_sender`	`STRING`	Address that initiated the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_recipient`	`STRING`	Address designated to receive the output tokens from a swap 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.

Sample Data

address	in_tick	removed	in_sender	log_index	in_amount0	in_amount1	block_number	in_liquidity	in_recipient	block_timestamp	in_sqrtPriceX96	transaction_hash
0x0d76866f78fcbca2730e60c5997d59d6ba585613	-86175	false	0x00000000000130ced6024c216d5636f216173feb	8	-113146941541201136768	20539020457462898	33033653	17984886093308766432103	0x00000000000130ced6024c216d5636f216173feb	2025-04-18T00:00:11.000Z	1065893945648952740777110749	0x03b44614d4ee8592c22acdae1523db53177a7c1a234d29ee0d0ec0d29fa6cafc
0x0d76866f78fcbca2730e60c5997d59d6ba585613	-86173	false	0x00000000000130ced6024c216d5636f216173feb	15	-125175676969432404018	22726590237980088	33034230	17984886093308766432103	0x00000000000130ced6024c216d5636f216173feb	2025-04-18T00:09:48.000Z	1065993761917874419653394209	0x9d0e5be9132396cf0ce062d07d8e8fde75354cd8e5ba64c8754620ab6695614d
0x0d76866f78fcbca2730e60c5997d59d6ba585613	-86167	false	0x00000000000130ced6024c216d5636f216173feb	24	-143886478326571270420	26139713174758826	33034273	17984886093308766432103	0x00000000000130ced6024c216d5636f216173feb	2025-04-18T00:10:31.000Z	1066328362300032546931294159	0x674d53f524daf2f197e38740393fd289414218db67ba5d7502334b33451cf237

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.uniswap_v3_celol2.Pool_Swap_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

Metrics

Primitives

Contracts

Blockchain

Tables

Factory_PoolCreated_event

Pool_Burn_event

Pool_Collect_event

Pool_Flash_event

Pool_Mint_event

Pool_Swap_event

Metrics

Primitives

Contracts

Blockchain

​Tables

​Factory_PoolCreated_event

​Pool_Burn_event

​Pool_Collect_event

​Pool_Flash_event

​Pool_Mint_event

​Pool_Swap_event

Tables

Factory_PoolCreated_event

Pool_Burn_event

Pool_Collect_event

Pool_Flash_event

Pool_Mint_event

Pool_Swap_event