Skip to content
OnchainQueries

OQ — D11 · Lending & Yield

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

Tables
15
Event tables
0
Instruction tables
15
Account types
3

Program ID

LiMoM9rMhrdYrfzUCxQppvxCSG1FcrUK9G8uLq4A1GF
OQ — D11·1Event tables

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

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

15/15
  • kamino_limit_orders_solana.kamino_limit_orders_call_assert_user_swap_balances_endkamino_limit_orders.call_assert_user_swap_balances_end
  • kamino_limit_orders_solana.kamino_limit_orders_call_assert_user_swap_balances_startkamino_limit_orders.call_assert_user_swap_balances_start
  • kamino_limit_orders_solana.kamino_limit_orders_call_close_order_and_claim_tipkamino_limit_orders.call_close_order_and_claim_tip
  • kamino_limit_orders_solana.kamino_limit_orders_call_create_orderkamino_limit_orders.call_create_order
  • kamino_limit_orders_solana.kamino_limit_orders_call_flash_take_order_endkamino_limit_orders.call_flash_take_order_end
  • kamino_limit_orders_solana.kamino_limit_orders_call_flash_take_order_startkamino_limit_orders.call_flash_take_order_start
  • kamino_limit_orders_solana.kamino_limit_orders_call_initialize_global_configkamino_limit_orders.call_initialize_global_config
  • kamino_limit_orders_solana.kamino_limit_orders_call_initialize_vaultkamino_limit_orders.call_initialize_vault
  • kamino_limit_orders_solana.kamino_limit_orders_call_log_user_swap_balances_endkamino_limit_orders.call_log_user_swap_balances_end
  • kamino_limit_orders_solana.kamino_limit_orders_call_log_user_swap_balances_startkamino_limit_orders.call_log_user_swap_balances_start
  • kamino_limit_orders_solana.kamino_limit_orders_call_take_orderkamino_limit_orders.call_take_order
  • kamino_limit_orders_solana.kamino_limit_orders_call_update_global_configkamino_limit_orders.call_update_global_config
  • kamino_limit_orders_solana.kamino_limit_orders_call_update_global_config_adminkamino_limit_orders.call_update_global_config_admin
  • kamino_limit_orders_solana.kamino_limit_orders_call_update_orderkamino_limit_orders.call_update_order
  • kamino_limit_orders_solana.kamino_limit_orders_call_withdraw_host_tipkamino_limit_orders.call_withdraw_host_tip
OQ — D11·3Example

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

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