# Robinhood Historical Indexer.

Query decoded swaps, pools, tokens and launchpad activity with ClickHouse SQL.

[\[ REQUEST ACCESS \]](https://supanode.xyz/services/robinhood/indexer#pricing)[Explore coverage](https://supanode.xyz/services/robinhood/indexer#coverage)

robinhood CLICKHOUSE / SQL

```
swaps → pools → tokens

SELECT pool_address, tick
FROM uniswap_v3_trades
```

Decoded events → Join context → Your analysis

## History with context.

Follow the relationships behind an event without building a log decoder first. Reconstruct pool activity, study a token or inspect a launchpad funnel using a defined SQL dataset.

ROBINHOOD / CLICKHOUSEHistorical data

MARKET ACTIVITY

Uniswap v3 + v4 swaps and pools

IDENTITY & ORIGIN

ERC-20 metadata, tokens and creators

LAUNCHPAD ACTIVITY

Eight launchpads: launches and trading

CATALOG

25 tables and views  
Schema snapshot: 01 Sep 2026

## From event logs  
to a question answered.

Start with decoded rows. Join a swap to its pool, resolve the token pair, then aggregate the time window you care about. Block, transaction and gas fields stay attached to each decoded event.

INPUT → DECODED EVENTS

### The swap

Signed token deltas, sender, post-swap price, liquidity and tick, with a transaction hash for provenance.

`uniswap_v3_trades   uniswap_v4_trades`

JOIN → CONTEXT

### The pool & pair

Resolve pool configuration and ERC-20 identity. Token decimals provide the scale for readable amounts.

`trades → pools → tokens`

SQL → ANALYSIS

### Your result

Rank active pools, build a price series, inspect a launchpad funnel or compare execution-cost fields.

`Filter → join → aggregate`

Conceptual data flow with illustrative examples.

## Know what  
you are querying.

Core coverage is decoded Uniswap v3/v4 activity and token metadata, with launchpad-specific tables and views. Check the catalog for the contracts, fields and dates your analysis needs.

| SURFACE | WHAT YOU GET | JOIN KEY | EARLIEST ROW\* |
| --- | --- | --- | --- |
| `uniswap_v3_trades` | Swaps, signed deltas, sender, recipient, tick, price | `pool_address` | 22 May 2026 |
| `uniswap_v4_trades` | Swaps, signed deltas, tick, price, per-swap fee | `pool_id` | 22 May 2026 |
| `uniswap_v3_pools` | Pool creation, token pair, fee tier, tick spacing | `pool_address` | 18 Jun 2026 |
| `uniswap_v4_pools` | Pool initialization, currencies, fee, hooks | `pool_id` | 22 May 2026 |
| `tokens` | Name, symbol, decimals, creator, metadata | `token_address` | 08 Jul 2026 |

\*Schema snapshot, 01 Sep 2026: 131.2M v3 + 69.1M v4 swaps. Confirm the available range for your tables before sizing a study.

### Explore the eight launchpads

Creations describe the launch; trading surfaces follow the associated pools. Curves and migrations exist where applicable. A view computes results from its underlying sources when queried.

| LAUNCHPAD | STORED TABLES | VIEWS |
| --- | --- | --- |
| Pons | `pons_creations   pons_curve_trades   pons_migrations` | `pons_trading` |
| Flap | `flap_creations   flap_curve_trades` | `flap_migrations   flap_trading` |
| Doppler | `doppler_creations` | `doppler_trading` |
| Noxa | `noxa_creations` | `noxa_trading` |
| Nox | `nox_creations` | `nox_trading` |
| Letscash | `letscash_creations` | `letscash_trading` |
| Varo | `varo_creations` | `varo_trading` |
| Long | Derived surfaces | `long_creations   long_trading` |

[Full schema, types and per-table date ranges ↗](https://supanode.xyz/docs/robinhood/tables)

**Different pool keys.** v3 uses `pool_address`; v4 uses `pool_id`. Normalize these before combining versions. The token joins are `token0/token1` for v3 and `currency0/currency1` for v4.

## Interpret events  
and units correctly.

The schema gives you events and context. Your query defines the window, units, joins and interpretation. Check these boundaries before turning a result into a chart or a report.

### Units & precision

-   Amounts and fee values are raw integers. Scale token amounts using `tokens.decimals`.
-   `sqrt_price_x96` is a Q64.96 square-root price. Converting it to a readable ratio also requires both token decimals.
-   Float conversion loses precision. Keep integers or decimal arithmetic for accounting.
-   Maximum fee fields show fee ceilings. Calculate the actual priority fee paid separately.

### History & freshness

The earliest swap history starts on 22 May 2026. Other tables start later, and views inherit their source coverage. Data refreshes continuously; test freshness for your workload.

Indexer history follows each table's coverage. RPC retains historical state, such as balances and `eth_call` results, for approximately five days.

[Compare with Robinhood RPC & WebSocket →](https://supanode.xyz/services/robinhood/rpc)

## Price & access.

Robinhood Chain

### Historical Data Indexer

Base subscription

Decoded swaps, pools, tokens and launchpad activity through ClickHouse SQL.

-   Queries are subject to tier limits
-   Confirm capacity and your workload with the team
-   Monthly, prepaid · USDC / SOL / ETH / USDT

$300

/ month

Free trial up to 24 hours on request. Our team confirms availability and provisions your ClickHouse connection manually.

[\[ REQUEST ACCESS \]](https://stg.portal.supanode.xyz/)[Documentation](https://supanode.xyz/docs/robinhood/indexer)

[Compare Robinhood services](https://supanode.xyz/pricing/robinhood) · [Billing & plan reference ↗](https://supanode.xyz/docs/robinhood/pricing)

## Connect and query.

1.  ### Open the portal.
    
    Tell the team which tables you need, your date range and how you plan to query them.
    
2.  ### Our team provisions access.
    
    Receive your ClickHouse host, port, username and password for the `robinhood` database. Setup is manual.
    
3.  ### Connect & validate your query.
    
    Use the trial to check coverage and fit. Keep credentials in environment variables or a local .env file.
    

Need help scoping the request? [Talk to support](https://telegram.me/supanode_tgs).

## Ask a precise  
question in SQL.

Retrieve recent v3 swaps with raw amounts intact. Use DBeaver, DataGrip or a ClickHouse Python client with the connection details supplied by our team.

recent\_swaps.sql · robinhoodExample SQLCopy SQL

```
SELECT
    block_timestamp,
    pool_address,
    sender,
    toString(amount0) AS amount0_raw,
    toString(amount1) AS amount1_raw,
    tick
FROM robinhood.uniswap_v3_trades
PREWHERE block_timestamp >= now()
    - INTERVAL 1 HOUR
ORDER BY block_number DESC,
    transaction_index DESC,
    log_index DESC
LIMIT 100;
```

Result columns: timestamp · pool · sender · two raw deltas · tick.  
Run the query to retrieve rows.

### Read the query.

Bound the scan.

`PREWHERE block_timestamp` filters the partitioned trade stream before further analysis.

Preserve precision.

`toString()` keeps 128/256-bit values intact when exporting into JSON or data tools.

Preserve event order.

Block number, transaction index and log index reproduce on-chain order when timestamps coincide.

[Cross-version & launchpad queries ↗](https://supanode.xyz/docs/robinhood/examples)

## Before you  
connect.

### Does this include every Robinhood Chain event?

The catalog covers decoded Uniswap v3/v4 activity, ERC-20 metadata and eight launchpads. Check the table reference against the contracts, fields and dates you need.

### Is the database the same as the RPC endpoint?

SQL access uses the `robinhood` ClickHouse database and separately issued credentials. Choose RPC and WebSocket for node requests and live subscriptions.

### How far back can I query?

The earliest documented swap rows are from 22 May 2026. Core tables and launchpad surfaces have different ranges. The table reference is a dated schema snapshot; confirm your required range during provisioning.

### Can I connect immediately after signing up?

Our team confirms availability and provisions the connection manually after your request in the portal. Free trials can run for up to 24 hours; setup timing is confirmed with the team.

### Can I reuse another chain's credentials?

The Robinhood database is provisioned separately. Use only the host, port, username and password issued for this dataset.

Need node access and subscriptions? [View Robinhood RPC & WebSocket →](https://supanode.xyz/services/robinhood/rpc)

---
Source: https://supanode.xyz/services/robinhood/indexer