OQ — 000 · Solana onchain data
OnchainQueries decodes Solana program data straight from the IDL into typed tables, then serves them over read-only OnchainQL. Thirty-seven protocols, sub-second reads, and every result checksummed so you can prove where the number came from.
- Slot
- 372,140,688
- Decode lag
- 1.4s
- Programs
- 37
- Tables
- 1074
From a question to a published dashboard, without leaving the browser.
- pump_fun.trade_event event1.94B
- pump_fun.create_event event31.7M
- pump_fun.complete_event event4.2M
- pump_fun.call_buy call1.21B
- pump_swaps.buy_event event612M
Every query is read-only, queued, and given the resources its shape calls for. You get the state, the attempt and the result — no dial to tune, no capacity planning.
SELECT date_trunc('hour', ts) AS hour, count_if(is_buy) AS buysFROM pump_fun.trade_eventWHERE ts >= {{start_time}}GROUP BY hourORDER BY hour;Job lifecycle
- Queued
- Running
- Complete
- TerminalFailed
- TerminalCancelled
- TerminalExpired · 24h
Cancel a running job and its capacity is released immediately. Results live for 24 hours, then expire — so nothing you did not ask for is kept around.
Not scraped, not inferred. OnchainQueries reads each program's IDL and produces typed tables with real column names — so pump_fun.complete has a sol_amount, not a byte offset.
1,074 tables · 37 programs
- BonkSwap19 tables/0 eventsbonkswap_bonkswap_solana
- Boop54 tables/25 eventsboop_boop_solana
- DFlow Aggregator v419 tables/2 eventsdflow_aggregator_v4_solana
- Dumpfun9 tables/4 eventsdumpfun_dump_solana
- Jupiter DCA12 tables/0 eventsjupiter_dca_solana
- Jupiter Limit Order9 tables/0 eventsjupiter_limit_order_solana
- Jupiter Perpetuals59 tables/0 eventsjupiter_perpetuals_solana
- Jupiter Swap23 tables/6 eventsjupiter_swap_solana
- Kamino Farms26 tables/0 eventskamino_farms_solana
- Kamino Lending58 tables/0 eventskamino_lending_solana
- Kamino Limit Orders15 tables/0 eventskamino_limit_orders_solana
- Kamino Vault12 tables/0 eventskamino_vault_solana
- Lifinity AMM v23 tables/0 eventslifinity_amm_v2_solana
- Marinade Finance28 tables/0 eventsmarinade_finance_solana
- Meteora AMM61 tables/23 eventsmeteora_amm_solana
- Meteora DLMM99 tables/25 eventsmeteora_dlmm_solana
- Meteora Dynamic Bonding Curve51 tables/23 eventsmeteora_dynamic_bonding_curve_solana
- Meteora Pools26 tables/0 eventsmeteora_pools_solana
- Meteora Vault14 tables/0 eventsmeteora_vault_solana
- Moonshot6 tables/0 eventsmoonshot_solana
- OKX DEX16 tables/2 eventsokx_okx_solana
- OKX DEX v325 tables/6 eventsokx_okx_v3_solana
- OpenBook v229 tables/0 eventsopenbook_v2_solana
- Orca Whirlpool72 tables/6 eventsorca_whirlpool_solana
- PancakeSwap38 tables/11 eventspancakeswap_pancakeswap_solana
- Pump Fees31 tables/14 eventspump_fees_solana
- Pump.fun52 tables/23 eventspump_fun_solana
- PumpSwap47 tables/22 eventspump_swaps_solana
- Raydium AMM19 tables/0 eventsraydium_solana
- Raydium CLMM36 tables/11 eventsraydium_clmm_solana
- Raydium CPMM16 tables/2 eventsraydium_cpmm_solana
- Raydium Launchpad29 tables/4 eventsraydium_launchpad_solana
- Raydium Liquidity Locking4 tables/0 eventsraydium_liquidity_locking_solana
- Stabble Stable Swap21 tables/2 eventsstabble_stable_swap_solana
- Stabble Weighted Swap15 tables/2 eventsstabble_weighted_swap_solana
- Vertigo9 tables/3 eventsvertigo_solana
- Virtuals12 tables/4 eventsvirtuals_solana
Save the query, pick a visualisation, and drop it on a canvas. Everything stays live against the engine — refresh it, schedule it, share it, or embed it in your own site.
- DEX & Trading41%
- Launchpads26%
- Lending19%
- Staking14%
37
Results are not locked in a web app. Every query can leave as Parquet or Arrow, with a manifest and a checksum per part, so the number in your model is provably the number OnchainQueries returned.
Parquet
Numbered Parquet parts plus a manifest recording schema, source coverage, row counts and a SHA-256 per part. The manifest is written last.
Arrow Flight
Arrow IPC stream parts and a signed Flight ticket. Pass the decoded ticket to GetFlightInfo and pull batches with DoGet.
REST API
Submit, poll status, attach to a running query, and cancel. The same control API the CLI uses — no private endpoints.
CLI
Run a .sql file with typed parameters, follow the job, and write checksum-verified results to disk in one command.
“We replaced four indexers and a warehouse with one SQL box.”
- Programs decoded
- 37
- Tables available
- 367
- Rows indexed
- 8.4B
- Median query
- 0.6s
Placeholder logos — replace before launch
Prepaid in SOL,on your schedule.
Top up when you need compute. The current rate is 50,000 credits per SOL, and your balance never resets.
1 SOL
1 SOL
one-time top-up
50,000 query credits
- Prepaid balance never resets
- Native SOL or quoted USDC
- Wallet extension or manual transfer
- Finalized on-chain receipt
5 SOL
5 SOL
one-time top-up
250,000 query credits
- Prepaid balance never resets
- Native SOL or quoted USDC
- Wallet extension or manual transfer
- Finalized on-chain receipt
10 SOL
10 SOL
one-time top-up
500,000 query credits
- Prepaid balance never resets
- Native SOL or quoted USDC
- Wallet extension or manual transfer
- Finalized on-chain receipt
Need a different amount? Enter any custom top-up from 0.1 to 100 SOL after signup. Enterprise capacity remains available by arrangement.