OQ — D34 · DEX & Trading
21 typed tables generated from the Stabble Stable Swap IDL — 2 event tables and 19 instruction tables. Every column name comes from the program's own interface definition.
- Tables
- 21
- Event tables
- 2
- Instruction tables
- 19
- Account types
- 3
Program ID
swapNyd8XiQwJ6ianp9snpu4brUqFxadzvHebnAXjJZOne 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.
stabble_stable_swap_solana.stabble_stable_swap_evt_pool_balance_updated_eventstabble_stable_swap.pool_balance_updated_eventstabble_stable_swap_solana.stabble_stable_swap_evt_pool_updated_eventstabble_stable_swap.pool_updated_event
One table per instruction. OnchainQueries also exposes verified account_<name> aliases for instruction account columns when the bundled IDL and the live schema agree.
stabble_stable_swap_solana.stabble_stable_swap_call_accept_ownerstabble_stable_swap.call_accept_ownerstabble_stable_swap_solana.stabble_stable_swap_call_approve_strategystabble_stable_swap.call_approve_strategystabble_stable_swap_solana.stabble_stable_swap_call_change_amp_factorstabble_stable_swap.call_change_amp_factorstabble_stable_swap_solana.stabble_stable_swap_call_change_max_supplystabble_stable_swap.call_change_max_supplystabble_stable_swap_solana.stabble_stable_swap_call_change_swap_feestabble_stable_swap.call_change_swap_feestabble_stable_swap_solana.stabble_stable_swap_call_change_swap_fee_privilegedstabble_stable_swap.call_change_swap_fee_privilegedstabble_stable_swap_solana.stabble_stable_swap_call_close_strategystabble_stable_swap.call_close_strategystabble_stable_swap_solana.stabble_stable_swap_call_create_strategystabble_stable_swap.call_create_strategystabble_stable_swap_solana.stabble_stable_swap_call_depositstabble_stable_swap.call_depositstabble_stable_swap_solana.stabble_stable_swap_call_exec_strategystabble_stable_swap.call_exec_strategystabble_stable_swap_solana.stabble_stable_swap_call_initializestabble_stable_swap.call_initializestabble_stable_swap_solana.stabble_stable_swap_call_pausestabble_stable_swap.call_pausestabble_stable_swap_solana.stabble_stable_swap_call_reject_ownerstabble_stable_swap.call_reject_ownerstabble_stable_swap_solana.stabble_stable_swap_call_shutdownstabble_stable_swap.call_shutdownstabble_stable_swap_solana.stabble_stable_swap_call_swapstabble_stable_swap.call_swapstabble_stable_swap_solana.stabble_stable_swap_call_swap_v2stabble_stable_swap.call_swap_v2stabble_stable_swap_solana.stabble_stable_swap_call_transfer_ownerstabble_stable_swap.call_transfer_ownerstabble_stable_swap_solana.stabble_stable_swap_call_unpausestabble_stable_swap.call_unpausestabble_stable_swap_solana.stabble_stable_swap_call_withdrawstabble_stable_swap.call_withdraw
Typed parameters keep values out of the SQL text. Save the file, then pass each value with its type.
SELECT date_trunc('hour', ts) AS hour, count(*) AS eventsFROM stabble_stable_swap_solana.stabble_stable_swap_evt_pool_balance_updated_eventWHERE ts >= {{start_time}}GROUP BY hourORDER BY hour;query sql \ --file stabble_stable_swap.sql \ --param 'start_time:timestamp=2026-08-01 00:00:00' \ --output ./resultsOnchainQueries 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.