> ## Documentation Index
> Fetch the complete documentation index at: https://tokenterminal.com/docs/llms.txt
> Use this file to discover all available pages before exploring further.
# pancakeswap_v1_bsc
> Tables in tt-contracts.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.
| 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. |
| 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 |
**Query with partition filter**
```sql theme={null}
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.
| 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. |
| 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 |
**Query with partition filter**
```sql theme={null}
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.
| 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. |
| gas | value | 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 | 0 | true | 2838417 | 0xdc6363df | 0xa5f8c5dbd5f286960b9d90548680ae5ebff07652 | 27743907 | 0xecc90d54b10add1ab746abe7e83abe178b72aa9e | 862962189942 | 0,2,0 | true | 2023-04-28T13:14:22.000Z | 0xc04a29e65a26f3decb5bb985746de5eab8f8592d4a96b3692769961fc94f7850 | 14686048280 | 122351761778 |
| 4392134 | 0 | true | 2334092 | 0xdc6363df | 0xa5f8c5dbd5f286960b9d90548680ae5ebff07652 | 43027108 | 0xa1f482dc58145ba2210bc21878ca34000e2e8fe4 | 965934098341 | 0,3,0,0 | true | 2024-10-11T15:39:40.000Z | 0x57828954754ab1e9233330d3a8296a56a8a6552470a0514e491ea6ecee9155f5 | 5868437079 | 28197464580 |
| 4123836 | 0 | true | 2315518 | 0xdc6363df | 0xa5f8c5dbd5f286960b9d90548680ae5ebff07652 | 35389061 | 0xa1f482dc58145ba2210bc21878ca34000e2e8fe4 | 965934098341 | 0,2,0,0 | true | 2024-01-19T19:12:54.000Z | 0x45ae014eea43f45dbf3371333595dbec94a1ae0f5e84f5622aba0a6d105c5f66 | 3798378999 | 30267522660 |
**Query with partition filter**
```sql theme={null}
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.
| 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). |
| gas | value | status | in\_\_pid | gas\_used | signature | in\_\_amount | to\_address | block\_number | from\_address | trace\_address | block\_timestamp | transaction\_hash |
| ------- | ----- | ------ | --------- | --------- | ---------- | ----------------- | ------------------------------------------ | ------------- | ------------------------------------------ | -------------- | ------------------------ | ------------------------------------------------------------------ |
| 1372635 | 0 | true | 11 | 79454 | 0x441a3e70 | 21086157075288542 | 0xa5f8c5dbd5f286960b9d90548680ae5ebff07652 | 50536266 | 0x285f793ce97079d4a5712e616afbbb971dbf1f1f | 0,3 | 2025-05-29T19:50:24.000Z | 0x76dcca9c87e1010cce9ba6df30c738559623fc125520f413eb7b090e7d113615 |
| 1594897 | 0 | true | 13 | 42543 | 0x441a3e70 | 0 | 0xa5f8c5dbd5f286960b9d90548680ae5ebff07652 | 50542666 | 0x83a5d5c54ad83bbea8667b3b95d7610e16e52723 | 0,1 | 2025-05-29T22:30:24.000Z | 0xb974e394a54b6ae9dd86474e78a62e3e64f09a96fc2853309c06afd06f5a40b3 |
| 1594897 | 0 | true | 13 | 42543 | 0x441a3e70 | 0 | 0xa5f8c5dbd5f286960b9d90548680ae5ebff07652 | 50515069 | 0x8ef56e94bbaee1638c3c87d3ab0de0a90e2cb067 | 0,1 | 2025-05-29T11:00:26.000Z | 0x2138fa06178da184ef9203c8e93c99d718123c018741af330eb178440e08e9d8 |
**Query with partition filter**
```sql theme={null}
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.
| 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. |
| 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 |
**Query with partition filter**
```sql theme={null}
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.
| 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. |
| in\_to | address | removed | in\_sender | log\_index | block\_number | in\_amount0In | in\_amount1In | in\_amount0Out | in\_amount1Out | block\_timestamp | transaction\_hash |
| ------------------------------------------ | ------------------------------------------ | ------- | ------------------------------------------ | ---------- | ------------- | --------------------------- | ------------- | -------------- | --------------------- | ------------------------ | ------------------------------------------------------------------ |
| 0x2cd7ca738e568589bc1c0875c0d6dec867f41bfa | 0x703f1c0b4399a51704e798002281bf26d6f9c2e6 | false | 0xacec72231a614fbfc154b9f950e994f1a9bb6d0a | 48 | 17009920 | 161708157203557416398 | 0 | 0 | 49059589 | 2022-04-17T00:05:45.000Z | 0xb13ff8ecf617f0a7d407c2c925fbe90ee60e1580b7d4db647ed08ae512cf5902 |
| 0x7efaef62fddcca950418312c6c91aef321375a00 | 0x7752e1fa9f3a2e860856458517008558deb989e3 | false | 0x10ed43c718714eb63d5aa57b78b54704e256024e | 369 | 17009920 | 610464228540823969725 | 0 | 0 | 365081817684335331700 | 2022-04-17T00:05:45.000Z | 0x2f5fb835d8897a75d3276ccd90107ebbbe326aedb33552a8f7bafd66f5652532 |
| 0x10ed43c718714eb63d5aa57b78b54704e256024e | 0x9b68b1ff6cddd2733c41c8bdf6f89c01db9baf86 | false | 0x10ed43c718714eb63d5aa57b78b54704e256024e | 140 | 17009920 | 533784739770816773329416095 | 0 | 0 | 1009499469524721946 | 2022-04-17T00:05:45.000Z | 0xe884f51d465b6b8d23c760849380a25c08823cb7383627a1d83cb8cde6e65e88 |
**Query with partition filter**
```sql theme={null}
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.
| 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. |
| 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 |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.pancakeswap_v1_bsc.PancakePair_Sync_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***