BSC DEX Trades

One Parquet table with 54 columns: one row per swap our indexer decodes on BSC DEXes, with both sides, the pool, fees, the transaction and a USD value. Failed trades stay in with a flag, and NFT marketplace trades stay in too.

About 6.2 billion trades over 73 months, roughly 2.1 TB as Parquet, estimated from the sample files. The last 24 months hold about 4.4 billion rows, the last 12 about 2.9 billion and the latest month about 287 million. Row counts come from the live table; exact figures arrive with the delivery manifest.

To the start of our index: from 12 September 2020, at block 413,426, the first swap in our index, to yesterday.

PancakeSwap v3 and Infinity, Uniswap v2, v3 and v4, and the Flap and Four.meme launchpads carry most rows, with Curve, Fluid and DODO behind them, 20 protocol names in the last month. On BSC most uniswap_v2 rows are PancakeSwap v2: 2.3 million of 2.4 million on 24 September 2026 came from its factory, 0xca143ce32fe78f1f7019d7d551a6402fc5350c73. The protocol name describes the pool design, so group by Trade_Dex_OwnerAddress, the factory, to split forks that share a design.

The export applies no filter of its own: failed trades, spam tokens and zero-value trades all stay in, and the columns let you drop them. Launchpad trades on Flap and Four.meme are kept; most of their tokens have no price unless the other side is BNB. Failed trades ran as high as 17.5% of rows on a sampled day in 2024.

Each swap takes its USD value from one side, the safer one: a stablecoin (USDT, USDC and BUSD) first, then BNB or WBNB, then any other priced token, at the block's hourly price from our own hourly BSC price series, which has covered about 7,600 tokens over its life. The same value goes on both sides, so a thin token cannot inflate a swap against BNB. On one sampled day a year, between 70% and 98% of trades had a stablecoin, BNB or WBNB on one side; the free sample has a USD value on 96.6% of rows. A value of 0 means no price for either side.

Decoded from BSC by our own indexer, which reads each DEX's swap events and ties them to the transaction and the calling contract. USD values are added at export from our price series. Before release we ran the export query over blocks 123,753,184 to 123,753,283 and read the two sample files back: 4,688 trades, 54 columns, no empty values, USD on 96.6% of rows. Rerun over the blocks of our older 2026 sample file, it found the same 1,455 trades.

For one token, filter the contract column on either side to its address and sum Trade_Buy_AmountInUSD over successful swaps. For a v2 or v3 pool, filter Trade_Dex_SmartContract to the pool; for Uniswap v4 and PancakeSwap Infinity, filter Trade_PoolId, since their pools share one contract.

A routed swap through several pools is several rows: 51% of sample trades share a transaction with another swap, so sum by transaction for trader volume and by pool for DEX volume. The buyer address is usually a router; Transaction_From is the trader. Failed trades are 7.0% of the sample, some inside successful transactions, so filter Trade_Success. USDT on BSC has 18 decimals where Ethereum uses 6, so compare decimal-adjusted amounts, never raw integers, across chains.

One line in DuckDB: SELECT * FROM read_parquet('dex_trades/*.parquet') LIMIT 10. Pandas works too: pandas.read_parquet(path). The sample file opens without credentials.

Refreshed daily with T+1 latency, so a purchase made today includes everything to yesterday. Delivered as Parquet named by block range, 50 blocks per file and sorted ascending, under a stable S3 layout with a JSON manifest listing every file and its sha256. Signed HTTPS links are emailed once the files are prepared, or on request we deliver into your own S3, GCS or R2 bucket.