A volatility smile is implied volatility (IV) plotted against strike for a single expiration. In stock options it usually slopes down from low strikes to high ones, which is why it is also called a skew. An end-of-day option chain file has every contract's IV at the close, so you can build one with a single query.
This post uses the free DIS option chain sample, every listed DIS contract on 2026-10-15, and DuckDB.
Pick one expiration
A smile mixes badly across expirations, so choose one. Here it is the November monthly, 2026-11-20, 36 days out. DIS closed at 110.68.
Use out-of-the-money options
Each strike has a call and a put, and their IVs differ, sometimes a lot. The standard choice is the out-of-the-money side, which trades more and is priced more cleanly: puts below the underlying price and calls above it.
SELECT strike,
put_call,
round(iv * 100, 1) AS iv_pct
FROM 'DIS_chains_2026-10-15.parquet'
WHERE expiration_date = DATE '2026-11-20'
AND strike BETWEEN 95 AND 125
AND ((put_call = 'PUT' AND strike < underlying_price)
OR (put_call = 'CALL' AND strike >= underlying_price))
ORDER BY strike;| Strike | Side | IV |
|---|---|---|
| 95 | Put | 35.8% |
| 100 | Put | 33.8% |
| 105 | Put | 33.3% |
| 110 | Put | 32.5% |
| 115 | Call | 31.4% |
| 120 | Call | 31.0% |
| 125 | Call | 31.3% |
IV falls from 35.8% at the 95 strike to 31.0% at 120, then turns up slightly at 125. That is the usual equity shape: downside protection costs more than upside, so the low strikes carry more IV. The slight rise at the far right is the "smile" part.
Why some contracts have no IV
The DIS sample has 1,010 contracts, and 58 of them have an empty iv. Every one of those 58 is in the money:
| Side | In the money | Without IV |
|---|---|---|
| Calls | 286 | 27 |
| Puts | 219 | 31 |
| Out of the money, both sides | 505 | 0 |
An in-the-money option's price is mostly intrinsic value, so a small gap in its quote can push it below intrinsic value, and no volatility can produce that price. The 107 call expiring 2026-10-16 is an example: its closing quote was 3.20 bid and 4.10 ask, a midpoint of 3.65, below its intrinsic value of 3.68. ThetaData gives no IV in that case, and the Greeks are empty too. Using out-of-the-money options avoids the gap.
Going further
- Term structure: take the at-the-money IV for each expiration and plot it against days to expiration.
- Skew over time: buy a range of chain days and track one number, such as the 95 put's IV minus the 115 call's, from day to day.
- Check the fit: the
iv_errorcolumn is ThetaData's error estimate for each IV; filter out large ones before fitting a curve.
Option chain files hold every listed contract for the whole market each trading day, about 2 million rows, for $1 a day with a $2 minimum. For how IV feeds gamma exposure, see the gamma flip.
Frequently asked questions
Is the IV in the file the closing IV? It is ThetaData's IV at about 17:15 New York time, from the closing quote and the underlying's last trade then.
Why not average the call and put IV at each strike? The in-the-money side is often empty or noisy, so averaging it in adds error.
Do index options have IV in the file? Most do. A few index symbols have no Greeks, and their IV is empty.