// solana · indexer

Solana Indexer

Query indexed Solana DEX activity like a database — ClickHouse SQL or custom REST over swaps, token flows, and holders across 6 DEX, ~15s fresh.

Solana · indexer● live
freshness
~15 s
query p99
82 ms
01.WHAT'S INCLUDED// Solana · indexer
  • Direct ClickHouse SQL: joins · CTEs · window fns
  • DEX swaps normalized across 6 platforms
  • Token data: holders · mints · burns · top-N
  • Wallet flows: PnL · whale · smart-money
  • Custom REST endpoints on request
// factsSPEC
Freshness
~15s from chain (p50 14s)
Query p99
82 ms
DEX platforms indexed
6
Historical since
2024-01-11
Interfaces
ClickHouse SQL + custom REST
02.HOW IT WORKS// query it like a database
query.sqlclickhouse · solana
1SELECT wallet, SUM(size) AS vol
2FROM solana.fills
3WHERE ts > now() - INTERVAL 1 HOUR
4GROUP BY wallet
5ORDER BY vol DESC LIMIT 20
→ 200 OK · 82ms · joins, CTEs, window fns
// HOW TO QUERY
Connect with any ClickHouse client — DBeaver, DataGrip, psql, or the Python client — against the solana database, then write SQL with joins, CTEs, and window functions.
// INTERFACES
Direct ClickHouse SQL, or a custom REST endpoint shaped to a recurring query (quoted per scope).
// SCHEMA
Tables, column types, and example queries live in the indexer docs.
03.FAQ// 5 questions
How do I query the Supanode Solana indexer?

Through direct ClickHouse SQL — joins, CTEs, and window functions over normalized tables — 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 historical coverage since 2024-01-11. That is real-time enough for analytics and bot decisioning; for execution-grade latency use streaming instead.

Can Supanode build custom endpoints or transforms?

Yes. Custom REST endpoints wrap a recurring query so your team calls an API instead of writing SQL, and Python ETL flows compute batch transformations or proprietary indicators stored as new tables. Both are quoted per scope on top of the base subscription.

Why is the indexer built on ClickHouse?

ClickHouse is a columnar database built for analytical scans over billions of rows: it reads only the columns a query touches, compresses aggressively, and parallelizes aggregations. That is what keeps query p99 at 82 ms over DEX history reaching back to January 2024.

Get Solana Indexer.

Set up over Telegram with an engineer — endpoint, allowlist, tuning.