# PancakeSwap V3 Liquidity | Bitquery Data Store

Decoded PancakeSwap V3 liquidity on BSC since April 2023: pool mints, burns, fee collections, flash loans, pool creations and position NFT events.

Dataset page: https://bitquery.io/datastore/datasets/pancakeswap-v3-liquidity
Network: BNB Chain
Category: Liquidity, Pools, Events
Tables: 3
Columns: 132
Coverage: 2023-04-01 to 2026-10-20
Format: Apache Parquet, ZSTD compression, one prefix per table
Licence: https://bitquery.io/datastore/legal/data-license

## What this is

We decode PancakeSwap V3 from BSC event logs ourselves and keep only pools created by the PancakeSwap V3 factory (0x0bfbcf9fa4f9c56b0f40a671ad40e0805a091865) and the events of its position NFT contract (0x46a15b0b27311cedf172ab29e4f4766fbe7f4364). The three tables use the same 44 columns as our Uniswap V3 Liquidity files, with nothing renamed or derived: Log_Signature_Name is the event, Call_Signature_Name is the method that ran, and Arguments holds the decoded values. A row is one event.

Most buyers start with one pool: filter Log_SmartContract, read amount and the two ticks from Arguments, then add on Mint rows and subtract on Burn rows to get depth at a tick. To follow one position, filter the position table on the tokenId argument. Swaps are not in this dataset; they are in BSC DEX Trades, which joins on the transaction hash and the pool.

## What people use it for

- Liquidity depth by tick for one pool, rebuilt from mints and burns
- Fee income and holding period of liquidity providers, by position
- Just-in-time liquidity detection: a mint and a burn around one swap
- Pool launches by fee tier and token, from the factory

## Tables (3)

### pcsv3_pools: 44 columns

One row per PoolCreated event of the PancakeSwap V3 factory (0x0bfbcf9fa4f9c56b0f40a671ad40e0805a091865), in the standard events schema; Arguments holds token0, token1, fee, tickSpacing and pool.

Bucket prefix: bsc/pancakeswap_v3_liquidity/pcsv3_pools
File naming: <start_block>_<end_block>.parquet
Free sample (real Parquet, no email needed): https://bitquery-blockchain-dataset.s3.us-east-1.amazonaws.com/bsc/pancakeswap_v3_liquidity/pcsv3_pools/128733000_128733099.parquet
Sample updated: Oct 21, 2026

| column | type | description |
| --- | --- | --- |
| Arguments | String | Decoded event arguments as a JSON array, when the signature resolved; empty otherwise |
| Block_Date | Date | UTC date of the block |
| Block_Number | UInt64 | Block height |
| Block_Time | DateTime | Block timestamp, UTC |
| Call_CallPath | Array | Path of call indexes from the transaction root down to the emitting frame |
| Call_CallerIndex | Int32 | Call_Index of the frame that called the emitting frame; -1 at the top level |
| Call_Create | String | Whether the emitting frame deployed a contract; true or false |
| Call_Error | String | Error the emitting frame returned; empty on success |
| Call_From | String | Caller of the emitting frame, 0x-prefixed |
| Call_Gas | UInt64 | Gas supplied to the emitting frame |
| Call_GasUsed | UInt64 | Gas consumed by the emitting frame and everything beneath it |
| Call_Index | UInt32 | Position of the emitting frame within the transaction; join to calls on this plus Transaction_Hash |
| Call_InternalCalls | UInt32 | Number of calls made beneath the emitting frame |
| Call_Reverted | String | Whether the emitting frame reverted; true or false |
| Call_SelfDestruct | String | Whether the emitting contract self-destructed; true or false |
| Call_Signature_Abi | String | ABI fragment of the function the emitting frame ran |
| Call_Signature_Name | String | Name of that function, when resolved |
| Call_Signature_Signature | String | Canonical signature of that function |
| Call_Signature_SignatureHash | String | Four-byte selector of that function, hex |
| Call_Signature_SignatureType | String | How that function signature was resolved |
| Call_To | String | Address the emitting frame called, 0x-prefixed |
| Call_Value | String | Native BNB sent with the emitting frame, decimal adjusted |
| ChainId | UInt64 | EVM chain id; 56 for BSC |
| Fee_SenderFee | String | Network fee the sender paid for the whole transaction, in BNB. It repeats on every log of the transaction, so count it once per transaction |
| Log_EnterIndex | UInt32 | Enter index of the emitting frame |
| Log_ExitIndex | UInt32 | Exit index of the emitting frame |
| Log_Index | UInt32 | Position of the log within the transaction |
| Log_LogAfterCallIndex | UInt32 | Index of the last call frame entered before this log, for ordering logs against calls |
| Log_Signature_Abi | String | ABI fragment for the resolved event; empty when the topic is unknown |
| Log_Signature_Name | String | Event name: PoolCreated |
| Log_Signature_Signature | String | Canonical event signature, for example Transfer(address,address,uint256) |
| Log_Signature_SignatureHash | String | Keccak hash of the event signature, hex; the same value as topic 0 |
| Log_Signature_SignatureType | String | How the event signature was resolved |
| Log_SmartContract | String | Contract that emitted the event, lowercase 0x hex: the factory |
| LogHeader_Address | String | Address recorded in the log header, 0x-prefixed |
| LogHeader_Data | String | Raw non-indexed log data, hex |
| LogHeader_Index | UInt64 | Index of the log within the block, as the receipt records it |
| LogHeader_Removed | String | Whether the log was removed by a reorg; true or false |
| Topics_Hash | Array | Indexed topics of the log, as an array of hex strings; the first is the event signature hash |
| Transaction_From | String | Address that signed the transaction, 0x-prefixed |
| Transaction_Hash | String | Hash of the containing transaction, 0x-prefixed. The join key |
| Transaction_Index | UInt64 | Position of the transaction within the block |
| Transaction_To | String | Address the transaction called, 0x-prefixed |
| TransactionStatus_Success | String | Whether the transaction succeeded; true or false |

