OQ — D27 · Launchpads & Tokens
52 typed tables generated from the Pump.fun IDL — 23 event tables and 29 instruction tables. Every column name comes from the program's own interface definition.
- Tables
- 52
- Event tables
- 23
- Instruction tables
- 29
- Account types
- 6
Program ID
6EF8rrecthR5Dkzon8Nwu78hRvfCKubJ14M5uBEwF6POQ — D27·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.
23/23
pump_fun_solana.pump_fun_evt_admin_set_creator_eventpump_fun.admin_set_creator_eventpump_fun_solana.pump_fun_evt_admin_set_idl_authority_eventpump_fun.admin_set_idl_authority_eventpump_fun_solana.pump_fun_evt_admin_update_token_incentives_eventpump_fun.admin_update_token_incentives_eventpump_fun_solana.pump_fun_evt_claim_cashback_eventpump_fun.claim_cashback_eventpump_fun_solana.pump_fun_evt_claim_token_incentives_eventpump_fun.claim_token_incentives_eventpump_fun_solana.pump_fun_evt_close_user_volume_accumulator_eventpump_fun.close_user_volume_accumulator_eventpump_fun_solana.pump_fun_evt_collect_creator_fee_eventpump_fun.collect_creator_fee_eventpump_fun_solana.pump_fun_evt_complete_eventpump_fun.complete_eventpump_fun_solana.pump_fun_evt_complete_pump_amm_migration_eventpump_fun.complete_pump_amm_migration_eventpump_fun_solana.pump_fun_evt_create_eventpump_fun.create_eventpump_fun_solana.pump_fun_evt_distribute_creator_fees_eventpump_fun.distribute_creator_fees_eventpump_fun_solana.pump_fun_evt_extend_account_eventpump_fun.extend_account_eventpump_fun_solana.pump_fun_evt_init_user_volume_accumulator_eventpump_fun.init_user_volume_accumulator_eventpump_fun_solana.pump_fun_evt_migrate_bonding_curve_creator_eventpump_fun.migrate_bonding_curve_creator_eventpump_fun_solana.pump_fun_evt_minimum_distributable_fee_eventpump_fun.minimum_distributable_fee_eventpump_fun_solana.pump_fun_evt_reserved_fee_recipients_eventpump_fun.reserved_fee_recipients_eventpump_fun_solana.pump_fun_evt_set_creator_eventpump_fun.set_creator_eventpump_fun_solana.pump_fun_evt_set_metaplex_creator_eventpump_fun.set_metaplex_creator_eventpump_fun_solana.pump_fun_evt_set_params_eventpump_fun.set_params_eventpump_fun_solana.pump_fun_evt_sync_user_volume_accumulator_eventpump_fun.sync_user_volume_accumulator_eventpump_fun_solana.pump_fun_evt_trade_eventpump_fun.trade_eventpump_fun_solana.pump_fun_evt_update_global_authority_eventpump_fun.update_global_authority_eventpump_fun_solana.pump_fun_evt_update_mayhem_virtual_params_eventpump_fun.update_mayhem_virtual_params_event
OQ — D27·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.
29/29
pump_fun_solana.pump_fun_call_admin_set_creatorpump_fun.call_admin_set_creatorpump_fun_solana.pump_fun_call_admin_set_idl_authoritypump_fun.call_admin_set_idl_authoritypump_fun_solana.pump_fun_call_admin_update_token_incentivespump_fun.call_admin_update_token_incentivespump_fun_solana.pump_fun_call_buypump_fun.call_buypump_fun_solana.pump_fun_call_buy_exact_sol_inpump_fun.call_buy_exact_sol_inpump_fun_solana.pump_fun_call_claim_cashbackpump_fun.call_claim_cashbackpump_fun_solana.pump_fun_call_claim_token_incentivespump_fun.call_claim_token_incentivespump_fun_solana.pump_fun_call_close_user_volume_accumulatorpump_fun.call_close_user_volume_accumulatorpump_fun_solana.pump_fun_call_collect_creator_feepump_fun.call_collect_creator_feepump_fun_solana.pump_fun_call_createpump_fun.call_createpump_fun_solana.pump_fun_call_create_v2pump_fun.call_create_v2pump_fun_solana.pump_fun_call_distribute_creator_feespump_fun.call_distribute_creator_feespump_fun_solana.pump_fun_call_extend_accountpump_fun.call_extend_accountpump_fun_solana.pump_fun_call_get_minimum_distributable_feepump_fun.call_get_minimum_distributable_feepump_fun_solana.pump_fun_call_initializepump_fun.call_initializepump_fun_solana.pump_fun_call_init_user_volume_accumulatorpump_fun.call_init_user_volume_accumulatorpump_fun_solana.pump_fun_call_migratepump_fun.call_migratepump_fun_solana.pump_fun_call_migrate_bonding_curve_creatorpump_fun.call_migrate_bonding_curve_creatorpump_fun_solana.pump_fun_call_sellpump_fun.call_sellpump_fun_solana.pump_fun_call_set_creatorpump_fun.call_set_creatorpump_fun_solana.pump_fun_call_set_mayhem_virtual_paramspump_fun.call_set_mayhem_virtual_paramspump_fun_solana.pump_fun_call_set_metaplex_creatorpump_fun.call_set_metaplex_creatorpump_fun_solana.pump_fun_call_set_paramspump_fun.call_set_paramspump_fun_solana.pump_fun_call_set_reserved_fee_recipientspump_fun.call_set_reserved_fee_recipientspump_fun_solana.pump_fun_call_sync_user_volume_accumulatorpump_fun.call_sync_user_volume_accumulatorpump_fun_solana.pump_fun_call_toggle_cashback_enabledpump_fun.call_toggle_cashback_enabledpump_fun_solana.pump_fun_call_toggle_create_v2pump_fun.call_toggle_create_v2pump_fun_solana.pump_fun_call_toggle_mayhem_modepump_fun.call_toggle_mayhem_modepump_fun_solana.pump_fun_call_update_global_authoritypump_fun.call_update_global_authority
OQ — D27·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_fun_solana.pump_fun_evt_create_eventWHERE ts >= {{start_time}}GROUP BY hourORDER BY hour;query sql \ --file pump_fun.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.