Base DEX Trades

One Parquet table with 54 columns: one row per swap our indexer decodes on Base 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 2.2 billion trades over 39 months, roughly 629 GB as Parquet, estimated from the sample files. The last 24 months hold about 2.0 billion rows, the last 12 about 981 million and the latest month about 69 million. Row counts come from the live table; exact figures arrive with the delivery manifest.

To the start of our index: from 19 July 2023, at block 1,472,162, the first swap in our index, to yesterday.

Aerodrome Slipstream, Uniswap v3 and v4, PancakeSwap v3 and Aerodrome v2 carry most of the last month's rows, with Uniswap v2, PancakeSwap Infinity, Zora, Balancer, Curve and Fluid behind them, 15 protocol names in the last month. 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. Aerodrome pools changed label on 31 May 2026: Slipstream trades read uniswap_v3 before that day and aerodrome_slipstream after, and classic Aerodrome pools read aerodrome_v1 before and aerodrome_v2 after. Filter Trade_Dex_OwnerAddress to follow them across the change: Slipstream uses three factories, 0x5e7bb104d84c7cb9b682aac2f3d509f5f406809a, 0xf8f2eb4940cfe7d13603dddd87f123820fc061ef and 0xade65c38cd4849adba595a4323a8c7ddfe89716a, and classic pools 0x420dd381b31aef6683db6b902084cb0ffece40da.

Each swap takes its USD value from one side, the safer one: a stablecoin (USDC, the bridged USDbC, USDT and DAI) first, then ETH or WETH, then any other priced token, at the block's hourly price from Ethereum's hourly series for ETH, WETH and the stablecoins, since Base has no price series of its own; other tokens carry a USD value only when the other side is one of these. The same value goes on both sides, so a thin token cannot inflate a swap against ETH. On one sampled day a year, between 90% and 99% of trades had a stablecoin, ETH or WETH on one side; the free sample has a USD value on 91.3% of rows. A value of 0 means no price for either side.

Decoded from Base 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 51,730,927 to 51,731,026 and read the two sample files back: 4,823 trades, 54 columns, no empty values, USD on 91.3% of rows. Rerun over the blocks of our older 2026 sample file, it found the same 2,539 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: 34% 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 9.6% of the sample, some inside successful transactions, so filter Trade_Success. Trade_Dex_Delegated is true on 44% of the sample rows: Slipstream and Aerodrome pools are clones that run through a delegate call.

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.