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.

Up to date · Data through 2026-10-01 03: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

Dataset status

Latest update

10 datasets · 5.12m rows

Status

Healthy

All datasets present and current

Last updated

2026-10-01 13:26 UTC

Version v0 · f90216806729

Data through

2026-10-01 01:20 UTC

Every dataset reaches this point

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, data-through times and source-file counts are from the latest update.

Dataset Rows Coverage Size Description Query

920k

Aug 2019–Oct 2026

Through 2026-10-01 04:00 UTC

395 source files

13.0 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

223k

Aug 2025–Oct 2026

Through 2026-10-01 03:00 UTC

487 source files

3.0 MB

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

707k

Jan 2021–Oct 2026

Through 2026-10-01 03:00 UTC

82 source files

3.9 MB

Annualized exchange funding history.

1.3m

Aug 2019–Oct 2026

Through 2026-10-01 03:00 UTC

65 source files

10.1 MB

Venue premium-index history with approximation flags.

122k

Aug 2025–Oct 2026

Through 2026-10-01 03:00 UTC

487 source files

1.8 MB

Settled funding-rate updates from FIndexUpdated events.

520k

Aug 2025–Oct 2026

Through 2026-10-01 01:20 UTC

450 source files

16.1 MB

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

246k

Aug 2025–Oct 2026

Through 2026-10-01 01:20 UTC

1,349 source files

4.5 MB

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

223k

Aug 2025–Oct 2026

Through 2026-10-01 03:00 UTC

487 source files

25.6 MB

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

895k

Aug 2025–Oct 2026

Through 2026-10-01 03:00 UTC

1,948 source files

133.7 MB

AMM-merged Boros books at each published APR tick.

224

Reference table

224 source files

5.2 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.