Optimism DEX Trades

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

To the start of our index: from 6 June 2023, just after the Bedrock upgrade, at block 105,238,867, to yesterday. Optimism before Bedrock is not in our index.

In the month to 1 July 2026 Uniswap v3 carried most rows, then Uniswap v4, Velodrome, Uniswap v2 and Balancer, 7 protocol names in all. Velodrome shares Aerodrome's code, so its pools carry the label aerodrome_v1 (factory 0xf1046053aa5682b4f9a81b5481394da16be5ff5a). 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. History before the Bedrock upgrade in June 2023 is not in our index.

Each swap takes its USD value from one side, the safer one: a stablecoin (USDC, the bridged USDC.e, 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 Optimism 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 88% and 96% of trades had a stablecoin, ETH or WETH on one side; the free sample has a USD value on 94.4% of rows. A value of 0 means no price for either side.

Decoded from Optimism 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 153,654,213 to 153,654,312 and read the two sample files back: 1,027 trades, 54 columns, no empty values, USD on 94.4% of rows.

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: 58% 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 14.5% of the sample, some inside successful transactions, so filter Trade_Success. The free sample comes from blocks on 1 July 2026.

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.