Docs/Historical Data Downloads
Account & billingHistorical 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.
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
| Order | Price |
|---|---|
| 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:
| Column | Type | Meaning |
|---|---|---|
date | Date | Trading day |
time | Timestamp | Time of the trade, to the millisecond |
symbol | Text | Option root, such as SPY, SPXW, NDXP, or VIXW |
put_call | Text | CALL or PUT |
strike | Number | Dollars |
expiration_date | Date | |
size | Whole number | Contracts traded |
price | Number | Trade price, in dollars per share. The premium is price × size × 100 |
bid, ask | Number | The best bid and ask at the time of the trade |
underlying_price | Number | The underlying's price at the time of the trade |
iv | Number | Implied volatility as a decimal: 0.35 is 35% |
delta, gamma | Number | The option's delta, from -1 to 1, and its gamma |
oi | Whole number | Open interest: contracts outstanding |
dei | Number | Delta 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.
| Order | Files | Example name |
|---|---|---|
| Whole market | One per trading day | trades_2026-10-20.parquet |
| Chosen symbols | One per symbol per calendar month | SPY_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.
| Format | Details | Typical size |
|---|---|---|
| Parquet (recommended) | zstd compression and typed columns. Smaller, and fast to load in Python, R, DuckDB, or Spark | About 14 bytes per row |
| CSV | gzip compression (.csv.gz), with a header row. Most tools can open it, but a whole-market day is too large for Excel | About 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.
| Column | Type | Meaning |
|---|---|---|
date | Date | Trading day |
symbol | Text | Option root, such as SPY, SPXW, NDXP, or VIXW. Like trades, SPX and SPXW are separate symbols |
expiration_date | Date | |
strike | Number | Dollars |
put_call | Text | CALL or PUT |
open, high, low, close | Number, or empty | The day's trades. Empty when the contract did not trade |
volume, trade_count | Whole number | Contracts and trades. Counts every session the report counts, so SPX, SPXW, XSP, and VIX include overnight trading |
last_trade_time | Timestamp, or empty | Time of the last trade. Empty when the contract did not trade |
bid, bid_size, ask, ask_size | Number, whole number | The last quote when the report is built, which is the closing quote. 0 means no bid or no ask |
crossed_quote | 0 or 1 | 1 when both sides are quoted and the bid is above the ask |
oi | Whole number, or empty | Open interest published on the morning of date, which is as of the previous close. Empty for a contract listed that day |
iv, iv_error | Number, or empty | Implied 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, rho | Number, or empty | Empty exactly when iv is |
underlying_price | Number, or empty | The 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.
| Column | Type | Meaning |
|---|---|---|
date | Date | Trading day |
symbol | Text | Option root, such as SPY, SPXW, NDXP, or VIXW. SPX and SPXW are separate rows |
underlying_price | Number, or empty | The 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 |
contracts | Whole number | Listed contracts counted: those that expire after date |
contracts_without_gamma | Whole number | Of 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_oi | Whole number | Total open interest, in contracts |
call_gex, put_gex | Number, or empty | Total gamma exposure, in dollars per 1% move in the underlying. Calls are positive and puts are negative. Empty without an underlying price |
gamma_flip | Number, or empty | The 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_pain | Number, or empty | The strike at which option holders would be paid the least at expiration |
call_gex_wall, put_gex_wall | Number, or empty | The 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_wall | Number, or empty | The same two strikes by open interest |
weekly_…, monthly_… | Number, or empty | The 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
dateare 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, andput_oiare 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
dateis not in this file; you can compute it from the chain file's open interest.
- On an expiration day,
- 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: