Near the money SPY put marks, May to June 2026

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(date)                                            AS session_date,
    formatDateTime(date, '%b %e')                             AS session_label,
    toDecimal64(round(avg(toFloat64(option_close)), 2), 2)    AS atm_put_mark,
    round(100 * avg(implied_volatility), 1)                   AS atm_iv_pct
FROM global_markets.options_greeks
WHERE underlying_symbol = 'SPY'
  AND lower(option_type) IN ('put', 'p')
  AND date >= '2026-05-01'
  AND date <  '2026-07-01'
  AND iv_converged = 1
  AND volume > 0
  AND days_to_expiry BETWEEN 20 AND 45
  AND underlying_close > 0
  AND abs(toFloat64(strike_price) / toFloat64(underlying_close) - 1) < 0.02
GROUP BY date
ORDER BY date