Coverage
The table shows one day of history, 2026-11-17, fromhistorical_spot_trades. A venue is a distinct venue label. Counts change from day to day.
The 275 venue labels include
unknown_amm, which marks pools whose program Dune has not attributed to a venue. On 2026-11-17 that label had 2,576 trades.
Examples of venues in the feed are Uniswap V2, V3 and V4, Curve, Balancer V2, Aerodrome and Slipstream, PancakeSwap V3 and Infinity, Camelot, GMX V2, and on Solana Raydium, Orca, Meteora, Pump.fun and PumpSwap. To browse instruments, open the instrument explorer.
Message envelope
Trade fields: EVM (dex-trades.json.v2)
The EVM format has no token symbols, token decimals or venue names. Use
instrument_code and the instrument reference data to get them.
Trade fields: Solana (dex-trades.json.v1)
Solana trades have the same identity fields, in Solana’s own formats, plus inline token and venue metadata.
Aggregator and router wrapper rows are not sent on the Solana feed. You receive the underlying pool fills only.
USD value
value.notional_usd is the trade’s USD value. Dune computes it from the quote token amount and an oracle price for the quote token.
price_sourceischainlinkorpyth. On Solana live it ispyth.- Staked SOL tokens (mSOL, bSOL, JupSOL, hSOL, stSOL) are priced at their protocol’s onchain exchange rate times the SOL price.
stale_usd_price: truemeans the oracle price was older than the staleness limit at the trade’s block.- If no oracle price exists for the quote token,
valueisnulland the trade has theunpricedflag. Not every trade has a USD value. executed_pricecomes from the token amounts only. It does not use an oracle.
Condition flags
Examples
EVM, Base (dex-trades.json.v2), captured on 19 November 2026:
dex-trades.json.v1), captured on 19 November 2026:
History
dune.dune.historical_spot_trades has one row per spot trade. Dune rebuilds it from raw chain data with the same decoders and oracle pricing as the live feed.
On 19 November 2026, every chain had a partition for every day from its first day to 2026-11-18.
Columns:
chain_type, chain_id, block_timestamp, block_date, block_number, tx_hash, tx_from, tx_to, tx_index, tx_source_kind, tx_source_index, trade_id, venue, venue_id, protocol, pool, pool_id, taker, maker, base_token_address, base_token_symbol, base_token_decimals, quote_token_address, quote_token_symbol, quote_token_decimals, base_amount_raw, base_amount, quote_amount_raw, quote_amount, side, executed_price, notional_usd, price_source, stale_usd_price, condition_flags, instrument_id, instrument_code.
Differences from the live feed:
- History keeps only pool fills. Aggregator wrapper rows are not in it.
- Each day keeps the trades of pools that qualified for the instrument universe on that day.
- Solana token symbols are the symbols at the time the day was rebuilt, because Solana token metadata can change.
DuneSQL