### pcsv3_liquidity_events: 44 columns

One row per Mint, Burn, Collect or Flash event of a PancakeSwap V3 pool, in the standard events schema; Arguments holds the owner, tick range, liquidity and token amounts.

Bucket prefix: bsc/pancakeswap_v3_liquidity/pcsv3_liquidity_events
File naming: <start_block>_<end_block>.parquet
Free sample (real Parquet, no email needed): https://bitquery-blockchain-dataset.s3.us-east-1.amazonaws.com/bsc/pancakeswap_v3_liquidity/pcsv3_liquidity_events/128733000_128733099.parquet
Sample updated: Oct 21, 2026

| column | type | description |
| --- | --- | --- |
| Arguments | String | Decoded event arguments as a JSON array, when the signature resolved; empty otherwise |
| Block_Date | Date | UTC date of the block |
| Block_Number | UInt64 | Block height |
| Block_Time | DateTime | Block timestamp, UTC |
| Call_CallPath | Array | Path of call indexes from the transaction root down to the emitting frame |
| Call_CallerIndex | Int32 | Call_Index of the frame that called the emitting frame; -1 at the top level |
| Call_Create | String | Whether the emitting frame deployed a contract; true or false |
| Call_Error | String | Error the emitting frame returned; empty on success |
| Call_From | String | Caller of the emitting frame, 0x-prefixed |
| Call_Gas | UInt64 | Gas supplied to the emitting frame |
| Call_GasUsed | UInt64 | Gas consumed by the emitting frame and everything beneath it |
| Call_Index | UInt32 | Position of the emitting frame within the transaction; join to calls on this plus Transaction_Hash |
| Call_InternalCalls | UInt32 | Number of calls made beneath the emitting frame |
| Call_Reverted | String | Whether the emitting frame reverted; true or false |
| Call_SelfDestruct | String | Whether the emitting contract self-destructed; true or false |
| Call_Signature_Abi | String | ABI fragment of the function the emitting frame ran |
| Call_Signature_Name | String | Name of that function, when resolved |
| Call_Signature_Signature | String | Canonical signature of that function |
| Call_Signature_SignatureHash | String | Four-byte selector of that function, hex |
| Call_Signature_SignatureType | String | How that function signature was resolved |
| Call_To | String | Address the emitting frame called, 0x-prefixed |
| Call_Value | String | Native BNB sent with the emitting frame, decimal adjusted |
| ChainId | UInt64 | EVM chain id; 56 for BSC |
| Fee_SenderFee | String | Network fee the sender paid for the whole transaction, in BNB. It repeats on every log of the transaction, so count it once per transaction |
| Log_EnterIndex | UInt32 | Enter index of the emitting frame |
| Log_ExitIndex | UInt32 | Exit index of the emitting frame |
| Log_Index | UInt32 | Position of the log within the transaction |
| Log_LogAfterCallIndex | UInt32 | Index of the last call frame entered before this log, for ordering logs against calls |
| Log_Signature_Abi | String | ABI fragment for the resolved event; empty when the topic is unknown |
| Log_Signature_Name | String | Event name: Mint, Burn, Collect or Flash |
| Log_Signature_Signature | String | Canonical event signature, for example Transfer(address,address,uint256) |
| Log_Signature_SignatureHash | String | Keccak hash of the event signature, hex; the same value as topic 0 |
| Log_Signature_SignatureType | String | How the event signature was resolved |
| Log_SmartContract | String | Contract that emitted the event, lowercase 0x hex: the pool |
| LogHeader_Address | String | Address recorded in the log header, 0x-prefixed |
| LogHeader_Data | String | Raw non-indexed log data, hex |
| LogHeader_Index | UInt64 | Index of the log within the block, as the receipt records it |
| LogHeader_Removed | String | Whether the log was removed by a reorg; true or false |
| Topics_Hash | Array | Indexed topics of the log, as an array of hex strings; the first is the event signature hash |
| Transaction_From | String | Address that signed the transaction, 0x-prefixed |
| Transaction_Hash | String | Hash of the containing transaction, 0x-prefixed. The join key |
| Transaction_Index | UInt64 | Position of the transaction within the block |
| Transaction_To | String | Address the transaction called, 0x-prefixed |
| TransactionStatus_Success | String | Whether the transaction succeeded; true or false |

