quickswap_v3_manta

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
10000	0x56c2162254b0e4417288786ee402c2b41d4e181e	0x607bc7d1852b6365f059bc0f6b188bb314590fee	false	0xb73603c5d87fa094b7314c74ace2e64d165016fb	0xbc4b38fdf8057ef4739ec5756faf63f6d853a828	3	1013430	200	2024-01-04T08:50:59.000Z	0xad848e659ce5838fd57e0c863e2c9a6cd518734bdccd859441a23013e739ddd4
100	0x56c2162254b0e4417288786ee402c2b41d4e181e	0xa148a7e44da4c7f9386c8c2f9efae340175bab60	false	0x0dc808adce2099a9f62aa87d9670745aba741746	0xcdbcd550d332b19e9c76b22166d9c32d076a3e8c	16	958376	1	2023-12-28T23:55:19.000Z	0xf80142963797c5f14ebd80ff3176cca9f6f21a12e5cb9ffc317ae8e41f7ad730
100	0x56c2162254b0e4417288786ee402c2b41d4e181e	0xba411f7a5be3dff6663ee3fa1918fcdcdda53055	false	0xb73603c5d87fa094b7314c74ace2e64d165016fb	0xbdad407f77f44f7da6684b416b1951eca461fb07	4	954755	1	2023-12-28T13:51:49.000Z	0x54af4a281c995ffe6174b41396999865dc466ee911041c0b28d6d211d62c0831

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.quickswap_v3_manta.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_amount0	in_amount1	block_number	in_tickLower	in_tickUpper	block_timestamp	transaction_hash
0x12cdded759b14bf6a34fbf6638aec9b735824a9e	false	0xa5e0829caced8ffdd4de3c43696c57f7d7a678ff	836769043974	7	1312995598320561	2385069	1912295	-197044	-194167	2024-04-17T09:41:49.000Z	0xab33105d6971c2c5c7cb9a882c9863cde5f7dbd7400122d0deccddc563ef8308
0x12cdded759b14bf6a34fbf6638aec9b735824a9e	false	0x63ccd0af9d8a452054d26dcdfc82ad0045753c94	201043996557743	1	1099452604280544299	3151416939	1916028	-202981	-189117	2024-04-17T20:03:59.000Z	0x326a78964baa9f219f31caa0cb6ae9b49531122a072019f033e4c98cc9b5c906
0x12cdded759b14bf6a34fbf6638aec9b735824a9e	false	0xa5e0829caced8ffdd4de3c43696c57f7d7a678ff	1539590772916	18	639805715849193	19202179	1915595	-201268	-195672	2024-04-17T18:51:49.000Z	0x5a747e5ba0dc129403b9de443912aeb52100743186bc33d6ec76d4cd2f633865

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.quickswap_v3_manta.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_amount0	in_amount1	block_number	in_recipient	in_tickLower	in_tickUpper	block_timestamp	transaction_hash
0x1a6378383258a5d8ae40d383200ae29c53e85af9	false	0x099dd23eaab20f5ec43f50055d6e3030c66cc182	2	782510731856200000	0	1407057	0x099dd23eaab20f5ec43f50055d6e3030c66cc182	-79980	-78480	2024-02-18T22:15:29.000Z	0x2f21c31df897b930aa5fb3d13b85487e822c540d6a1842693db52647e40c0dba
0x1a6378383258a5d8ae40d383200ae29c53e85af9	false	0x099dd23eaab20f5ec43f50055d6e3030c66cc182	16	16273333044010178108983	0	1407057	0x099dd23eaab20f5ec43f50055d6e3030c66cc182	-79380	-74220	2024-02-18T22:15:29.000Z	0x2f21c31df897b930aa5fb3d13b85487e822c540d6a1842693db52647e40c0dba
0x1a6378383258a5d8ae40d383200ae29c53e85af9	false	0x099dd23eaab20f5ec43f50055d6e3030c66cc182	13	1985446581835881578178	328031041037201664	1407057	0x099dd23eaab20f5ec43f50055d6e3030c66cc182	-79980	-78480	2024-02-18T22:15:29.000Z	0x2f21c31df897b930aa5fb3d13b85487e822c540d6a1842693db52647e40c0dba

Example Query

Query with partition filter

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

