[ SUPANODE ]by hightower
01.DATA ANALYTICS// solana indexer · clickhouse SQL
// clickhouse SQL · 6 DEX pre-indexed · custom REST · since 2024-01-11

Query Solana
like a database.

Supanode indexes Solana DEX activity across 6 platforms — swaps, token flows, holder distributions, LP positions — with ~15s freshness from chain. Query it with direct ClickHouse SQL, or a custom REST endpoint shaped to your exact query.

[ get started ]view pricing →
INDEXER · LIVE● operational
freshness · p50
14 s
▂▃▂▃▂▂▃▂▃▂▃▂▂▃▂▃
query p99
82 ms
▁▂▃▂▁▂▃▂▁▂▁▂▃▂▁▂
rows indexed · 24h
218M
DEX platforms
6
historical from
2024-01-11
interface
SQL + REST
02.WHAT WE INDEX// 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
03.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.
◆6 DEX platforms pre-indexed
Raydium · Meteora · Pump.fun · PumpSwap · LaunchLab · Letsbonk.fun. Swap events normalized to one schema — query across DEXs in one statement.
◆~15s freshness
Data appears in the indexer after Solana network validation. 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.
04.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
05.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 48h trial included.

[ get started ]
// analytics pricing models
◆Trial→ /pricing#trial
◆Flat monthly→ /pricing#indexer
◆Custom REST builds→ talk to us
06.GET STARTED// first query in 10 minutes

Query Solana 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.

[ get started ][ view pricing ]
→ 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?

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 and historical coverage since 2024-01-11 — real-time enough for analytics and bot decisioning.

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.

// this page is about Solana analytics
Indexer is Solana-only. For Monad/Hyperliquid/EVM analytics — use dedicated nodes + your own indexer setup.
see /services →