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
1000x0bfbcf9fa4f9c56b0f40a671ad40e0805a0918650x8861bda820460e6931a6087397844a71e1d368b4false0x3055913c90fcc1a6ce9a358911721eeb942013a10x833589fcd6edb6e08f4c7c32d4f71b54bda029130806421312023-12-18T16:42:53.000Z0x8de7bed3309dfb52fd940b47ef55d71991b36501bfaade5a4cf1fd5bd3e7a189
5000x0bfbcf9fa4f9c56b0f40a671ad40e0805a0918650x486d1e5e5f97f44ea8db217598c1e61e21f54084false0x50c5725949a6f0c72e6c4a641f24049a917db0cb0x833589fcd6edb6e08f4c7c32d4f71b54bda02913158054019102023-12-18T11:03:05.000Z0xabd411e5bfa4284b09ba178a0587f4ddae00dbf88052db8492a6b6cacf42fbd8
1000x0bfbcf9fa4f9c56b0f40a671ad40e0805a0918650x9672e324ca965bfc1078c7c93b1311ccd00c0f9ffalse0x1cc98b19b9068a8d4084e6102459237a2f58d83e0x420000000000000000000000000000000000000619554048612023-10-21T06:38:39.000Z0x5a17c81d084409a9bb7238649b9b1eb650e8cc4adcefae1c7d2518759726fc13
Query with partition filter
SELECT *
FROM `tt-contracts.pancakeswap_v3_base.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
0x03c33a2fc0d444a5b61e573f9e1a285357a694fcfalse0x46a15b0b27311cedf172ab29e4f4766fbe7f436414694591724322966180447174104622684509552254200416034617683798-70800-664002023-12-09T21:22:23.000Z0xf67264bb0513410fe2368217307aab072a3b53c7be4f33b5f4eaf622d7443749
0x03c33a2fc0d444a5b61e573f9e1a285357a694fcfalse0x46a15b0b27311cedf172ab29e4f4766fbe7f4364030007680429-75400-616002023-12-09T19:30:05.000Z0x5370fc93a800db038a29b47faab813a77cbe58b5a7d0a323950b31121989bc18
0x03c33a2fc0d444a5b61e573f9e1a285357a694fcfalse0x46a15b0b27311cedf172ab29e4f4766fbe7f436418826249266726280361673416442184634701802919806567527680442-75400-616002023-12-09T19:30:31.000Z0x11885cf680758683a10ed5868cc39be7e064558fbcff8129a7308eaa5e173c57
Query with partition filter
SELECT *
FROM `tt-contracts.pancakeswap_v3_base.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
0x29ed55b18af0add137952cb3e29fb77b32fce426false0x46a15b0b27311cedf172ab29e4f4766fbe7f436480106680249955614300x0bf1daf1c680514b5c90e2ceb49f19b117f86135-19-32023-10-21T18:16:47.000Z0x255bc1b698ef19c713edff2519911139ee860ad7c72760468db789725d023ca3
0x29ed55b18af0add137952cb3e29fb77b32fce426false0x46a15b0b27311cedf172ab29e4f4766fbe7f43643294647432014430155422090x0f9cf78002d256a033323ced7f236a96c7bbf01c042023-10-21T07:36:05.000Z0xd2a879bb754ddf12cc28a9e296374d7975cd1e1ec0e9aee8cbfcc10763326265
0x29ed55b18af0add137952cb3e29fb77b32fce426false0x46a15b0b27311cedf172ab29e4f4766fbe7f4364800121096389955497400x15a8b3166294b26aded44de9dff2fcd26409de26-11-22023-10-21T11:47:07.000Z0xab8c032ee63412a9988e377d0f605934a9f6ff6dd68632fdbbdb7a9c4865b5e9
Query with partition filter
SELECT *
FROM `tt-contracts.pancakeswap_v3_base.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
0x72ab388e2e2f6facef59e3c3fa2c4e29011c2d38false0x0eb5c70f0cbd990e111227ce4dafc31e036f7964879022973348789307734930x0eb5c70f0cbd990e111227ce4dafc31e036f79642025-05-27T08:58:53.000Z0xcf52ef300bb7e6387ef9a5e3eca098c1cee3fcb262ecc26f0e877d9502d268fb
0x00efd5fcf7eb40d6af892bdec9e62ba3ba50e6d9false0x0eb5c70f0cbd990e111227ce4dafc31e036f7964867022103238887977787627307736900x0eb5c70f0cbd990e111227ce4dafc31e036f79642025-05-27T09:05:27.000Z0xa5a472a1df5f79dca9943929fdf5bfef5f270db13a4ad6fb99407b8767f1743e
0x765bf105ed38d2ee7801210b4bb2b8b7d9b3a17ffalse0x0eb5c70f0cbd990e111227ce4dafc31e036f7964610093613055050246187649307736030x0eb5c70f0cbd990e111227ce4dafc31e036f79642025-05-27T09:02:33.000Z0x3effbf92ebc4d2069c770c74e8135990b4d73bfb6bd0f793eff73658799838d6
Query with partition filter
SELECT *
FROM `tt-contracts.pancakeswap_v3_base.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
0x25dee2707979055245a18ae6a415bb7b1435eb06false17090000xac53cd599ec308eef9a4c1ca9c35117876978f0d161709000000095266210xd612079030bbd214e9d98facf1c3c32fe0b2d8652024-01-21T13:09:49.000Z0x9216419157d9df32031fda62f418778c73ea307ef51dd40be35ed90adf9f0450
0x25dee2707979055245a18ae6a415bb7b1435eb06false15020000xac53cd599ec308eef9a4c1ca9c35117876978f0d191502000000095261730x89cfef6706fadda02e3b006e523f1a445a9299c52024-01-21T12:54:53.000Z0x865149eb709c854ec6a4172fca6c3c88a9478bec0ebd03ce951e9cd29f6653cb
0x25dee2707979055245a18ae6a415bb7b1435eb06false18170000xac53cd599ec308eef9a4c1ca9c35117876978f0d131817000000095174050xeba11e96adc11fb609d733bf4d4f1132e8aeab812024-01-21T08:02:37.000Z0xdebe606aa385351e63263a3912d920a6c30bf13bd038e81421a7b9f4ca2ff3a3
Query with partition filter
SELECT *
FROM `tt-contracts.pancakeswap_v3_base.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
0x03c33a2fc0d444a5b61e573f9e1a285357a694fcfalse0x46a15b0b27311cedf172ab29e4f4766fbe7f4364496794922684665090x46a15b0b27311cedf172ab29e4f4766fbe7f43642199999999999999225579416456899955067436-73200-712002023-10-10T07:50:19.000Z0x930c2a6a868032b7957ca3e9dd3bc814e67878e73e8102b0fb6ca22da4a7f3fc
0x03c33a2fc0d444a5b61e573f9e1a285357a694fcfalse0x46a15b0b27311cedf172ab29e4f4766fbe7f436412605145963124907360x46a15b0b27311cedf172ab29e4f4766fbe7f4364461373202878999999977798497761034088445074775-79200-654002023-10-10T11:54:57.000Z0x04292f0bffae78316cb7c33038031546c9d7a12c0377ab606b9e855780e54685
0x03c33a2fc0d444a5b61e573f9e1a285357a694fcfalse0x46a15b0b27311cedf172ab29e4f4766fbe7f43647904539660423871299870x46a15b0b27311cedf172ab29e4f4766fbe7f436414015850000000000000005054763-79200-772002023-10-10T00:47:53.000Z0xa159b4694870257ee975ffda427c275d77d6d02f5781bf64cb6935efa6e366b0
Query with partition filter
SELECT *
FROM `tt-contracts.pancakeswap_v3_base.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
0xcb5efa901172c092fac066f3773ad0e022a87d72-201016false0x678aa4bf4e210cf2166753e054d5b7c31cc7fa8621-15388814791102804611138228009424650x37ee0122459de84927e083cd5937ffcac86bbec72023-11-03T11:48:31.000Z34205957749202678503420830xf5b6a55868736e23f9af7e132a0ecda229044f3089669f448a7e297b724cbbf000
0xcb5efa901172c092fac066f3773ad0e022a87d72-201485false0x678aa4bf4e210cf2166753e054d5b7c31cc7fa8612113699761807054-215407610869728009424650x678aa4bf4e210cf2166753e054d5b7c31cc7fa862023-11-03T10:19:01.000Z33413376987052076192005240xa244bbe97d2a5a0b04a74efd6e7daee554368a4f899d950ff0e5b7f4e56006c8193289595070
0x16de087bb1a220c7fc388f3f0dfd38eb1fcdf8b0-201271false0x678aa4bf4e210cf2166753e054d5b7c31cc7fa8624-8617729399710615733961284776909358116910x678aa4bf4e210cf2166753e054d5b7c31cc7fa862023-11-03T21:18:21.000Z33772993257830401880779630xe70998e56eec54bd611d4849b7dca17dce49d6b3264bdb65535be2e5f0c2e2ff0503
Query with partition filter
SELECT *
FROM `tt-contracts.pancakeswap_v3_base.Pool_Swap_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100