Query decoded swaps, pools, tokens and launchpad activity with ClickHouse SQL.
swaps → pools → tokens
SELECT pool_address, tick
FROM uniswap_v3_tradesFollow 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.
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
Signed token deltas, sender, post-swap price, liquidity and tick, with a transaction hash for provenance.
uniswap_v3_trades
uniswap_v4_tradesJOIN → CONTEXT
Resolve pool configuration and ERC-20 identity. Token decimals provide the scale for readable amounts.
trades → pools → tokensSQL → ANALYSIS
Rank active pools, build a price series, inspect a launchpad funnel or compare execution-cost fields.
Filter → join → aggregateConceptual data flow with illustrative examples.
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.
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_trading |
| Flap | flap_creations | flap_migrations |
| 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 |
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.
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.
tokens.decimals.sqrt_price_x96 is a Q64.96 square-root price. Converting it to a readable ratio also requires both token decimals.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.
Decoded swaps, pools, tokens and launchpad activity through ClickHouse SQL.
Free trial up to 24 hours on request. Our team confirms availability and provisions your ClickHouse connection manually.
Tell the team which tables you need, your date range and how you plan to query them.
Receive your ClickHouse host, port, username and password for the robinhood database. Setup is manual.
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.
Retrieve recent v3 swaps with raw amounts intact. Use DBeaver, DataGrip or a ClickHouse Python client with the connection details supplied by our team.
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;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.
SQL access uses the robinhood ClickHouse database and separately issued credentials. Choose RPC and WebSocket for node requests and live subscriptions.
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.
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.
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 →