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 and decoded Robinhood Chain activity. Solana rows become available approximately 15 seconds after block confirmation. Query SQL directly; custom REST endpoints are scoped separately.

[ get started ]view pricing →
INDEXER FORMATSClickHouse SQL
Solana schema
21 tables
ClickHouse SQL
Solana columns
557 cols
Typed fields
Access setup
By team
Networks indexed
3
solana history from
2024-01-17
interface
SQL
02.WHERE IT RUNS// 3 live

Every indexer here is decoded chain history in ClickHouse, queried the same way. What changes per network is what there is to decode - swaps on one, perpetual fills on another - and whether it is on the shelf today.

SolanaHistorical DataliveHyperliquidHistorical DataliveRobinhoodHistorical Datalive
Another network? Discuss your infrastructure requirements with our team.talk to us →
03.SOLANA, IN DETAIL// 4 data domains
/ dex-activityFLAGSHIP
DEX swaps
Decoded swaps in the documented Solana DEX tables. Coverage and retention vary by table.
◆Raydium · Meteora · Pump.fun
◆PumpSwap · LaunchLab · Letsbonk.fun
◆wSOL flows
/ token-dataSCHEMA
Token & SOL transfers
token_transfers and sol_top_ups record token and native SOL transfers, with 31-day retention.
◆SPL and Token-2022 transfers
◆Native SOL transfers
◆31-day retention for both tables
/ wallet-flowsSCHEMA
Address analysis
Query address activity across swaps and transfers with SQL. Your query defines the metrics.
◆Swap activity by address
◆Token and SOL transfer flows
◆SQL aggregates within table coverage
/ timing-and-tipsSCHEMA
Timing & tips
Solana Jito tips and recorded receiver-arrival timestamps. Confirm current timestamp coverage.
◆Jito tips in lamports
◆Recorded receiver-arrival timestamps
◆14-day retention: jito_tips and tx_timestamps
04.WHY OURS// 4 reasons
◆Direct ClickHouse SQL
Full SQL surface with joins, CTEs, and window functions, plus a custom REST endpoint quoted for your specific query.
◆One schema per domain
Solana DEX activity, Hyperliquid perpetual fills and decoded Robinhood Chain activity have their documented tables, fields and coverage.
◆Solana rows: ~15s
Solana Indexer rows are available approximately 15 seconds after block confirmation. Coverage and retention vary by table; this is separate from SQL query runtime.
◆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.

Flat monthly subscriptions cover SQL access within agreed usage limits. Custom REST endpoints are quoted separately. Request a trial up to 24 hours; our team confirms availability and setup.

[ get started ]
// 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 - 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.

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

Solana Indexer rows are available approximately 15 seconds after block confirmation. Solana history begins on 2024-01-17, with coverage and retention varying by table. Hyperliquid and Robinhood datasets have their own documented coverage.

Which networks are indexed?

Solana DEX activity, Hyperliquid perpetual fills with nanosecond timing, and Robinhood Chain activity are live today.

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.