pancakeswap_v2_base

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	0x061dc98bdc3a6dc1ce66a2f1ccb2812ff6b208f3	false	27	0x4200000000000000000000000000000000000006	0xf518f1ae3f62f0a0277e4431241500e04abf9e34	1	4138274	2023-09-18T19:38:15.000Z	0x4af49fe4ad25e75d566f1c03b0b246cdd4857bd6286d7a2af98274c55d664feb
0x02a84c1b3bbd7401a5f7fa98a384ebc70bb5749e	0x881267c700745fad3f3f41f56fe2dca09656b80f	false	28	0x291bed29520bff05ab888a8d47554ed4bebd48f7	0x4200000000000000000000000000000000000006	1	4138709	2023-09-18T19:52:45.000Z	0x828c583c3ddb8d6b4af3a6636e739adec7a09894daee5dc9bc501ad96c0522df
0x02a84c1b3bbd7401a5f7fa98a384ebc70bb5749e	0x2be9a91901b7209d52e2dd2a2c33a6c9c5e2ce40	false	25	0x0d317d14e751cce02029e2051923a46b366b4a78	0x4200000000000000000000000000000000000006	1	4135472	2023-09-18T18:04:51.000Z	0x0ba51f50ffbc1679c647047cd3e9843bdc0b575fdac3499ae3d5d7caa7258a80

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.pancakeswap_v2_base.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	0xc637ab6d3ab0c55a7812b0b23955ba6e40859447	false	0x8cfe327cec66d1c090dd72bd0ff11d690c33a2eb	50	165638043854152699517	187516971323555285	9862329	2024-01-29T07:40:05.000Z	0x88077d4cc426fb75ada7c448124a441409072c8b89f2258a7bdf1aa077f8990a
0x8cfe327cec66d1c090dd72bd0ff11d690c33a2eb	0xc637ab6d3ab0c55a7812b0b23955ba6e40859447	false	0x8cfe327cec66d1c090dd72bd0ff11d690c33a2eb	12	174689179870382157182	197763660872094929	9862363	2024-01-29T07:41:13.000Z	0x8af106dd3a179d2b72077a2398aa878e045b6ce2850cc006c3c6a84262a2b878
0x4543a5e44131f1b6cfd047e8326ee82d99de9841	0xc0e3d8ebffb13edf41430af5b456631f2c8a0a33	false	0x8cfe327cec66d1c090dd72bd0ff11d690c33a2eb	47	298579998	299998560	9867463	2024-01-29T10:31:13.000Z	0xc8e4590ca942bf33e23edcfa81fc5dcc8f2d588d3f82db492600053da062f81a

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.pancakeswap_v2_base.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
0xc637ab6d3ab0c55a7812b0b23955ba6e40859447	false	0x8cfe327cec66d1c090dd72bd0ff11d690c33a2eb	65	168473721050000000000	183126662516861137	9554020	2024-01-22T04:23:07.000Z	0x89a602ead42c2b8be631b705b548cf2cf44a9ab3f2addcda664c791634a4b0b5
0x92363f9817f92a7ae0592a4cb29959a88d885cc8	false	0x8cfe327cec66d1c090dd72bd0ff11d690c33a2eb	45	90514352476558	201960	8421375	2023-12-26T23:08:17.000Z	0xee3f5b37b4bb1a6e498b8db9d668d44d436cc011e82449782330819463f2e153
0xb5d365c872565e74340039b705b6786ce534b064	false	0x8cfe327cec66d1c090dd72bd0ff11d690c33a2eb	39	944910991310802678	943272628658981	8420191	2023-12-26T22:28:49.000Z	0x062bfd9a7ded70459c5b7a096c9b7ed46c459b247d643e4d507503fded689394

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.pancakeswap_v2_base.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
0x0d1b37728c75e0bf69bb0f5c997add8b15ee9103	0xeaa13b4f85a98e6ccaf65606361bd590e98de2cb	false	0x678aa4bf4e210cf2166753e054d5b7c31cc7fa86	25	5375435	87220336427899592	9117330003766026266	2023-10-17T10:56:57.000Z	0x18a4662fc2c921eab99e4a33d481c7c354276fd1b7b3f6b1efea1a8524059ecf
0x19ceead7105607cd444f5ad10dd51356436095a1	0x92363f9817f92a7ae0592a4cb29959a88d885cc8	false	0xac041df48df9791b0654f1dbbf2cc8450c5f2e9d	5	5391285	100000000000000	156458	2023-10-17T19:45:17.000Z	0x81c0a4895bdc6dda6c672882b9de4a9830b1e6a6578db763e2fe27380e7d9fd4
0x19ceead7105607cd444f5ad10dd51356436095a1	0x92363f9817f92a7ae0592a4cb29959a88d885cc8	false	0xac041df48df9791b0654f1dbbf2cc8450c5f2e9d	5	5389993	10000000000000	15711	2023-10-17T19:02:13.000Z	0x7718ee74177a8619c68612ce6fdbcd59407e920b30e8884c962ecd2511cab1e4

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.pancakeswap_v2_base.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
0x156bab5865e1b4b7777d4174f75673a715ff5e15	false	14	3120247983234584	994477313632281890252019697517128	3565245	2023-09-05T13:17:17.000Z	0xddadae225c6b7d96e3de23202087924c07b012bf14c42cad12a9dd880f992483
0x156bab5865e1b4b7777d4174f75673a715ff5e15	false	15	2809608629217245	1103929165247380553251020796033448	3565143	2023-09-05T13:13:53.000Z	0x785d30ca78c7bfe1946a8e2871398d5e81ef57d844dbaab149e1bbf315e3317b
0x156bab5865e1b4b7777d4174f75673a715ff5e15	false	18	2870247983234584	1080663675650818383602961470481400	3565171	2023-09-05T13:14:49.000Z	0xcea3787242bac4ded595a5edbc4fd8fa05f2d64b89e72b348d9728ae77f0f6f4

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.pancakeswap_v2_base.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
0x7fc42c8c0b2683c2ac8ef6fb4d7490488f6e0d2e	0x70ec099f22a13dbcaf047704e2bf78a675993d8a	0x0000000000000000000000000000000000000000	false	273861278752583055728	7	6902129	2023-11-21T19:06:45.000Z	0x60d12aa2afe1ce905c6a63b07bd8fa8d3a2cdba9fb69257a647d8d3fefaaa0f0
0x0000000000000000000000000000000000000000	0x70ec099f22a13dbcaf047704e2bf78a675993d8a	0x0000000000000000000000000000000000000000	false	1000	6	6902129	2023-11-21T19:06:45.000Z	0x60d12aa2afe1ce905c6a63b07bd8fa8d3a2cdba9fb69257a647d8d3fefaaa0f0
0x3f735bc202f47945b705908da46f59784469d653	0xb5d365c872565e74340039b705b6786ce534b064	0xb53c72242400d3b49e2d9279a572760ecb3750bd	false	2039395462589853	9	6883162	2023-11-21T08:34:31.000Z	0xafd48e92a4c8b0c2709fe46a5a60e8d05c183edeb7ee39b9c8f776da6d6ac96b

Example Query

Query with partition filter

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