Skip to content
OnchainQueries

OQ — D24 · DEX & Trading

72 typed tables generated from the Orca Whirlpool IDL — 6 event tables and 66 instruction tables. Every column name comes from the program's own interface definition.

Tables
72
Event tables
6
Instruction tables
66
Account types
12

Program ID

whirLbMiicVdio4qvUfM5KAg6Ct8VwpYzGff3uctyCc
OQ — D24·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.

  • orca_whirlpool_solana.orca_whirlpool_evt_liquidity_decreasedorca_whirlpool.liquidity_decreased
  • orca_whirlpool_solana.orca_whirlpool_evt_liquidity_increasedorca_whirlpool.liquidity_increased
  • orca_whirlpool_solana.orca_whirlpool_evt_liquidity_repositionedorca_whirlpool.liquidity_repositioned
  • orca_whirlpool_solana.orca_whirlpool_evt_pool_initializedorca_whirlpool.pool_initialized
  • orca_whirlpool_solana.orca_whirlpool_evt_position_openedorca_whirlpool.position_opened
  • orca_whirlpool_solana.orca_whirlpool_evt_tradedorca_whirlpool.traded
OQ — D24·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.

66/66
  • orca_whirlpool_solana.orca_whirlpool_call_close_bundled_positionorca_whirlpool.call_close_bundled_position
  • orca_whirlpool_solana.orca_whirlpool_call_close_positionorca_whirlpool.call_close_position
  • orca_whirlpool_solana.orca_whirlpool_call_close_position_with_token_extensionsorca_whirlpool.call_close_position_with_token_extensions
  • orca_whirlpool_solana.orca_whirlpool_call_collect_feesorca_whirlpool.call_collect_fees
  • orca_whirlpool_solana.orca_whirlpool_call_collect_fees_v2orca_whirlpool.call_collect_fees_v2
  • orca_whirlpool_solana.orca_whirlpool_call_collect_protocol_feesorca_whirlpool.call_collect_protocol_fees
  • orca_whirlpool_solana.orca_whirlpool_call_collect_protocol_fees_v2orca_whirlpool.call_collect_protocol_fees_v2
  • orca_whirlpool_solana.orca_whirlpool_call_collect_rewardorca_whirlpool.call_collect_reward
  • orca_whirlpool_solana.orca_whirlpool_call_collect_reward_v2orca_whirlpool.call_collect_reward_v2
  • orca_whirlpool_solana.orca_whirlpool_call_decrease_liquidityorca_whirlpool.call_decrease_liquidity
  • orca_whirlpool_solana.orca_whirlpool_call_decrease_liquidity_v2orca_whirlpool.call_decrease_liquidity_v2
  • orca_whirlpool_solana.orca_whirlpool_call_delete_position_bundleorca_whirlpool.call_delete_position_bundle
  • orca_whirlpool_solana.orca_whirlpool_call_delete_token_badgeorca_whirlpool.call_delete_token_badge
  • orca_whirlpool_solana.orca_whirlpool_call_idl_includeorca_whirlpool.call_idl_include
  • orca_whirlpool_solana.orca_whirlpool_call_increase_liquidityorca_whirlpool.call_increase_liquidity
  • orca_whirlpool_solana.orca_whirlpool_call_increase_liquidity_by_token_amounts_v2orca_whirlpool.call_increase_liquidity_by_token_amounts_v2
  • orca_whirlpool_solana.orca_whirlpool_call_increase_liquidity_v2orca_whirlpool.call_increase_liquidity_v2
  • orca_whirlpool_solana.orca_whirlpool_call_initialize_adaptive_fee_tierorca_whirlpool.call_initialize_adaptive_fee_tier
  • orca_whirlpool_solana.orca_whirlpool_call_initialize_configorca_whirlpool.call_initialize_config
  • orca_whirlpool_solana.orca_whirlpool_call_initialize_config_extensionorca_whirlpool.call_initialize_config_extension
  • orca_whirlpool_solana.orca_whirlpool_call_initialize_dynamic_tick_arrayorca_whirlpool.call_initialize_dynamic_tick_array
  • orca_whirlpool_solana.orca_whirlpool_call_initialize_fee_tierorca_whirlpool.call_initialize_fee_tier
  • orca_whirlpool_solana.orca_whirlpool_call_initialize_poolorca_whirlpool.call_initialize_pool
  • orca_whirlpool_solana.orca_whirlpool_call_initialize_pool_v2orca_whirlpool.call_initialize_pool_v2
  • orca_whirlpool_solana.orca_whirlpool_call_initialize_pool_with_adaptive_feeorca_whirlpool.call_initialize_pool_with_adaptive_fee
  • orca_whirlpool_solana.orca_whirlpool_call_initialize_position_bundleorca_whirlpool.call_initialize_position_bundle
  • orca_whirlpool_solana.orca_whirlpool_call_initialize_position_bundle_with_metadataorca_whirlpool.call_initialize_position_bundle_with_metadata
  • orca_whirlpool_solana.orca_whirlpool_call_initialize_rewardorca_whirlpool.call_initialize_reward
  • orca_whirlpool_solana.orca_whirlpool_call_initialize_reward_v2orca_whirlpool.call_initialize_reward_v2
  • orca_whirlpool_solana.orca_whirlpool_call_initialize_tick_arrayorca_whirlpool.call_initialize_tick_array
  • orca_whirlpool_solana.orca_whirlpool_call_initialize_token_badgeorca_whirlpool.call_initialize_token_badge
  • orca_whirlpool_solana.orca_whirlpool_call_lock_positionorca_whirlpool.call_lock_position
  • orca_whirlpool_solana.orca_whirlpool_call_migrate_repurpose_reward_authority_spaceorca_whirlpool.call_migrate_repurpose_reward_authority_space
  • orca_whirlpool_solana.orca_whirlpool_call_open_bundled_positionorca_whirlpool.call_open_bundled_position
  • orca_whirlpool_solana.orca_whirlpool_call_open_positionorca_whirlpool.call_open_position
  • orca_whirlpool_solana.orca_whirlpool_call_open_position_with_metadataorca_whirlpool.call_open_position_with_metadata
  • orca_whirlpool_solana.orca_whirlpool_call_open_position_with_token_extensionsorca_whirlpool.call_open_position_with_token_extensions
  • orca_whirlpool_solana.orca_whirlpool_call_reposition_liquidity_v2orca_whirlpool.call_reposition_liquidity_v2
  • orca_whirlpool_solana.orca_whirlpool_call_reset_position_rangeorca_whirlpool.call_reset_position_range
  • orca_whirlpool_solana.orca_whirlpool_call_set_adaptive_fee_constantsorca_whirlpool.call_set_adaptive_fee_constants
  • orca_whirlpool_solana.orca_whirlpool_call_set_collect_protocol_fees_authorityorca_whirlpool.call_set_collect_protocol_fees_authority
  • orca_whirlpool_solana.orca_whirlpool_call_set_config_extension_authorityorca_whirlpool.call_set_config_extension_authority
  • orca_whirlpool_solana.orca_whirlpool_call_set_config_feature_flagorca_whirlpool.call_set_config_feature_flag
  • orca_whirlpool_solana.orca_whirlpool_call_set_default_base_fee_rateorca_whirlpool.call_set_default_base_fee_rate
  • orca_whirlpool_solana.orca_whirlpool_call_set_default_fee_rateorca_whirlpool.call_set_default_fee_rate
  • orca_whirlpool_solana.orca_whirlpool_call_set_default_protocol_fee_rateorca_whirlpool.call_set_default_protocol_fee_rate
  • orca_whirlpool_solana.orca_whirlpool_call_set_delegated_fee_authorityorca_whirlpool.call_set_delegated_fee_authority
  • orca_whirlpool_solana.orca_whirlpool_call_set_fee_authorityorca_whirlpool.call_set_fee_authority
  • orca_whirlpool_solana.orca_whirlpool_call_set_fee_rateorca_whirlpool.call_set_fee_rate
  • orca_whirlpool_solana.orca_whirlpool_call_set_fee_rate_by_delegated_fee_authorityorca_whirlpool.call_set_fee_rate_by_delegated_fee_authority
  • orca_whirlpool_solana.orca_whirlpool_call_set_initialize_pool_authorityorca_whirlpool.call_set_initialize_pool_authority
  • orca_whirlpool_solana.orca_whirlpool_call_set_preset_adaptive_fee_constantsorca_whirlpool.call_set_preset_adaptive_fee_constants
  • orca_whirlpool_solana.orca_whirlpool_call_set_protocol_fee_rateorca_whirlpool.call_set_protocol_fee_rate
  • orca_whirlpool_solana.orca_whirlpool_call_set_reward_authorityorca_whirlpool.call_set_reward_authority
  • orca_whirlpool_solana.orca_whirlpool_call_set_reward_authority_by_super_authorityorca_whirlpool.call_set_reward_authority_by_super_authority
  • orca_whirlpool_solana.orca_whirlpool_call_set_reward_emissionsorca_whirlpool.call_set_reward_emissions
  • orca_whirlpool_solana.orca_whirlpool_call_set_reward_emissions_super_authorityorca_whirlpool.call_set_reward_emissions_super_authority
  • orca_whirlpool_solana.orca_whirlpool_call_set_reward_emissions_v2orca_whirlpool.call_set_reward_emissions_v2
  • orca_whirlpool_solana.orca_whirlpool_call_set_token_badge_attributeorca_whirlpool.call_set_token_badge_attribute
  • orca_whirlpool_solana.orca_whirlpool_call_set_token_badge_authorityorca_whirlpool.call_set_token_badge_authority
  • orca_whirlpool_solana.orca_whirlpool_call_swaporca_whirlpool.call_swap
  • orca_whirlpool_solana.orca_whirlpool_call_swap_v2orca_whirlpool.call_swap_v2
  • orca_whirlpool_solana.orca_whirlpool_call_transfer_locked_positionorca_whirlpool.call_transfer_locked_position
  • orca_whirlpool_solana.orca_whirlpool_call_two_hop_swaporca_whirlpool.call_two_hop_swap
  • orca_whirlpool_solana.orca_whirlpool_call_two_hop_swap_v2orca_whirlpool.call_two_hop_swap_v2
  • orca_whirlpool_solana.orca_whirlpool_call_update_fees_and_rewardsorca_whirlpool.call_update_fees_and_rewards
OQ — D24·3Example

Typed parameters keep values out of the SQL text. Save the file, then pass each value with its type.

orca_whirlpool.sql
SELECT  date_trunc('hour', ts) AS hour,  count(*) AS eventsFROM orca_whirlpool_solana.orca_whirlpool_evt_tradedWHERE ts >= {{start_time}}GROUP BY hourORDER BY hour;
shell
query sql \  --file orca_whirlpool.sql \  --param 'start_time:timestamp=2026-08-01 00:00:00' \  --output ./results

OnchainQueries selects an engine, queues the query, and downloads checksum-verified Parquet parts plus a manifest. See the CLI guide.

More in DEX & Trading

Pro includes every engine class and 50,000 query credits a month.

Start queryingRead the docs