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 support

Pricing - Solana Historical Data Indexer

  • Solana Historical Data Indexer

    $300 USD / month - one subscription within tier limits

Crypto-only, prepaid. No per-request fees.

Full pricing and plan limits

Pricing - Hyperliquid Historical Data Indexer

  • Hyperliquid Historical Data Indexer

    $300 USD / month - one subscription within tier limits

Crypto-only, prepaid. No per-request fees.

Full pricing and plan limits

Pricing - Polymarket Historical Data Indexer

  • Polymarket Historical Data Indexer

    $300 USD / month - one subscription within tier limits

Crypto-only, prepaid. No per-request fees.

Full pricing and plan limits

Pricing - Robinhood Chain Historical Data Indexer

  • Robinhood Chain Historical Data Indexer

    $300 USD / month - one subscription within tier limits

Crypto-only, prepaid. No per-request fees.

Full pricing and plan limits
07.GET STARTED// first query in 10 minutes

First query in 10 minutes.

Start in the portal, get your ClickHouse credentials from our team, connect with any SQL client (DBeaver, DataGrip, or psql-style CLI). First sample queries ready in docs.

→ opens the portal · questions: Telegram support
[ 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.