Protocol

Public data lake

Historical Boros data, ready for SQL

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.

Official source & schema Raw manifest DuckDB guide

Try it here

Query the lake in your browser

No install · no API key · no server SQL

Browser SQL playground

DuckDB-WasmRead only100-row display cap15s timeout

market_data Hourly Boros market state across IY, book, mark, and open interest.

Fresh receipt · Data through 2026-09-09 08:00 UTC

SQL

ResultsReady

Run a recipe to inspect its rows

DuckDB loads on the first run, then remains warm for subsequent queries.

⌘↵ or Ctrl↵ runs · one read-only statement · timestamps in UTC · SQL and results stay in this browser tab · remote reads are limited to the published lake · Share copies a link that reopens this query

Lake status

Current build receipt

10 datasets · 4.89m rows

Overall health

Healthy

Manifest, inventory, and watermarks pass

Last successful build

2026-09-09 13:25 UTC

Data through

2026-09-09 08:00 UTC

Oldest fact-plane watermark

Dataset catalogue

Public Parquet files

Select a dataset to inspect its contract

These schemas describe the Parquet mirror; Boros's reference describes the source NDJSON fields. Row counts, coverage, file sizes, exact watermarks, and source-file counts come from the current build receipt. Dimension labels distinguish manifest values, the dim_markets reference table, and versioned v0 baselines.

Dataset Rows Coverage Size Description Query

887k

Aug 2019–Sep 2026

Through 2026-09-09 09:00 UTC

383 source files

12.6 MB

Annualized dated-futures premium against spot.

Schema

venue	VARCHAR
base	VARCHAR
expiry_date	DATE
ts	TIMESTAMPTZ
contract_symbol	VARCHAR
expiry_ts	TIMESTAMPTZ
premium_apr	DOUBLE
futures_price	DOUBLE
spot_price	DOUBLE
days_to_expiry	DOUBLE
is_spot_proxy	BOOLEAN
source_path	VARCHAR

Units

premium_apr is annualized dated-futures basis in decimal APR.

Sorted by

venuebaseexpiry_datets

Enumerated dimensions

Venuesv0 baseline

binancebybitcmederibit

Assetsv0 baseline

BTCBZCLETHSOLSP500XAGXAUXRP

Example DuckDB query

SELECT venue, base, expiry_date,
       round(avg(premium_apr) * 100, 2) AS premium_pct,
       max(ts) AS last_observation
FROM read_parquet('https://data.borosexplorer.com/v0/futures_premium.parquet')
WHERE base = 'BTC'
  AND days_to_expiry > 2
  AND ts >= current_date - INTERVAL '7 days'
GROUP BY 1, 2, 3
ORDER BY expiry_date;

Source lineage

Venue, base, and expiry_date are parsed from the source path. expiry_ts comes from each archive row.

Known caveats

Check days_to_expiry before interpreting annualized premium close to settlement.
spot_price is joined to spot or index data within ±1 hour. is_spot_proxy=true means the source used a synthetic front-month proxy.

Direct Parquet endpoint

https://data.borosexplorer.com/v0/futures_premium.parquet

204k

Aug 2025–Sep 2026

Through 2026-09-09 08:00 UTC

437 source files

2.8 MB

Hourly Boros market state across IY, book, mark, and open interest.

690k

Jan 2021–Sep 2026

Through 2026-09-09 08:00 UTC

82 source files

3.8 MB

Annualized exchange funding history.

1.2m

Aug 2019–Sep 2026

Through 2026-09-09 08:00 UTC

65 source files

9.8 MB

Venue premium-index history with approximation flags.

113k

Aug 2025–Sep 2026

Through 2026-09-09 08:01 UTC

437 source files

1.7 MB

Settled funding-rate updates from FIndexUpdated events.

509k

Aug 2025–Sep 2026

Through 2026-09-09 08:07 UTC

431 source files

15.8 MB

Indexed Boros fills with side, rate, size, and transaction hash.

239k

Aug 2025–Sep 2026

Through 2026-09-09 08:05 UTC

1,293 source files

4.3 MB

Boros implied-rate OHLCV at 5m, 1h, and 1d intervals.

204k

Aug 2025–Sep 2026

Through 2026-09-09 08:00 UTC

437 source files

23.4 MB

Portal-faithful raw Boros book snapshots with separate AMM state.

817k

Aug 2025–Sep 2026

Through 2026-09-09 08:00 UTC

1,748 source files

128.1 MB

AMM-merged Boros books at each published APR tick.

206

Reference table

206 source files

5.1 KB

Market identity, venue, symbol, maturity, and dataset coverage.

Data boundary

Historical archive and live data

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.