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
100000x0bfbcf9fa4f9c56b0f40a671ad40e0805a0918650x23e6619590080fc2d50a6692aa0d58e5085248bffalse0x54bdbf3ce36f451ec61493236b8e6213ac87c0f60x82af49447d8a07e3bd95bd0d56f35241523fbab101707915792002024-01-15T19:20:02.000Z0x720e1a8b3446790de7bb8ee874e61e1708ddbf21edd3eb6f54f554e165e82118
100000x0bfbcf9fa4f9c56b0f40a671ad40e0805a0918650x27863df58356335b9d1bc24fcb5fff0e24ca2a82false0x2823f231b8b7121c4ba6b6c0ceef37b6a5bda5470xfd086bc7cd5c481dcc9c85ebe478a1c0b69fcbb931707444802002024-01-15T15:56:18.000Z0xf00431dd598488bd8bd82a2010f204f6e2bbd5ecb03813e8ade1ba1f41a529d7
25000x0bfbcf9fa4f9c56b0f40a671ad40e0805a0918650x012b299349e04e5db4808c2be4606e3688edeb60false0x0c880f6761f1af8d9aa9c466984b80dab9a8c9e80xfd086bc7cd5c481dcc9c85ebe478a1c0b69fcbb910277295908502024-11-23T00:07:59.000Z0x69d66e4ddb588f30ebd2031bc8bd086aad70cbe0b2d0af35f2fa8228c7f4fbb0
Query with partition filter
SELECT *
FROM `tt-contracts.pancakeswap_v3_arbitrum.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
0x0bacc7a9717e70ea0da5ac075889bd87d4c81197false0x46a15b0b27311cedf172ab29e4f4766fbe7f43640300166286577-200900-1964402024-01-02T10:38:08.000Z0x82521dbff6cc73a0db3a5e5042033f28738bbf18941e2896637bb7c10d5a3668
0x0bacc7a9717e70ea0da5ac075889bd87d4c81197false0x46a15b0b27311cedf172ab29e4f4766fbe7f43640400166419345-199010-1981702024-01-02T19:50:36.000Z0xa97bf589f7eaeea2fb343346b84103672a2f731be943ff69ea18704afdefe720
0x0bacc7a9717e70ea0da5ac075889bd87d4c81197false0x46a15b0b27311cedf172ab29e4f4766fbe7f43640000166372485-200560-1974902024-01-02T16:34:37.000Z0x7321f46a8e260080863a8177da3a0e1b857a5bd29391af0d66376c882ce22528
Query with partition filter
SELECT *
FROM `tt-contracts.pancakeswap_v3_arbitrum.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
0x0bacc7a9717e70ea0da5ac075889bd87d4c81197false0x46a15b0b27311cedf172ab29e4f4766fbe7f4364926920673269077910962117565531754550860x5e09acf80c0296740ec5d6f643005a4ef8daa694-199090-1988702024-01-29T17:34:50.000Z0x1c3c7d5ffe6bd0ec8bb83b7f9bf000cd0becb4b6483f8427427c7e934255b7b3
0x0bacc7a9717e70ea0da5ac075889bd87d4c81197false0x46a15b0b27311cedf172ab29e4f4766fbe7f43646701052991566000520322031218581753002430x5e09acf80c0296740ec5d6f643005a4ef8daa694-199080-1988702024-01-29T06:42:06.000Z0x97c71196842aac9d39ecd048a3ec84ac7ccfa23759a7b66617cad165dee003e4
0x0bacc7a9717e70ea0da5ac075889bd87d4c81197false0x46a15b0b27311cedf172ab29e4f4766fbe7f436452795811062446927799438919881754555010x5e09acf80c0296740ec5d6f643005a4ef8daa694-199050-1988702024-01-29T17:36:35.000Z0x1715ce7a0927704d123178af6c41bd4acce416c0b6ac1e0bd952addabded135a
Query with partition filter
SELECT *
FROM `tt-contracts.pancakeswap_v3_arbitrum.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
0x843ac8dc6d34aeb07a56812b8b36429ee46bdd07false0x40c79220a51bcc879dd52a2fcd96f0dba4d89540275617877940863873003330x40c79220a51bcc879dd52a2fcd96f0dba4d895402025-10-08T08:03:19.000Z0x178cf99de206337802b3046d3805dbc5c7d04512f6f796fa2093a5fe1059e99b
0x7fcdc35463e3770c2fb992716cd070b63540b947false0x40c79220a51bcc879dd52a2fcd96f0dba4d895402902136511394427533991391493872998290x40c79220a51bcc879dd52a2fcd96f0dba4d895402025-10-08T08:01:13.000Z0xe9f6c26857471b99b5d4bdf049076042bb6d30c914a0e049d75310308acf08e0
0x0bacc7a9717e70ea0da5ac075889bd87d4c81197false0x40c79220a51bcc879dd52a2fcd96f0dba4d895402311356013473134681276997873872999520x40c79220a51bcc879dd52a2fcd96f0dba4d895402025-10-08T08:01:43.000Z0x16a1726d75e490e21b3050e2e72382e6e9acb430b8f3c941ed8058abd5109f8b
Query with partition filter
SELECT *
FROM `tt-contracts.pancakeswap_v3_arbitrum.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
0x11d53ec50bc8f54b9357fbfe2a7de034fc00f8b3false0614946565308112520x993a603575ff0dbcb58921004ec7161c19ac34627906149465653081125167252684469750x993a603575ff0dbcb58921004ec7161c19ac34622024-10-28T06:02:31.000Z0x8c3c30b87b305b93d59a312967141cea73fc018e8b809b1d4b38158d3aea280b
0x11d53ec50bc8f54b9357fbfe2a7de034fc00f8b3false0512923090877295910x993a603575ff0dbcb58921004ec7161c19ac34627705129230908772959018502683878910x993a603575ff0dbcb58921004ec7161c19ac34622024-10-28T01:55:51.000Z0x2e4732d6f7fc2f7ce9a3e2b7ab74c8af1c481d883606c34d2bda2491ed60b062
0x11d53ec50bc8f54b9357fbfe2a7de034fc00f8b3false0550065958489760820x993a603575ff0dbcb58921004ec7161c19ac34627405500659584897608141402686681090x993a603575ff0dbcb58921004ec7161c19ac34622024-10-28T21:40:31.000Z0x50ddbb149da758ee9f1f46611de59e9b1679739f1520adbbd17395e9662034b2
Query with partition filter
SELECT *
FROM `tt-contracts.pancakeswap_v3_arbitrum.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
0x0bacc7a9717e70ea0da5ac075889bd87d4c81197false0x46a15b0b27311cedf172ab29e4f4766fbe7f43641009074906159660x46a15b0b27311cedf172ab29e4f4766fbe7f436411102711013256556852259298536170974082-198960-1968602024-01-16T09:03:44.000Z0x864ae874a1bc8e334e8ba78d705cafc7e5288b097fe6a420820b3d88165cabf8
0x0bacc7a9717e70ea0da5ac075889bd87d4c81197false0x46a15b0b27311cedf172ab29e4f4766fbe7f4364197726582168800x46a15b0b27311cedf172ab29e4f4766fbe7f4364401000000171144760-197860-1978402024-01-16T21:31:54.000Z0xb6e313dc0eec03b25b12d4cbb611e08aa4ae84bea40fb887eeea760fce23c7b5
0x0bacc7a9717e70ea0da5ac075889bd87d4c81197false0x46a15b0b27311cedf172ab29e4f4766fbe7f4364197726582168800x46a15b0b27311cedf172ab29e4f4766fbe7f4364401000000171120976-197860-1978402024-01-16T19:49:17.000Z0x258a7486a207e07750abe6646d7abc6298183d7428f94785a2e821f28d9d1831
Query with partition filter
SELECT *
FROM `tt-contracts.pancakeswap_v3_arbitrum.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
0x280ae11f4329d94a69a8be97e892d27c8b650961-56false0x1b81d678ffb9c0263b24a97847620c99d213eb149-92064339246355154966299552327556600x1b81d678ffb9c0263b24a97847620c99d213eb142023-11-28T16:31:50.000Z790083194646856253492967407760xd16b5faf7157b00baa933f6cb002f22b983cf7e0602594b12d64290e0b7a67c2029588
0xaeab1336efc2bf74bc89fcf0e33e6013f3c8587e-200042false0x32226588378236fd0c7c4053999f88ac0e5cac779-12078415241168924762815497820811609371023670xd195aeb77a0c13d5ca42fb5136dad570e2ef78f12023-11-28T17:23:33.000Z35913007295748876150396780xab55eb37cbe95a82ea38ad67f29f07a11bb482085d94687200eed44c2b6c209d0198
0x38e81e616fa532201e4c7ff9953a9b40cc842f39-200031false0x32226588378236fd0c7c4053999f88ac0e5cac7711179509337758582-36950015504188025078433133670x3d26d281e4a971a2e6ce7c9ffcb08cee6e85bddb2023-11-28T22:26:03.000Z35932124831855727993312510x11a4cbfbbc0fb3474b0fb48a18d888e7ee823e667ad8ee0eebf79b7809aece031436074702070
Query with partition filter
SELECT *
FROM `tt-contracts.pancakeswap_v3_arbitrum.Pool_Swap_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100