pancakeswap_v1_bsc

Tables

CakePool_Harvest_event

CAKE token reward harvest events from PancakeSwap V1 staking pools on BNB Smart Chain. Tracks when users claim accumulated staking rewards with sender addresses and harvested amounts for yield farming analysis.

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_amount`	`STRING`	Input amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination.

Sample Data

address	removed	in_amount	in_sender	log_index	block_number	block_timestamp	transaction_hash
0x45c54210128a065de780c4b0df3d16664f7f859e	false	1999999596535325980	0xd583b8b4afbda844b3b1f92cf6f5a52462417b04	173	29646510	2023-07-03T18:05:54.000Z	0x61d7a0d3f78dd96e9dc0460a2974b060e28fce4cdecd6c3417cc473a01028233
0x45c54210128a065de780c4b0df3d16664f7f859e	false	1999999596535325980	0xab97b45c25d20ade1abcfb5c2a76ae05ca338925	248	29638598	2023-07-03T11:29:19.000Z	0x6b2cc1fb7d4df1a5825dbffca5b134993b9913b132a42fecb91c6cff8a72764f
0x45c54210128a065de780c4b0df3d16664f7f859e	false	1999999596535325980	0x1d6d65ed253f5c710f5194592dd8a904e2592903	365	29643235	2023-07-03T15:21:39.000Z	0x6d2aaee232461fe3a02cc2c110128e67e4fc3c8f3ebd55387d0989831e0655da

Example Query

Query with partition filter

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

MasterChefV2_UpdateCakeRate_event

CAKE token emission rate adjustments in PancakeSwap V2 MasterChef farming contract on BSC. Tracks changes to regular farm, special farm, and burn rate parameters for analyzing tokenomics and yield distribution over time.

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_burnRate`	`STRING`	Rate at which CAKE tokens are burned per block in this emission configuration update, denominated in smallest token units (wei). This value, along with regular and special farm rates, determines the total CAKE emission distribution across PancakeSwap’s MasterChef V2 pools.
`in_regularFarmRate`	`STRING`	Rate at which CAKE tokens are allocated to regular liquidity mining farms per block, denominated in the smallest token unit (wei). This parameter determines the emission rate for standard yield farming pools on PancakeSwap V2.
`in_specialFarmRate`	`STRING`	Token emission rate allocated to special farms per block, denominated in the smallest token unit (wei). Values represent the distribution rate for priority farming pools as configured in PancakeSwap’s MasterChef V2 contract.

Sample Data

address	removed	log_index	in_burnRate	block_number	block_timestamp	transaction_hash	in_regularFarmRate	in_specialFarmRate
0xa5f8c5dbd5f286960b9d90548680ae5ebff07652	false	392	721180555555	22050574	2022-10-10T08:39:54.000Z	0x203eccfe9973516d9da5fc616ad449fa1d161c9cbd5477cad3ba339214da4f15	50819500000	227999944445
0xa5f8c5dbd5f286960b9d90548680ae5ebff07652	false	387	752430558075	24352239	2022-12-30T13:02:02.000Z	0x49750b952493607a6dedd3ec780ee17e10fc7fcc0f1315f7ab70731f146252ba	50819500000	196749941925
0xa5f8c5dbd5f286960b9d90548680ae5ebff07652	false	248	899996126377	29530461	2023-06-29T17:06:51.000Z	0x3dff1b640917bd3513804132a91b90b1c19c904ea1427f48a92ce7aef05b002c	4003198545	96000675078

Example Query

Query with partition filter

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

MasterChefV2_updateCakeRate_function

