OnchainDivers data and examples
OnchainDivers provides read-only ClickHouse access to structured blockchain and exchange data. We collect raw activity, parse protocol-specific transactions and events, and expose analysis-ready tables with consistent timestamps, asset and wallet identifiers, amounts, fees, and execution context.
The datasets cover the main Solana DEXes and launchpads, HyperLiquid, Polymarket, and Robinhood Chain. They are designed for quantitative research, strategy backtesting, market and wallet analysis, execution-quality studies, dashboards, alerts, and production data pipelines. Researchers can work directly in SQL without operating archive nodes or maintaining a separate parser for every protocol revision.
This site is an executable guide to those datasets. Every published example has a corresponding source file in the repository and is rerun against live data during the documentation build.
Data products
| Product | Structured data | Raw workflows |
|---|---|---|
| Solana | Pump.fun, PumpSwap, Raydium, Meteora, Jito and helper tables | Transfers, top-ups, reserve accounting and creator migration analysis |
| Polymarket | On-chain fills plus event and market metadata | Capture discovery, download and CLOB snapshot/delta replay |
| HyperLiquid | Fills, fulfilled orders, wallets and positions | Recovery-file discovery, download and order-level book replay |
| Robinhood Chain | Tokens plus Uniswap v3/v4 pools and swaps | Pool discovery, protocol comparison and EVM transaction context |
| Fees API | Aggregate transaction, priority, tip and trading fees | Validated JSON client |
The ClickHouse datasets are complemented by high-precision raw order-book archives for Polymarket and HyperLiquid. These archives support historical book reconstruction, spread and liquidity analysis, cross-venue comparisons, and backtests that require the market state visible at a specific moment rather than trades alone.
What you can build
- Research token launches, migrations, swaps, transfers, creator fees, and trader behavior across the main Solana venues.
- Backtest signals against decoded trades and historically reconstructed order books without relying on today's market state.
- Compare Polymarket probability markets with HyperLiquid perpetual futures at sub-market time ranges.
- Analyze wallets, positions, fills, fees, slippage, pool state, and protocol activity using regular ClickHouse SQL.
- Build reproducible notebooks, scheduled reports, dashboards, and monitoring jobs on top of the same documented schemas.
The flagship Bitcoin five-minute cross-venue reconstruction combines the Polymarket metadata and CLOB archives with HyperLiquid's raw BTC perpetual book in one reproducible analysis. Its companion simple microprice study reuses the same raw download to measure how one- and two-level book imbalance relates to midpoint movement 300 milliseconds later on both venues.
The Solana research pages apply the same approach to Pump.fun launches. The reliable-creator screen looks for creators with at least five recent launches and ranks them by the trade count of their least-active launch during its first 100 slots. It also reports each token's migration status and p95 swap-implied market cap using a median Meteora DLMM SOL/USDC rate, while the migration parent-program study compares the early transaction composition of tokens that migrated with those that had not migrated by the 24-hour cohort cutoff.
The wallet fingerprint study shows how stable transaction-construction features can complement PnL when monitoring a public wallet for a possible operator or automation change.
Why the examples stay current
The static site has a strict build gate. Before the pages are compiled, Python:
- compares each live database with its published table whitelist;
- requires a description for every published column;
- executes all ClickHouse examples with bounded time windows;
- checks PumpSwap reserve and fee identities;
- regenerates the live Pump.fun creator and parent-program research tables;
- scans, copies and reconstructs deterministic raw order-book captures;
- downloads a Bitcoin five-minute market around UTC now minus 24 hours, assembles both raw books, and renders the synchronized analysis chart; and
- validates the configured fees service.
If any of those checks fails, no site image is produced.
Start with Solana connection setup, or go directly to the example pages for Solana, Polymarket, and HyperLiquid, or explore the Robinhood Chain examples.