[ SUPANODE ]by hightower
// robinhood · indexer

Robinhood Chain Historical Data Indexer

Decoded Robinhood Chain activity - 200M Uniswap v3 and v4 swaps, pool and token metadata, eight launchpads - in a SQL-queryable ClickHouse warehouse.

[ view pricing ]join group
Robinhood · indexer● live
swaps
200M
since
2026
01.WHAT'S INCLUDED// Robinhood · indexer
  • Direct ClickHouse SQL over the decoded history
  • Uniswap v3 + v4: swaps, pools, hooks, ticks
  • ERC-20 tokens: name · symbol · decimals · creator
  • Eight launchpads: launches · curve trades · graduations
  • Gas and EIP-1559 fee fields on every decoded row
  • Custom REST endpoints, quoted per scope
// factsSPEC
Uniswap v3 swaps
131.2M rows (34.14 GB)
Uniswap v4 swaps
69.1M rows (16.34 GB)
Pools indexed
657.6K v3 · 554.3K v4
Launchpads
8 (Pons · Flap · Doppler · Noxa · Nox · Letscash · Varo · Long)
Tables
25
History since
2026-05-22
Refresh
continuous updates
Interfaces
ClickHouse SQL + custom REST
Database name
robinhood
Free trial
up to 24h, no card
see the full product overview →
02.HOW IT WORKS// query it like a database
query.sqlclickhouse · robinhood
1SELECT sender, count() AS swaps
2FROM robinhood.uniswap_v3_trades
3WHERE block_timestamp > now() - INTERVAL 1 HOUR
4GROUP BY sender
5ORDER BY swaps 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 robinhood 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// 4 questions
What does the Supanode Robinhood indexer contain?

Twenty-five tables in a `robinhood` ClickHouse database. The core is Uniswap: 131.2M decoded v3 swaps and 69.1M v4 swaps, plus 657.6K v3 pools and 554.3K v4 pools with their fee tiers, tick spacing and hooks contracts. Around them sit ERC-20 token identities (name, symbol, decimals, creator) and eight launchpads - Pons, Flap, Doppler, Noxa, Nox, Letscash, Varo and Long - each with its launches, swap stream, and where applicable bonding-curve trades and graduations. Every decoded row carries block, log, transaction, gas and EIP-1559 fee fields.

How far back does the history go?

To 22 May 2026, and it is refreshed continuously. Robinhood Chain is a young network, so this is close to its full life so far - but it is months of history, not years. Size backtests accordingly.

How do I query it?

Through direct ClickHouse SQL against the `robinhood` database, using clients like DBeaver, DataGrip, psql, or the Python client. Supanode can also deploy custom REST endpoints around recurring queries, quoted per scope.

How is the Robinhood indexer priced and provisioned?

The subscription is quoted per customer - tell us on Telegram which tables you need and how you will query them. Billing is crypto-only and prepaid, with unlimited queries within tier limits. Connection details are provisioned over Telegram, and a free trial of up to 24 hours is available before committing.

Get Robinhood Chain Historical Data Indexer.

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

[ talk to us ]◀ Robinhood services