OQ — D02 · Launchpads & Tokens
54 typed tables generated from the Boop IDL — 25 event tables and 29 instruction tables. Every column name comes from the program's own interface definition.
- Tables
- 54
- Event tables
- 25
- Instruction tables
- 29
- Account types
- 4
Program ID
boop8hVGQGqehUK2iVEMEnMrL5RbjywRzHKBmBE7ry4OQ — D02·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.
25/25
boop_boop_solana.boop_boop_evt_authority_transfer_cancelled_eventboop_boop.authority_transfer_cancelled_eventboop_boop_solana.boop_boop_evt_authority_transfer_completed_eventboop_boop.authority_transfer_completed_eventboop_boop_solana.boop_boop_evt_authority_transfer_initiated_eventboop_boop.authority_transfer_initiated_eventboop_boop_solana.boop_boop_evt_bonding_curve_deployed_eventboop_boop.bonding_curve_deployed_eventboop_boop_solana.boop_boop_evt_bonding_curve_deployed_fallback_eventboop_boop.bonding_curve_deployed_fallback_eventboop_boop_solana.boop_boop_evt_bonding_curve_vault_closed_eventboop_boop.bonding_curve_vault_closed_eventboop_boop_solana.boop_boop_evt_config_updated_eventboop_boop.config_updated_eventboop_boop_solana.boop_boop_evt_liquidity_deposited_into_raydium_eventboop_boop.liquidity_deposited_into_raydium_eventboop_boop_solana.boop_boop_evt_operators_added_eventboop_boop.operators_added_eventboop_boop_solana.boop_boop_evt_operators_removed_eventboop_boop.operators_removed_eventboop_boop_solana.boop_boop_evt_paused_toggled_eventboop_boop.paused_toggled_eventboop_boop_solana.boop_boop_evt_post_graduation_trading_fees_split_eventboop_boop.post_graduation_trading_fees_split_eventboop_boop_solana.boop_boop_evt_raydium_liquidity_locked_eventboop_boop.raydium_liquidity_locked_eventboop_boop_solana.boop_boop_evt_raydium_pool_created_eventboop_boop.raydium_pool_created_eventboop_boop_solana.boop_boop_evt_raydium_random_pool_created_eventboop_boop.raydium_random_pool_created_eventboop_boop_solana.boop_boop_evt_swap_sol_for_tokens_on_raydium_eventboop_boop.swap_sol_for_tokens_on_raydium_eventboop_boop_solana.boop_boop_evt_swap_tokens_for_sol_on_raydium_eventboop_boop.swap_tokens_for_sol_on_raydium_eventboop_boop_solana.boop_boop_evt_token_bought_eventboop_boop.token_bought_eventboop_boop_solana.boop_boop_evt_token_created_eventboop_boop.token_created_eventboop_boop_solana.boop_boop_evt_token_created_fallback_eventboop_boop.token_created_fallback_eventboop_boop_solana.boop_boop_evt_token_graduated_eventboop_boop.token_graduated_eventboop_boop_solana.boop_boop_evt_token_sold_eventboop_boop.token_sold_eventboop_boop_solana.boop_boop_evt_trading_fees_collected_eventboop_boop.trading_fees_collected_eventboop_boop_solana.boop_boop_evt_trading_fees_collected_v2_eventboop_boop.trading_fees_collected_v2_eventboop_boop_solana.boop_boop_evt_trading_fees_split_eventboop_boop.trading_fees_split_event
OQ — D02·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
boop_boop_solana.boop_boop_call_add_operatorsboop_boop.call_add_operatorsboop_boop_solana.boop_boop_call_buy_tokenboop_boop.call_buy_tokenboop_boop_solana.boop_boop_call_cancel_authority_transferboop_boop.call_cancel_authority_transferboop_boop_solana.boop_boop_call_close_bonding_curve_vaultboop_boop.call_close_bonding_curve_vaultboop_boop_solana.boop_boop_call_collect_meteora_trading_feesboop_boop.call_collect_meteora_trading_feesboop_boop_solana.boop_boop_call_collect_meteora_trading_fees_v2boop_boop.call_collect_meteora_trading_fees_v2boop_boop_solana.boop_boop_call_collect_trading_feesboop_boop.call_collect_trading_feesboop_boop_solana.boop_boop_call_collect_trading_fees_v2boop_boop.call_collect_trading_fees_v2boop_boop_solana.boop_boop_call_complete_authority_transferboop_boop.call_complete_authority_transferboop_boop_solana.boop_boop_call_create_meteora_poolboop_boop.call_create_meteora_poolboop_boop_solana.boop_boop_call_create_raydium_poolboop_boop.call_create_raydium_poolboop_boop_solana.boop_boop_call_create_raydium_random_poolboop_boop.call_create_raydium_random_poolboop_boop_solana.boop_boop_call_create_tokenboop_boop.call_create_tokenboop_boop_solana.boop_boop_call_create_token_fallbackboop_boop.call_create_token_fallbackboop_boop_solana.boop_boop_call_deploy_bonding_curveboop_boop.call_deploy_bonding_curveboop_boop_solana.boop_boop_call_deploy_bonding_curve_fallbackboop_boop.call_deploy_bonding_curve_fallbackboop_boop_solana.boop_boop_call_deposit_into_raydiumboop_boop.call_deposit_into_raydiumboop_boop_solana.boop_boop_call_graduateboop_boop.call_graduateboop_boop_solana.boop_boop_call_initializeboop_boop.call_initializeboop_boop_solana.boop_boop_call_initiate_authority_transferboop_boop.call_initiate_authority_transferboop_boop_solana.boop_boop_call_lock_raydium_liquidityboop_boop.call_lock_raydium_liquidityboop_boop_solana.boop_boop_call_remove_operatorsboop_boop.call_remove_operatorsboop_boop_solana.boop_boop_call_sell_tokenboop_boop.call_sell_tokenboop_boop_solana.boop_boop_call_split_post_graduation_trading_feesboop_boop.call_split_post_graduation_trading_feesboop_boop_solana.boop_boop_call_split_trading_feesboop_boop.call_split_trading_feesboop_boop_solana.boop_boop_call_swap_sol_for_tokens_on_raydiumboop_boop.call_swap_sol_for_tokens_on_raydiumboop_boop_solana.boop_boop_call_swap_tokens_for_sol_on_raydiumboop_boop.call_swap_tokens_for_sol_on_raydiumboop_boop_solana.boop_boop_call_toggle_pausedboop_boop.call_toggle_pausedboop_boop_solana.boop_boop_call_update_configboop_boop.call_update_config
OQ — D02·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 boop_boop_solana.boop_boop_evt_liquidity_deposited_into_raydium_eventWHERE ts >= {{start_time}}GROUP BY hourORDER BY hour;query sql \ --file boop_boop.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.