Ten versioned Parquet datasets mirror Boros's official historical archive. Boros publishes NDJSON-in-ZIP files and reference schemas every 2–3 days. DuckDB reads the consolidated mirror directly over HTTP without an API key or a bulk export step.
market_data Hourly Boros market state across IY, book, mark, and open interest.
DuckDB loads on the first run, then remains warm for subsequent queries.
These schemas describe the Parquet mirror; Boros's reference describes the source NDJSON fields. Row counts, coverage, file sizes, data-through times and source-file counts are from the latest update.
| Dataset | Rows | Coverage | Size | Description | Query | ||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 989k | Aug 2019–Nov 2026 Through 2026-11-16 04:00 UTC 412 source files | 14.1 MB | Annualized dated-futures premium against spot. | ||||||||||||||||||||||||||
Schema
Unitspremium_apr is annualized dated-futures basis in decimal APR. Sorted byvenuebaseexpiry_datetsEnumerated dimensionsVenuesv0 baseline binancebybitcmederibitAssetsv0 baseline BTCBZCLETHSOLSP500XAGXAUXRPExample DuckDB querySource lineageVenue, base, and expiry_date are parsed from the source path. expiry_ts comes from each archive row. Known caveats
Direct Parquet endpoint | |||||||||||||||||||||||||||||
| 264k | Aug 2025–Nov 2026 Through 2026-11-16 03:00 UTC 541 source files | 3.4 MB | Hourly Boros market state across IY, book, mark, and open interest. | ||||||||||||||||||||||||||
| 743k | Jan 2021–Nov 2026 Through 2026-11-16 03:00 UTC 82 source files | 4.0 MB | Annualized exchange funding history. | ||||||||||||||||||||||||||
| 1.3m | Aug 2019–Nov 2026 Through 2026-11-16 03:00 UTC 65 source files | 10.7 MB | Venue premium-index history with approximation flags. | ||||||||||||||||||||||||||
| 142k | Aug 2025–Nov 2026 Through 2026-11-16 03:00 UTC 541 source files | 2.2 MB | Settled funding-rate updates from FIndexUpdated events. | ||||||||||||||||||||||||||
| 540k | Aug 2025–Nov 2026 Through 2026-11-16 03:19 UTC 535 source files | 16.7 MB | Boros fills with side, rate, size, and transaction hash. | ||||||||||||||||||||||||||
| 259k | Aug 2025–Nov 2026 Through 2026-11-16 03:15 UTC 1,605 source files | 4.7 MB | Boros implied-rate OHLCV at 5m, 1h, and 1d intervals. | ||||||||||||||||||||||||||
| 264k | Aug 2025–Nov 2026 Through 2026-11-16 03:00 UTC 541 source files | 29.2 MB | Portal-faithful raw Boros book snapshots with separate AMM state. | ||||||||||||||||||||||||||
| 1.1m | Aug 2025–Nov 2026 Through 2026-11-16 03:00 UTC 2,164 source files | 141.0 MB | AMM-merged Boros books at each published APR tick. | ||||||||||||||||||||||||||
| 245 | Reference table 245 source files | 5.5 KB | Market identity, venue, symbol, maturity, and dataset coverage. | ||||||||||||||||||||||||||
Boros Historical Data is the official archive and schema. The lake mirrors it as snake-case Parquet with UTC timestamps and source lineage; numeric values remain unchanged.
Use the lake for research and bulk queries. For current market state, use the official Boros API, Boros Explorer MCP, or GraphQL API.