OQ — D37 · Launchpads & Tokens
12 typed tables generated from the Virtuals IDL — 4 event tables and 8 instruction tables. Every column name comes from the program's own interface definition.
- Tables
- 12
- Event tables
- 4
- Instruction tables
- 8
- Account types
- 1
Program ID
5U3EU2ubXtK84QcRjWVmYt9RaDyA8gKxdUrPFXmZyakiOne 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.
virtuals_solana.virtuals_evt_buy_eventvirtuals.buy_eventvirtuals_solana.virtuals_evt_graduation_eventvirtuals.graduation_eventvirtuals_solana.virtuals_evt_launch_eventvirtuals.launch_eventvirtuals_solana.virtuals_evt_sell_eventvirtuals.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.
virtuals_solana.virtuals_call_buyvirtuals.call_buyvirtuals_solana.virtuals_call_claim_feesvirtuals.call_claim_feesvirtuals_solana.virtuals_call_create_meteora_poolvirtuals.call_create_meteora_poolvirtuals_solana.virtuals_call_initializevirtuals.call_initializevirtuals_solana.virtuals_call_initialize_meteora_accountsvirtuals.call_initialize_meteora_accountsvirtuals_solana.virtuals_call_launchvirtuals.call_launchvirtuals_solana.virtuals_call_sellvirtuals.call_sellvirtuals_solana.virtuals_call_update_pool_creatorvirtuals.call_update_pool_creator
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 virtuals_solana.virtuals_evt_buy_eventWHERE ts >= {{start_time}}GROUP BY hourORDER BY hour;query sql \ --file virtuals.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.