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
1000x1bb72e0cbbea93c08f535fc7856e0338d7f7a8ab0x5189204c7db46642db5425181705af1165bad125false0x5aea5775959fbc2557cc8789bc1bf90a239d9a910x67aca761837f507063bbe1f071cf91418b5f131378993331812023-07-30T11:31:06.000Z0x28f7e566ca6bc1c9cbce70467283d21c0db72050cfde42f6bfb3dfec18082550
25000x1bb72e0cbbea93c08f535fc7856e0338d7f7a8ab0x16de9c6ef8f50e7a8aaebcad7ef86d7365f15c5ffalse0x3355df6d4c9c3035724fd0e3914de96a5a83aaf40xbbeb516fb02a01611cbbe0453fe3c580d72810111610510500502023-08-06T05:44:23.000Z0xf6fec62cf813c4401b7923149b2212d9d75da09029da53cf8839f82441c82142
100000x1bb72e0cbbea93c08f535fc7856e0338d7f7a8ab0x0c9937cb11fb683ec70ba3ab452654662621ba56false0x3355df6d4c9c3035724fd0e3914de96a5a83aaf40x8e86e46278518efc1c5ced245cba2c7e3ef1155722149126512002023-09-27T07:48:54.000Z0x6ceca49832df73c96370c6e8e17221eda24f05fbdbee6bc779099eaad10c9c2f
Query with partition filter
SELECT *
FROM `tt-contracts.pancakeswap_v3_zksyncera.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
0x16de9c6ef8f50e7a8aaebcad7ef86d7365f15c5ffalse0xa815e2ed7f7d5b0c49fda367f249232a1b9d2883333523545246181532809818528913-62450-491502023-11-09T09:18:30.000Z0x8753a09b04c66909fe18de9c1bdd5b04ccb371245daae5fc27faa7c9767c5ba8
0x16de9c6ef8f50e7a8aaebcad7ef86d7365f15c5ffalse0xa815e2ed7f7d5b0c49fda367f249232a1b9d28830470018528913-62450-491502023-11-09T09:18:30.000Z0x8753a09b04c66909fe18de9c1bdd5b04ccb371245daae5fc27faa7c9767c5ba8
0x16de9c6ef8f50e7a8aaebcad7ef86d7365f15c5ffalse0xa815e2ed7f7d5b0c49fda367f249232a1b9d28830510018528881-62450-491502023-11-09T09:17:58.000Z0x748cd6314857f7cb190db13eb02401e3a8e4778124dcde4beb77736a9e0ab406
Query with partition filter
SELECT *
FROM `tt-contracts.pancakeswap_v3_zksyncera.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
0x141853f48b5fe6cc6cc792417dff59b9009d796dfalse0xa815e2ed7f7d5b0c49fda367f249232a1b9d28838711995363011578198418114322430x2dd622305147e919ae28bf5728312b89452ce06c0202023-08-17T02:20:52.000Z0xa1dc6cf31f3ddd9e3a3e7d6ddce9dab19a8b240827a06c40602489c66e3ac9ae
0x16de9c6ef8f50e7a8aaebcad7ef86d7365f15c5ffalse0xa815e2ed7f7d5b0c49fda367f249232a1b9d28837205042648114553510x879b55fc9527515867bd952cbb062dbdc11272bb-62650-586002023-08-17T08:58:48.000Z0x5e125b30f331f75b69835be7532fea0b19fc718e451fba2b106d367571672f71
0x291d9f9764c72c9ba6ff47b451a9f7885ebf9977false0xa815e2ed7f7d5b0c49fda367f249232a1b9d2883600615672931998967293114441550xa815e2ed7f7d5b0c49fda367f249232a1b9d28832009402009602023-08-17T05:44:16.000Z0xf543346f6f018d45c70e5bbd9037eb64f555a2b6bad46de6d2cd60a674e57605
Query with partition filter
SELECT *
FROM `tt-contracts.pancakeswap_v3_zksyncera.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
0xb76e382cd2b20beb2730da25ae1500162eb8ab9cfalse0x98f5d395418ac99c03bca6902c27081c97c6ed4b272894720597507210x98f5d395418ac99c03bca6902c27081c97c6ed4b2025-04-29T09:17:32.000Z0xfb8ee444f021905cdc2199332343f6db0c3d74e04851c2396f8848a359fca898
0xec706fcdca09273945ae7c3c4d29e4a5f4482a23false0x98f5d395418ac99c03bca6902c27081c97c6ed4b369470466875361113487199212673254837310597507630x98f5d395418ac99c03bca6902c27081c97c6ed4b2025-04-29T09:18:42.000Z0x112daf461f9cc09df6fc3599fe6cd57cee51f00e91aa94e3229e3e3e22beaa2c
0x7c0e7d6066af191977a4483b445b5c06fc41ecd6false0x98f5d395418ac99c03bca6902c27081c97c6ed4b3119800937627531866834227597506660x98f5d395418ac99c03bca6902c27081c97c6ed4b2025-04-29T09:15:28.000Z0x33b7fb711242dafd58f3edd07db13489b702d86f7d8e245838e9644b39870da5
Query with partition filter
SELECT *
FROM `tt-contracts.pancakeswap_v3_zksyncera.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
0x662cd659f91528ff27d7cb6ac25e6eba11c4003cfalse05450010x038d49ab8b35c5f1aa71c76ad754a8584fbacbab7605450000559209587220x038d49ab8b35c5f1aa71c76ad754a8584fbacbab2023-12-08T07:53:39.000Z0xc1a769793d42ca645e3e96d9b3b113373b16f4683a4b214cab97c04e06440342
0x7c0e7d6066af191977a4483b445b5c06fc41ecd6false0301246989274810x55d5038ab57492dea8f9db6e8bfabd6be5834df0640301246989274802170209758850x55d5038ab57492dea8f9db6e8bfabd6be5834df02023-12-08T12:58:03.000Z0x0161f8d4110c460fa756134ccb9a3c3d41fbd2c3cad4e532d3b48ce30066318a
0x7c0e7d6066af191977a4483b445b5c06fc41ecd6false0126600387584660x55d5038ab57492dea8f9db6e8bfabd6be5834df0640126600387584656606210101190x55d5038ab57492dea8f9db6e8bfabd6be5834df02023-12-08T22:44:35.000Z0xbad010b06605d621951b6f78dc09d34910239340ef7cb9b83288a0041dae60dd
Query with partition filter
SELECT *
FROM `tt-contracts.pancakeswap_v3_zksyncera.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
0x291d9f9764c72c9ba6ff47b451a9f7885ebf9977false0xa815e2ed7f7d5b0c49fda367f249232a1b9d288334353722958639820xa815e2ed7f7d5b0c49fda367f249232a1b9d2883820237999999999999965398411851990301996802023-07-29T09:38:16.000Z0x0606c72480c1edfac9b9a32611180f8a41857fc581c3276596c788166bd8cbda
0x291d9f9764c72c9ba6ff47b451a9f7885ebf9977false0xa815e2ed7f7d5b0c49fda367f249232a1b9d288315709096801122090xa815e2ed7f7d5b0c49fda367f249232a1b9d28831730698999999999999753398318341966802009602023-07-29T07:00:35.000Z0xa45b472fb7043530cdff7d1b4011769417eb029aa2b08d275b8de7af79f6e475
0x291d9f9764c72c9ba6ff47b451a9f7885ebf9977false0xa815e2ed7f7d5b0c49fda367f249232a1b9d288314180887098008640xa815e2ed7f7d5b0c49fda367f249232a1b9d28836330630999999999999813598344321966802009602023-07-29T07:44:29.000Z0x065d01eeb5c9ff65be4b8abc1131037360324cb3e32d4612058fdca2a66d3294
Query with partition filter
SELECT *
FROM `tt-contracts.pancakeswap_v3_zksyncera.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
0x342b221540d65329d62af8eb1bb1b13ad1c5f194-58845false0xf8b59f3c3ab33200ec80a8a58b2aa5f5d2a8944c281251000-7011793309731505080x86b04d463cb60e702ebdada9431b0cd25a47bc0b2023-11-02T08:46:04.000Z41797921983705315718170737300x32321f0409aa487a64af84c4c1640b236d19a58fd073ff413b9d5b9ec5fa26a5420
0x342b221540d65329d62af8eb1bb1b13ad1c5f194-58922false0xf8b59f3c3ab33200ec80a8a58b2aa5f5d2a8944c126230000-6371793314931505080x100b70b8b6476568a7eea9cb127c6ae394f91f7a2023-11-02T08:46:57.000Z41637638669161493383404047720xcfc80d1810031eab4b8797664264f29f1e52ba91bbef4f1c23117dbb60f8277e390
0x342b221540d65329d62af8eb1bb1b13ad1c5f194-58761false0xf8b59f3c3ab33200ec80a8a58b2aa5f5d2a8944c43219447-6171793303931505080xe707f1e173a8eeb0d884cad975a245db5a9c182e2023-11-02T08:45:04.000Z41974254810416029645557174880x795c9b5a64c7d3845226cd9ba40d535ebf95f329c3688c31e99be3d4c00f5a01370
Query with partition filter
SELECT *
FROM `tt-contracts.pancakeswap_v3_zksyncera.Pool_Swap_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100