01.DATA ANALYTICS// decoded history · clickhouse SQL
// clickhouse SQL · decoded history · custom REST · one dialect per chain

Query the chain
like a database.

Supanode decodes chain history into typed ClickHouse tables — DEX swaps and token flows on Solana, perpetual fills on Hyperliquid, prediction markets on Polymarket, and more networks in the same SQL dialect. ~15s freshness from chain. Query it directly, or through a custom REST endpoint shaped to your exact question.

INDEXER · LIVE● operational
freshness · p50
14 s
▂▃▂▃▂▂▃▂▃▂▃▂▂▃▂▃
query p99
82 ms
▁▂▃▂▁▂▃▂▁▂▁▂▃▂▁▂
rows indexed · 24h
218M
networks live
4
solana history from
2024-01-17
interface
SQL + REST
02.WHERE IT RUNS// 4 live · 5 in build
03.SOLANA, IN DETAIL// 4 data domains
/ dex-activityFLAGSHIP
DEX swaps
Every swap, every LP, every fee — pre-parsed and queryable.
Raydium · Meteora · Pump.fun
PumpSwap · LaunchLab · Letsbonk.fun
wSOL flows
/ token-dataLIVE
Token flows
Holder distributions, mints, burns, transfers — full lifecycle.
Holder counts & distribution
Mint / burn history
Top-N wallets per token
/ wallet-flowsLIVE
Wallet activity
Track addresses, behaviour, whales, sniping patterns over time.
Whale & smart-money flows
Wallet PnL history
Cross-token activity
/ lp-positionsBETA
Liquidity depth
LP positions, fee tiers, range orders — full DEX depth state.
Concentrated liquidity ranges
Pool TVL over time
LP add / remove events
04.WHY OURS// 4 reasons
Direct ClickHouse SQL
Full SQL surface with joins, CTEs, and window functions, plus a custom REST endpoint when you want one. Same speed as a local OLAP DB.
One schema per domain
Swaps from six Solana DEX platforms, perpetual fills, prediction markets — each normalized to a single schema, so one statement spans every venue in it.
~15s freshness
Rows appear once the network has settled the block. Real-time enough for analytics and bot decisioning; not for execution (use Streaming for that).
Custom REST endpoints
If SQL is too low-level for your team, Supanode builds bespoke REST endpoints around your specific query. Ship to product without learning ClickHouse.
05.CODE// sql or rest
query.sqlclickhouse · top whales by net flow
1SELECT wallet, SUM(net_sol) AS flow
2FROM dex_swaps
3WHERE token = '$MYTOKEN'
4  AND ts > now() - INTERVAL 1 HOUR
5GROUP BY wallet
6ORDER BY flow DESC LIMIT 20
~/supanodebash · curl · custom rest
$ curl "https://idx.supanode.xyz/v1/\
top-holders?token=$MYTOKEN&n=20"
-H "x-token: $KEY"
200 OK · 82ms
→ [{ wallet, balance, pct }, ...]
see schema docs →tables · column types · example queries in /docs/solana/indexer
06.PRICING// flat monthly

Flat monthly.
No per-query bills.

One plan, query as much as you want — no metering, no surprise bills from a full-table scan. Up to 24h trial included.

// analytics pricing models
Trial→ /pricing
Flat monthly→ /pricing
Custom REST builds→ talk to us
07.GET STARTED// first query in 10 minutes

First query in 10 minutes.

Open Telegram, get your ClickHouse credentials, connect with any SQL client (DBeaver, DataGrip, or psql-style CLI). First sample queries ready in docs.

→ opens Telegram · provisioning is manual
[ FAQ ]
How do I query the Supanode indexer?

Through direct ClickHouse SQL — joins, CTEs, and window functions — using clients like DBeaver, DataGrip, or psql. Supanode can also build a custom REST endpoint around a specific query if SQL is too low-level for your team.

Which DEX platforms are indexed on Solana?

Six: Raydium, Meteora, Pump.fun, PumpSwap, LaunchLab, and Letsbonk.fun. Swap events are normalized to one schema so you can query across DEXs in a single statement.

How fresh is the data?

About 15 seconds from chain (p50 14s), with an 82 ms query p99 — real-time enough for analytics and bot decisioning. Solana history goes back to 2024-01-17; each other network is indexed from the point its dataset starts.

Which networks are indexed?

Solana DEX activity, Hyperliquid perpetual fills with nanosecond timing, Polymarket prediction-market history, and Robinhood Chain activity are live today. Monad, BNB Chain, Lighter, Fomo and Arc datasets are in build - tell us which tables you need and you go to the front of that queue.

How is the indexer priced?

A flat monthly subscription with unlimited queries within tier limits — see pricing for the rate. Custom REST endpoints are quoted per scope.