quickswap_v3_immutablezkevm

Tables

factory_PoolCreated_event

Pool creation events from QuickSwap V3 DEX factory contract on Immutable zkEVM, capturing new liquidity pool deployments with token pairs, fee tiers (in basis points), and tick spacing configurations for analyzing market structure and LP deployment patterns.

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	block_number	in_tickSpacing	block_timestamp	transaction_hash
500	0x56c2162254b0e4417288786ee402c2b41d4e181e	0x525299ce36040baee478d17ec26fe5962a75a304	false	0x3a0c2ba54d6cbd3121f01b96dfd20e99d1696c9d	0x6de8acc0d406837030ce4dd28e7c08c5a96a30d2	1308995	10	2024-01-10T10:47:59.000Z	0xc7c683fa255b1e131ada7343d36ab78d1bafcd5cbc23d1c45f03526efd3f2072
100	0x56c2162254b0e4417288786ee402c2b41d4e181e	0x8dfdc0b03d1672cb8798736dc8c1d8cec304aec2	false	0x3a0c2ba54d6cbd3121f01b96dfd20e99d1696c9d	0xf61d97166dbaf0e397fd0c9eb7d9809ef5d24e71	5115684	1	2024-04-07T13:45:52.000Z	0x4cade5f7364af09e855638617f93aa6ef5d71e91db3d5c94ccd6e080cab6fdc7
10000	0x56c2162254b0e4417288786ee402c2b41d4e181e	0x424055790214df46c5baf91cc966fab1b2d74516	false	0x3a0c2ba54d6cbd3121f01b96dfd20e99d1696c9d	0x9b4c72f539ae3e2fb381fd1b706214b9a65763f3	5606444	200	2024-04-18T22:24:50.000Z	0xf756538c7884696b4b445ded0504b4ab7eb3195ff5582f03011500d902021bdd

Example Query

