跳到主要内容

Docs/Historical Data Downloads

Account & billing

Historical Data Downloads

Buy historical option trade files for the whole market by the day or for the symbols you choose, and end-of-day option chain and GEX levels files for the whole market: price, available dates, file layout, formats, delivery, and purchase terms.

Open product
On this page

Historical Data Downloads sell option trades, for the whole market by the trading day or for the symbols you choose, and end-of-day option chains and GEX levels, for the whole market by the trading day. Each order is paid once.

Price

OrderPrice
Option trades, whole market$2 per trading day, however many rows the day has. A recent day has about 9 to 17 million rows
Option trades, chosen symbols$1 per 10 million rows, rounded up to the next 10 million, with a $2 minimum
Option chains, whole market$1 per trading day, with a $2 minimum. A day has about 2 million contracts
GEX levels, whole market$1 per trading day, with a $2 minimum. A day has one row per option root

Each kind of file has its own order page in the dashboard, starting with option trades. It shows example orders, and the exact row count and price before you pay. The file format does not change the price. You pay by card through Stripe Checkout, and Stripe issues an invoice.

Available dates

The order page shows the dates on sale for each kind of file. Each starts on 2026-09-29.

  • Option trades: the range ends 15 days before today, and each new day is added once its files are built.
  • Option chains: each trading day is added the next weekday evening, New York time, so Friday's chain arrives on Monday evening.
  • GEX levels: each trading day is added with that day's option chain.

Dates with no data, such as weekends and market holidays, cannot be chosen. A range that spans them includes only the days with data, and you pay only for those.

Choosing what to buy

An order is a kind of file, a date range, a format, and, for trades, either the whole market or a list of symbols. Option chains are sold for the whole market only. So are GEX levels. Each trade file holds every trade in that selection, sorted by symbol and then time. Filter by expiration, put or call, or premium after you download.

Some index options are listed under two symbols, and ordering one does not include the other: SPX and SPXW, NDX and NDXP, RUT and RUTW, VIX and VIXW. Most SPX trades are under SPXW. The order page warns you before you pay if you chose only one of a pair.

What is in a trade file

Download a free sample to check the layout before you buy, in Parquet or CSV. It holds every DIS trade on 2026-10-15, 8,087 rows.

Each row is one trade, with 16 columns:

ColumnTypeMeaning
dateDateTrading day
timeTimestampTime of the trade, to the millisecond
symbolTextOption root, such as SPY, SPXW, NDXP, or VIXW
put_callTextCALL or PUT
strikeNumberDollars
expiration_dateDate
sizeWhole numberContracts traded
priceNumberTrade price, in dollars per share. The premium is price × size × 100
bid, askNumberThe best bid and ask at the time of the trade
underlying_priceNumberThe underlying's price at the time of the trade
ivNumberImplied volatility as a decimal: 0.35 is 35%
delta, gammaNumberThe option's delta, from -1 to 1, and its gamma
oiWhole numberOpen interest: contracts outstanding
deiNumberDelta exposure as a percent of the underlying's average daily share volume

The time column is written differently by format: CSV shows New York local time with no offset, and Parquet stores the same moment as a UTC timestamp, so a trade at 09:30 in CSV reads 13:30 in Parquet during daylight saving time. date is the trading date in both.

OrderFilesExample name
Whole marketOne per trading daytrades_2026-10-20.parquet
Chosen symbolsOne per symbol per calendar monthSPY_2026-10.parquet

A symbol with no trades in your range is left out of the order at no cost, and the order page names it before you pay. A month with no trades produces no file.

FormatDetailsTypical size
Parquet (recommended)zstd compression and typed columns. Smaller, and fast to load in Python, R, DuckDB, or SparkAbout 14 bytes per row
CSVgzip compression (.csv.gz), with a header row. Most tools can open it, but a whole-market day is too large for ExcelAbout 17 bytes per row

What is in an option chain file

Download a free sample in Parquet or CSV. It holds every listed DIS contract on 2026-10-15, 1,010 rows.

Each file covers one trading day for the whole market, named like chains_2026-10-30.parquet. It has one row per listed option contract, about 2 million rows, sorted by symbol, expiration_date, strike, and put_call. A day is about 60 MB in Parquet and 70 MB in CSV. The data comes from ThetaData's end-of-day reports, which are built at about 17:15 New York time.

ColumnTypeMeaning
dateDateTrading day
symbolTextOption root, such as SPY, SPXW, NDXP, or VIXW. Like trades, SPX and SPXW are separate symbols
expiration_dateDate
strikeNumberDollars
put_callTextCALL or PUT
open, high, low, closeNumber, or emptyThe day's trades. Empty when the contract did not trade
volume, trade_countWhole numberContracts and trades. Counts every session the report counts, so SPX, SPXW, XSP, and VIX include overnight trading
last_trade_timeTimestamp, or emptyTime of the last trade. Empty when the contract did not trade
bid, bid_size, ask, ask_sizeNumber, whole numberThe last quote when the report is built, which is the closing quote. 0 means no bid or no ask
crossed_quote0 or 11 when both sides are quoted and the bid is above the ask
oiWhole number, or emptyOpen interest published on the morning of date, which is as of the previous close. Empty for a contract listed that day
iv, iv_errorNumber, or emptyImplied volatility and ThetaData's error estimate for it. Empty where ThetaData gives no volatility, mostly in-the-money contracts priced below intrinsic value, and for the few index symbols without Greeks
delta, gamma, theta, vega, rhoNumber, or emptyEmpty exactly when iv is
underlying_priceNumber, or emptyThe underlying price the Greeks use: its last trade at about 17:15 New York time, after the close

