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-08-16 05: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 · SQL and results stay in this browser tab · remote reads are limited to the published lake

Lake status

Current build receipt

10 datasets · 4.67m rows

Overall health

Healthy

Manifest, inventory, and watermarks pass

Last successful build

2026-08-16 13:24 UTC

Data through

2026-08-16 05: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

849k

Aug 2019–Aug 2026

Through 2026-08-16 06:00 UTC

377 source files

12.2 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

186k

Aug 2025–Aug 2026

Through 2026-08-16 05:00 UTC

392 source files

2.6 MB

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

671k

Jan 2021–Aug 2026

Through 2026-08-16 05:00 UTC

82 source files

3.6 MB

Annualized exchange funding history.

1.2m

Aug 2019–Aug 2026

Through 2026-08-16 05:00 UTC

65 source files

9.5 MB

Venue premium-index history with approximation flags.

105k

Aug 2025–Aug 2026

Through 2026-08-16 05:00 UTC

392 source files

1.7 MB

Settled funding-rate updates from FIndexUpdated events.

498k

Aug 2025–Aug 2026

Through 2026-08-16 05:04 UTC

386 source files

15.4 MB

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

233k

Aug 2025–Aug 2026

Through 2026-08-16 05:00 UTC

1,158 source files

4.2 MB

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

186k

Aug 2025–Aug 2026

Through 2026-08-16 05:00 UTC

392 source files

21.5 MB

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

747k

Aug 2025–Aug 2026

Through 2026-08-16 05:00 UTC

1,568 source files

122.5 MB

AMM-merged Boros books at each published APR tick.

188

Reference table

188 source files

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