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
25000x0bfbcf9fa4f9c56b0f40a671ad40e0805a0918650x2c545cefddafd2ce8ad709df888fdee081cb241afalse0x42000000000000000000000000000000000000060x5c750f8cd4a3b5f211e0894a68f82611211e8fb42732672526502024-08-23T15:17:29.000Z0xac8f338d9156601964e8552867b9114ff9584ff218add16627f1844fea13dd2b
25000x0bfbcf9fa4f9c56b0f40a671ad40e0805a0918650xa536d38d9c1363ed235ec757600a19cd7d297dd9false0x0ede01a62360a4d92d7caac38d7701e95142efb50x42000000000000000000000000000000000000063416579676502024-02-19T09:03:19.000Z0x8f2a4cf79a926844a5c29e38431d6c6f66a2e2e2c4298c363993914f8123e8ab
1000x0bfbcf9fa4f9c56b0f40a671ad40e0805a0918650xf13ac1b43300ed87f5d38993c73762ca5ecb8b19false0x42000000000000000000000000000000000000060x762463066a3f67575c5e6b175bdbbbb4927528f2102672187712024-06-15T18:20:00.000Z0xb7f46939c9d306b878977d330634d4aca4b79c6633948c3313e1452fb4fc95f0
Query with partition filter
SELECT *
FROM `tt-contracts.pancakeswap_v3_opbnb.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
0x12b3d79d6c05b7e495a3f50114e230e540151b50false0x46a15b0b27311cedf172ab29e4f4766fbe7f436462742393888693651206764799999999999999901761742851400514202024-03-02T09:19:11.000Z0x81e318e7c7312d745c9c87f9677b9d17e841ea02276dcaf851ec8c6c8d09b3a4
0x4a5c4ce5728d59a41e8dcd7a5e6697f9dc31aa0efalse0x46a15b0b27311cedf172ab29e4f4766fbe7f43640100017664895-49600-478002024-03-02T22:30:18.000Z0x22c913f315a5fbf5378a84c90f748cdd9f85a5ba968397ce345923de30af54c9
0x4a5c4ce5728d59a41e8dcd7a5e6697f9dc31aa0efalse0x46a15b0b27311cedf172ab29e4f4766fbe7f4364240704641665585080334290210867849555145625917622897-48800-486002024-03-02T10:50:20.000Z0x6f2a6ec136f56d71069c3b4b92da8d35231bbad5ba0c044adc348f4a327d9c8d
Query with partition filter
SELECT *
FROM `tt-contracts.pancakeswap_v3_opbnb.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
0xd9004241d34392e9ae0c84d5acdf76941a27d8d1false0x46a15b0b27311cedf172ab29e4f4766fbe7f4364142825087458077476696598838988597940880184088070x00dfbcf0c5afe7f3228f1b93af2eb77b45b7cbec252024-03-11T13:08:50.000Z0xc38d2f8a274a9f54e1d1ca1debc75f9a4e7d3c0d5683b19570713a0a6f0e4b9c
0xd9004241d34392e9ae0c84d5acdf76941a27d8d1false0x46a15b0b27311cedf172ab29e4f4766fbe7f4364453048742102414762051024894658755251999183843850x00dfbcf0c5afe7f3228f1b93af2eb77b45b7cbec10122024-03-11T06:21:48.000Z0xc47379d7dfaa4bf618ed4302645b3e9e26b8b5d7d2f5d5ab6b12e00752382410
0xd9004241d34392e9ae0c84d5acdf76941a27d8d1false0x46a15b0b27311cedf172ab29e4f4766fbe7f4364252936134757372544470959087621223243406184167550x00dfbcf0c5afe7f3228f1b93af2eb77b45b7cbec-5-32024-03-11T15:21:18.000Z0x98a61352b3d292579ac9eecb3647f3119585eab30996ad25356b0146f6aecb9d
Query with partition filter
SELECT *
FROM `tt-contracts.pancakeswap_v3_opbnb.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
0xde632a1481a8e01700cdf1818e89fb4c2a9acec6false0xd3cc086b024f109b53f00cc98e4cf7785e1fad7451554959930989978335205602926024598233750xd3cc086b024f109b53f00cc98e4cf7785e1fad742025-05-28T00:05:49.000Z0xc7ecc1493eb09a2eaa601f8a0c2b8e67e492392fca5822b047897e6eccf2aa6f
0x88e5b75ba8456df571787af1115568cad9d93ca6false0xd3cc086b024f109b53f00cc98e4cf7785e1fad745710756447400371890882447874561450528034598233750xd3cc086b024f109b53f00cc98e4cf7785e1fad742025-05-28T00:05:49.000Z0xc7ecc1493eb09a2eaa601f8a0c2b8e67e492392fca5822b047897e6eccf2aa6f
0xc4f981189558682f15f60513158b699354b30204false0xd3cc086b024f109b53f00cc98e4cf7785e1fad74488811999445275896854529460342148621288598233750xd3cc086b024f109b53f00cc98e4cf7785e1fad742025-05-28T00:05:49.000Z0xc7ecc1493eb09a2eaa601f8a0c2b8e67e492392fca5822b047897e6eccf2aa6f
Query with partition filter
SELECT *
FROM `tt-contracts.pancakeswap_v3_opbnb.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
0xa71b4754c325a9e8f5de3cfa315109f12e29d995false40089061102800xac541896626f68133338d464f6d1847a9062502b958017812220553580404923220xac541896626f68133338d464f6d1847a9062502b2024-11-22T03:27:25.000Z0xc7a13648c77c52a1b5bbd63633b1403e76ed0b68058fac01f5d3a0bbcae0afce
0x006123f0dd1261e2758f7c889ad0ed1898b2c31afalse5000000000000xac541896626f68133338d464f6d1847a9062502b691000000000000000436506970xac541896626f68133338d464f6d1847a9062502b2024-12-28T16:47:00.000Z0x24b0b7f98c748fa9fc2e5a432f9fac145a25eea1debc23eba9dbad053bcd33db
0x421698a6d381b9090d9d92f63bef2d81f46ba911false1000000000000xac541896626f68133338d464f6d1847a9062502b1131000000000000000388479350xac541896626f68133338d464f6d1847a9062502b2024-11-03T02:40:58.000Z0x5fda84195bb9e55f50285b4bca9ea1769f3b737c7f423a6eabc93f1c7082d200
Query with partition filter
SELECT *
FROM `tt-contracts.pancakeswap_v3_opbnb.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
0xc4f981189558682f15f60513158b699354b30204false0x46a15b0b27311cedf172ab29e4f4766fbe7f43642061427142212074839367160x46a15b0b27311cedf172ab29e4f4766fbe7f43646360981954664824718915882977474736884940471442550456840568502024-01-25T10:40:27.000Z0xcdb2abf3611da1526b0cdfbefb6892e89317536f35f517500efbd1ad88c5768c
0xc4f981189558682f15f60513158b699354b30204false0x46a15b0b27311cedf172ab29e4f4766fbe7f43642095203644823490302921210x46a15b0b27311cedf172ab29e4f4766fbe7f43647796554335713950847515125745125261182766021442934556840568502024-01-25T11:44:28.000Z0xa79be361b141c33c19c9a4e4b60502ec312c6c87d61e08bae8961b58efcca80d
0xc4f981189558682f15f60513158b699354b30204false0x46a15b0b27311cedf172ab29e4f4766fbe7f43645743772579228441669840x46a15b0b27311cedf172ab29e4f4766fbe7f4364417104488191407779274998201368656007850741444352655820579102024-01-25T15:40:49.000Z0x0ec9d303b744c08645a2bd4354c7d4e30265ccd56cdef93044a89bae3583f21e
Query with partition filter
SELECT *
FROM `tt-contracts.pancakeswap_v3_opbnb.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
0x8e97fb6bee1813cb09a241db04809da8c43f49d5-82221false0x1b81d678ffb9c0263b24a97847620c99d213eb1427976835333591-2624158652547379940474209541959420x1b81d678ffb9c0263b24a97847620c99d213eb142024-06-01T07:38:42.000Z12988879559278207764910320730x7527da8042e28ed8b0f4e91a5501c3212584ecbde8ed611038ea0dc398b6568b1660620060
0xc71c9b3d94916630309d67651ae00a69c47bdf8a-53761false0xb89a6778d1efe7a5b7096757a21b810cc2886fa1275559148839480846-267966782561372552581993301455744471090xb89a6778d1efe7a5b7096757a21b810cc2886fa12024-06-01T22:05:42.000Z53894522092424276284198005330x500e4e6380af7093075b44a2c6bd0955a90ff29cf722aebf9f16bcbb1f7dac4e9450553027100
0x12b3d79d6c05b7e495a3f50114e230e540151b50-18492false0x1b81d678ffb9c0263b24a97847620c99d213eb1430-166647504026241586525473799476047693315432600x438d13cacc131fcad75aca9c3222c58354dbd0582024-06-01T07:38:42.000Z314316097065506769591708046710x7527da8042e28ed8b0f4e91a5501c3212584ecbde8ed611038ea0dc398b6568b044610
Query with partition filter
SELECT *
FROM `tt-contracts.pancakeswap_v3_opbnb.Pool_Swap_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100