pancakeswap_v2_bsc

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
0xca143ce32fe78f1f7019d7d551a6402fc5350c73	0xf44f3cc1defacc086a805592d4f7b299ea62bd9b	false	1291965	0xd9e0adeb9a8d384315a14e3703c77131feef4e34	0xe9e7cea3dedca5984780bafc599bd69add087d56	0	27441382	2023-04-18T00:36:58.000Z	0xb32087cd64fa9f2b6dcca95da4e95b86f75e6af02cf6eee1da461512be5d94cc
0xca143ce32fe78f1f7019d7d551a6402fc5350c73	0x7af71a08461b001573cae20a41959b959e9a8e64	false	1292224	0x6ddd36f6c7c021ebf7d4b9753537d7bca8ed4e37	0xbb4cdb9cbd36b01bd1cbaebf2de08d9173bc095c	256	27451047	2023-04-18T08:41:29.000Z	0xc74db8fc86cadaecacabebd00764755b44bbfe561475a44392ac4206727e10ed
0xca143ce32fe78f1f7019d7d551a6402fc5350c73	0x5b1ba85a495734635644d56c33a71f79da80115b	false	1292546	0x50dca860ef66b2f76e14cfc88d955f3ff7c6f435	0xbb4cdb9cbd36b01bd1cbaebf2de08d9173bc095c	512	27458902	2023-04-18T15:14:57.000Z	0xe182fbbd2cb904ef402a2bea529d1b4bbc4b67d7a32bf4bd6c72c710c9ff2936

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.pancakeswap_v2_bsc.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
0x1ad9feb1af22bed6e61fc9cea780fb0367a16cda	0x6c3061b1bb8674fecc49240e2ab91a04127a6365	false	0x10ed43c718714eb63d5aa57b78b54704e256024e	256	1013367653096291882465445	10658091139340154785070	33031358	2023-10-29T16:22:53.000Z	0x928568ec6fa8878d57f8bfaebfb3a68da388d715d66c71d1a5fe6cbcc6b24bd1
0x82b1878066149a727f6b6736feb155bea7c2a779	0x046a9b3a9b743340ee2bc4c6ddd35543e237c6c2	false	0x10ed43c718714eb63d5aa57b78b54704e256024e	256	120458239679138495	581807514785418968659	33021727	2023-10-29T08:20:10.000Z	0xc7f8b0d9ee4029c3051ee0e7862b213f5910244b85dc0823eed0a94f411bd6d8
0x4ec7c9f185d4cd8342492522a80a416ea5de9817	0xb74d3f55adb14e5c18590c18b2c071e71c8ff19f	false	0x10ed43c718714eb63d5aa57b78b54704e256024e	256	18213863837971263454	4601350816072190419743	33013815	2023-10-29T01:43:38.000Z	0x1f7228b21f2786672d2e63fa471edfb2feae9339e670cd0fb1df2f3c0745baa0

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.pancakeswap_v2_bsc.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
0x6612879d031846723ecf7322afb4f3a97a045dc2	false	0x10ed43c718714eb63d5aa57b78b54704e256024e	646	1283113441593685015182604	106480399318898264	9568256	2021-07-29T06:47:04.000Z	0x3874e6563c54047f8b0263bc0bdbda378710a4c1bc4b66b3a559db4d6801cdab
0x8dbcd6222213b7829910a51dd217ef9e94fa16de	false	0x10ed43c718714eb63d5aa57b78b54704e256024e	492	49877160037650582	10520380309066489	9568256	2021-07-29T06:47:04.000Z	0xf68488ee575ae7ccbbf180cb442c15010adcd36f7589923e0e09da0c869785d0
0x4f2ee75371b31af8ffa7de05ac04ca670390410f	false	0x10ed43c718714eb63d5aa57b78b54704e256024e	625	2310691287310203954340	1756792096694708732	9568512	2021-07-29T06:59:56.000Z	0x87ed736a2d834570cd4d4471ff54a1306a5ccfc76dc4f7d68c42fd6e67ff9209

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.pancakeswap_v2_bsc.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_amount1In	in_amount0Out	block_timestamp	transaction_hash
0xbe4b76587af273d2f78477b080bb5e22ff0e560b	0x1372d045ccd6f05cf5e6fcf1d6946b85ec165fd7	false	0x10ed43c718714eb63d5aa57b78b54704e256024e	94	15750656	83103084147332791	139804000000000000000000	2022-03-04T00:10:40.000Z	0x34407f15ce48960b4363a8794fe4dbd9778e9fc49e505e0188fb124f8cb6e536
0x16f5724e55dd31d3f9108927da30cbc6926e5b92	0x7291f24a881b7b0e6bea9eb8e5cb8082c3945be3	false	0x10ed43c718714eb63d5aa57b78b54704e256024e	341	15750656	1998317545000000000	21578345967322076855406087	2022-03-04T00:10:40.000Z	0xf1c18c6d1c3c7f5ed75d3785dd5ee637801709fbe3e94776149c2583022fd2cb
0xea046790029536f455042409a4c5f6d26f909cc1	0x7291f24a881b7b0e6bea9eb8e5cb8082c3945be3	false	0xea046790029536f455042409a4c5f6d26f909cc1	4	15750656	212082000000000000	2349129682739809428313195	2022-03-04T00:10:40.000Z	0xc8503d1940233dbccf895dd1080d58d68dc349df059e14c7a62dc39006fea179

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.pancakeswap_v2_bsc.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
0xba01662e978de7d67f8ffc937726215eb8995d17	false	81	1667975575117920644421945	4507588925681895135998	11636736	2021-10-10T00:07:54.000Z	0x25e8c176d91bebbdb4ed5da0c843d917f84b56082f86352413c1671e67923c26
0xbcfd0d4a37feb4dceaaefa9da28cd833e5f04e9f	false	355	346104549650394139611703	3415139790564459215439	11636736	2021-10-10T00:07:54.000Z	0xc6e1d3733fc54075f18b7dee10a284195d2fb37cc24c7459193e9765d5ab1968
0xb43bc4ba0a476b37a640324cee67e9c27ab740b5	false	162	191114994795863896	13087965625920230217392	11636736	2021-10-10T00:07:54.000Z	0xa2ade3bd4e3205b320b6bc964db52e024a3723dfe6d9fcd5d4abd3ca7786b309

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.pancakeswap_v2_bsc.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
0x7fe377759ac1b0237e135cf5dc1530f1d698d78c	0x00039ec7875b6124c0f18e739da9d9c12c6e46ab	0x0000000000000000000000000000000000000000	false	5291502622129181181002231	185	8689839	2021-06-28T11:47:42.000Z	0x45ac092d957ed8de4ddf6a59be6392899f58a85517924409be9e3fe2bfa81bfb
0x0000000000000000000000000000000000000000	0x00039ec7875b6124c0f18e739da9d9c12c6e46ab	0x0000000000000000000000000000000000000000	false	1000	184	8689839	2021-06-28T11:47:42.000Z	0x45ac092d957ed8de4ddf6a59be6392899f58a85517924409be9e3fe2bfa81bfb
0x000000000000000000000000000000000000dead	0x00039ec7875b6124c0f18e739da9d9c12c6e46ab	0x7fe377759ac1b0237e135cf5dc1530f1d698d78c	false	5291502622129181181002231	234	8689883	2021-06-28T11:49:54.000Z	0x49ceb6b6e86e9fe71445cec29b3256074cf7c03c7fef14da84b99ad0e1723360

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.pancakeswap_v2_bsc.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