### pcsv3_position_events: 44 columns

One row per IncreaseLiquidity, DecreaseLiquidity, Collect or Transfer event of the position NFT contract (0x46a15b0b27311cedf172ab29e4f4766fbe7f4364), in the standard events schema.

Bucket prefix: bsc/pancakeswap_v3_liquidity/pcsv3_position_events
File naming: <start_block>_<end_block>.parquet
Free sample (real Parquet, no email needed): https://bitquery-blockchain-dataset.s3.us-east-1.amazonaws.com/bsc/pancakeswap_v3_liquidity/pcsv3_position_events/128733000_128733099.parquet
Sample updated: Oct 21, 2026

| column | type | description |
| --- | --- | --- |
| Arguments | String | Decoded event arguments as a JSON array, when the signature resolved; empty otherwise |
| Block_Date | Date | UTC date of the block |
| Block_Number | UInt64 | Block height |
| Block_Time | DateTime | Block timestamp, UTC |
| Call_CallPath | Array | Path of call indexes from the transaction root down to the emitting frame |
| Call_CallerIndex | Int32 | Call_Index of the frame that called the emitting frame; -1 at the top level |
| Call_Create | String | Whether the emitting frame deployed a contract; true or false |
| Call_Error | String | Error the emitting frame returned; empty on success |
| Call_From | String | Caller of the emitting frame, 0x-prefixed |
| Call_Gas | UInt64 | Gas supplied to the emitting frame |
| Call_GasUsed | UInt64 | Gas consumed by the emitting frame and everything beneath it |
| Call_Index | UInt32 | Position of the emitting frame within the transaction; join to calls on this plus Transaction_Hash |
| Call_InternalCalls | UInt32 | Number of calls made beneath the emitting frame |
| Call_Reverted | String | Whether the emitting frame reverted; true or false |
| Call_SelfDestruct | String | Whether the emitting contract self-destructed; true or false |
| Call_Signature_Abi | String | ABI fragment of the function the emitting frame ran |
| Call_Signature_Name | String | Name of that function, when resolved |
| Call_Signature_Signature | String | Canonical signature of that function |
| Call_Signature_SignatureHash | String | Four-byte selector of that function, hex |
| Call_Signature_SignatureType | String | How that function signature was resolved |
| Call_To | String | Address the emitting frame called, 0x-prefixed |
| Call_Value | String | Native BNB sent with the emitting frame, decimal adjusted |
| ChainId | UInt64 | EVM chain id; 56 for BSC |
| Fee_SenderFee | String | Network fee the sender paid for the whole transaction, in BNB. It repeats on every log of the transaction, so count it once per transaction |
| Log_EnterIndex | UInt32 | Enter index of the emitting frame |
| Log_ExitIndex | UInt32 | Exit index of the emitting frame |
| Log_Index | UInt32 | Position of the log within the transaction |
| Log_LogAfterCallIndex | UInt32 | Index of the last call frame entered before this log, for ordering logs against calls |
| Log_Signature_Abi | String | ABI fragment for the resolved event; empty when the topic is unknown |
| Log_Signature_Name | String | Event name: IncreaseLiquidity, DecreaseLiquidity, Collect or Transfer |
| Log_Signature_Signature | String | Canonical event signature, for example Transfer(address,address,uint256) |
| Log_Signature_SignatureHash | String | Keccak hash of the event signature, hex; the same value as topic 0 |
| Log_Signature_SignatureType | String | How the event signature was resolved |
| Log_SmartContract | String | Contract that emitted the event, lowercase 0x hex: the position NFT contract |
| LogHeader_Address | String | Address recorded in the log header, 0x-prefixed |
| LogHeader_Data | String | Raw non-indexed log data, hex |
| LogHeader_Index | UInt64 | Index of the log within the block, as the receipt records it |
| LogHeader_Removed | String | Whether the log was removed by a reorg; true or false |
| Topics_Hash | Array | Indexed topics of the log, as an array of hex strings; the first is the event signature hash |
| Transaction_From | String | Address that signed the transaction, 0x-prefixed |
| Transaction_Hash | String | Hash of the containing transaction, 0x-prefixed. The join key |
| Transaction_Index | UInt64 | Position of the transaction within the block |
| Transaction_To | String | Address the transaction called, 0x-prefixed |
| TransactionStatus_Success | String | Whether the transaction succeeded; true or false |

