Skip to content
OnchainQueries

OQ — D06 · DEX & Trading

9 typed tables generated from the Jupiter Limit Order IDL — 0 event tables and 9 instruction tables. Every column name comes from the program's own interface definition.

Tables
9
Event tables
0
Instruction tables
9
Account types
2

Program ID

jupoNjAxXgZ4rjzxzPMP4oxduvQsQtZzyknqvzYNrNu
OQ — D06·1Event tables

Jupiter Limit Order declares no events in its IDL, so it has no evt_ tables. That is a property of the program, not a gap in coverage — use the 9 instruction tables below to read what it did and which accounts were involved.

OQ — D06·2Instruction tables

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_limit_order_solana.jupiter_limit_order_call_cancel_expired_orderjupiter_limit_order.call_cancel_expired_order
  • jupiter_limit_order_solana.jupiter_limit_order_call_cancel_orderjupiter_limit_order.call_cancel_order
  • jupiter_limit_order_solana.jupiter_limit_order_call_fill_orderjupiter_limit_order.call_fill_order
  • jupiter_limit_order_solana.jupiter_limit_order_call_flash_fill_orderjupiter_limit_order.call_flash_fill_order
  • jupiter_limit_order_solana.jupiter_limit_order_call_init_feejupiter_limit_order.call_init_fee
  • jupiter_limit_order_solana.jupiter_limit_order_call_initialize_orderjupiter_limit_order.call_initialize_order
  • jupiter_limit_order_solana.jupiter_limit_order_call_pre_flash_fill_orderjupiter_limit_order.call_pre_flash_fill_order
  • jupiter_limit_order_solana.jupiter_limit_order_call_update_feejupiter_limit_order.call_update_fee
  • jupiter_limit_order_solana.jupiter_limit_order_call_withdraw_feejupiter_limit_order.call_withdraw_fee
OQ — D06·3Example

Typed parameters keep values out of the SQL text. Save the file, then pass each value with its type.

jupiter_limit_order.sql
SELECT  date_trunc('hour', ts) AS hour,  count(*) AS eventsFROM jupiter_limit_order_solana.jupiter_limit_order_call_cancel_expired_orderWHERE ts >= {{start_time}}GROUP BY hourORDER BY hour;
shell
query sql \  --file jupiter_limit_order.sql \  --param 'start_time:timestamp=2026-08-01 00:00:00' \  --output ./results

OnchainQueries selects an engine, queues the query, and downloads checksum-verified Parquet parts plus a manifest. See the CLI guide.

More in DEX & Trading

Pro includes every engine class and 50,000 query credits a month.

Start queryingRead the docs