Nightly margin requirement on one short AAPL 200 put, May 1 to June 13, 2025

Run it yourself

This is the exact query behind the result above. Change a ticker, a date or a column and run it against the warehouse — no account, no key. The no-signup tier is smaller than the one this page was computed on; a query that reaches past it comes back saying which plan runs it.

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