apertureswap_v1_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
100	0x5bd1f6735b80e58aac88b8a94836854d3068a13a	0xdc82144246f20b7591c26a9338a7adae2a6bdfd5	false	0x0dc808adce2099a9f62aa87d9670745aba741746	0xb73603c5d87fa094b7314c74ace2e64d165016fb	0	277063	1	2023-10-11T03:23:09.000Z	0x6fa0b65442a7f1bebb37955a05e4602d121aca68ee95f5841f4df3bd6d17760c
100	0x5bd1f6735b80e58aac88b8a94836854d3068a13a	0xb1d248be37c19c3c1539be906c85c617a91323ba	false	0x0dc808adce2099a9f62aa87d9670745aba741746	0x2fe3ad97a60eb7c79a976fc18bb5ffd07dd94ba5	0	57852	1	2023-09-15T18:27:59.000Z	0xfdcf9127f4aeaafca54e65b04ff05a2a60f2176ad031bd98152febd7e29f6cb6
100	0x5bd1f6735b80e58aac88b8a94836854d3068a13a	0xa10206a00dcab230fa85b6d77e902f532a6ef14a	false	0x1c466b9371f8aba0d7c458be10a62192fcb8aa71	0xf417f5a458ec102b90352f697d6e2ac3a3d2851f	168	53359	1	2023-09-15T05:59:09.000Z	0xbf4a863f982a394421898f988b5680bee0430ba2c1aef8f02fc8a1a0e6a5b16c

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.apertureswap_v1_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
0x7cb96b00c02e9d93ce32a06ebd6f47c13643942e	false	0xe77e3f98a386a4c8f8c706a2acffdf57e70d06c6	10213310683742300	0	679071796016223	340401083865172	130769	-2060	-50	2023-09-24T05:00:49.000Z	0x2ce665ac3979c5f8d05810a083a1bb8056f8c9ae1fe11e5b34e0d9d74f54078c
0x553f4ebe95a796af390019b9dbdd8e94014780c5	false	0xe77e3f98a386a4c8f8c706a2acffdf57e70d06c6	0	43	0	0	773749	21600	23580	2023-12-07T15:04:09.000Z	0x4170e4a527236b99b4aa60c72e625cecc6da27f250be896d133a90536387a910
0x553f4ebe95a796af390019b9dbdd8e94014780c5	false	0xe77e3f98a386a4c8f8c706a2acffdf57e70d06c6	0	16	0	0	773354	22440	23580	2023-12-07T13:58:19.000Z	0xca5ecfc1312e8ac8d87952703956984331a8543894c591300c4d93c3f675f8a6

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.apertureswap_v1_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
0xfee7caae3540d7dbe325b34e57e596139cc81f4e	false	0xe77e3f98a386a4c8f8c706a2acffdf57e70d06c6	4	1547891073	1523287235	448571	0xb99b470cf2db7e2963f5f28d7f701454d09b783f	-100	100	2023-10-30T23:47:49.000Z	0x7d5c4649e4ed594af9211d5e060b532068ddb0200dadb2d2c86f5cd9b730024c
0xd7f09148eb22686cb5dcbdd0cf27d04123d14c74	false	0xe77e3f98a386a4c8f8c706a2acffdf57e70d06c6	4	1355302903331	2163474	444018	0xe77e3f98a386a4c8f8c706a2acffdf57e70d06c6	-203570	-201570	2023-10-30T11:08:59.000Z	0xd3d59a52ba24a340d86aa37dc48698adf4d229fc4acc581e50ab1299e31fb035
0xd7f09148eb22686cb5dcbdd0cf27d04123d14c74	false	0xe77e3f98a386a4c8f8c706a2acffdf57e70d06c6	4	7502021370079	3905216	444627	0xe77e3f98a386a4c8f8c706a2acffdf57e70d06c6	-203360	-201350	2023-10-30T12:50:29.000Z	0xc3f5dca1990177c22cbff9a552d3adf6ac39a685bf7f98c8c66705a0d29c698e

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.apertureswap_v1_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_paid1	in_sender	log_index	in_amount0	in_amount1	block_number	in_recipient	block_timestamp	transaction_hash
0x553f4ebe95a796af390019b9dbdd8e94014780c5	false	51538	0	0x21bf277a0e437ec1936edb7cb7a3c0acea62290c	14	17179309	0	880736	0x0839649fc7cbf74fea6978affdce3cadd7495f06	2023-12-20T00:15:19.000Z	0x3e387037267da68285f5c61aa01f1bffe7ecae14dd0c318cac996a301c1bbd50
0x177b0d886f673a0d1df92a906689068394e1b5af	false	0	603192606915178863	0x21bf277a0e437ec1936edb7cb7a3c0acea62290c	36	0	60319260691517886203	973940	0x0839649fc7cbf74fea6978affdce3cadd7495f06	2023-12-30T19:09:19.000Z	0x27fb060fd436a6c2d050871869a84b47d297c1d63310845c6543c340bb2e871e
0xa28ec66e6b3936fa80d3314cd3d09f2726fc989e	false	0	9332	0x21bf277a0e437ec1936edb7cb7a3c0acea62290c	54	0	933166	969404	0x0839649fc7cbf74fea6978affdce3cadd7495f06	2023-12-30T06:33:19.000Z	0x80634b8693ff58e727b0f3694567b90394fd50bbdedb206f540288eb40aa1fd6

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.apertureswap_v1_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
0xd7f09148eb22686cb5dcbdd0cf27d04123d14c74	false	0xe77e3f98a386a4c8f8c706a2acffdf57e70d06c6	188334702673	0xe77e3f98a386a4c8f8c706a2acffdf57e70d06c6	23	3226199533142535	5139845	354936	-225690	-179640	2023-10-20T03:41:59.000Z	0x194904673d93b28da6f4c60e038504ff1d8b4fd4ce26b9da1520fd5ffa93dc88
0xd7f09148eb22686cb5dcbdd0cf27d04123d14c74	false	0xe77e3f98a386a4c8f8c706a2acffdf57e70d06c6	192463170187	0xe77e3f98a386a4c8f8c706a2acffdf57e70d06c6	33	3306835279616442	5236792	356068	-225690	-179640	2023-10-20T06:50:39.000Z	0x4ad2e194bb1717c6aa9aa9f3442dd863ee10febbd85b84cb95438d3fb716124a
0xd7f09148eb22686cb5dcbdd0cf27d04123d14c74	false	0xe77e3f98a386a4c8f8c706a2acffdf57e70d06c6	5553186496061	0xe77e3f98a386a4c8f8c706a2acffdf57e70d06c6	19	3998417871079622	6732089	361142	-203120	-201920	2023-10-20T20:56:19.000Z	0x7a0cacc86296ecc51e8d5abc7cf5157a7246cdc3ded8b6cd361957bb560439bf

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.apertureswap_v1_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
0x016b36fe5a322e1bffcec489335fb4543f1f5c41	-283188	false	0x3488d5a2d0281f546e43435715c436b46ec1c678	13	-161903107163354	76	193356	1000000000	0x2c772eef4aa4af21bab416654bbaa25cf341c1bf	2023-10-01T10:51:59.000Z	56213615307069063932670	0x16ed108a605862d3b538e87b7380813273efa9d3b211894d2dfb1994de4ea3ed
0x5fc070379287d52826fa532bde1270897e2b44a2	-286483	false	0x3488d5a2d0281f546e43435715c436b46ec1c678	10	200000000000043	-76	193356	2000000000	0x3488d5a2d0281f546e43435715c436b46ec1c678	2023-10-01T10:51:59.000Z	47675679661579484576309	0x16ed108a605862d3b538e87b7380813273efa9d3b211894d2dfb1994de4ea3ed
0xffeee0b83fd00032cb035b57a725c9670dfa6f2f	-201893	false	0x3488d5a2d0281f546e43435715c436b46ec1c678	10	-14937361243743959	25103127	197601	34663529615606	0x3488d5a2d0281f546e43435715c436b46ec1c678	2023-10-01T22:39:29.000Z	3273880058681423597423452	0x7e4fc3be1756b1d58bea87cb54706e52266312f1c624f8f364169a7c45880fba

Example Query

Query with partition filter

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