As with trades, last_trade_time is New York local time in CSV and a UTC timestamp in Parquet, and an empty value is an empty field in CSV and null in Parquet. ThetaData occasionally revises a report after the fact, so a day can change slightly when we rebuild it; links always serve the current file.

What is in a GEX levels file

GEX levels are sold for the whole market only, at $1 per trading day, with a $2 minimum. Days start on 2026-09-29, and each trading day is added with that day's option chain.

Download a free sample in Parquet or CSV. It holds the DIS row on 2026-10-15, computed from the free option chain sample above, so you can check the calculation against it.

Each file covers one trading day for the whole market, named like levels_2026-10-30.parquet. It has one row per option root, sorted by symbol. Every value is computed from that day's option chain file, so you can reproduce it from that file.

ColumnTypeMeaning
dateDateTrading day
symbolTextOption root, such as SPY, SPXW, NDXP, or VIXW. SPX and SPXW are separate rows
underlying_priceNumber, or emptyThe underlying price the levels use, from the chain file: its last trade at about 17:15 New York time, after the close. Empty when the chain file has none for the root
contractsWhole numberListed contracts counted: those that expire after date
contracts_without_gammaWhole numberOf those, contracts that have open interest but no gamma in the chain file. They count toward open interest and max pain, and add no GEX
call_oi, put_oiWhole numberTotal open interest, in contracts
call_gex, put_gexNumber, or emptyTotal gamma exposure, in dollars per 1% move in the underlying. Calls are positive and puts are negative. Empty without an underlying price
gamma_flipNumber, or emptyThe underlying price nearest underlying_price at which net GEX would be zero. Empty when net GEX keeps one sign from 50% to 150% of the underlying price
max_painNumber, or emptyThe strike at which option holders would be paid the least at expiration
call_gex_wall, put_gex_wallNumber, or emptyThe strike at or above the underlying price with the most call GEX, and the strike at or below it with the most put GEX
call_oi_wall, put_oi_wallNumber, or emptyThe same two strikes by open interest
weekly_…, monthly_…Number, or emptyThe same six levels for contracts that expire in 1 to 7 days and in 8 to 31 days. Each prefix has all six columns, such as weekly_gamma_flip and monthly_call_oi_wall. Empty when no contract expires in that range

The file has 27 columns.

How the values are calculated:

  • GEX for one contract is gamma × open interest × 100 × underlying price² × 1%.
  • Open interest is the figure published on the morning of date, which is as of the previous close. Gamma, implied volatility, and the underlying price are ThetaData's at about 17:15 New York time.
  • Gamma flip reprices each contract's gamma at other underlying prices, with its implied volatility held fixed and a 5% interest rate. A contract without implied volatility is left out of it.
  • Walls: when no strike lies on the wall's side of the underlying price, the wall is the largest strike on either side.
  • Contracts that expire on date are left out of every column, because they have expired by the time the data is taken after the close. So:
    • On an expiration day, contracts, call_oi, and put_oi are lower than in that day's option chain file, and a root whose only contracts expire that day has no row.
    • Contracts that expire on the next trading day are part of weekly; use the option chain file to look at them alone.
    • Max pain for the expiration on date is not in this file; you can compute it from the chain file's open interest.
  • Option roots that carry a digit, which mark contracts adjusted to deliver something other than 100 shares, are left out.

An empty value is an empty field in CSV and null in Parquet. A levels day is rebuilt when its chain day is, so it can change slightly; links always serve the current file.

Receiving your files

Whole-market files, of any kind, are ready as soon as you have paid. Chosen-symbol files are built after you pay: small orders take minutes and large orders can take hours. Either way, we email you when they are ready.

On My downloads, each order lists its files with their rows and sizes, and offers a link per file, Copy download command, one curl command that saves every file in a folder for that order, and Copy all links. If a download stops, run the command again in the same place and it continues each file where it stopped.

Each link works for 24 hours, and reopening the order page gives you fresh links and a fresh command. Links are available for 30 days from purchase, so please save your files before then.

Before offering chosen-symbol files, we compare the rows delivered with the rows you paid for. Corrected trades can move the count by up to 0.1%, and the order shows the rows your files hold. An order further short than that shows as needing attention, and we fix or refund it.

Limits

A chosen-symbol order can include up to 40 symbols and up to 5 billion rows. Contact Support if you need a larger or custom export.

Purchase terms

  • You must accept the Historical Data Agreement before you pay. The order page shows it when you click Pay, the first time you buy.
  • Purchases are final once paid. Files cannot be returned. We refund an order we cannot deliver.
  • Files are licensed for your own personal, non-professional use and may not be redistributed. You may keep them after 30 days, under the agreement and the Terms of Service. Contact Support about commercial use.

Ask ChatGPT or Claude Code

Copy this prompt, paste it into ChatGPT, Claude, Claude Code, Cursor, or Codex, then add your question. It tells the model to read our public docs first — no API key needed for that step.

You are helping me use OptionData (https://www.optiondata.io/), a historical U.S. equity options data API.

Before answering, fetch these public files (no login required) and treat them as the source of truth:
- https://www.optiondata.io/llms.txt — short product map (same content as https://www.optiondata.io/llm.txt)
- https://www.optiondata.io/llms-full.txt — full API reference
- https://www.optiondata.io/openapi.json — HTTP OpenAPI

Do not invent endpoints, fields, tables, or limits. Prefer `Authorization: Bearer apikey_…` for HTTP APIs.

Products:
- Historical SQL: POST https://www.optiondata.io/api/historical/sql
- Option chain: POST https://www.optiondata.io/api/option-chain

I am asking about: Historical Data Downloads
- Markdown: https://www.optiondata.io/md/historical-data-downloads
- HTML docs: https://www.optiondata.io/docs/historical-data-downloads

My question: