OQ — D26 · Launchpads & Tokens
31 typed tables generated from the Pump Fees IDL — 14 event tables and 17 instruction tables. Every column name comes from the program's own interface definition.
- Tables
- 31
- Event tables
- 14
- Instruction tables
- 17
- Account types
- 7
Program ID
pfeeUxB6jkeY1Hxd7CsFCAjcbHA9rWtchMGdZ6VojVZOne 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.
pump_fees_solana.pump_fees_evt_create_fee_sharing_config_eventpump_fees.create_fee_sharing_config_eventpump_fees_solana.pump_fees_evt_initialize_fee_config_eventpump_fees.initialize_fee_config_eventpump_fees_solana.pump_fees_evt_initialize_fee_program_global_eventpump_fees.initialize_fee_program_global_eventpump_fees_solana.pump_fees_evt_reset_fee_sharing_config_eventpump_fees.reset_fee_sharing_config_eventpump_fees_solana.pump_fees_evt_set_authority_eventpump_fees.set_authority_eventpump_fees_solana.pump_fees_evt_set_claim_rate_limit_eventpump_fees.set_claim_rate_limit_eventpump_fees_solana.pump_fees_evt_set_disable_flags_eventpump_fees.set_disable_flags_eventpump_fees_solana.pump_fees_evt_set_social_claim_authority_eventpump_fees.set_social_claim_authority_eventpump_fees_solana.pump_fees_evt_social_fee_pda_claimedpump_fees.social_fee_pda_claimedpump_fees_solana.pump_fees_evt_social_fee_pda_createdpump_fees.social_fee_pda_createdpump_fees_solana.pump_fees_evt_update_admin_eventpump_fees.update_admin_eventpump_fees_solana.pump_fees_evt_update_fee_config_eventpump_fees.update_fee_config_eventpump_fees_solana.pump_fees_evt_update_fee_shares_eventpump_fees.update_fee_shares_eventpump_fees_solana.pump_fees_evt_upsert_fee_tiers_eventpump_fees.upsert_fee_tiers_event
One table per instruction. OnchainQueries also exposes verified account_<name> aliases for instruction account columns when the bundled IDL and the live schema agree.
pump_fees_solana.pump_fees_call_claim_social_fee_pdapump_fees.call_claim_social_fee_pdapump_fees_solana.pump_fees_call_create_fee_sharing_configpump_fees.call_create_fee_sharing_configpump_fees_solana.pump_fees_call_create_social_fee_pdapump_fees.call_create_social_fee_pdapump_fees_solana.pump_fees_call_get_feespump_fees.call_get_feespump_fees_solana.pump_fees_call_initialize_fee_configpump_fees.call_initialize_fee_configpump_fees_solana.pump_fees_call_initialize_fee_program_globalpump_fees.call_initialize_fee_program_globalpump_fees_solana.pump_fees_call_reset_fee_sharing_configpump_fees.call_reset_fee_sharing_configpump_fees_solana.pump_fees_call_revoke_fee_sharing_authoritypump_fees.call_revoke_fee_sharing_authoritypump_fees_solana.pump_fees_call_set_authoritypump_fees.call_set_authoritypump_fees_solana.pump_fees_call_set_claim_rate_limitpump_fees.call_set_claim_rate_limitpump_fees_solana.pump_fees_call_set_disable_flagspump_fees.call_set_disable_flagspump_fees_solana.pump_fees_call_set_social_claim_authoritypump_fees.call_set_social_claim_authoritypump_fees_solana.pump_fees_call_transfer_fee_sharing_authoritypump_fees.call_transfer_fee_sharing_authoritypump_fees_solana.pump_fees_call_update_adminpump_fees.call_update_adminpump_fees_solana.pump_fees_call_update_fee_configpump_fees.call_update_fee_configpump_fees_solana.pump_fees_call_update_fee_sharespump_fees.call_update_fee_sharespump_fees_solana.pump_fees_call_upsert_fee_tierspump_fees.call_upsert_fee_tiers
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_fees_solana.pump_fees_evt_create_fee_sharing_config_eventWHERE ts >= {{start_time}}GROUP BY hourORDER BY hour;query sql \ --file pump_fees.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.