Skip to content
OnchainQueries

OQ — D10 · DEX & Trading

Aggregators, constant-product AMMs, concentrated liquidity, order books and perpetuals. Each program contributes its own instruction and event tables, so a route through four venues is four joinable rows, not one opaque transaction.

Programs
21
Tables
664
Event tables
120
Instruction tables
544
OQ — D10·1Example

Joins execute as a single query rather than partitioned tasks, so constrain ts on both sides.

orca-volume.sql
-- Hourly Orca Whirlpool swap volumeSELECT  date_trunc('hour', ts) AS hour,  count(*) AS swapsFROM orca_whirlpool_solana.orca_whirlpool_evt_tradedWHERE ts >= {{start_time}}GROUP BY hourORDER BY hour;
Programs in this family
BonkSwap · DFlow Aggregator v4 · Jupiter DCA · Jupiter Limit Order · Jupiter Perpetuals · Jupiter Swap · Lifinity AMM v2 · Meteora AMM · Meteora DLMM · Meteora Pools · OKX DEX · OKX DEX v3 · OpenBook v2 · Orca Whirlpool · PancakeSwap · PumpSwap · Raydium AMM · Raydium CLMM · Raydium CPMM · Stabble Stable Swap · Stabble Weighted Swap
Instruction-only programs
8 of 21 declare no events in their IDL and expose call_ tables only.

Read the table naming rules, or create an account and query them.