OQ — D07 · DEX & Trading
59 typed tables generated from the Jupiter Perpetuals IDL — 0 event tables and 59 instruction tables. Every column name comes from the program's own interface definition.
- Tables
- 59
- Event tables
- 0
- Instruction tables
- 59
- Account types
- 8
Program ID
PERPHjGBqRHArX4DySjwM6UJHiR3sWAatqfdBS2qQJuOQ — D07·1Event tables
Jupiter Perpetuals 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 59 instruction tables below to read what it did and which accounts were involved.
OQ — D07·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.
59/59
jupiter_perpetuals_solana.jupiter_perpetuals_call_add_custodyjupiter_perpetuals.call_add_custodyjupiter_perpetuals_solana.jupiter_perpetuals_call_add_liquidity2jupiter_perpetuals.call_add_liquidity2jupiter_perpetuals_solana.jupiter_perpetuals_call_add_pooljupiter_perpetuals.call_add_pooljupiter_perpetuals_solana.jupiter_perpetuals_call_borrow_from_custodyjupiter_perpetuals.call_borrow_from_custodyjupiter_perpetuals_solana.jupiter_perpetuals_call_close_borrow_positionjupiter_perpetuals.call_close_borrow_positionjupiter_perpetuals_solana.jupiter_perpetuals_call_close_position_request2jupiter_perpetuals.call_close_position_request2jupiter_perpetuals_solana.jupiter_perpetuals_call_close_position_request3jupiter_perpetuals.call_close_position_request3jupiter_perpetuals_solana.jupiter_perpetuals_call_create_and_delegate_stake_accountjupiter_perpetuals.call_create_and_delegate_stake_accountjupiter_perpetuals_solana.jupiter_perpetuals_call_create_decrease_position_market_requestjupiter_perpetuals.call_create_decrease_position_market_requestjupiter_perpetuals_solana.jupiter_perpetuals_call_create_decrease_position_request2jupiter_perpetuals.call_create_decrease_position_request2jupiter_perpetuals_solana.jupiter_perpetuals_call_create_increase_position_market_requestjupiter_perpetuals.call_create_increase_position_market_requestjupiter_perpetuals_solana.jupiter_perpetuals_call_create_token_ledgerjupiter_perpetuals.call_create_token_ledgerjupiter_perpetuals_solana.jupiter_perpetuals_call_create_token_metadatajupiter_perpetuals.call_create_token_metadatajupiter_perpetuals_solana.jupiter_perpetuals_call_decrease_position4jupiter_perpetuals.call_decrease_position4jupiter_perpetuals_solana.jupiter_perpetuals_call_decrease_position_with_internal_swapjupiter_perpetuals.call_decrease_position_with_internal_swapjupiter_perpetuals_solana.jupiter_perpetuals_call_decrease_position_with_tpsljupiter_perpetuals.call_decrease_position_with_tpsljupiter_perpetuals_solana.jupiter_perpetuals_call_decrease_position_with_tpsl_and_internal_swapjupiter_perpetuals.call_decrease_position_with_tpsl_and_internal_swapjupiter_perpetuals_solana.jupiter_perpetuals_call_deposit_collateral_for_borrowsjupiter_perpetuals.call_deposit_collateral_for_borrowsjupiter_perpetuals_solana.jupiter_perpetuals_call_get_add_liquidity_amount_and_fee2jupiter_perpetuals.call_get_add_liquidity_amount_and_fee2jupiter_perpetuals_solana.jupiter_perpetuals_call_get_assets_under_management2jupiter_perpetuals.call_get_assets_under_management2jupiter_perpetuals_solana.jupiter_perpetuals_call_get_remove_liquidity_amount_and_fee2jupiter_perpetuals.call_get_remove_liquidity_amount_and_fee2jupiter_perpetuals_solana.jupiter_perpetuals_call_increase_position4jupiter_perpetuals.call_increase_position4jupiter_perpetuals_solana.jupiter_perpetuals_call_increase_position_pre_swapjupiter_perpetuals.call_increase_position_pre_swapjupiter_perpetuals_solana.jupiter_perpetuals_call_increase_position_with_internal_swapjupiter_perpetuals.call_increase_position_with_internal_swapjupiter_perpetuals_solana.jupiter_perpetuals_call_initjupiter_perpetuals.call_initjupiter_perpetuals_solana.jupiter_perpetuals_call_instant_create_limit_orderjupiter_perpetuals.call_instant_create_limit_orderjupiter_perpetuals_solana.jupiter_perpetuals_call_instant_create_tpsljupiter_perpetuals.call_instant_create_tpsljupiter_perpetuals_solana.jupiter_perpetuals_call_instant_decrease_positionjupiter_perpetuals.call_instant_decrease_positionjupiter_perpetuals_solana.jupiter_perpetuals_call_instant_decrease_position2jupiter_perpetuals.call_instant_decrease_position2jupiter_perpetuals_solana.jupiter_perpetuals_call_instant_increase_positionjupiter_perpetuals.call_instant_increase_positionjupiter_perpetuals_solana.jupiter_perpetuals_call_instant_increase_position_pre_swapjupiter_perpetuals.call_instant_increase_position_pre_swapjupiter_perpetuals_solana.jupiter_perpetuals_call_instant_update_limit_orderjupiter_perpetuals.call_instant_update_limit_orderjupiter_perpetuals_solana.jupiter_perpetuals_call_instant_update_tpsljupiter_perpetuals.call_instant_update_tpsljupiter_perpetuals_solana.jupiter_perpetuals_call_liquidate_borrow_positionjupiter_perpetuals.call_liquidate_borrow_positionjupiter_perpetuals_solana.jupiter_perpetuals_call_liquidate_full_position4jupiter_perpetuals.call_liquidate_full_position4jupiter_perpetuals_solana.jupiter_perpetuals_call_operator_set_custody_configjupiter_perpetuals.call_operator_set_custody_configjupiter_perpetuals_solana.jupiter_perpetuals_call_operator_set_pool_configjupiter_perpetuals.call_operator_set_pool_configjupiter_perpetuals_solana.jupiter_perpetuals_call_partial_liquidate_borrow_positionjupiter_perpetuals.call_partial_liquidate_borrow_positionjupiter_perpetuals_solana.jupiter_perpetuals_call_realloc_custodyjupiter_perpetuals.call_realloc_custodyjupiter_perpetuals_solana.jupiter_perpetuals_call_realloc_pooljupiter_perpetuals.call_realloc_pooljupiter_perpetuals_solana.jupiter_perpetuals_call_redeem_stakejupiter_perpetuals.call_redeem_stakejupiter_perpetuals_solana.jupiter_perpetuals_call_refresh_assets_under_managementjupiter_perpetuals.call_refresh_assets_under_managementjupiter_perpetuals_solana.jupiter_perpetuals_call_remove_liquidity2jupiter_perpetuals.call_remove_liquidity2jupiter_perpetuals_solana.jupiter_perpetuals_call_repay_to_custodyjupiter_perpetuals.call_repay_to_custodyjupiter_perpetuals_solana.jupiter_perpetuals_call_set_custody_configjupiter_perpetuals.call_set_custody_configjupiter_perpetuals_solana.jupiter_perpetuals_call_set_max_global_sizesjupiter_perpetuals.call_set_max_global_sizesjupiter_perpetuals_solana.jupiter_perpetuals_call_set_perpetuals_configjupiter_perpetuals.call_set_perpetuals_configjupiter_perpetuals_solana.jupiter_perpetuals_call_set_pool_configjupiter_perpetuals.call_set_pool_configjupiter_perpetuals_solana.jupiter_perpetuals_call_set_test_timejupiter_perpetuals.call_set_test_timejupiter_perpetuals_solana.jupiter_perpetuals_call_set_token_ledgerjupiter_perpetuals.call_set_token_ledgerjupiter_perpetuals_solana.jupiter_perpetuals_call_swap2jupiter_perpetuals.call_swap2jupiter_perpetuals_solana.jupiter_perpetuals_call_swap_with_token_ledgerjupiter_perpetuals.call_swap_with_token_ledgerjupiter_perpetuals_solana.jupiter_perpetuals_call_test_initjupiter_perpetuals.call_test_initjupiter_perpetuals_solana.jupiter_perpetuals_call_transfer_adminjupiter_perpetuals.call_transfer_adminjupiter_perpetuals_solana.jupiter_perpetuals_call_unstakejupiter_perpetuals.call_unstakejupiter_perpetuals_solana.jupiter_perpetuals_call_update_decrease_position_request2jupiter_perpetuals.call_update_decrease_position_request2jupiter_perpetuals_solana.jupiter_perpetuals_call_withdraw_collateral_for_borrowsjupiter_perpetuals.call_withdraw_collateral_for_borrowsjupiter_perpetuals_solana.jupiter_perpetuals_call_withdraw_fees2jupiter_perpetuals.call_withdraw_fees2jupiter_perpetuals_solana.jupiter_perpetuals_call_withdraw_stakejupiter_perpetuals.call_withdraw_stake
OQ — D07·3Example
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_perpetuals_solana.jupiter_perpetuals_call_create_and_delegate_stake_accountWHERE ts >= {{start_time}}GROUP BY hourORDER BY hour;query sql \ --file jupiter_perpetuals.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.