Skip to content
OnchainQueries

OQ — D12 · Lending & Yield

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

Tables
12
Event tables
0
Instruction tables
12
Account types
2

Program ID

kvauTFR8qm1dhniz6pYuBZkuene3Hfrs1VQhVRgCNrr
OQ — D12·1Event tables

Kamino Vault 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 12 instruction tables below to read what it did and which accounts were involved.

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

  • kamino_vault_solana.kamino_vault_call_depositkamino_vault.call_deposit
  • kamino_vault_solana.kamino_vault_call_give_up_pending_feeskamino_vault.call_give_up_pending_fees
  • kamino_vault_solana.kamino_vault_call_initialize_shares_metadatakamino_vault.call_initialize_shares_metadata
  • kamino_vault_solana.kamino_vault_call_init_vaultkamino_vault.call_init_vault
  • kamino_vault_solana.kamino_vault_call_investkamino_vault.call_invest
  • kamino_vault_solana.kamino_vault_call_update_adminkamino_vault.call_update_admin
  • kamino_vault_solana.kamino_vault_call_update_reserve_allocationkamino_vault.call_update_reserve_allocation
  • kamino_vault_solana.kamino_vault_call_update_shares_metadatakamino_vault.call_update_shares_metadata
  • kamino_vault_solana.kamino_vault_call_update_vault_configkamino_vault.call_update_vault_config
  • kamino_vault_solana.kamino_vault_call_withdrawkamino_vault.call_withdraw
  • kamino_vault_solana.kamino_vault_call_withdraw_from_availablekamino_vault.call_withdraw_from_available
  • kamino_vault_solana.kamino_vault_call_withdraw_pending_feeskamino_vault.call_withdraw_pending_fees
OQ — D12·3Example

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

kamino_vault.sql
SELECT  date_trunc('hour', ts) AS hour,  count(*) AS eventsFROM kamino_vault_solana.kamino_vault_call_depositWHERE ts >= {{start_time}}GROUP BY hourORDER BY hour;
shell
query sql \  --file kamino_vault.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.

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