OQ — D23 · DEX & Trading
29 typed tables generated from the OpenBook v2 IDL — 0 event tables and 29 instruction tables. Every column name comes from the program's own interface definition.
- Tables
- 29
- Event tables
- 0
- Instruction tables
- 29
- Account types
- 6
Program ID
opnb2LAfJYbRMAHHvqjCwQxanZn7ReEHp1k81EohpZbOpenBook v2 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 29 instruction tables below to read what it did and which accounts were involved.
One table per instruction. OnchainQueries also exposes verified account_<name> aliases for instruction account columns when the bundled IDL and the live schema agree.
openbook_v2_solana.openbook_v2_call_cancel_all_and_place_ordersopenbook_v2.call_cancel_all_and_place_ordersopenbook_v2_solana.openbook_v2_call_cancel_all_ordersopenbook_v2.call_cancel_all_ordersopenbook_v2_solana.openbook_v2_call_cancel_orderopenbook_v2.call_cancel_orderopenbook_v2_solana.openbook_v2_call_cancel_order_by_client_order_idopenbook_v2.call_cancel_order_by_client_order_idopenbook_v2_solana.openbook_v2_call_close_marketopenbook_v2.call_close_marketopenbook_v2_solana.openbook_v2_call_close_open_orders_accountopenbook_v2.call_close_open_orders_accountopenbook_v2_solana.openbook_v2_call_close_open_orders_indexeropenbook_v2.call_close_open_orders_indexeropenbook_v2_solana.openbook_v2_call_consume_eventsopenbook_v2.call_consume_eventsopenbook_v2_solana.openbook_v2_call_consume_given_eventsopenbook_v2.call_consume_given_eventsopenbook_v2_solana.openbook_v2_call_create_marketopenbook_v2.call_create_marketopenbook_v2_solana.openbook_v2_call_create_open_orders_accountopenbook_v2.call_create_open_orders_accountopenbook_v2_solana.openbook_v2_call_create_open_orders_indexeropenbook_v2.call_create_open_orders_indexeropenbook_v2_solana.openbook_v2_call_depositopenbook_v2.call_depositopenbook_v2_solana.openbook_v2_call_edit_orderopenbook_v2.call_edit_orderopenbook_v2_solana.openbook_v2_call_edit_order_peggedopenbook_v2.call_edit_order_peggedopenbook_v2_solana.openbook_v2_call_place_orderopenbook_v2.call_place_orderopenbook_v2_solana.openbook_v2_call_place_order_peggedopenbook_v2.call_place_order_peggedopenbook_v2_solana.openbook_v2_call_place_ordersopenbook_v2.call_place_ordersopenbook_v2_solana.openbook_v2_call_place_take_orderopenbook_v2.call_place_take_orderopenbook_v2_solana.openbook_v2_call_prune_ordersopenbook_v2.call_prune_ordersopenbook_v2_solana.openbook_v2_call_refillopenbook_v2.call_refillopenbook_v2_solana.openbook_v2_call_set_delegateopenbook_v2.call_set_delegateopenbook_v2_solana.openbook_v2_call_set_market_expiredopenbook_v2.call_set_market_expiredopenbook_v2_solana.openbook_v2_call_settle_fundsopenbook_v2.call_settle_fundsopenbook_v2_solana.openbook_v2_call_settle_funds_expiredopenbook_v2.call_settle_funds_expiredopenbook_v2_solana.openbook_v2_call_stub_oracle_closeopenbook_v2.call_stub_oracle_closeopenbook_v2_solana.openbook_v2_call_stub_oracle_createopenbook_v2.call_stub_oracle_createopenbook_v2_solana.openbook_v2_call_stub_oracle_setopenbook_v2.call_stub_oracle_setopenbook_v2_solana.openbook_v2_call_sweep_feesopenbook_v2.call_sweep_fees
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 openbook_v2_solana.openbook_v2_call_create_marketWHERE ts >= {{start_time}}GROUP BY hourORDER BY hour;query sql \ --file openbook_v2.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.