OQ — D25 · DEX & Trading
38 typed tables generated from the PancakeSwap IDL — 11 event tables and 27 instruction tables. Every column name comes from the program's own interface definition.
- Tables
- 38
- Event tables
- 11
- Instruction tables
- 27
- Account types
- 10
Program ID
HpNfyc2Saw7RKkQd8nEL4khUcuPhQ7WwY1B2qjx8jxFqOQ — D25·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.
pancakeswap_pancakeswap_solana.pancakeswap_pancakeswap_evt_collect_personal_fee_eventpancakeswap_pancakeswap.collect_personal_fee_eventpancakeswap_pancakeswap_solana.pancakeswap_pancakeswap_evt_collect_protocol_fee_eventpancakeswap_pancakeswap.collect_protocol_fee_eventpancakeswap_pancakeswap_solana.pancakeswap_pancakeswap_evt_config_change_eventpancakeswap_pancakeswap.config_change_eventpancakeswap_pancakeswap_solana.pancakeswap_pancakeswap_evt_create_personal_position_eventpancakeswap_pancakeswap.create_personal_position_eventpancakeswap_pancakeswap_solana.pancakeswap_pancakeswap_evt_decrease_liquidity_eventpancakeswap_pancakeswap.decrease_liquidity_eventpancakeswap_pancakeswap_solana.pancakeswap_pancakeswap_evt_increase_liquidity_eventpancakeswap_pancakeswap.increase_liquidity_eventpancakeswap_pancakeswap_solana.pancakeswap_pancakeswap_evt_liquidity_calculate_eventpancakeswap_pancakeswap.liquidity_calculate_eventpancakeswap_pancakeswap_solana.pancakeswap_pancakeswap_evt_liquidity_change_eventpancakeswap_pancakeswap.liquidity_change_eventpancakeswap_pancakeswap_solana.pancakeswap_pancakeswap_evt_pool_created_eventpancakeswap_pancakeswap.pool_created_eventpancakeswap_pancakeswap_solana.pancakeswap_pancakeswap_evt_swap_eventpancakeswap_pancakeswap.swap_eventpancakeswap_pancakeswap_solana.pancakeswap_pancakeswap_evt_update_reward_infos_eventpancakeswap_pancakeswap.update_reward_infos_event
OQ — D25·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.
27/27
pancakeswap_pancakeswap_solana.pancakeswap_pancakeswap_call_close_positionpancakeswap_pancakeswap.call_close_positionpancakeswap_pancakeswap_solana.pancakeswap_pancakeswap_call_collect_fund_feepancakeswap_pancakeswap.call_collect_fund_feepancakeswap_pancakeswap_solana.pancakeswap_pancakeswap_call_collect_protocol_feepancakeswap_pancakeswap.call_collect_protocol_feepancakeswap_pancakeswap_solana.pancakeswap_pancakeswap_call_collect_remaining_rewardspancakeswap_pancakeswap.call_collect_remaining_rewardspancakeswap_pancakeswap_solana.pancakeswap_pancakeswap_call_create_amm_configpancakeswap_pancakeswap.call_create_amm_configpancakeswap_pancakeswap_solana.pancakeswap_pancakeswap_call_create_operation_accountpancakeswap_pancakeswap.call_create_operation_accountpancakeswap_pancakeswap_solana.pancakeswap_pancakeswap_call_create_permissionless_farm_switchpancakeswap_pancakeswap.call_create_permissionless_farm_switchpancakeswap_pancakeswap_solana.pancakeswap_pancakeswap_call_create_poolpancakeswap_pancakeswap.call_create_poolpancakeswap_pancakeswap_solana.pancakeswap_pancakeswap_call_create_support_mint_associatedpancakeswap_pancakeswap.call_create_support_mint_associatedpancakeswap_pancakeswap_solana.pancakeswap_pancakeswap_call_decrease_liquiditypancakeswap_pancakeswap.call_decrease_liquiditypancakeswap_pancakeswap_solana.pancakeswap_pancakeswap_call_decrease_liquidity_v2pancakeswap_pancakeswap.call_decrease_liquidity_v2pancakeswap_pancakeswap_solana.pancakeswap_pancakeswap_call_increase_liquiditypancakeswap_pancakeswap.call_increase_liquiditypancakeswap_pancakeswap_solana.pancakeswap_pancakeswap_call_increase_liquidity_v2pancakeswap_pancakeswap.call_increase_liquidity_v2pancakeswap_pancakeswap_solana.pancakeswap_pancakeswap_call_initialize_rewardpancakeswap_pancakeswap.call_initialize_rewardpancakeswap_pancakeswap_solana.pancakeswap_pancakeswap_call_open_positionpancakeswap_pancakeswap.call_open_positionpancakeswap_pancakeswap_solana.pancakeswap_pancakeswap_call_open_position_v2pancakeswap_pancakeswap.call_open_position_v2pancakeswap_pancakeswap_solana.pancakeswap_pancakeswap_call_open_position_with_token22_nftpancakeswap_pancakeswap.call_open_position_with_token22_nftpancakeswap_pancakeswap_solana.pancakeswap_pancakeswap_call_set_reward_paramspancakeswap_pancakeswap.call_set_reward_paramspancakeswap_pancakeswap_solana.pancakeswap_pancakeswap_call_swappancakeswap_pancakeswap.call_swappancakeswap_pancakeswap_solana.pancakeswap_pancakeswap_call_swap_router_base_inpancakeswap_pancakeswap.call_swap_router_base_inpancakeswap_pancakeswap_solana.pancakeswap_pancakeswap_call_swap_v2pancakeswap_pancakeswap.call_swap_v2pancakeswap_pancakeswap_solana.pancakeswap_pancakeswap_call_toggle_permissionless_farm_switchpancakeswap_pancakeswap.call_toggle_permissionless_farm_switchpancakeswap_pancakeswap_solana.pancakeswap_pancakeswap_call_transfer_reward_ownerpancakeswap_pancakeswap.call_transfer_reward_ownerpancakeswap_pancakeswap_solana.pancakeswap_pancakeswap_call_update_amm_configpancakeswap_pancakeswap.call_update_amm_configpancakeswap_pancakeswap_solana.pancakeswap_pancakeswap_call_update_operation_accountpancakeswap_pancakeswap.call_update_operation_accountpancakeswap_pancakeswap_solana.pancakeswap_pancakeswap_call_update_pool_statuspancakeswap_pancakeswap.call_update_pool_statuspancakeswap_pancakeswap_solana.pancakeswap_pancakeswap_call_update_reward_infospancakeswap_pancakeswap.call_update_reward_infos
OQ — D25·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 pancakeswap_pancakeswap_solana.pancakeswap_pancakeswap_evt_create_personal_position_eventWHERE ts >= {{start_time}}GROUP BY hourORDER BY hour;query sql \ --file pancakeswap_pancakeswap.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.