Skip to main content

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.
ColumnTypeDescription
block_timestampTIMESTAMPTimestamp when the block was produced. UTC timezone, millisecond precision.
block_numberINT64Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
transaction_hashSTRINGUnique identifier for the transaction. 66-character hex string including 0x prefix.
log_indexINT64Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
addressSTRINGContract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
removedBOOLBoolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
in_token0STRINGContract address of the first token in the trading pair. Hex-encoded, 0x-prefixed, 42-character string.
in_token1STRINGContract address of the second token in the trading pair. Hex-encoded, 0x-prefixed, 42-character string.
in_feeSTRINGFee 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_tickSpacingINT64Minimum price movement increment between adjacent ticks in a concentrated liquidity pool.
in_poolSTRINGContract address of the pool being referenced in the event. Hex-encoded, 0x-prefixed, 42-character string.
in_feeaddressin_poolremovedin_token0in_token1log_indexblock_numberin_tickSpacingblock_timestamptransaction_hash
1000x5bd1f6735b80e58aac88b8a94836854d3068a13a0xb1d248be37c19c3c1539be906c85c617a91323bafalse0x0dc808adce2099a9f62aa87d9670745aba7417460x2fe3ad97a60eb7c79a976fc18bb5ffd07dd94ba505785212023-09-15T18:27:59.000Z0xfdcf9127f4aeaafca54e65b04ff05a2a60f2176ad031bd98152febd7e29f6cb6
1000x5bd1f6735b80e58aac88b8a94836854d3068a13a0x2dc3bf572b1d489a2f8e544d1ab96e64cd3f4a63false0x1c466b9371f8aba0d7c458be10a62192fcb8aa710xb73603c5d87fa094b7314c74ace2e64d165016fb05332812023-09-15T05:53:59.000Z0x255771129e0205e8f5a5e2790586103eef2e95cced82293100f30fa6e5a49f09
1000x5bd1f6735b80e58aac88b8a94836854d3068a13a0xa10206a00dcab230fa85b6d77e902f532a6ef14afalse0x1c466b9371f8aba0d7c458be10a62192fcb8aa710xf417f5a458ec102b90352f697d6e2ac3a3d2851f1685335912023-09-15T05:59:09.000Z0xbf4a863f982a394421898f988b5680bee0430ba2c1aef8f02fc8a1a0e6a5b16c
Query with partition filter
SELECT *
FROM `tt-contracts.aperture_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.
ColumnTypeDescription
block_timestampTIMESTAMPTimestamp when the block was produced. UTC timezone, millisecond precision.
block_numberINT64Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
transaction_hashSTRINGUnique identifier for the transaction. 66-character hex string including 0x prefix.
log_indexINT64Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
addressSTRINGContract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
removedBOOLBoolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
in_ownerSTRINGAddress that owns or controls the shares or position being deposited or withdrawn. Hex-encoded, 0x-prefixed, 42-character string.
in_tickLowerINT64Lower 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_tickUpperINT64Upper 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_amountSTRINGInput amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination.
in_amount0STRINGAmount of token0 involved in the liquidity pool operation. Numeric string representation of token quantity in smallest denomination.
in_amount1STRINGAmount of token1 involved in the liquidity pool operation. Numeric string representation of token quantity in smallest denomination.
addressremovedin_ownerin_amountlog_indexin_amount0in_amount1block_numberin_tickLowerin_tickUpperblock_timestamptransaction_hash
0x06b949b314affb56a4ff181182e90f8db45088bcfalse0xe77e3f98a386a4c8f8c706a2acffdf57e70d06c6684099767657549999999999944330466557-195180-1842002023-11-02T01:45:29.000Z0xa665f579d1fff8833cea600e254f540cd515dca52ccef7bc8f0c63d198a045a8
0x2dc3bf572b1d489a2f8e544d1ab96e64cd3f4a63false0xe77e3f98a386a4c8f8c706a2acffdf57e70d06c639679246736530124015983280707291265252466857-277376-2753692023-11-02T02:35:29.000Z0xf2abaed62718ee174e9e1e53f6a889772b0b8e2ffd250c5faff5f7548429f7cf
0x2eacae338757a0da399468b41db5d02f5e0e9a19false0xe77e3f98a386a4c8f8c706a2acffdf57e70d06c60200467453980601000602023-11-02T04:14:49.000Z0x7aa1030797791e396f14fe82badb6175f99b5c0289e9e9a6d861f71f86289540
Query with partition filter
SELECT *
FROM `tt-contracts.aperture_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.
ColumnTypeDescription
block_timestampTIMESTAMPTimestamp when the block was produced. UTC timezone, millisecond precision.
block_numberINT64Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
transaction_hashSTRINGUnique identifier for the transaction. 66-character hex string including 0x prefix.
log_indexINT64Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
addressSTRINGContract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
removedBOOLBoolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
in_ownerSTRINGAddress that owns or controls the shares or position being deposited or withdrawn. Hex-encoded, 0x-prefixed, 42-character string.
in_recipientSTRINGAddress designated to receive the output tokens from a swap or operation. Hex-encoded, 0x-prefixed, 42-character string.
in_tickLowerINT64Lower 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_tickUpperINT64Upper 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_amount0STRINGAmount of token0 involved in the liquidity pool operation. Numeric string representation of token quantity in smallest denomination.
in_amount1STRINGAmount of token1 involved in the liquidity pool operation. Numeric string representation of token quantity in smallest denomination.
addressremovedin_ownerlog_indexin_amount0in_amount1block_numberin_recipientin_tickLowerin_tickUpperblock_timestamptransaction_hash
0xd7f09148eb22686cb5dcbdd0cf27d04123d14c74false0xe77e3f98a386a4c8f8c706a2acffdf57e70d06c64128314868787857577203741599150xe77e3f98a386a4c8f8c706a2acffdf57e70d06c6-204220-2022202023-09-27T13:58:29.000Z0x029c83d84e68a091a51d63d2d2d73b659b93fa63433268d03036a41f3c3282c9
0x96ae63822c9a8a207274a2a77491f8c29068a3ccfalse0xe77e3f98a386a4c8f8c706a2acffdf57e70d06c6473726505002879999992996680xe77e3f98a386a4c8f8c706a2acffdf57e70d06c6-203820-2018402023-10-13T18:10:39.000Z0x06877131908df69cdeacedef8fc5d6803f9496892ea808de2a58506d0cdf0eb1
0xb1d248be37c19c3c1539be906c85c617a91323bafalse0xe77e3f98a386a4c8f8c706a2acffdf57e70d06c641948505642766662281881643477739767992980370xe77e3f98a386a4c8f8c706a2acffdf57e70d06c6-2386-3792023-10-13T13:38:49.000Z0xcab4e2c203ae65049b47e4bffb4538c1f7ab580bff160317197063e318aa85c8
Query with partition filter
SELECT *
FROM `tt-contracts.aperture_v1_manta.Pool_Collect_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

Pool_CollectProtocol_event

Protocol fee collection events from concentrated liquidity pools, recording fees withdrawn by the protocol from trading activity. Contains token amounts collected (amount0, amount1), sender address initiating the collection, and recipient address receiving the fees.
ColumnTypeDescription
block_timestampTIMESTAMPTimestamp when the block was produced. UTC timezone, millisecond precision.
block_numberINT64Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
transaction_hashSTRINGUnique identifier for the transaction. 66-character hex string including 0x prefix.
log_indexINT64Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
addressSTRINGContract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
removedBOOLBoolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
in_senderSTRINGAddress that initiated the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string.
in_recipientSTRINGAddress designated to receive the output tokens from a swap or operation. Hex-encoded, 0x-prefixed, 42-character string.
in_amount0STRINGAmount of token0 involved in the liquidity pool operation. Numeric string representation of token quantity in smallest denomination.
in_amount1STRINGAmount of token1 involved in the liquidity pool operation. Numeric string representation of token quantity in smallest denomination.
No sample data available.
Query with partition filter
SELECT *
FROM `tt-contracts.aperture_v1_manta.Pool_CollectProtocol_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.
ColumnTypeDescription
block_timestampTIMESTAMPTimestamp when the block was produced. UTC timezone, millisecond precision.
block_numberINT64Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
transaction_hashSTRINGUnique identifier for the transaction. 66-character hex string including 0x prefix.
log_indexINT64Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
addressSTRINGContract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
removedBOOLBoolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
in_senderSTRINGAddress that initiated the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string.
in_recipientSTRINGAddress designated to receive the output tokens from a swap or operation. Hex-encoded, 0x-prefixed, 42-character string.
in_amount0STRINGAmount of token0 involved in the liquidity pool operation. Numeric string representation of token quantity in smallest denomination.
in_amount1STRINGAmount of token1 involved in the liquidity pool operation. Numeric string representation of token quantity in smallest denomination.
in_paid0STRINGAmount of token0 paid as flash loan fee. Numeric string representation of token quantity in smallest denomination.
in_paid1STRINGAmount of token1 paid as flash loan fee. Numeric string representation of token quantity in smallest denomination.
addressremovedin_paid0in_paid1in_senderlog_indexin_amount0in_amount1block_numberin_recipientblock_timestamptransaction_hash
0x553f4ebe95a796af390019b9dbdd8e94014780c5false54900x21bf277a0e437ec1936edb7cb7a3c0acea62290c2618272206450960x0839649fc7cbf74fea6978affdce3cadd7495f062023-11-22T17:41:59.000Z0x7f9f6383ef835ce3a1637c9354973efdfc70d21a428230cdc1504988e682e5cd
0x02b25ffb7269fc167f8959de9a1bcd4213c06aaffalse429305886230600xef83900594d75f0a919cf6a1097c7899d6eceede128586117724610891011318410xef83900594d75f0a919cf6a1097c7899d6eceede2024-01-18T01:46:09.000Z0x789138283866607bea6295d88dd4694c6cd597a48e9c924090b041550a72e3a9
0x02b25ffb7269fc167f8959de9a1bcd4213c06aaffalse1855794260512800xef83900594d75f0a919cf6a1097c7899d6eceede1437115885210255692011330950xef83900594d75f0a919cf6a1097c7899d6eceede2024-01-18T05:15:09.000Z0x660458bd383d089a0a1e0801c922033c360c2fcc516515e9bacf0ccbba0f54c7
Query with partition filter
SELECT *
FROM `tt-contracts.aperture_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.
ColumnTypeDescription
block_timestampTIMESTAMPTimestamp when the block was produced. UTC timezone, millisecond precision.
block_numberINT64Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
transaction_hashSTRINGUnique identifier for the transaction. 66-character hex string including 0x prefix.
log_indexINT64Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
addressSTRINGContract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
removedBOOLBoolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
in_senderSTRINGAddress that initiated the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string.
in_ownerSTRINGAddress that owns or controls the shares or position being deposited or withdrawn. Hex-encoded, 0x-prefixed, 42-character string.
in_tickLowerINT64Lower 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_tickUpperINT64Upper 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_amountSTRINGInput amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination.
in_amount0STRINGAmount of token0 involved in the liquidity pool operation. Numeric string representation of token quantity in smallest denomination.
in_amount1STRINGAmount of token1 involved in the liquidity pool operation. Numeric string representation of token quantity in smallest denomination.
addressremovedin_ownerin_amountin_senderlog_indexin_amount0in_amount1block_numberin_tickLowerin_tickUpperblock_timestamptransaction_hash
0xd7f09148eb22686cb5dcbdd0cf27d04123d14c74false0xe77e3f98a386a4c8f8c706a2acffdf57e70d06c696389787402040xe77e3f98a386a4c8f8c706a2acffdf57e70d06c621856358036425870631001431191073-204240-2009602023-10-01T04:31:29.000Z0x0b98708508ac236db269f619eb8d05f0e6ce34e0f8fbf843653facfa92d8b630
0xb1d248be37c19c3c1539be906c85c617a91323bafalse0xe77e3f98a386a4c8f8c706a2acffdf57e70d06c6170999500838594890xe77e3f98a386a4c8f8c706a2acffdf57e70d06c63928352353719060752294386280930193364-4149-21422023-10-01T10:53:19.000Z0x7694775bb0533dc643d1c25158aa0fed619c9022dc723bd7e281b80c8d3d9ab6
0xffeee0b83fd00032cb035b57a725c9670dfa6f2ffalse0xe77e3f98a386a4c8f8c706a2acffdf57e70d06c6191174301849540xe77e3f98a386a4c8f8c706a2acffdf57e70d06c632991654282098142742257475193694-203660-2012302023-10-01T11:48:19.000Z0xc3dcc571a94418974be30979d9be31f5fb4d01f26acd17519f2b78bd44b662b5
Query with partition filter
SELECT *
FROM `tt-contracts.aperture_v1_manta.Pool_Mint_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