Administrative function calls that update CAKE token emission rates in PancakeSwap V2’s MasterChef staking contract on BSC. Tracks governance adjustments to regular farm, special farm, and burn rate parameters for analyzing tokenomics changes.

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.
`trace_address`	`STRING`	Hierarchical position of the internal call within a transaction’s execution trace. Comma-separated sequence of integers representing the call path, where each number indicates the index of the call at that nesting level, with null representing top-level calls.
`status`	`BOOL`	Transaction execution outcome indicator. Boolean value where true represents successful execution and false represents failed execution.
`from_address`	`STRING`	Address that initiated the transaction or contract call. Hex-encoded, 0x-prefixed, 42-character string.
`to_address`	`STRING`	Address receiving the transaction or contract call. Hex-encoded, 0x-prefixed, 42-character string.
`value`	`FLOAT64`	Amount of native cryptocurrency sent with the transaction. Floating-point representation in whole units (e.g., ETH, BNB, MATIC).
`gas_used`	`INT64`	Amount of gas consumed by the transaction execution. Integer representing the actual computational steps used.
`gas`	`NUMERIC`	Gas limit allocated for the transaction execution. Integer representing the maximum computational steps allowed.
`signature`	`STRING`	Function selector identifying which contract function was called. 10-character hex string including 0x prefix.
`in__burnRate`	`STRING`	Rate of CAKE tokens designated for burning, specified as a per-block emission parameter in wei units. This parameter is one of three distribution rates updated when adjusting tokenomics in PancakeSwap’s MasterChef V2 contract.
`in__regularFarmRate`	`STRING`	CAKE emission rate allocated to regular farms per block, denominated in the smallest token unit (wei). Values typically range from 1 to 14 billion wei per block based on tokenomics adjustments.
`in__specialFarmRate`	`STRING`	Emission rate of CAKE tokens allocated to special farms in the PancakeSwap MasterChef V2 contract, expressed as tokens per block in Wei units. This rate governs rewards for priority liquidity pools and is adjusted through governance updates.
`in__withUpdate`	`BOOL`	Boolean flag indicating whether to trigger an immediate update of all pool reward calculations when adjusting CAKE emission rates. When true, recalculates pending rewards across all farms before applying the new rate parameters.

Sample Data

gas	status	gas_used	signature	to_address	block_number	from_address	in__burnRate	trace_address	in__withUpdate	block_timestamp	transaction_hash	in__regularFarmRate	in__specialFarmRate
4111108	true	2838417	0xdc6363df	0xa5f8c5dbd5f286960b9d90548680ae5ebff07652	27743907	0xecc90d54b10add1ab746abe7e83abe178b72aa9e	862962189942	0,2,0	true	2023-04-28T13:14:22.000Z	0xc04a29e65a26f3decb5bb985746de5eab8f8592d4a96b3692769961fc94f7850	14686048280	122351761778
4392134	true	2334092	0xdc6363df	0xa5f8c5dbd5f286960b9d90548680ae5ebff07652	43027108	0xa1f482dc58145ba2210bc21878ca34000e2e8fe4	965934098341	0,3,0,0	true	2024-10-11T15:39:40.000Z	0x57828954754ab1e9233330d3a8296a56a8a6552470a0514e491ea6ecee9155f5	5868437079	28197464580
4123836	true	2315518	0xdc6363df	0xa5f8c5dbd5f286960b9d90548680ae5ebff07652	35389061	0xa1f482dc58145ba2210bc21878ca34000e2e8fe4	965934098341	0,2,0,0	true	2024-01-19T19:12:54.000Z	0x45ae014eea43f45dbf3371333595dbec94a1ae0f5e84f5622aba0a6d105c5f66	3798378999	30267522660

Example Query

Query with partition filter

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

MasterChefV2_withdraw_function

