put_trace
Answered against 22 years of US equities and 12 years of US options data and published with the query that produced it. This result is stored as of 2026-09-18, from how-much-money-do-you-need-to-trade-options.
| session_date | day_label | stock_close | margin_required_usd | stock_vs_strike_pct |
|---|---|---|---|---|
| 2025-05-01 | May 1 | 205.25 | 4099 | 2.6 |
| 2025-05-02 | May 2 | 205.04 | 4232 | 2.5 |
| 2025-05-05 | May 5 | 198.6 | 4892 | -0.7 |
| 2025-05-06 | May 6 | 201.15 | 4843 | 0.6 |
| 2025-05-07 | May 7 | 196.45 | 4964 | -1.8 |
| 2025-05-08 | May 8 | 197.51 | 4910 | -1.2 |
| 2025-05-09 | May 9 | 198.52 | 4835 | -0.7 |
| 2025-05-12 | May 12 | 210.15 | 3506 | 5.1 |
| 2025-05-13 | May 13 | 212.15 | 3292 | 6.1 |
| 2025-05-14 | May 14 | 211.97 | 3333 | 6 |
| 2025-05-15 | May 15 | 211.01 | 3414 | 5.5 |
| 2025-05-16 | May 16 | 207.93 | 3637 | 4 |
| 2025-05-19 | May 19 | 208.9 | 3608 | 4.4 |
| 2025-05-20 | May 20 | 206.62 | 3845 | 3.3 |
| 2025-05-21 | May 21 | 201.85 | 4435 | 0.9 |
| 2025-05-22 | May 22 | 201.5 | 4485 | 0.8 |
| 2025-05-23 | May 23 | 195.85 | 4867 | -2.1 |
| 2025-05-27 | May 27 | 200.4 | 4563 | 0.2 |
| 2025-05-28 | May 28 | 207.41 | 3977 | 3.7 |
| 2025-05-29 | May 29 | 199 | 4565 | -0.5 |
| 2025-05-30 | May 30 | 200.29 | 4501 | 0.1 |
| 2025-06-02 | Jun 2 | 201.68 | 4293 | 0.8 |
| 2025-06-03 | Jun 3 | 202.96 | 4138 | 1.5 |
| 2025-06-04 | Jun 4 | 201.86 | 4180 | 0.9 |
| 2025-06-05 | Jun 5 | 200.8 | 4371 | 0.4 |
| 2025-06-06 | Jun 6 | 204.47 | 3906 | 2.2 |
| 2025-06-09 | Jun 9 | 201.75 | 4190 | 0.9 |
| 2025-06-10 | Jun 10 | 202.9 | 3998 | 1.4 |
| 2025-06-11 | Jun 11 | 198.76 | 4369 | -0.6 |
| 2025-06-12 | Jun 12 | 198.58 | 4308 | -0.7 |
| 2025-06-13 | Jun 13 | 196.4 | 4403 | -1.8 |
- Rows × columns
- 31 × 5
- Period covered
- to
- Computed
- Completeness
- No missing values
- Source
- US exchange, SIP and OPRA market data
- Licence
- Strasmore terms · free, no signup
What each column holds
| Column | Type | Range | Notes |
|---|---|---|---|
session_date |
date | 2025-05-01 to 2025-06-13 | |
day_label |
text | 31 distinct values (Jun 10, Jun 11, Jun 12…) | |
stock_close |
text | 31 distinct values (195.85, 196.4, 196.45…) | |
margin_required_usd |
number | 3,292 to 4,964 | US dollars |
stock_vs_strike_pct |
number | -2.1 to 6.1 | percent |
Computed from Strasmore's warehouse of US exchange, SIP and OPRA market data. Equity prices are delayed; options greeks and implied volatility are end-of-day. This result is stored, not recomputed on load — it is exactly the numbers that were returned on , and the query below is what returned them.
the exact SQL behind every number
SELECT
toString(toDate(date)) AS session_date,
concat(formatDateTime(toDate(date), '%b'), ' ', toString(toDayOfMonth(toDate(date)))) AS day_label,
toString(round(toFloat64(max(underlying_close)), 2)) AS stock_close,
toUInt32(round(greatest(
0.20 * toFloat64(max(underlying_close))
- greatest(toFloat64(max(underlying_close)) - 200.0, 0.0)
+ toFloat64(max(option_close)),
0.10 * 200.0 + toFloat64(max(option_close))
) * 100)) AS margin_required_usd,
round((toFloat64(max(underlying_close)) / 200.0 - 1) * 100, 1) AS stock_vs_strike_pct
FROM global_markets.options_greeks
WHERE underlying_symbol = 'AAPL'
AND toDate(expiration_date) = '2025-06-20'
AND lower(toString(option_type)) IN ('p', 'put')
AND toFloat64(strike_price) = 200
AND toDate(date) BETWEEN '2025-05-01' AND '2025-06-13'
AND iv_converged = 1
AND volume > 0
GROUP BY toDate(date)
ORDER BY session_date
Run your own version of this
The same 22 years of US equities and 12 years of options data are queryable in SQL or plain English. A free account runs 100 queries a day and takes no card.
More from this analysishow-much-money-do-you-need-to-trade-options
spread_ladder
ranking 8×3
→
put_ladder
table 8×5
→
call_ladder
table 8×5
→
One SPY $600 LEAPS call's price over two years (expired Jan 16 2026)
series 470×2
→
monthly
series 241×4
→
2s10s spread, monthly average: last 20 years
series 240×2
→
See all 2,358 queries →