OQ — D05 · DEX & Trading
12 typed tables generated from the Jupiter DCA IDL — 0 event tables and 12 instruction tables. Every column name comes from the program's own interface definition.
- Tables
- 12
- Event tables
- 0
- Instruction tables
- 12
- Account types
- 1
Program ID
DCA265Vj8a9CEuX1eb1LWRnDT7uK6q1xMipnNyatn23MJupiter DCA 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 12 instruction tables below to read what it did and which accounts were involved.
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_dca_solana.jupiter_dca_call_close_dcajupiter_dca.call_close_dcajupiter_dca_solana.jupiter_dca_call_depositjupiter_dca.call_depositjupiter_dca_solana.jupiter_dca_call_end_and_closejupiter_dca.call_end_and_closejupiter_dca_solana.jupiter_dca_call_fulfill_dlmm_filljupiter_dca.call_fulfill_dlmm_filljupiter_dca_solana.jupiter_dca_call_fulfill_flash_filljupiter_dca.call_fulfill_flash_filljupiter_dca_solana.jupiter_dca_call_initiate_dlmm_filljupiter_dca.call_initiate_dlmm_filljupiter_dca_solana.jupiter_dca_call_initiate_flash_filljupiter_dca.call_initiate_flash_filljupiter_dca_solana.jupiter_dca_call_open_dcajupiter_dca.call_open_dcajupiter_dca_solana.jupiter_dca_call_open_dca_v2jupiter_dca.call_open_dca_v2jupiter_dca_solana.jupiter_dca_call_transferjupiter_dca.call_transferjupiter_dca_solana.jupiter_dca_call_withdrawjupiter_dca.call_withdrawjupiter_dca_solana.jupiter_dca_call_withdraw_feesjupiter_dca.call_withdraw_fees
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_dca_solana.jupiter_dca_call_depositWHERE ts >= {{start_time}}GROUP BY hourORDER BY hour;query sql \ --file jupiter_dca.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.