Skip to content
OnchainQueries

OQ — D33 · Lending & Yield

4 typed tables generated from the Raydium Liquidity Locking IDL — 0 event tables and 4 instruction tables. Every column name comes from the program's own interface definition.

Tables
4
Event tables
0
Instruction tables
4
Account types
2

Program ID

LockrWmn6K5twhz3y9w1dQERbmgSaRkfnTeTKbpofwE
OQ — D33·1Event tables

Raydium Liquidity Locking 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 4 instruction tables below to read what it did and which accounts were involved.

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

  • raydium_liquidity_locking_solana.raydium_liquidity_locking_call_collect_clmm_fees_and_rewardsraydium_liquidity_locking.call_collect_clmm_fees_and_rewards
  • raydium_liquidity_locking_solana.raydium_liquidity_locking_call_collect_cp_feesraydium_liquidity_locking.call_collect_cp_fees
  • raydium_liquidity_locking_solana.raydium_liquidity_locking_call_lock_clmm_positionraydium_liquidity_locking.call_lock_clmm_position
  • raydium_liquidity_locking_solana.raydium_liquidity_locking_call_lock_cp_liquidityraydium_liquidity_locking.call_lock_cp_liquidity
OQ — D33·3Example

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

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