Query with partition filter

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

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	block_number	in_tickSpacing	block_timestamp	transaction_hash
10000	0x56c2162254b0e4417288786ee402c2b41d4e181e	0xc860785d8a1f6670f7ba9e4a336cd413523be6a6	false	0x3a0c2ba54d6cbd3121f01b96dfd20e99d1696c9d	0xb00ed913aaff8280c17bff33cce82fe6d79e85e8	3884726	200	2024-03-10T01:52:23.000Z	0xd5e0896abe720ac0b6f7a55caf88637f019a05b577a94675c0c908b2f73b60b7
10000	0x56c2162254b0e4417288786ee402c2b41d4e181e	0x768b702eb997ce303f763e69b7acb0052643cff6	false	0x52a6c53869ce09a731cd772f245b97a4401d3348	0x6de8acc0d406837030ce4dd28e7c08c5a96a30d2	4072208	200	2024-03-14T10:01:47.000Z	0xe39fb091671f97dbc1fb10f4537e6c69cc006a14f9223589811adb41c8f56578
100	0x56c2162254b0e4417288786ee402c2b41d4e181e	0xb80121a9a29259796df6439896b1da6f5342c658	false	0x52a6c53869ce09a731cd772f245b97a4401d3348	0x6de8acc0d406837030ce4dd28e7c08c5a96a30d2	1508624	1	2024-01-15T01:42:17.000Z	0x4bd7944ecad6517da826a64b7bfbfa0cf6ca389a501924bd1a816c136c7c03bb

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.quickswap_v3_immutablezkevm.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	in_amount0	in_amount1	block_number	in_tickLower	in_tickUpper	block_timestamp	transaction_hash
0x5f5664979ed0f8124e9910f9476b12304ed85e61	false	0xa5e0829caced8ffdd4de3c43696c57f7d7a678ff	64763834520909	50993999457271630098	82251917	3772570	-887220	887220	2024-03-07T11:33:51.000Z	0xb50e779bff0c055763145ff9f7addd2457b13657c04128630ad59a293896f752
0xf3fd6e78a832b67eb80c6683d696d50193576f3c	false	0xa5e0829caced8ffdd4de3c43696c57f7d7a678ff	556653092891159033	4426609511789904	69999999999999994390	3773105	-887220	887220	2024-03-07T11:51:41.000Z	0x8957933a7cdb6a83a6bf64a4e69b095f530d72fa4217341295e679515e712a0a
0xee997f15eaca3012e4825f1aefe12136216cf3af	false	0xa5e0829caced8ffdd4de3c43696c57f7d7a678ff	114290042244351649194	99499999997499999867	150091431052185039	3772357	-71820	-70380	2024-03-07T11:26:45.000Z	0x5e0bda229f0129a094d77a32b0da44854b6fc76b9881f432f5869b75793e3aa4

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.quickswap_v3_immutablezkevm.Pool_Burn_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
0x525299ce36040baee478d17ec26fe5962a75a304	false	0x6e9d701fb6478ed5972a37886c2ba6c82a4cbb4c	110769856384351	0x6e9d701fb6478ed5972a37886c2ba6c82a4cbb4c	27	7594442119372491395	17981424	5840003	-269690	-265230	2024-04-24T08:10:08.000Z	0x3b07c8cb9fe657244e9b2330688986571d4d71c8899c2ebe731998b2eaa2b9f9
0x525299ce36040baee478d17ec26fe5962a75a304	false	0x6e9d701fb6478ed5972a37886c2ba6c82a4cbb4c	1190729636694	0x6e9d701fb6478ed5972a37886c2ba6c82a4cbb4c	20	102803986001173114	143447	5858514	-269690	-265230	2024-04-24T18:27:10.000Z	0x71351351b3d8b535f8b93ccc93f819f26d4dfca2874b7616751916afb37c272c
0x525299ce36040baee478d17ec26fe5962a75a304	false	0x6e9d701fb6478ed5972a37886c2ba6c82a4cbb4c	2	0x6e9d701fb6478ed5972a37886c2ba6c82a4cbb4c	23	35282	1	5858514	-271410	-267490	2024-04-24T18:27:10.000Z	0x71351351b3d8b535f8b93ccc93f819f26d4dfca2874b7616751916afb37c272c

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.quickswap_v3_immutablezkevm.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
0x525299ce36040baee478d17ec26fe5962a75a304	-265866	false	0x6c28aef8977c9b773996d0e8376d2ee379446f2f	3	155055385429746436262	-467000000	3821063	4695922637569220	0x0da76aa41275dbed112f17b139b36513a99172d9	2024-03-08T14:30:17.000Z	133648693738452290657700	0x969059bfe2f6ae6c8f95df09db69a2bc69d680639bee0fbd2bb381624e28d9c0
0xee997f15eaca3012e4825f1aefe12136216cf3af	-70765	false	0x6c28aef8977c9b773996d0e8376d2ee379446f2f	3	115000000000000000000	-97095496517228572	3826218	1583435710200812892732	0x0da76aa41275dbed112f17b139b36513a99172d9	2024-03-08T17:22:07.000Z	2303165073261110618332447346	0x00817629684d6abfa7acd5b7a7ee9aa9f5e1cd38c30390ee2255c8c738d7999f
0xb80121a9a29259796df6439896b1da6f5342c658	-193698	false	0x6c28aef8977c9b773996d0e8376d2ee379446f2f	3	5206467887734876	-20188980	3836671	404687810517699	0x2a9f63d7ae95a5447eb26df7162e527b6980e68e	2024-03-08T23:10:33.000Z	4931884954136944482735809	0x207c86949b54965ed0b3f699cf4b85af01f8d75fea8739cf1c81eb495d870053

Example Query

Query with partition filter

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

Overview

Metrics

Primitives

Contracts

Blockchain

Tables

factory_PoolCreated_event

Factory_PoolCreated_event

Pool_Burn_event

Pool_Mint_event

Pool_Swap_event

​Tables

​factory_PoolCreated_event

​Factory_PoolCreated_event

​Pool_Burn_event

​Pool_Mint_event

​Pool_Swap_event

Tables

factory_PoolCreated_event

Factory_PoolCreated_event

Pool_Burn_event

Pool_Mint_event

Pool_Swap_event