Pool_SetFeeProtocol_event

Protocol fee configuration change events emitted when liquidity pool fee parameters are updated. Records old and new fee protocol values for both tokens in the pool, tracking governance-initiated fee structure modifications.
ColumnTypeDescription
block_timestampTIMESTAMPTimestamp when the block was produced. UTC timezone, millisecond precision.
block_numberINT64Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
transaction_hashSTRINGUnique identifier for the transaction. 66-character hex string including 0x prefix.
log_indexINT64Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
addressSTRINGContract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
removedBOOLBoolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
in_feeProtocol0OldINT64Previous protocol fee for token0. Integer value representing the fee denominator where the protocol collected 1/x of swap fees before the update.
in_feeProtocol1OldINT64Previous protocol fee for token1. Integer value representing the fee denominator where the protocol collected 1/x of swap fees before the update.
in_feeProtocol0NewINT64New protocol fee for token0. Integer value representing the fee denominator where the protocol collects 1/x of swap fees.
in_feeProtocol1NewINT64New protocol fee for token1. Integer value representing the fee denominator where the protocol collects 1/x of swap fees.
No sample data available.
Query with partition filter
SELECT *
FROM `tt-contracts.aperture_v1_manta.Pool_SetFeeProtocol_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.
ColumnTypeDescription
block_timestampTIMESTAMPTimestamp when the block was produced. UTC timezone, millisecond precision.
block_numberINT64Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
transaction_hashSTRINGUnique identifier for the transaction. 66-character hex string including 0x prefix.
log_indexINT64Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
addressSTRINGContract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
removedBOOLBoolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
in_senderSTRINGAddress that initiated the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string.
in_recipientSTRINGAddress designated to receive the output tokens from a swap or operation. Hex-encoded, 0x-prefixed, 42-character string.
in_amount0STRINGAmount of token0 involved in the liquidity pool operation. Numeric string representation of token quantity in smallest denomination.
in_amount1STRINGAmount of token1 involved in the liquidity pool operation. Numeric string representation of token quantity in smallest denomination.
in_sqrtPriceX96STRINGSquare 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_liquiditySTRINGTotal liquidity available in the pool at the time of the event. Numeric string representation of liquidity in smallest denomination.
in_tickINT64Current 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.
addressin_tickremovedin_senderlog_indexin_amount0in_amount1block_numberin_liquidityin_recipientblock_timestampin_sqrtPriceX96transaction_hash
0xdc82144246f20b7591c26a9338a7adae2a6bdfd5-202571false0x3488d5a2d0281f546e43435715c436b46ec1c6786998336535188042-15933533634611179445317734930x70260dd7ae1a8c1524946e73d72dfca71e7a5bd02023-10-21T03:22:49.000Z31647941124981403994516300x7b8d2856fe0fe4640f25a8829f01700ed3f4fc34d4cf1ff54a856766b0211eda
0xdc82144246f20b7591c26a9338a7adae2a6bdfd5-202554false0x3488d5a2d0281f546e43435715c436b46ec1c67831100000000000000-1598093645821179445317734930x655d008f8e51d77d854966b7fff6455d50da2a752023-10-21T06:29:39.000Z31673469336752471706942780x054ed16ca1bbe736dc5a86f4ee1f97c3c3d3d1b1f66a4b727a1c6fe6a0a52b28
0xdc82144246f20b7591c26a9338a7adae2a6bdfd5-202527false0x3488d5a2d0281f546e43435715c436b46ec1c67873000000000000000-48122293654461179445317734930xd913c0eff133fde760b66070fe9b7e9f5502d3992023-10-21T08:53:39.000Z31717039549003582157983160x1c71258e02eec791cb945fe822ab9b3f6f82b13a27c7f890b0ca563014b0e1c8
Query with partition filter
SELECT *
FROM `tt-contracts.aperture_v1_manta.Pool_Swap_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100