OQ — D04 · Launchpads & Tokens
9 typed tables generated from the Dumpfun IDL — 4 event tables and 5 instruction tables. Every column name comes from the program's own interface definition.
- Tables
- 9
- Event tables
- 4
- Instruction tables
- 5
- Account types
- 1
Program ID
DumpFunGAgW6kPHzWMA3Nnqecyrd6SGnLZvNGp2aHwEaOne 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.
dumpfun_dump_solana.dumpfun_dump_evt_buy_token_eventdumpfun_dump.buy_token_eventdumpfun_dump_solana.dumpfun_dump_evt_drain_pool_eventdumpfun_dump.drain_pool_eventdumpfun_dump_solana.dumpfun_dump_evt_sell_token_eventdumpfun_dump.sell_token_eventdumpfun_dump_solana.dumpfun_dump_evt_token_created_eventdumpfun_dump.token_created_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.
dumpfun_dump_solana.dumpfun_dump_call_buy_exact_tokensdumpfun_dump.call_buy_exact_tokensdumpfun_dump_solana.dumpfun_dump_call_buy_tokens_with_exact_soldumpfun_dump.call_buy_tokens_with_exact_soldumpfun_dump_solana.dumpfun_dump_call_drain_pool_surplusdumpfun_dump.call_drain_pool_surplusdumpfun_dump_solana.dumpfun_dump_call_mintdumpfun_dump.call_mintdumpfun_dump_solana.dumpfun_dump_call_sell_exact_tokensdumpfun_dump.call_sell_exact_tokens
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 dumpfun_dump_solana.dumpfun_dump_evt_buy_token_eventWHERE ts >= {{start_time}}GROUP BY hourORDER BY hour;query sql \ --file dumpfun_dump.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.