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
100000x0bfbcf9fa4f9c56b0f40a671ad40e0805a0918650x7b26e6f221010b095ac6cc7b049b715b30c02d1afalse0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc20xc41d2b3f3fa4f927104be7011f6f4debd1764ffe232172375292002023-05-11T13:53:11.000Z0xdd03a2654de58e1d3f735730a327d38b143a54c79439d4d3aba003b325ab81a6
1000x0bfbcf9fa4f9c56b0f40a671ad40e0805a0918650x91e1233e5efeb8833b67d7e41d6a8285dd8cce13false0x35aa01f3bffc0b0dcab259a05840c0525b987ee00xdac17f958d2ee523a2206206994597c13d831ec72571833504412023-10-12T14:50:23.000Z0x09c2d1fab7156b4b20d27bb74ed3f0bf567e50163e06398d355642f30822ccd5
25000x0bfbcf9fa4f9c56b0f40a671ad40e0805a0918650x3fc47be8264e473dd2b3e80d144f9efffc18f438false0x14778860e937f509e651192a90589de711fb88a90xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc227617917925502023-08-15T04:41:35.000Z0x27c613b0c74e885e8901b07a73b498d964afb718d7a7b226f2b93a9d30b3fd24
Query with partition filter
SELECT *
FROM `tt-contracts.pancakeswap_v3_ethereum.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
0x04c8577958ccc170eb3d2cca76f9d51bc6e42d8ffalse0x46a15b0b27311cedf172ab29e4f4766fbe7f4364572576362834953160114543903675017030970-8-42023-04-12T09:14:35.000Z0x58ab416a1dd24cdb0bb471929208204569258dfcd4601976a7d07dc7cb80841a
0x04c8577958ccc170eb3d2cca76f9d51bc6e42d8ffalse0x46a15b0b27311cedf172ab29e4f4766fbe7f436413596382623749323983670750421202399999817031107-11-82023-04-12T09:41:59.000Z0xcde860aa2bb99a9a1c73ba60327bd71e30affcf91a2bef319743a10040921819
0x04c8577958ccc170eb3d2cca76f9d51bc6e42d8ffalse0x46a15b0b27311cedf172ab29e4f4766fbe7f436413596382624129428515663340601202399999817031054-11-92023-04-12T09:31:23.000Z0x56598cd1feb8c6694c68e27e478a40a01ca76ebce8ec79b53979191f3f9bccbf
Query with partition filter
SELECT *
FROM `tt-contracts.pancakeswap_v3_ethereum.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
0x04c8577958ccc170eb3d2cca76f9d51bc6e42d8ffalse0x46a15b0b27311cedf172ab29e4f4766fbe7f43647786900971598875982596175138240x1980475c3a279935ca611c9a41f17974ebc2e050-412023-06-19T12:34:35.000Z0x1a5b8c11537faaddd251a2c70da6fa5dd812a90eba8298b087cac57e3afcccd8
0x04c8577958ccc170eb3d2cca76f9d51bc6e42d8ffalse0x46a15b0b27311cedf172ab29e4f4766fbe7f436425184885511996380800892175166020xa8d7f201936eae4d51095ed70d36f06fdc91dc4d042023-06-19T21:57:47.000Z0x72bfac694d8002c041bd86eca26dbc11f638ad24d2f19ba2bd95023945dd2ac3
0x04c8577958ccc170eb3d2cca76f9d51bc6e42d8ffalse0x46a15b0b27311cedf172ab29e4f4766fbe7f4364142587636903254427089779732175103270xa8d7f201936eae4d51095ed70d36f06fdc91dc4d262023-06-19T00:48:23.000Z0x33740d2b55f3d7624a38e0b3c9e754752ef65bca3386c27939d1c1d6693a7147
Query with partition filter
SELECT *
FROM `tt-contracts.pancakeswap_v3_ethereum.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.
addressremovedin_senderlog_indexin_amount0in_amount1block_numberin_recipientblock_timestamptransaction_hash
0x54e30a703e9b6068cf0eb317c4192223e62cfcddfalse0x0c0388e4bbf121a06ea531d2244e93e0449648798606569324651267281931645206238861160x0c0388e4bbf121a06ea531d2244e93e0449648792025-11-26T23:14:23.000Z0x14a109013bee4fb25a0f97a41d45db79e961820232e9df58d0d94553010d0162
0x1445f32d1a74872ba41f3d8cf4022e9996120b31false0x0c0388e4bbf121a06ea531d2244e93e0449648798574881965514988334638011156238861160x0c0388e4bbf121a06ea531d2244e93e0449648792025-11-26T23:14:23.000Z0x14a109013bee4fb25a0f97a41d45db79e961820232e9df58d0d94553010d0162
0xacdb27b266142223e1e676841c1e809255fc6d07false0x0c0388e4bbf121a06ea531d2244e93e04496487986313565399414875924377677238861160x0c0388e4bbf121a06ea531d2244e93e0449648792025-11-26T23:14:23.000Z0x14a109013bee4fb25a0f97a41d45db79e961820232e9df58d0d94553010d0162
Query with partition filter
SELECT *
FROM `tt-contracts.pancakeswap_v3_ethereum.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
0x07a6d7404448567f801d6f8bb82063600176e283false0353868236332940x3e0918f43458db9f02d7ca915cc422204619f5a5350353868236332932968182205850x3e0918f43458db9f02d7ca915cc422204619f5a52023-09-26T14:36:11.000Z0x9e547ed12b21d00c75998b49d0f7ca02c35850c3b452972ef99e21ae19c4dd72
0x3733493ec5d2c181dcd7c54ed100641c0f07bb0efalse0349345607570630x1c8563033e47b2341da5002f907af98906e4ec4b710349345607570628087197841760x1c8563033e47b2341da5002f907af98906e4ec4b2024-05-02T18:18:11.000Z0xe1b2c84b6eeedfb3160fc5f117ed65792c69bc886551941d367d3aae9c4d7141
0xa06fc67e6fe3c34736d295fff71a358c3bb83476false11254441370000x167f6e958a1a082e33c75fab66bd511016e51340100450177654799150198572980x167f6e958a1a082e33c75fab66bd511016e513402024-05-12T23:43:59.000Z0xda033f199433daf0ac0fbb2bfa0daf769a6a78357a8256c5d5b9f699f9f72a8a
Query with partition filter
SELECT *
FROM `tt-contracts.pancakeswap_v3_ethereum.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
0x04c8577958ccc170eb3d2cca76f9d51bc6e42d8ffalse0x46a15b0b27311cedf172ab29e4f4766fbe7f436413223048780766760x46a15b0b27311cedf172ab29e4f4766fbe7f436422632440390343127052502622717938593092023-08-18T02:05:59.000Z0xc2df5ac205b47595a9bf6c41e73a2dd6ed0132ceb4a3eac4b29fb30497ab1840
0x04c8577958ccc170eb3d2cca76f9d51bc6e42d8ffalse0x46a15b0b27311cedf172ab29e4f4766fbe7f436419221356137488460x46a15b0b27311cedf172ab29e4f4766fbe7f43641834805179954832459913199817941266072023-08-18T11:06:35.000Z0x2af10a9ed82b407d97a1151405ca31afdaa4f740dba0a0e226e040257c15c037
0x04c8577958ccc170eb3d2cca76f9d51bc6e42d8ffalse0x46a15b0b27311cedf172ab29e4f4766fbe7f43646690373371920500x46a15b0b27311cedf172ab29e4f4766fbe7f4364107206126350834629017814417940454242023-08-18T08:21:23.000Z0x710c194a75bf50a49330350f77450d989d8734ee2681db2b33bae8c6f7cc4964
Query with partition filter
SELECT *
FROM `tt-contracts.pancakeswap_v3_ethereum.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.
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.
in_protocolFeesToken0STRINGProtocol fees collected in token0 from the swap transaction. Numeric string representation of fee amount in smallest denomination.
in_protocolFeesToken1STRINGProtocol fees collected in token1 from the swap transaction. Numeric string representation of fee amount in smallest denomination.
addressin_tickremovedin_senderlog_indexin_amount0in_amount1block_numberin_liquidityin_recipientblock_timestampin_sqrtPriceX96transaction_hashin_protocolFeesToken0in_protocolFeesToken1
0x3364f7925b3e499ec45f6a0c6f744912fb7394cf-9775false0x13f4ea83d0bd40e75c8222255bc855a974568dd422010000000000-3793939931178872455744597343820xbfda4ea1fedc10d099ceccd5d4c6bb723f3001fd2023-08-10T21:43:47.000Z486007503844109683152399401190xdb9eb63237febfb5da2b8df1820947070bc9d1f7d066e1250c24b366281eeb5080000000
0x31c0cda3662ae2cc42008772b14e6dfcc4ae0829133325false0x13f4ea83d0bd40e75c8222255bc855a974568dd4341-2098050904412299429304121818178823782640994642041580x403b68ca34e2d9c4f7c56cc0f186eba9652660542023-08-10T05:22:23.000Z622116108748746836006686779324300xa9c936a1b5143980f11f92a4160b6fd7b08746a90b5d41d52f1afc47aebb35f4039358173773190
0x04c8577958ccc170eb3d2cca76f9d51bc6e42d8f8false0x13f4ea83d0bd40e75c8222255bc855a974568dd4256-52000000520514871788284633415844973246150x0d39a27a118888bc2c1927e3267e82395b2c36622023-08-10T06:56:59.000Z792634125143760964053816568030xf43f0470769c15a64fbd46ac2a6f84c7728a50eddb9e30c8fdb758843f4435ae01717
Query with partition filter
SELECT *
FROM `tt-contracts.pancakeswap_v3_ethereum.Pool_Swap_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100