Skip to main content
The Spot Trades feed streams every decentralized exchange (DEX) trade on 12 EVM chains and Solana. Each WebSocket message holds one block. Each trade has its pool, its token amounts, the executed price, the taker side, a USD notional, and the transaction that settled it. For connection, resume, corrections and latency, see the Market Data Feeds overview.

Coverage

The table shows one day of history, 2026-11-17, from historical_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_source is chainlink or pyth. On Solana live it is pyth.
  • Staked SOL tokens (mSOL, bSOL, JupSOL, hSOL, stSOL) are priced at their protocol’s onchain exchange rate times the SOL price.
  • stale_usd_price: true means the oracle price was older than the staleness limit at the trade’s block.
  • If no oracle price exists for the quote token, value is null and the trade has the unpriced flag. Not every trade has a USD value.
  • executed_price comes 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:
Solana (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