Withdrawal transactions from PancakeSwap V1 MasterChef V2 yield farming contract on BNB Smart Chain (BSC), capturing when users unstake LP tokens from specific pool IDs. Used for analyzing farming position exits, liquidity changes, and harvest claim patterns across 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.
`trace_address`	`STRING`	Hierarchical position of the internal call within a transaction’s execution trace. Comma-separated sequence of integers representing the call path, where each number indicates the index of the call at that nesting level, with null representing top-level calls.
`status`	`BOOL`	Transaction execution outcome indicator. Boolean value where true represents successful execution and false represents failed execution.
`from_address`	`STRING`	Address that initiated the transaction or contract call. Hex-encoded, 0x-prefixed, 42-character string.
`to_address`	`STRING`	Address receiving the transaction or contract call. Hex-encoded, 0x-prefixed, 42-character string.
`value`	`FLOAT64`	Amount of native cryptocurrency sent with the transaction. Floating-point representation in whole units (e.g., ETH, BNB, MATIC).
`gas_used`	`INT64`	Amount of gas consumed by the transaction execution. Integer representing the actual computational steps used.
`gas`	`NUMERIC`	Gas limit allocated for the transaction execution. Integer representing the maximum computational steps allowed.
`signature`	`STRING`	Function selector identifying which contract function was called. 10-character hex string including 0x prefix.
`in__pid`	`STRING`	Pool identifier for the reward pool or staking position. String-encoded integer used to reference specific pools within the protocol.
`in__amount`	`STRING`	Amount of tokens involved in the transaction. String-encoded integer representing token quantity in smallest unit (wei for ETH, base units for ERC20 tokens).

Sample Data

gas	status	in__pid	gas_used	signature	in__amount	to_address	block_number	from_address	trace_address	block_timestamp	transaction_hash
1372635	true	11	79454	0x441a3e70	21086157075288542	0xa5f8c5dbd5f286960b9d90548680ae5ebff07652	50536266	0x285f793ce97079d4a5712e616afbbb971dbf1f1f	0,3	2025-05-29T19:50:24.000Z	0x76dcca9c87e1010cce9ba6df30c738559623fc125520f413eb7b090e7d113615
1594897	true	13	42543	0x441a3e70	0	0xa5f8c5dbd5f286960b9d90548680ae5ebff07652	50542666	0x83a5d5c54ad83bbea8667b3b95d7610e16e52723	0,1	2025-05-29T22:30:24.000Z	0xb974e394a54b6ae9dd86474e78a62e3e64f09a96fc2853309c06afd06f5a40b3
1594897	true	13	42543	0x441a3e70	0	0xa5f8c5dbd5f286960b9d90548680ae5ebff07652	50515069	0x8ef56e94bbaee1638c3c87d3ab0de0a90e2cb067	0,1	2025-05-29T11:00:26.000Z	0x2138fa06178da184ef9203c8e93c99d718123c018741af330eb178440e08e9d8

Example Query

Query with partition filter

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

PancakeFactory_PairCreated_event

Liquidity pool creation events from PancakeSwap V1 automated market maker (AMM) factory contract on BNB Smart Chain. Tracks token0/token1 pairs and their deployed pool addresses for analyzing DEX (decentralized exchange) liquidity provisioning and new market launches.

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	0x832c97a61cccd3bcce924936222a55642943983b	false	1334542	0x4c8c66ebf4075dc0823ed6933e517d317d24191b	0xbb4cdb9cbd36b01bd1cbaebf2de08d9173bc095c	0	28306064	2023-05-18T02:25:11.000Z	0x7206ae8580d5c6c0e0bc9d13f2ddec2848e25ef523e20a3bcff4e2c80c8755a5
0xca143ce32fe78f1f7019d7d551a6402fc5350c73	0x6a6dfa6d95909f08a5456356e26f0c10ff1bf3eb	false	1334890	0x9376ee93f38779121cdfc3f7f588548b28ee3232	0xbb4cdb9cbd36b01bd1cbaebf2de08d9173bc095c	256	28312996	2023-05-18T08:12:02.000Z	0xc0f88b09d94f375c754f1da0e7c7df6fa0eb73e18a6a718a3b12aaf8d95fa09f
0xca143ce32fe78f1f7019d7d551a6402fc5350c73	0x9c157a40cb5a336be66d7a73daa1a030458670d3	false	1335349	0x6e4ed12ebb1d770edc8811503c12fcde6649da14	0xbb4cdb9cbd36b01bd1cbaebf2de08d9173bc095c	512	28319613	2023-05-18T13:43:14.000Z	0xfd6cab9fee8389ce5c149f364985cbd939c18183b917a943df60aae821e1ab2a

