OQ — D28 · DEX & Trading
47 typed tables generated from the PumpSwap IDL — 22 event tables and 25 instruction tables. Every column name comes from the program's own interface definition.
- Tables
- 47
- Event tables
- 22
- Instruction tables
- 25
- Account types
- 7
Program ID
pAMMBay6oceH9fJKBRHGP5D4bD4sWpmSwMn52FMfXEAOQ — D28·1Event tables
One 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.
22/22
pump_swaps_solana.pump_swaps_evt_admin_set_coin_creator_eventpump_swaps.admin_set_coin_creator_eventpump_swaps_solana.pump_swaps_evt_admin_update_token_incentives_eventpump_swaps.admin_update_token_incentives_eventpump_swaps_solana.pump_swaps_evt_buy_eventpump_swaps.buy_eventpump_swaps_solana.pump_swaps_evt_claim_cashback_eventpump_swaps.claim_cashback_eventpump_swaps_solana.pump_swaps_evt_claim_token_incentives_eventpump_swaps.claim_token_incentives_eventpump_swaps_solana.pump_swaps_evt_close_user_volume_accumulator_eventpump_swaps.close_user_volume_accumulator_eventpump_swaps_solana.pump_swaps_evt_collect_coin_creator_fee_eventpump_swaps.collect_coin_creator_fee_eventpump_swaps_solana.pump_swaps_evt_create_config_eventpump_swaps.create_config_eventpump_swaps_solana.pump_swaps_evt_create_pool_eventpump_swaps.create_pool_eventpump_swaps_solana.pump_swaps_evt_deposit_eventpump_swaps.deposit_eventpump_swaps_solana.pump_swaps_evt_disable_eventpump_swaps.disable_eventpump_swaps_solana.pump_swaps_evt_extend_account_eventpump_swaps.extend_account_eventpump_swaps_solana.pump_swaps_evt_init_user_volume_accumulator_eventpump_swaps.init_user_volume_accumulator_eventpump_swaps_solana.pump_swaps_evt_migrate_pool_coin_creator_eventpump_swaps.migrate_pool_coin_creator_eventpump_swaps_solana.pump_swaps_evt_reserved_fee_recipients_eventpump_swaps.reserved_fee_recipients_eventpump_swaps_solana.pump_swaps_evt_sell_eventpump_swaps.sell_eventpump_swaps_solana.pump_swaps_evt_set_bonding_curve_coin_creator_eventpump_swaps.set_bonding_curve_coin_creator_eventpump_swaps_solana.pump_swaps_evt_set_metaplex_coin_creator_eventpump_swaps.set_metaplex_coin_creator_eventpump_swaps_solana.pump_swaps_evt_sync_user_volume_accumulator_eventpump_swaps.sync_user_volume_accumulator_eventpump_swaps_solana.pump_swaps_evt_update_admin_eventpump_swaps.update_admin_eventpump_swaps_solana.pump_swaps_evt_update_fee_config_eventpump_swaps.update_fee_config_eventpump_swaps_solana.pump_swaps_evt_withdraw_eventpump_swaps.withdraw_event
OQ — D28·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.
25/25
pump_swaps_solana.pump_swaps_call_admin_set_coin_creatorpump_swaps.call_admin_set_coin_creatorpump_swaps_solana.pump_swaps_call_admin_update_token_incentivespump_swaps.call_admin_update_token_incentivespump_swaps_solana.pump_swaps_call_buypump_swaps.call_buypump_swaps_solana.pump_swaps_call_buy_exact_quote_inpump_swaps.call_buy_exact_quote_inpump_swaps_solana.pump_swaps_call_claim_cashbackpump_swaps.call_claim_cashbackpump_swaps_solana.pump_swaps_call_claim_token_incentivespump_swaps.call_claim_token_incentivespump_swaps_solana.pump_swaps_call_close_user_volume_accumulatorpump_swaps.call_close_user_volume_accumulatorpump_swaps_solana.pump_swaps_call_collect_coin_creator_feepump_swaps.call_collect_coin_creator_feepump_swaps_solana.pump_swaps_call_create_configpump_swaps.call_create_configpump_swaps_solana.pump_swaps_call_create_poolpump_swaps.call_create_poolpump_swaps_solana.pump_swaps_call_depositpump_swaps.call_depositpump_swaps_solana.pump_swaps_call_disablepump_swaps.call_disablepump_swaps_solana.pump_swaps_call_extend_accountpump_swaps.call_extend_accountpump_swaps_solana.pump_swaps_call_init_user_volume_accumulatorpump_swaps.call_init_user_volume_accumulatorpump_swaps_solana.pump_swaps_call_migrate_pool_coin_creatorpump_swaps.call_migrate_pool_coin_creatorpump_swaps_solana.pump_swaps_call_sellpump_swaps.call_sellpump_swaps_solana.pump_swaps_call_set_coin_creatorpump_swaps.call_set_coin_creatorpump_swaps_solana.pump_swaps_call_set_reserved_fee_recipientspump_swaps.call_set_reserved_fee_recipientspump_swaps_solana.pump_swaps_call_sync_user_volume_accumulatorpump_swaps.call_sync_user_volume_accumulatorpump_swaps_solana.pump_swaps_call_toggle_cashback_enabledpump_swaps.call_toggle_cashback_enabledpump_swaps_solana.pump_swaps_call_toggle_mayhem_modepump_swaps.call_toggle_mayhem_modepump_swaps_solana.pump_swaps_call_transfer_creator_fees_to_pumppump_swaps.call_transfer_creator_fees_to_pumppump_swaps_solana.pump_swaps_call_update_adminpump_swaps.call_update_adminpump_swaps_solana.pump_swaps_call_update_fee_configpump_swaps.call_update_fee_configpump_swaps_solana.pump_swaps_call_withdrawpump_swaps.call_withdraw
OQ — D28·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 pump_swaps_solana.pump_swaps_evt_buy_eventWHERE ts >= {{start_time}}GROUP BY hourORDER BY hour;query sql \ --file pump_swaps.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.