pancakeswap_v2_opbnb

Tables

Factory_PairCreated_event

Decentralized exchange (DEX) liquidity pool creation events emitted by Automated Market Maker (AMM) factory contracts. Records new trading pair deployments with token addresses, deployed pair contract address, and creation sequence number for tracking pool instantiation across DEX protocols.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_token0`	`STRING`	Contract address of the first token in the trading pair. Hex-encoded, 0x-prefixed, 42-character string.
`in_token1`	`STRING`	Contract address of the second token in the trading pair. Hex-encoded, 0x-prefixed, 42-character string.
`in_pair`	`STRING`	Contract address of the liquidity pool pair created for trading between two tokens. Hex-encoded, 0x-prefixed, 42-character string.
`in_anon3`	`STRING`	Sequential counter tracking the total number of pairs created by the factory contract.

Sample Data

address	in_pair	removed	in_anon3	in_token0	in_token1	log_index	block_number	block_timestamp	transaction_hash
0x02a84c1b3bbd7401a5f7fa98a384ebc70bb5749e	0x955f4d38e0443a750bc404ddef4bac36bf696c74	false	11828	0x2779106e4f4a8a28d77a24c18283651a2ae22d1c	0xe2864c5ee37a3178d560c55282637cdda355c351	20	38274131	2024-10-27T11:17:34.000Z	0x677a1b0966ed5214ebd19cdfcdd9d25bbf43d8e09a7ab5ed9f9db7f2ee1fba34
0x02a84c1b3bbd7401a5f7fa98a384ebc70bb5749e	0xa962cddfabf9edd10c560916acc508c7d3317547	false	59	0x4200000000000000000000000000000000000006	0x74a6287bdd90831cff5bdb70a8bc25dba53e96c6	1	9709855	2023-12-01T20:46:18.000Z	0x594efcf4c6d5bebb9e80688879bac20a6b39b7ded606696f933ee4afbfa000f0
0x02a84c1b3bbd7401a5f7fa98a384ebc70bb5749e	0x948a7114ba61e28559276d983b2a049a404086a8	false	200	0x7c6b91d9be155a6db01f749217d76ff02a7227f2	0x9e5aac1ba1a2e6aed6b32689dfcf62a509ca96f3	33	22924815	2024-05-02T19:35:38.000Z	0x03faf140f80968bcd2cb2f626fccdeb65a1e03782776dc9a4b74fb538e475d80

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.pancakeswap_v2_opbnb.Factory_PairCreated_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

Pair_Burn_event

Liquidity removal events from DEX (Decentralized Exchange) trading pairs recording amounts of both tokens withdrawn when liquidity providers burn LP tokens. Used for tracking liquidity provision activity and calculating total value locked (TVL) changes in automated market maker (AMM) pools.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_sender`	`STRING`	Address that initiated the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_amount0`	`STRING`	Amount of token0 involved in the liquidity pool operation. Numeric string representation of token quantity in smallest denomination.
`in_amount1`	`STRING`	Amount of token1 involved in the liquidity pool operation. Numeric string representation of token quantity in smallest denomination.
`in_to`	`STRING`	Destination address receiving tokens or assets in the operation. Hex-encoded, 0x-prefixed, 42-character string.

Sample Data

in_to	address	removed	in_sender	log_index	in_amount0	in_amount1	block_number	block_timestamp	transaction_hash
0x8cfe327cec66d1c090dd72bd0ff11d690c33a2eb	0x4106f2efc659b89563886590057005961df1de87	false	0x8cfe327cec66d1c090dd72bd0ff11d690c33a2eb	16	26819989723294507888	2617446814191582796	6357323	2023-10-24T01:30:46.000Z	0xf1971d687c33a15664cf8d7e0e3bb62320710cac70f91485122868bb55e6c406
0xcab8788c9c788eee1741a00f9bb742230be426cc	0x83156933912102600305864d350f02934d3388df	false	0x8cfe327cec66d1c090dd72bd0ff11d690c33a2eb	42	1024285104778351860210	61744219658033277541730	19598061	2024-03-25T07:29:44.000Z	0xde7c4708ab0c1d039879b3b01ae3c62b48cd67e40708e5b6459c89eedc846c8b
0x5adf094d761386ba011cc3236d5905a06b45e4ba	0xb0dd4b25026cf685eb988d47a4f34cf84c47f2f0	false	0x8cfe327cec66d1c090dd72bd0ff11d690c33a2eb	39	37541545858663429	6189288616152447	19651698	2024-03-25T22:23:41.000Z	0xa6d890dd9bbd9b5353b890624707b02525ab6888da4988e6e0b74fd72e6a8aa6

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.pancakeswap_v2_opbnb.Pair_Burn_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

Pair_Mint_event

Liquidity provision events emitted when users add tokens to a DEX pair contract. Records sender address and token amounts deposited for liquidity pool operations.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_sender`	`STRING`	Address that initiated the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_amount0`	`STRING`	Amount of token0 involved in the liquidity pool operation. Numeric string representation of token quantity in smallest denomination.
`in_amount1`	`STRING`	Amount of token1 involved in the liquidity pool operation. Numeric string representation of token quantity in smallest denomination.

Sample Data

address	removed	in_sender	log_index	in_amount0	in_amount1	block_number	block_timestamp	transaction_hash
0x177f0bcef458cb379581a9b8e67e02abfe4a3d08	false	0x8cfe327cec66d1c090dd72bd0ff11d690c33a2eb	48	681500000000000000000	456670911300296500	13365502	2024-01-13T04:13:45.000Z	0x51c851c9807c009d1ea3f6c4e25d1aa08a804754f285330a85f510b28f935c9e
0x937d951a63c8a42bc369c3266dce9f73a629fd27	false	0x8cfe327cec66d1c090dd72bd0ff11d690c33a2eb	32	100000000000	100000000	13376114	2024-01-13T07:10:37.000Z	0xf78604131d0e668f6423a7588f770dd4dfe4ee13f345a3636398e70de2b78c1c
0x937d951a63c8a42bc369c3266dce9f73a629fd27	false	0x8cfe327cec66d1c090dd72bd0ff11d690c33a2eb	61	1000000000000	1000000000	13375078	2024-01-13T06:53:21.000Z	0x43fc94768aaa8d1cc22ce558ed5ca26a2a63417239a7db027fc11b58a7ea1f3a

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.pancakeswap_v2_opbnb.Pair_Mint_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

Pair_Swap_event

Token swap events from decentralized exchange (DEX) liquidity pairs recording input and output amounts for both tokens. Primary source for tracking DEX trading activity and price discovery.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_sender`	`STRING`	Address that initiated the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_amount0In`	`STRING`	Amount of token0 transferred into the liquidity pool during a swap operation. Stored as decimal string representing the smallest unit of the token.
`in_amount1In`	`STRING`	Amount of token1 transferred into the liquidity pool during a swap operation. Stored as decimal string representing the smallest unit of the token.
`in_amount0Out`	`STRING`	Amount of token0 transferred out of the liquidity pool during a swap operation. Stored as decimal string representing the smallest unit of the token.
`in_amount1Out`	`STRING`	Amount of token1 transferred out of the liquidity pool during a swap operation. Stored as decimal string representing the smallest unit of the token.
`in_to`	`STRING`	Destination address receiving tokens or assets in the operation. Hex-encoded, 0x-prefixed, 42-character string.

Sample Data

in_to	address	removed	in_sender	log_index	block_number	in_amount0In	in_amount1Out	block_timestamp	transaction_hash
0x000000000000c6399510f47ef7691db4db17ae8a	0xad762f6c35a1d871508831edd568e497e27cf87e	false	0x000000000000c6399510f47ef7691db4db17ae8a	3	26366470	994994749894334	626294874728040478	2024-06-11T15:36:33.000Z	0xfeebef80847edc11e8b7f4efbe61be829304219d9488cb6f1176b20730a7ea2f
0x000000000000c6399510f47ef7691db4db17ae8a	0x706f7257e78b6f2404a1afb5c480645a6f5be91d	false	0x000000000000c6399510f47ef7691db4db17ae8a	3	26385072	3100831777459541	1902146135669330781	2024-06-11T20:46:35.000Z	0x84e58dd669763d590551a312ad2d0152f078ca1bbd9d0dc189368aa913e96e76
0x04556a9977761b3fb08f575d54a3affe339003cd	0x6273081f09b0d0ee17627e28ce5f7ceba9c97040	false	0x04556a9977761b3fb08f575d54a3affe339003cd	14	26391231	3542168743399342	31805719136980	2024-06-11T22:29:14.000Z	0xe09abbb19e814244c70abc4d08c60e3d7ca7c024a4f0a9dccf043754831c8315

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.pancakeswap_v2_opbnb.Pair_Swap_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

Pair_Sync_event

Liquidity pair reserve synchronization events emitted after each swap, mint, or burn operation. Contains updated reserve balances for both tokens in AMM (Automated Market Maker) pools, enabling real-time price calculation and liquidity tracking.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_reserve0`	`STRING`	Reserve amount of the first token in a liquidity pool after a state-changing operation. Stored as decimal string representing the smallest unit of the token.
`in_reserve1`	`STRING`	Reserve amount of the second token in a liquidity pool after a state-changing operation. Stored as decimal string representing the smallest unit of the token.

