OQ — D30 · DEX & Trading
36 typed tables generated from the Raydium CLMM IDL — 11 event tables and 25 instruction tables. Every column name comes from the program's own interface definition.
- Tables
- 36
- Event tables
- 11
- Instruction tables
- 25
- Account types
- 9
Program ID
CAMMCzo5YL8w4VFF8KVHrK22GGUsp5VTaW7grrKgrWqKOQ — D30·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.
raydium_clmm_solana.raydium_clmm_evt_collect_personal_fee_eventraydium_clmm.collect_personal_fee_eventraydium_clmm_solana.raydium_clmm_evt_collect_protocol_fee_eventraydium_clmm.collect_protocol_fee_eventraydium_clmm_solana.raydium_clmm_evt_config_change_eventraydium_clmm.config_change_eventraydium_clmm_solana.raydium_clmm_evt_create_personal_position_eventraydium_clmm.create_personal_position_eventraydium_clmm_solana.raydium_clmm_evt_decrease_liquidity_eventraydium_clmm.decrease_liquidity_eventraydium_clmm_solana.raydium_clmm_evt_increase_liquidity_eventraydium_clmm.increase_liquidity_eventraydium_clmm_solana.raydium_clmm_evt_liquidity_calculate_eventraydium_clmm.liquidity_calculate_eventraydium_clmm_solana.raydium_clmm_evt_liquidity_change_eventraydium_clmm.liquidity_change_eventraydium_clmm_solana.raydium_clmm_evt_pool_created_eventraydium_clmm.pool_created_eventraydium_clmm_solana.raydium_clmm_evt_swap_eventraydium_clmm.swap_eventraydium_clmm_solana.raydium_clmm_evt_update_reward_infos_eventraydium_clmm.update_reward_infos_event
OQ — D30·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
raydium_clmm_solana.raydium_clmm_call_close_positionraydium_clmm.call_close_positionraydium_clmm_solana.raydium_clmm_call_collect_fund_feeraydium_clmm.call_collect_fund_feeraydium_clmm_solana.raydium_clmm_call_collect_protocol_feeraydium_clmm.call_collect_protocol_feeraydium_clmm_solana.raydium_clmm_call_collect_remaining_rewardsraydium_clmm.call_collect_remaining_rewardsraydium_clmm_solana.raydium_clmm_call_create_amm_configraydium_clmm.call_create_amm_configraydium_clmm_solana.raydium_clmm_call_create_operation_accountraydium_clmm.call_create_operation_accountraydium_clmm_solana.raydium_clmm_call_create_poolraydium_clmm.call_create_poolraydium_clmm_solana.raydium_clmm_call_create_support_mint_associatedraydium_clmm.call_create_support_mint_associatedraydium_clmm_solana.raydium_clmm_call_decrease_liquidityraydium_clmm.call_decrease_liquidityraydium_clmm_solana.raydium_clmm_call_decrease_liquidity_v2raydium_clmm.call_decrease_liquidity_v2raydium_clmm_solana.raydium_clmm_call_increase_liquidityraydium_clmm.call_increase_liquidityraydium_clmm_solana.raydium_clmm_call_increase_liquidity_v2raydium_clmm.call_increase_liquidity_v2raydium_clmm_solana.raydium_clmm_call_initialize_rewardraydium_clmm.call_initialize_rewardraydium_clmm_solana.raydium_clmm_call_open_positionraydium_clmm.call_open_positionraydium_clmm_solana.raydium_clmm_call_open_position_v2raydium_clmm.call_open_position_v2raydium_clmm_solana.raydium_clmm_call_open_position_with_token22_nftraydium_clmm.call_open_position_with_token22_nftraydium_clmm_solana.raydium_clmm_call_set_reward_paramsraydium_clmm.call_set_reward_paramsraydium_clmm_solana.raydium_clmm_call_swapraydium_clmm.call_swapraydium_clmm_solana.raydium_clmm_call_swap_router_base_inraydium_clmm.call_swap_router_base_inraydium_clmm_solana.raydium_clmm_call_swap_v2raydium_clmm.call_swap_v2raydium_clmm_solana.raydium_clmm_call_transfer_reward_ownerraydium_clmm.call_transfer_reward_ownerraydium_clmm_solana.raydium_clmm_call_update_amm_configraydium_clmm.call_update_amm_configraydium_clmm_solana.raydium_clmm_call_update_operation_accountraydium_clmm.call_update_operation_accountraydium_clmm_solana.raydium_clmm_call_update_pool_statusraydium_clmm.call_update_pool_statusraydium_clmm_solana.raydium_clmm_call_update_reward_infosraydium_clmm.call_update_reward_infos
OQ — D30·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 raydium_clmm_solana.raydium_clmm_evt_create_personal_position_eventWHERE ts >= {{start_time}}GROUP BY hourORDER BY hour;query sql \ --file raydium_clmm.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.