OQ — D16 · DEX & Trading
99 typed tables generated from the Meteora DLMM IDL — 25 event tables and 74 instruction tables. Every column name comes from the program's own interface definition.
- Tables
- 99
- Event tables
- 25
- Instruction tables
- 74
- Account types
- 12
Program ID
LBUZKhRxPF3XUpBCjp4YzTKgLccjZhTSDM9YuVaPwxoOQ — D16·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
meteora_dlmm_solana.meteora_dlmm_evt_add_liquiditymeteora_dlmm.add_liquiditymeteora_dlmm_solana.meteora_dlmm_evt_claim_feemeteora_dlmm.claim_feemeteora_dlmm_solana.meteora_dlmm_evt_claim_fee2meteora_dlmm.claim_fee2meteora_dlmm_solana.meteora_dlmm_evt_claim_rewardmeteora_dlmm.claim_rewardmeteora_dlmm_solana.meteora_dlmm_evt_claim_reward2meteora_dlmm.claim_reward2meteora_dlmm_solana.meteora_dlmm_evt_composition_feemeteora_dlmm.composition_feemeteora_dlmm_solana.meteora_dlmm_evt_decrease_position_lengthmeteora_dlmm.decrease_position_lengthmeteora_dlmm_solana.meteora_dlmm_evt_dynamic_fee_parameter_updatemeteora_dlmm.dynamic_fee_parameter_updatemeteora_dlmm_solana.meteora_dlmm_evt_fee_parameter_updatemeteora_dlmm.fee_parameter_updatemeteora_dlmm_solana.meteora_dlmm_evt_fund_rewardmeteora_dlmm.fund_rewardmeteora_dlmm_solana.meteora_dlmm_evt_go_to_a_binmeteora_dlmm.go_to_a_binmeteora_dlmm_solana.meteora_dlmm_evt_increase_observationmeteora_dlmm.increase_observationmeteora_dlmm_solana.meteora_dlmm_evt_increase_position_lengthmeteora_dlmm.increase_position_lengthmeteora_dlmm_solana.meteora_dlmm_evt_initialize_rewardmeteora_dlmm.initialize_rewardmeteora_dlmm_solana.meteora_dlmm_evt_lb_pair_createmeteora_dlmm.lb_pair_createmeteora_dlmm_solana.meteora_dlmm_evt_position_closemeteora_dlmm.position_closemeteora_dlmm_solana.meteora_dlmm_evt_position_createmeteora_dlmm.position_createmeteora_dlmm_solana.meteora_dlmm_evt_rebalancingmeteora_dlmm.rebalancingmeteora_dlmm_solana.meteora_dlmm_evt_remove_liquiditymeteora_dlmm.remove_liquiditymeteora_dlmm_solana.meteora_dlmm_evt_swapmeteora_dlmm.swapmeteora_dlmm_solana.meteora_dlmm_evt_update_position_lock_release_pointmeteora_dlmm.update_position_lock_release_pointmeteora_dlmm_solana.meteora_dlmm_evt_update_position_operatormeteora_dlmm.update_position_operatormeteora_dlmm_solana.meteora_dlmm_evt_update_reward_durationmeteora_dlmm.update_reward_durationmeteora_dlmm_solana.meteora_dlmm_evt_update_reward_fundermeteora_dlmm.update_reward_fundermeteora_dlmm_solana.meteora_dlmm_evt_withdraw_ineligible_rewardmeteora_dlmm.withdraw_ineligible_reward
OQ — D16·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.
74/74
meteora_dlmm_solana.meteora_dlmm_call_add_liquiditymeteora_dlmm.call_add_liquiditymeteora_dlmm_solana.meteora_dlmm_call_add_liquidity2meteora_dlmm.call_add_liquidity2meteora_dlmm_solana.meteora_dlmm_call_add_liquidity_by_strategymeteora_dlmm.call_add_liquidity_by_strategymeteora_dlmm_solana.meteora_dlmm_call_add_liquidity_by_strategy2meteora_dlmm.call_add_liquidity_by_strategy2meteora_dlmm_solana.meteora_dlmm_call_add_liquidity_by_strategy_one_sidemeteora_dlmm.call_add_liquidity_by_strategy_one_sidemeteora_dlmm_solana.meteora_dlmm_call_add_liquidity_by_weightmeteora_dlmm.call_add_liquidity_by_weightmeteora_dlmm_solana.meteora_dlmm_call_add_liquidity_one_sidemeteora_dlmm.call_add_liquidity_one_sidemeteora_dlmm_solana.meteora_dlmm_call_add_liquidity_one_side_precisemeteora_dlmm.call_add_liquidity_one_side_precisemeteora_dlmm_solana.meteora_dlmm_call_add_liquidity_one_side_precise2meteora_dlmm.call_add_liquidity_one_side_precise2meteora_dlmm_solana.meteora_dlmm_call_claim_feemeteora_dlmm.call_claim_feemeteora_dlmm_solana.meteora_dlmm_call_claim_fee2meteora_dlmm.call_claim_fee2meteora_dlmm_solana.meteora_dlmm_call_claim_rewardmeteora_dlmm.call_claim_rewardmeteora_dlmm_solana.meteora_dlmm_call_claim_reward2meteora_dlmm.call_claim_reward2meteora_dlmm_solana.meteora_dlmm_call_close_claim_fee_operator_accountmeteora_dlmm.call_close_claim_fee_operator_accountmeteora_dlmm_solana.meteora_dlmm_call_close_operator_accountmeteora_dlmm.call_close_operator_accountmeteora_dlmm_solana.meteora_dlmm_call_close_positionmeteora_dlmm.call_close_positionmeteora_dlmm_solana.meteora_dlmm_call_close_position2meteora_dlmm.call_close_position2meteora_dlmm_solana.meteora_dlmm_call_close_position_if_emptymeteora_dlmm.call_close_position_if_emptymeteora_dlmm_solana.meteora_dlmm_call_close_preset_parametermeteora_dlmm.call_close_preset_parametermeteora_dlmm_solana.meteora_dlmm_call_close_preset_parameter2meteora_dlmm.call_close_preset_parameter2meteora_dlmm_solana.meteora_dlmm_call_close_token_badgemeteora_dlmm.call_close_token_badgemeteora_dlmm_solana.meteora_dlmm_call_create_operator_accountmeteora_dlmm.call_create_operator_accountmeteora_dlmm_solana.meteora_dlmm_call_decrease_position_lengthmeteora_dlmm.call_decrease_position_lengthmeteora_dlmm_solana.meteora_dlmm_call_for_idl_type_generation_do_not_callmeteora_dlmm.call_for_idl_type_generation_do_not_callmeteora_dlmm_solana.meteora_dlmm_call_fund_rewardmeteora_dlmm.call_fund_rewardmeteora_dlmm_solana.meteora_dlmm_call_go_to_a_binmeteora_dlmm.call_go_to_a_binmeteora_dlmm_solana.meteora_dlmm_call_increase_oracle_lengthmeteora_dlmm.call_increase_oracle_lengthmeteora_dlmm_solana.meteora_dlmm_call_increase_position_lengthmeteora_dlmm.call_increase_position_lengthmeteora_dlmm_solana.meteora_dlmm_call_increase_position_length2meteora_dlmm.call_increase_position_length2meteora_dlmm_solana.meteora_dlmm_call_initialize_bin_arraymeteora_dlmm.call_initialize_bin_arraymeteora_dlmm_solana.meteora_dlmm_call_initialize_bin_array_bitmap_extensionmeteora_dlmm.call_initialize_bin_array_bitmap_extensionmeteora_dlmm_solana.meteora_dlmm_call_initialize_customizable_permissionless_lb_pairmeteora_dlmm.call_initialize_customizable_permissionless_lb_pairmeteora_dlmm_solana.meteora_dlmm_call_initialize_customizable_permissionless_lb_pair2meteora_dlmm.call_initialize_customizable_permissionless_lb_pair2meteora_dlmm_solana.meteora_dlmm_call_initialize_lb_pairmeteora_dlmm.call_initialize_lb_pairmeteora_dlmm_solana.meteora_dlmm_call_initialize_lb_pair2meteora_dlmm.call_initialize_lb_pair2meteora_dlmm_solana.meteora_dlmm_call_initialize_permission_lb_pairmeteora_dlmm.call_initialize_permission_lb_pairmeteora_dlmm_solana.meteora_dlmm_call_initialize_positionmeteora_dlmm.call_initialize_positionmeteora_dlmm_solana.meteora_dlmm_call_initialize_position2meteora_dlmm.call_initialize_position2meteora_dlmm_solana.meteora_dlmm_call_initialize_position_by_operatormeteora_dlmm.call_initialize_position_by_operatormeteora_dlmm_solana.meteora_dlmm_call_initialize_position_pdameteora_dlmm.call_initialize_position_pdameteora_dlmm_solana.meteora_dlmm_call_initialize_preset_parametermeteora_dlmm.call_initialize_preset_parametermeteora_dlmm_solana.meteora_dlmm_call_initialize_rewardmeteora_dlmm.call_initialize_rewardmeteora_dlmm_solana.meteora_dlmm_call_initialize_token_badgemeteora_dlmm.call_initialize_token_badgemeteora_dlmm_solana.meteora_dlmm_call_migrate_positionmeteora_dlmm.call_migrate_positionmeteora_dlmm_solana.meteora_dlmm_call_rebalance_liquiditymeteora_dlmm.call_rebalance_liquiditymeteora_dlmm_solana.meteora_dlmm_call_remove_all_liquiditymeteora_dlmm.call_remove_all_liquiditymeteora_dlmm_solana.meteora_dlmm_call_remove_liquiditymeteora_dlmm.call_remove_liquiditymeteora_dlmm_solana.meteora_dlmm_call_remove_liquidity2meteora_dlmm.call_remove_liquidity2meteora_dlmm_solana.meteora_dlmm_call_remove_liquidity_by_rangemeteora_dlmm.call_remove_liquidity_by_rangemeteora_dlmm_solana.meteora_dlmm_call_remove_liquidity_by_range2meteora_dlmm.call_remove_liquidity_by_range2meteora_dlmm_solana.meteora_dlmm_call_reset_bin_array_tombstone_fieldsmeteora_dlmm.call_reset_bin_array_tombstone_fieldsmeteora_dlmm_solana.meteora_dlmm_call_reset_pool_tombstone_fieldsmeteora_dlmm.call_reset_pool_tombstone_fieldsmeteora_dlmm_solana.meteora_dlmm_call_reset_position_tombstone_fieldsmeteora_dlmm.call_reset_position_tombstone_fieldsmeteora_dlmm_solana.meteora_dlmm_call_set_activation_pointmeteora_dlmm.call_set_activation_pointmeteora_dlmm_solana.meteora_dlmm_call_set_pair_statusmeteora_dlmm.call_set_pair_statusmeteora_dlmm_solana.meteora_dlmm_call_set_pair_status_permissionlessmeteora_dlmm.call_set_pair_status_permissionlessmeteora_dlmm_solana.meteora_dlmm_call_set_pre_activation_durationmeteora_dlmm.call_set_pre_activation_durationmeteora_dlmm_solana.meteora_dlmm_call_set_pre_activation_swap_addressmeteora_dlmm.call_set_pre_activation_swap_addressmeteora_dlmm_solana.meteora_dlmm_call_swapmeteora_dlmm.call_swapmeteora_dlmm_solana.meteora_dlmm_call_swap2meteora_dlmm.call_swap2meteora_dlmm_solana.meteora_dlmm_call_swap_exact_outmeteora_dlmm.call_swap_exact_outmeteora_dlmm_solana.meteora_dlmm_call_swap_exact_out2meteora_dlmm.call_swap_exact_out2meteora_dlmm_solana.meteora_dlmm_call_swap_with_price_impactmeteora_dlmm.call_swap_with_price_impactmeteora_dlmm_solana.meteora_dlmm_call_swap_with_price_impact2meteora_dlmm.call_swap_with_price_impact2meteora_dlmm_solana.meteora_dlmm_call_update_base_fee_parametersmeteora_dlmm.call_update_base_fee_parametersmeteora_dlmm_solana.meteora_dlmm_call_update_dynamic_fee_parametersmeteora_dlmm.call_update_dynamic_fee_parametersmeteora_dlmm_solana.meteora_dlmm_call_update_fees_and_reward2meteora_dlmm.call_update_fees_and_reward2meteora_dlmm_solana.meteora_dlmm_call_update_fees_and_rewardsmeteora_dlmm.call_update_fees_and_rewardsmeteora_dlmm_solana.meteora_dlmm_call_update_position_operatormeteora_dlmm.call_update_position_operatormeteora_dlmm_solana.meteora_dlmm_call_update_reward_durationmeteora_dlmm.call_update_reward_durationmeteora_dlmm_solana.meteora_dlmm_call_update_reward_fundermeteora_dlmm.call_update_reward_fundermeteora_dlmm_solana.meteora_dlmm_call_withdraw_ineligible_rewardmeteora_dlmm.call_withdraw_ineligible_rewardmeteora_dlmm_solana.meteora_dlmm_call_withdraw_protocol_feemeteora_dlmm.call_withdraw_protocol_feemeteora_dlmm_solana.meteora_dlmm_call_zap_protocol_feemeteora_dlmm.call_zap_protocol_fee
OQ — D16·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 meteora_dlmm_solana.meteora_dlmm_evt_lb_pair_createWHERE ts >= {{start_time}}GROUP BY hourORDER BY hour;query sql \ --file meteora_dlmm.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.