Sample Data

address	removed	log_index	in_reserve0	in_reserve1	block_number	block_timestamp	transaction_hash
0x0087ee7a03f0b2bc1cee2314ac30b7b902f59f28	false	15	1852468775593503591	144808877770822416458	31028789	2024-08-04T14:41:52.000Z	0x1bd58c5e5a87756e131b728bd6cf8421c1e7001c6a697c057d2c6b750dee1fd3
0x0087ee7a03f0b2bc1cee2314ac30b7b902f59f28	false	10	1816452979685897909	147687277730156690149	31037917	2024-08-04T17:14:00.000Z	0x732209c50328d4d9090a90bbb2d102540a49f3575ae5bb92e92eeb884ac0e8aa
0x03c50d27f98e9ad3d378aad558aede066cda5496	false	9	1108185408483715781	451373928550828048174	31039789	2024-08-04T17:45:12.000Z	0x7675ea6a97079665f95a38e915bc704346e1703dd90406771aaf1fb861d5fd33

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.pancakeswap_v2_opbnb.Pair_Sync_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

Pair_Transfer_event

ERC20 Transfer events emitted by liquidity pair contracts in automated market maker (AMM) decentralized exchanges (DEXs). Records minting, burning, and transfer of LP (liquidity provider) tokens representing ownership shares in trading pairs.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_from`	`STRING`	Address originating the transfer or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_to`	`STRING`	Destination address receiving tokens or assets in the operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_value`	`STRING`	Amount of tokens transferred, minted, or burned in the operation. Numeric string representation preserving precision for large integer values.

Sample Data

in_to	address	in_from	removed	in_value	log_index	block_number	block_timestamp	transaction_hash
0xb0dd4b25026cf685eb988d47a4f34cf84c47f2f0	0xb0dd4b25026cf685eb988d47a4f34cf84c47f2f0	0xa44c097e7ddfa2beafc4d16c9bda5e4f294497d2	false	18289566758555952	16	20833090	2024-04-08T14:33:33.000Z	0xf189ad81500e6d2c14efa4b63f5ea26b386664b7c7f204592d56fd40854f1bc7
0x0000000000000000000000000000000000000000	0xb0dd4b25026cf685eb988d47a4f34cf84c47f2f0	0xb0dd4b25026cf685eb988d47a4f34cf84c47f2f0	false	18289566758555952	18	20833090	2024-04-08T14:33:33.000Z	0xf189ad81500e6d2c14efa4b63f5ea26b386664b7c7f204592d56fd40854f1bc7
0xa35e7c976c90212e6000b67d0b39d737d8e05e24	0xb0dd4b25026cf685eb988d47a4f34cf84c47f2f0	0x0000000000000000000000000000000000000000	false	629013825303	17	20833090	2024-04-08T14:33:33.000Z	0xf189ad81500e6d2c14efa4b63f5ea26b386664b7c7f204592d56fd40854f1bc7

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.pancakeswap_v2_opbnb.Pair_Transfer_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

Metrics

Primitives

Contracts

Blockchain

Tables

Factory_PairCreated_event

Pair_Burn_event

Pair_Mint_event

Pair_Swap_event

Pair_Sync_event

Pair_Transfer_event

Metrics

Primitives

Contracts

Blockchain

​Tables

​Factory_PairCreated_event

​Pair_Burn_event

​Pair_Mint_event

​Pair_Swap_event

​Pair_Sync_event

​Pair_Transfer_event

Tables

Factory_PairCreated_event

Pair_Burn_event

Pair_Mint_event

Pair_Swap_event

Pair_Sync_event

Pair_Transfer_event