Example Query

Query with partition filter

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

PancakePair_Swap_event

Token swap events from PancakeSwap V1 liquidity pairs on BNC Smart Chain (BSC). Records input/output amounts for both tokens in each swap, useful for analyzing DEX trading volume, price impact, and liquidity pool activity.

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
0x2cd7ca738e568589bc1c0875c0d6dec867f41bfa	0x703f1c0b4399a51704e798002281bf26d6f9c2e6	false	0xacec72231a614fbfc154b9f950e994f1a9bb6d0a	48	17009920	161708157203557416398	49059589	2022-04-17T00:05:45.000Z	0xb13ff8ecf617f0a7d407c2c925fbe90ee60e1580b7d4db647ed08ae512cf5902
0x7efaef62fddcca950418312c6c91aef321375a00	0x7752e1fa9f3a2e860856458517008558deb989e3	false	0x10ed43c718714eb63d5aa57b78b54704e256024e	369	17009920	610464228540823969725	365081817684335331700	2022-04-17T00:05:45.000Z	0x2f5fb835d8897a75d3276ccd90107ebbbe326aedb33552a8f7bafd66f5652532
0x10ed43c718714eb63d5aa57b78b54704e256024e	0x9b68b1ff6cddd2733c41c8bdf6f89c01db9baf86	false	0x10ed43c718714eb63d5aa57b78b54704e256024e	140	17009920	533784739770816773329416095	1009499469524721946	2022-04-17T00:05:45.000Z	0xe884f51d465b6b8d23c760849380a25c08823cb7383627a1d83cb8cde6e65e88

Example Query

Query with partition filter

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

PancakePair_Sync_event

Liquidity pool reserve balance updates from PancakeSwap V1 automated market maker (AMM) on BNB Smart Chain (BSC). Sync events capture token reserve levels (reserve0, reserve1) after each swap, mint, or burn operation for analyzing pool liquidity depth and price movements.

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
0x580e98a1879c01be5a534a90babf4c45f12ec4b8	false	487	238735725533328954421263297812983	45442344880569344516	13434880	2021-12-13T08:45:38.000Z	0xa2bcc9caee0562f01805058a4c62cfb610d0f7cb43762d53f63b51e010b018f8
0xb72723e36a83fb5fe1793f06b436f4720f5de4f9	false	59	166652530331145446393248	14815199699262201278639638	13434880	2021-12-13T08:45:38.000Z	0x2b7b5224996551d82c033213805f704a18a114359c867409e6a7e30ca47ded5d
0x4d2274fecb0783f7d10f581ea59097c4ed031779	false	768	66904581122742749193543	44901555474589408	13434880	2021-12-13T08:45:38.000Z	0x4a35d8b1f0dfc52790b4924807f8d9a231fc5b108fbd5ba79f9d6206a38ff01f

Example Query

Query with partition filter

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

Metrics

Primitives

Contracts

Blockchain

Tables

CakePool_Harvest_event

MasterChefV2_UpdateCakeRate_event

MasterChefV2_updateCakeRate_function

MasterChefV2_withdraw_function

PancakeFactory_PairCreated_event

PancakePair_Swap_event

PancakePair_Sync_event

Metrics

Primitives

Contracts

Blockchain

​Tables

​CakePool_Harvest_event

​MasterChefV2_UpdateCakeRate_event

​MasterChefV2_updateCakeRate_function

​MasterChefV2_withdraw_function

​PancakeFactory_PairCreated_event

​PancakePair_Swap_event

​PancakePair_Sync_event

Tables

CakePool_Harvest_event

MasterChefV2_UpdateCakeRate_event

MasterChefV2_updateCakeRate_function

MasterChefV2_withdraw_function

PancakeFactory_PairCreated_event

PancakePair_Swap_event

PancakePair_Sync_event