address	removed	in_paid0	in_sender	log_index	in_amount0	block_number	in_recipient	block_timestamp	transaction_hash
0x366b51393de6af97b28650148c764113ee9c2fbf	false	41943040000	0x7c4e501044811e379bccbf7025f9a01749dfabac	14	419430400000000	2105442	0x7c4e501044811e379bccbf7025f9a01749dfabac	2024-05-09T18:12:59.000Z	0xf032b74a28b4c41bdebaf7fa345d1ce4469cf0f37e55cda806832eaa0389c111
0x366b51393de6af97b28650148c764113ee9c2fbf	false	41943040000	0x7c4e501044811e379bccbf7025f9a01749dfabac	33	419430400000000	2105413	0x7c4e501044811e379bccbf7025f9a01749dfabac	2024-05-09T18:08:09.000Z	0xdb05330d5f942498bc100d92a41828fd12bea3793655a3f2cb052f78c99c9a8d
0x366b51393de6af97b28650148c764113ee9c2fbf	false	335544320000	0x7c4e501044811e379bccbf7025f9a01749dfabac	23	3355443200000000	2105403	0x7c4e501044811e379bccbf7025f9a01749dfabac	2024-05-09T18:06:29.000Z	0x60c868c02595f440620a8d8b137415df1ab0a22d3558a47107f288ba428cdbcf

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.quickswap_v3_manta.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
0x739ee4c59ed05fcaab772ee6cee1f39d360740be	false	0x0d8f8eb720f4e3c1bcaa50c78339f796cd4a380f	9798842798	0x0d8f8eb720f4e3c1bcaa50c78339f796cd4a380f	29	4061276930586	7444	1204508	-199470	-198750	2024-01-26T11:37:19.000Z	0xbff03dd82e269d257a719232f9b03877096ce9d3a99faae2b2719927a8dbe590
0x739ee4c59ed05fcaab772ee6cee1f39d360740be	false	0x0d8f8eb720f4e3c1bcaa50c78339f796cd4a380f	9800159139	0x0d8f8eb720f4e3c1bcaa50c78339f796cd4a380f	25	4061822507798	7445	1204502	-199470	-198750	2024-01-26T11:36:19.000Z	0x429229338f6af01804e8d9a74d936289fc6e1de2263a382dce6f4aa7b47cf6cc
0x739ee4c59ed05fcaab772ee6cee1f39d360740be	false	0x0d8f8eb720f4e3c1bcaa50c78339f796cd4a380f	3576314941	0x0d8f8eb720f4e3c1bcaa50c78339f796cd4a380f	31	18900570585856	0	1204508	-199140	-193370	2024-01-26T11:37:19.000Z	0xbff03dd82e269d257a719232f9b03877096ce9d3a99faae2b2719927a8dbe590

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.quickswap_v3_manta.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
0x024008e268a970a59e0eb07d940375b56de2d947	60618	false	0xfde3eac61c5ad5ed617eb1451cc7c3a0ac197564	18	2334	-1003137	1270913	16214217	0xcbc92a43d1a2a1177b4634c355754166bdf8d089	2024-02-03T04:04:49.000Z	1641104126351187771742037590792	0x9a3be48eca3c7a2f78481b9889a925006a7a111689b33b6dfdd63880a5904607
0x024008e268a970a59e0eb07d940375b56de2d947	60600	false	0xfde3eac61c5ad5ed617eb1451cc7c3a0ac197564	13	334	-142674	1277594	16214217	0x051d7518bbc60842d440ae3ff5e56edee76075a7	2024-02-03T22:38:19.000Z	1639600212418256501877276091190	0xb9a1891218c8be2744c71e2992cfa0ac498d0b1eac03904800e337badf8bbe80
0x024008e268a970a59e0eb07d940375b56de2d947	60609	false	0xfde3eac61c5ad5ed617eb1451cc7c3a0ac197564	15	386	-165105	1277005	16214217	0x85d948cbe9fcd30db164bf0aa4545cc6f0a7faca	2024-02-03T21:00:09.000Z	1640297367219204717398780485412	0x84ce8bcd5062689d45dfaf94cf25b788e9fec8726b3aa179ce0bb8393a48d5d1

Example Query

Query with partition filter

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