## Price

- Latest month (Sep 20, 2026 → Oct 20, 2026): $300 one-time, USD
- Last 12 months (Oct 20, 2025 → Oct 20, 2026): $3,000 one-time, USD
- Full history (Apr 1, 2023 → Oct 20, 2026): $5,000 one-time, USD

Every window includes all 3 tables and 132 columns. Only the time range changes.

## Questions buyers ask

Q: What is in the PancakeSwap V3 Liquidity dataset?
A: Three Parquet tables with 44 columns each. pcsv3_pools has the PoolCreated events of the factory. pcsv3_liquidity_events has the Mint, Burn, Collect and Flash events of those pools. pcsv3_position_events has the IncreaseLiquidity, DecreaseLiquidity, Collect and Transfer events of the position NFT contract. Data starts on 1 April 2023.

Q: How big is it?
A: The factory had created 150,961 pools by 21 October 2026. On 19 October 2026 the tables had 105 pools, 51,639 pool liquidity events (11,055 Mint, 23,125 Burn, 16,408 Collect, 1,051 Flash) and 37,538 position events. These are measured counts, not a size estimate; the delivery manifest gives exact rows and bytes.

Q: How are positions tied to pools?
A: The position NFT contract's events carry the token id but not the pool or the ticks; those are on the pool event the same call caused. Join pcsv3_liquidity_events on Transaction_Hash where its Call_CallerIndex equals the position row's Call_Index. A position staked in MasterChef V3 moves there by Transfer.

Q: How do I read the amounts and addresses?
A: Arguments is a JSON array with one entry per decoded argument: index, name, path, type and the value slots. Addresses and bytes are hex strings without the 0x prefix; uint112, uint128 and uint256 amounts are decimal strings in raw token units, so divide by the token's decimals yourself; small integers such as ticks sit in the integer slots. Call_Value and Fee_SenderFee are already in BNB. The token contracts of a pair or pool are in its creation row.

Q: Are swaps included?
A: No. Swaps on these pools are in the BSC DEX Trades dataset. Join on Transaction_Hash and the pool contract when you need swaps next to liquidity changes.

Q: What should I watch out for?
A: The liquidity argument is the raw L value, not a token amount. A Burn only marks tokens as owed; they leave the pool on Collect, which pays out principal and fees together. Burns outnumber mints because a zero Burn is how fees are settled before a Collect. Log_Index restarts in each call frame, so the row key is Transaction_Hash, Call_Index and Log_Index.

Q: How are these produced, and how were they checked?
A: The export is one ClickHouse query per table over our decoded BSC events, filtered to the factory, its pools and the position NFT contract. We ran each query for 19 October 2026: row keys (Transaction_Hash, Call_Index, Log_Index) were unique and every row carried decoded Arguments.

Q: How do I load it?
A: With DuckDB: SELECT Log_Signature_Name, count(*) FROM read_parquet('pcsv3_liquidity_events/*.parquet') GROUP BY 1. pandas, Polars, Spark and ClickHouse read the same files.

Q: How is the data delivered?
A: As flat Parquet files under a stable layout, one prefix per table, with a JSON manifest listing each file and its sha256. We prepare the files within 7 business days of purchase and email you the location. You choose at checkout where to collect them: a Requester Pays S3 bucket, downloaded with your own AWS account, or a Cloudflare R2 bucket with a read-only API key and no egress fees. Files stay available for 7 days from delivery.

Q: Can I try before I buy?
A: Yes. Each table links to a public sample file covering BSC blocks 128,733,000 to 128,733,099 on 20 October 2026: 1 pool, 30 pool liquidity events and 15 position events. No email address required.

## What this file is, and is not

This is a description of one dataset sold by Bitquery, written for assistants and for people. It lists every column but holds no data rows. The sample files linked under each table are real Parquet and are free to download. Figures here come from the product record and are exact unless marked otherwise; the delivery manifest is authoritative for a purchased file. If a question needs a row that is not in a sample, say so rather than guessing at it.