Skip to content
OnchainQueries

OQ — D09 · Lending & Yield

26 typed tables generated from the Kamino Farms IDL — 0 event tables and 26 instruction tables. Every column name comes from the program's own interface definition.

Tables
26
Event tables
0
Instruction tables
26
Account types
4

Program ID

FarmsPZpWu9i7Kky8tPN37rs2TpmMrAZrC7S7vJa91Hr
OQ — D09·1Event tables

Kamino Farms declares no events in its IDL, so it has no evt_ tables. That is a property of the program, not a gap in coverage — use the 26 instruction tables below to read what it did and which accounts were involved.

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

26/26
  • kamino_farms_solana.kamino_farms_call_add_rewardskamino_farms.call_add_rewards
  • kamino_farms_solana.kamino_farms_call_deposit_to_farm_vaultkamino_farms.call_deposit_to_farm_vault
  • kamino_farms_solana.kamino_farms_call_harvest_rewardkamino_farms.call_harvest_reward
  • kamino_farms_solana.kamino_farms_call_idl_missing_typeskamino_farms.call_idl_missing_types
  • kamino_farms_solana.kamino_farms_call_initialize_farmkamino_farms.call_initialize_farm
  • kamino_farms_solana.kamino_farms_call_initialize_farm_delegatedkamino_farms.call_initialize_farm_delegated
  • kamino_farms_solana.kamino_farms_call_initialize_global_configkamino_farms.call_initialize_global_config
  • kamino_farms_solana.kamino_farms_call_initialize_rewardkamino_farms.call_initialize_reward
  • kamino_farms_solana.kamino_farms_call_initialize_userkamino_farms.call_initialize_user
  • kamino_farms_solana.kamino_farms_call_refresh_farmkamino_farms.call_refresh_farm
  • kamino_farms_solana.kamino_farms_call_refresh_user_statekamino_farms.call_refresh_user_state
  • kamino_farms_solana.kamino_farms_call_reward_user_oncekamino_farms.call_reward_user_once
  • kamino_farms_solana.kamino_farms_call_set_stake_delegatedkamino_farms.call_set_stake_delegated
  • kamino_farms_solana.kamino_farms_call_stakekamino_farms.call_stake
  • kamino_farms_solana.kamino_farms_call_transfer_ownershipkamino_farms.call_transfer_ownership
  • kamino_farms_solana.kamino_farms_call_unstakekamino_farms.call_unstake
  • kamino_farms_solana.kamino_farms_call_update_farm_adminkamino_farms.call_update_farm_admin
  • kamino_farms_solana.kamino_farms_call_update_farm_configkamino_farms.call_update_farm_config
  • kamino_farms_solana.kamino_farms_call_update_global_configkamino_farms.call_update_global_config
  • kamino_farms_solana.kamino_farms_call_update_global_config_adminkamino_farms.call_update_global_config_admin
  • kamino_farms_solana.kamino_farms_call_update_second_delegated_authoritykamino_farms.call_update_second_delegated_authority
  • kamino_farms_solana.kamino_farms_call_withdraw_from_farm_vaultkamino_farms.call_withdraw_from_farm_vault
  • kamino_farms_solana.kamino_farms_call_withdraw_rewardkamino_farms.call_withdraw_reward
  • kamino_farms_solana.kamino_farms_call_withdraw_slashed_amountkamino_farms.call_withdraw_slashed_amount
  • kamino_farms_solana.kamino_farms_call_withdraw_treasurykamino_farms.call_withdraw_treasury
  • kamino_farms_solana.kamino_farms_call_withdraw_unstaked_depositskamino_farms.call_withdraw_unstaked_deposits
OQ — D09·3Example

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

kamino_farms.sql
SELECT  date_trunc('hour', ts) AS hour,  count(*) AS eventsFROM kamino_farms_solana.kamino_farms_call_deposit_to_farm_vaultWHERE ts >= {{start_time}}GROUP BY hourORDER BY hour;
shell
query sql \  --file kamino_farms.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 Lending & Yield

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

Start queryingRead the docs