pancakeswap_v2_zksyncera

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
0xd03d8d566183f0086d8d09a84e1e30b58dd5619d	0x02c362ab72ce14e9fe187f59711ecc70a0e52864	false	9	0x5aea5775959fbc2557cc8789bc1bf90a239d9a91	0xc49fccde799448fb4f306f88905fe01790dd45f3	13	9909918	2023-07-30T04:57:33.000Z	0x2c969c9e20ae79bed99c8cd9e51773a608a159d62910d0ebd399d8e15d3045e6
0xd03d8d566183f0086d8d09a84e1e30b58dd5619d	0xd0f4d683ed1653bed0f99ed30a83565551490959	false	10	0x0e97c7a0f8b2c9885c8ac9fc6136e829cbc21d42	0x5aea5775959fbc2557cc8789bc1bf90a239d9a91	42	9911064	2023-07-30T05:16:45.000Z	0x0bd59b469edbe99210838b66f52dee43207af1f1a6fcc80e52c5c7ba8749a68f
0xd03d8d566183f0086d8d09a84e1e30b58dd5619d	0x410d9a30853b4e55df53ce3912b90e0ab6c5aad4	false	81	0x2050149d278170e3b6aee33dbde29ceb714a1b86	0x5aea5775959fbc2557cc8789bc1bf90a239d9a91	197	21178535	2023-12-11T00:10:54.000Z	0x7b1bc7f23ffe17a680199921d6f122db2ee8995141c40f2f084c7bc5acc2014d

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.pancakeswap_v2_zksyncera.Factory_PairCreated_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
0x14e12b53458b30fcb9065ebf539aedd0791063d9	0x6221d55a5da5f89970aa4e3a54142948e5120e1d	false	0x14e12b53458b30fcb9065ebf539aedd0791063d9	46	16673433	27139462227254871559	20100220381436029	2023-10-18T06:36:54.000Z	0xcbe3d7ade22aa74bb79cd83935e083dfbb563c4f47b48cf8960a0ee5b8de82ee
0x14e12b53458b30fcb9065ebf539aedd0791063d9	0x63edb9338d81c6d8219856548251bacf2a9b1830	false	0x14e12b53458b30fcb9065ebf539aedd0791063d9	62	16704259	342849276	220661403908489221	2023-10-18T15:35:42.000Z	0x3efb1a4b3b24abf005a5c332b6f163add160c8ac7b84dd5dc683a92f73e77e89
0x14e12b53458b30fcb9065ebf539aedd0791063d9	0x63edb9338d81c6d8219856548251bacf2a9b1830	false	0x14e12b53458b30fcb9065ebf539aedd0791063d9	36	16726633	109424781	70307368469983439	2023-10-18T21:56:04.000Z	0x4ccb9d5cff5bda71c079aa9eeab9549e87169446965ae86f4cec8ce964b876cd

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.pancakeswap_v2_zksyncera.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
0x1d2fce385d536798036b936139887e825f147d49	false	7	21980681803204098790	9156363500998	11209905	2023-08-14T11:03:52.000Z	0x39e1c590b94b26452ae94b8dfc99d7b6385110075eb426839f36a573adc740fd
0x1d2fce385d536798036b936139887e825f147d49	false	13	22164193783458827333	9080363500998	11206819	2023-08-14T10:10:57.000Z	0x40c83dd52e276ceafd9ad4e415f094e3427d22a21ea4f60b22d501adc4506d44
0x1d2fce385d536798036b936139887e825f147d49	false	13	21065711122360484167	9555075544464	11221750	2023-08-14T14:25:20.000Z	0xd7209e7cec2e4fabbcc83278d3860f3997af6155c982b57bdcbaad2672d77b78

Example Query

Query with partition filter

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

Metrics

Primitives

Contracts

Blockchain

Tables

Factory_PairCreated_event

Pair_Swap_event

Pair_Sync_event

Metrics

Primitives

Contracts

Blockchain

​Tables

​Factory_PairCreated_event

​Pair_Swap_event

​Pair_Sync_event

Tables

Factory_PairCreated_event

Pair_Swap_event

Pair_Sync_event