OQ — D36 · Launchpads & Tokens
9 typed tables generated from the Vertigo IDL — 3 event tables and 6 instruction tables. Every column name comes from the program's own interface definition.
- Tables
- 9
- Event tables
- 3
- Instruction tables
- 6
- Account types
- 1
Program ID
vrTGoBuy5rYSxAfV3jaRJWHH6nN9WK4NRExGxsk1bCJOne 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.
vertigo_solana.vertigo_evt_buy_eventvertigo.buy_eventvertigo_solana.vertigo_evt_pool_createdvertigo.pool_createdvertigo_solana.vertigo_evt_sell_eventvertigo.sell_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.
vertigo_solana.vertigo_call_buyvertigo.call_buyvertigo_solana.vertigo_call_claimvertigo.call_claimvertigo_solana.vertigo_call_createvertigo.call_createvertigo_solana.vertigo_call_quote_buyvertigo.call_quote_buyvertigo_solana.vertigo_call_quote_sellvertigo.call_quote_sellvertigo_solana.vertigo_call_sellvertigo.call_sell
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 vertigo_solana.vertigo_evt_buy_eventWHERE ts >= {{start_time}}GROUP BY hourORDER BY hour;query sql \ --file vertigo.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.