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
1000x0bfbcf9fa4f9c56b0f40a671ad40e0805a0918650xe043558b77e2b4c262d7d6e579b005ceb7f4591cfalse0x1af3f329e8be154074d8769d1ffa4ee058b1dbc30x55d398326f99059ff775485246999027b31979551353204334312023-09-25T06:13:04.000Z0x63d9dadc688aa02d581596dba7ca984aebe9c0bef3099cf21dc17cd76ee5d4b0
1000x0bfbcf9fa4f9c56b0f40a671ad40e0805a0918650xe9e04e9681f0a5d53a69612ad169f87377a2e3a1false0x2466858ab5edad0bb597fe9f008f568b00d25fe30xbb4cdb9cbd36b01bd1cbaebf2de08d9173bc095c2373205514712023-09-25T16:04:52.000Z0xf5ebcde9b1a7b8bcdd263457279e581939d70ff330d20a4ab1fddec63d226572
1000x0bfbcf9fa4f9c56b0f40a671ad40e0805a0918650x84e5661b5a5f2107927430e2bda411996c71b552false0x25296b367e6407c6c79bd0ad8ecd59ae8bea1d4e0xc209831f7349d4e200d420326b3401899ab9ae681113204948912023-09-25T11:21:02.000Z0xade0b946bfdd6c29d2a7151b1efc5fe7ec1ecaff295c89baa6a3ce9ecd693bad
Query with partition filter
SELECT *
FROM `tt-contracts.pancakeswap_v3_bsc.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
0x024d6e69a0d5320e2051dc68cfe9a7c257855d5efalse0x46a15b0b27311cedf172ab29e4f4766fbe7f4364337429217926853768423011421794999999999999999999999990289027603834-139400-1364002023-04-23T16:17:11.000Z0x431795e757dac41ea164ae832d03812da5720a1b272ba01f29b8a08053adc7d9
0x024d6e69a0d5320e2051dc68cfe9a7c257855d5efalse0x46a15b0b27311cedf172ab29e4f4766fbe7f4364440453601445309158038086891406187608606197708603666981957027603648-141000-1384002023-04-23T16:07:53.000Z0x91ef590e809003ad6afcc088b78a9a8947fb9d8d7bf25c6500673d6798f681bc
0x024d6e69a0d5320e2051dc68cfe9a7c257855d5efalse0x46a15b0b27311cedf172ab29e4f4766fbe7f436434492517235529690850927117914786246128699584501857655216404041713528095627584639-145000-1442002023-04-23T00:15:45.000Z0x6e5acfd0a472c5dba05ecf9009b2856d34c4c64a50b30e140483410ce387da25
Query with partition filter
SELECT *
FROM `tt-contracts.pancakeswap_v3_bsc.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
0x0004222c2075e9a1291e41f1ca4c8d32141db501false0x46a15b0b27311cedf172ab29e4f4766fbe7f4364134130880337710970694808575473362082040517510323834960x556b9306565093c855aea9ae92a594704c2cd59e-68550-676002023-10-07T02:36:17.000Z0x2d98ec5dfe13c89309cce83d8e4a8c77378f63a9a317f007317b1b201beb6ab8
0x0153120a524a0af0bf2d798a366e4bfb010898a2false0x46a15b0b27311cedf172ab29e4f4766fbe7f43641714813910741558107500951078962377705596415537459916323987910x46a15b0b27311cedf172ab29e4f4766fbe7f4364-8872008872002023-10-07T15:27:40.000Z0x5fd9e1ed73e01050a19e63fdfe8ab7fa701215008ca0c2613af8e0ce6ca9a068
0x03b3d493d744b373342abc75244b0d29cee3717dfalse0x46a15b0b27311cedf172ab29e4f4766fbe7f43641218512870822486021073442416305483323961150xe540b0030bd66403583c40ec02c8c522c95836d943721439212023-10-07T13:13:37.000Z0x8f217b27a29b50047d99b8f445eda4051f18906b657db3310406f74f0c153347
Query with partition filter
SELECT *
FROM `tt-contracts.pancakeswap_v3_bsc.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
0xbb87f33d9f43ec3fe75502958408262e7043b2e8false0x518d9643160cfd6fe469bfbd3ba66fc8035a68a3127181522587236934186948775490445608313232320x518d9643160cfd6fe469bfbd3ba66fc8035a68a32023-08-31T04:09:40.000Z0x012d7aa672bfa31e2f3548b35163bd5e306d496767c2b9f40fc2e9d50536d47b
0x293c665b9b98cd51d6454c72529fe17a1cf1f504false0x518d9643160cfd6fe469bfbd3ba66fc8035a68a31212587287181272224107219163704674241404217313232320x518d9643160cfd6fe469bfbd3ba66fc8035a68a32023-08-31T04:09:40.000Z0x012d7aa672bfa31e2f3548b35163bd5e306d496767c2b9f40fc2e9d50536d47b
0x6dba30870bc46bd6d2289e1827cc415f6fa23e1afalse0x518d9643160cfd6fe469bfbd3ba66fc8035a68a31246878696393477206422120645166257054408538313232320x518d9643160cfd6fe469bfbd3ba66fc8035a68a32023-08-31T04:09:40.000Z0x012d7aa672bfa31e2f3548b35163bd5e306d496767c2b9f40fc2e9d50536d47b
Query with partition filter
SELECT *
FROM `tt-contracts.pancakeswap_v3_bsc.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
0x36696169c63e42cd08ce11f5deebbcebae652050false0599430235443620x6c57141535ef42ee1ce9fdca57d4a81929556c0b120119886047088722784315825500x6c57141535ef42ee1ce9fdca57d4a81929556c0b2023-09-09T05:09:04.000Z0x75de348888775962d502c11d388e2da207f1d327c4a6a985ff0626fb391fc85b
0x36696169c63e42cd08ce11f5deebbcebae652050false02484030135017650x6c57141535ef42ee1ce9fdca57d4a81929556c0b90496806027003529337315801740x6c57141535ef42ee1ce9fdca57d4a81929556c0b2023-09-09T03:09:55.000Z0x4ffd0394e12840ac595b2ea9062db5ec72712326741aaac2736d61764251fbe7
0x36696169c63e42cd08ce11f5deebbcebae652050false03259123759571070x6c57141535ef42ee1ce9fdca57d4a81929556c0b80651824751914213407315904870x6c57141535ef42ee1ce9fdca57d4a81929556c0b2023-09-09T11:46:57.000Z0x01313f1af3e9e3eca64bb7bbe082961258a031fea743a9bdeabfbeef24946e49
Query with partition filter
SELECT *
FROM `tt-contracts.pancakeswap_v3_bsc.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
0x0004222c2075e9a1291e41f1ca4c8d32141db501false0x46a15b0b27311cedf172ab29e4f4766fbe7f4364241365639333011347300x46a15b0b27311cedf172ab29e4f4766fbe7f4364741999999999999999998638938161243112306932962461-69050-599002023-10-27T06:48:17.000Z0x798aca086e8f551fa128939d20e03dbf53bfe0e19676bf08e7b2115669b929d4
0x0004222c2075e9a1291e41f1ca4c8d32141db501false0x46a15b0b27311cedf172ab29e4f4766fbe7f436428412259287815003755490x46a15b0b27311cedf172ab29e4f4766fbe7f43642714000000000000000000495502922313551111061532975815-68600-665502023-10-27T17:58:23.000Z0xbdba662ade8544a36bee63c086a66b0e9a7d8a28273556c412523192d98f1df3
0x0004222c2075e9a1291e41f1ca4c8d32141db501false0x46a15b0b27311cedf172ab29e4f4766fbe7f436421637617334859666560x46a15b0b27311cedf172ab29e4f4766fbe7f43641746694067618918571058775178339955472832979132-69700-652502023-10-27T20:44:44.000Z0x4852b93a39242d500a5c15879aacc9c642e42c674fc81bc0f6f9115b52156f2e
Query with partition filter
SELECT *
FROM `tt-contracts.pancakeswap_v3_bsc.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
0xf5705623b2b77e220602362205d9e14ba08ad77c-887272false0x13f4ea83d0bd40e75c8222255bc855a974568dd4581656698103321656-16509058014242752630300x0d80c497c988b211ed03f5e217b681b06aa26f522023-04-20T23:33:40.000Z42951287400xc0a41e341e7877f3349eaad6312ac4d02e3a9edb2223a33a955732043f1eea6413253584826570
0xc857708e1bed576018697c9e78dfa7313d82de85-887272false0x13f4ea83d0bd40e75c8222255bc855a974568dd424732961-5991988043027280013824632751982400x61dfef70b152bd17d6f2527320c382864487ce902023-04-20T18:08:43.000Z42951287400x06821ada86d816afdff53d066b3e67bb34f6f954f5d5a08bc578244352f4a42d1040
0x06a6707a0a8c4bb1f5332896ef465f789fe27441-887272false0x287a7f469455e97ead50990bbc95a19b3a28318a14034086994182313-105996694173415702751696400x4e2d7bce766c526535004ed510d51b959fdf3ae02023-04-20T15:45:30.000Z42951287400x0ac3304d8ab8e95997f6f4ea387888a470357415cdc047eb5716a457e4fd47451090783813830
Query with partition filter
SELECT *
FROM `tt-contracts.pancakeswap_v3_bsc.Pool_Swap_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100