Home · Guides · Bitcoin 1-minute historical data: what is in the files and how to load them

GUIDE · BTC · 1-MINUTE · UTC · CATALOG VERIFIED 2026-10-04

Bitcoin 1-minute historical data: what is in the files and how to load them

AI Options Data Store sells Bitcoin 1-minute historical data as a Parquet download: BTC perpetual futures OHLC and mark-price OHLC for three series (BTCUSD inverse 3 Apr 2019 – 20 Feb 2026, BTCUSDT 4 Apr 2020 – 3 Oct 2026, BTCUSD USD-settled 29 Jan 2024 – 3 Oct 2026), hourly funding rates for each, and 25 expired dated BTC futures (SEP 2018 → DEC 2022). Timestamps are UTC; the BTC pack is ₹2,999 by UPI.

BTC pack · ₹2,999BTC historical dataTop 10 crypto Free sample (no email)

Dates on this page are read from the live file catalog, not typed by hand. Full matrix: /coverage.

What one row means

Each row of a perpetual file is one minute (UTC, minute start) with open, high, low, close and the mark-price OHLC for the same minute (mark_open … mark_close).

Known gaps: about 6.7 hours on 28–29 Mar 2021 in the perpetuals, and a few 1–3 hour gaps in BTCUSDT in Apr–Sep 2026.

Load it in Python (pandas)

Parquet keeps the UTC timezone and the numeric types, and loads far faster than CSV. Convert to CSV in one line if a tool needs it.

import pandas as pd

df = pd.read_parquet('BTCUSDT_PERP_FUT_1min_2025-01-01_2025-12-31.parquet')
df = df.set_index('datetime')            # tz-aware UTC
df.index = df.index.tz_convert('Asia/Kolkata')   # optional: IST
bars_5m = df.resample('5min').agg({'open': 'first', 'high': 'max',
                                    'low': 'min', 'close': 'last'})
df.to_csv('btcusdt_1min_2025.csv')       # CSV if you need it

Funding rates and expired futures

Each perpetual has a funding file (…_PERP_FUNDING) with the published funding rate in percent as hourly open/high/low/close — useful for carry and basis studies alongside the 1-minute prices.

The 25 expired dated futures (SEP 2018 → DEC 2022) are one file per contract with contract and expiry_utc columns, so you can study the roll and the basis into expiry.

More coins: the Top 10 crypto pack adds ETH, SOL, XRP, BNB, DOGE, ADA, AVAX, LINK, LTC and DOT in the same layouts.

Exactly which fields are in the files

Perpetual 1-minute files

ColumnTypeMeaning
datetimetimestamp (UTC)Minute start, timezone-aware UTC (add 5:30 for IST)
open / high / low / closefloatTraded price OHLC of the perpetual in that minute
mark_open / mark_high / mark_low / mark_closefloatMark-price OHLC for the same minute; empty where no mark price was published

Funding-rate files (hourly)

ColumnTypeMeaning
datetimetimestamp (UTC)Hour start, UTC
funding_rate_pct_open / _high / _low / _closefloatPublished funding rate of the perpetual in percent, as hourly OHLC

Expired dated-futures files

ColumnTypeMeaning
datetimetimestamp (UTC)Minute start, UTC
open / high / low / closefloatTraded price OHLC of the contract in that minute
contractstringContract code, e.g. BTCUSDT_30DEC22
expiry_utctimestamp (UTC)Expiry time of the contract

Not included: options, implied volatility, Greeks, order book or bid/ask, and spot (cash) prices. Futures and perpetuals only.

Format: Parquet, one file per calendar year per perpetual, one funding file per perpetual and one file per expired dated future. Check the layout on the free BTC sample before buying.

FAQ

Where can I download Bitcoin 1-minute historical data?

AI Options Data Store sells BTC perpetual futures at 1-minute (APR 2019 → OCT 2026) with mark price, hourly funding and 25 expired dated futures as Parquet, ₹2,999 by UPI. A free one-week sample needs no email.

Is it BTCUSDT or BTCUSD?

Both. BTCUSDT perpetual (4 Apr 2020 – 3 Oct 2026), BTCUSD USD-settled perpetual (29 Jan 2024 – 3 Oct 2026) and BTCUSD inverse perpetual (3 Apr 2019 – 20 Feb 2026).

Is this spot bitcoin data?

No. These are perpetual and dated futures prices, not spot (cash) prices. Perpetuals track spot closely through funding, and the mark-price columns are included.

What timezone are the timestamps?

UTC, minute start, stored timezone-aware. Add 5 hours 30 minutes for IST, or use tz_convert in pandas.

Can I get it as CSV?

The files are Parquet. One line of pandas (df.to_csv) converts any file to CSV.

Get the data

Free sample · Schema · Ask the AI for your data

BTC pack · ₹2,999BTC historical dataTop 10 crypto Free sample

Related guides

Crypto files: futures and perpetuals only, timestamps in UTC.