OQ — D08 · DEX & Trading
23 typed tables generated from the Jupiter Swap IDL — 6 event tables and 17 instruction tables. Every column name comes from the program's own interface definition.
- Tables
- 23
- Event tables
- 6
- Instruction tables
- 17
- Account types
- 1
Program ID
JUP6LkbZbjS1jKKwapdHNy74zcZ3tLUZoi5QNyVTaV4One table per event declared in the IDL. The fully qualified name is on the left, the short alias on the right — both resolve to the same physical table.
jupiter_swap_solana.jupiter_swap_evt_best_swap_out_amount_violationjupiter_swap.best_swap_out_amount_violationjupiter_swap_solana.jupiter_swap_evt_candidate_swap_quote_errorjupiter_swap.candidate_swap_quote_errorjupiter_swap_solana.jupiter_swap_evt_candidate_swap_resultsjupiter_swap.candidate_swap_resultsjupiter_swap_solana.jupiter_swap_evt_fee_eventjupiter_swap.fee_eventjupiter_swap_solana.jupiter_swap_evt_swap_eventjupiter_swap.swap_eventjupiter_swap_solana.jupiter_swap_evt_swaps_eventjupiter_swap.swaps_event
One table per instruction. OnchainQueries also exposes verified account_<name> aliases for instruction account columns when the bundled IDL and the live schema agree.
jupiter_swap_solana.jupiter_swap_call_claimjupiter_swap.call_claimjupiter_swap_solana.jupiter_swap_call_claim_tokenjupiter_swap.call_claim_tokenjupiter_swap_solana.jupiter_swap_call_close_tokenjupiter_swap.call_close_tokenjupiter_swap_solana.jupiter_swap_call_close_wsol_token_accountjupiter_swap.call_close_wsol_token_accountjupiter_swap_solana.jupiter_swap_call_create_token_accountjupiter_swap.call_create_token_accountjupiter_swap_solana.jupiter_swap_call_create_token_ledgerjupiter_swap.call_create_token_ledgerjupiter_swap_solana.jupiter_swap_call_exact_out_routejupiter_swap.call_exact_out_routejupiter_swap_solana.jupiter_swap_call_exact_out_route_v2jupiter_swap.call_exact_out_route_v2jupiter_swap_solana.jupiter_swap_call_routejupiter_swap.call_routejupiter_swap_solana.jupiter_swap_call_route_v2jupiter_swap.call_route_v2jupiter_swap_solana.jupiter_swap_call_route_with_token_ledgerjupiter_swap.call_route_with_token_ledgerjupiter_swap_solana.jupiter_swap_call_set_token_ledgerjupiter_swap.call_set_token_ledgerjupiter_swap_solana.jupiter_swap_call_shared_accounts_exact_out_routejupiter_swap.call_shared_accounts_exact_out_routejupiter_swap_solana.jupiter_swap_call_shared_accounts_exact_out_route_v2jupiter_swap.call_shared_accounts_exact_out_route_v2jupiter_swap_solana.jupiter_swap_call_shared_accounts_routejupiter_swap.call_shared_accounts_routejupiter_swap_solana.jupiter_swap_call_shared_accounts_route_v2jupiter_swap.call_shared_accounts_route_v2jupiter_swap_solana.jupiter_swap_call_shared_accounts_route_with_token_ledgerjupiter_swap.call_shared_accounts_route_with_token_ledger
Typed parameters keep values out of the SQL text. Save the file, then pass each value with its type.
SELECT date_trunc('hour', ts) AS hour, count(*) AS eventsFROM jupiter_swap_solana.jupiter_swap_evt_best_swap_out_amount_violationWHERE ts >= {{start_time}}GROUP BY hourORDER BY hour;query sql \ --file jupiter_swap.sql \ --param 'start_time:timestamp=2026-08-01 00:00:00' \ --output ./resultsOnchainQueries selects an engine, queues the query, and downloads checksum-verified Parquet parts plus a manifest. See the CLI guide.
Pro includes every engine class and 50,000 query credits a month.