options expiration — 11 answered market questions

Listed versus traded strikes by moneyness (SPY, Sep 18 2026 expiry, as of Aug 14 2026)

most recentas of 2026-11-01 ranking 10×3read in context →

Listed versus traded strikes by moneyness (SPY, Sep 18 2026 expiry, as of Aug 14 2026) — 10 rows by 3 columns, computed 2026-11-01 from US exchange, SIP and OPRA data.
moneyness_band	listed_strikes	traded_strikes
-20% to -16%	12	12
-16% to -12%	21	21
-12% to -8%	31	31
-8% to -4%	31	31
-4% to 0%	32	32
0% to 4%	31	31
4% to 8%	20	20
8% to 12%	5	5
12% to 16%	6	6
16% to 20%	1	1

the exact SQL behind every number

SELECT
    concat(toString(pct_band), '% to ', toString(pct_band + 4), '%') AS moneyness_band,
    countDistinct(strike_price)                                      AS listed_strikes,
    countDistinctIf(strike_price, volume > 0)                        AS traded_strikes
FROM
(
    SELECT
        strike_price,
        volume,
        toInt32(floor((toFloat64(strike_price) / toFloat64(underlying_close) - 1) * 25) * 4) AS pct_band
    FROM global_markets.options_greeks
    WHERE underlying_symbol = 'SPY'
      AND date = '2026-08-14'
      AND expiration_date = '2026-09-18'
      AND underlying_close > 0
)
WHERE pct_band BETWEEN -20 AND 16
GROUP BY pct_band
ORDER BY pct_band

More from this analysisHow VIX Settlement Works: the SOQ

Average high to low range by minute, first half hour (SPY, trailing ~4 months) series 30×3 → Upcoming VIX settlement dates and the SPX expiry each one uses series 13×5 → Expirations three to six weeks out on a pinned session (SPY, Aug 14 2026) series 3×4 → SPY near-the-money implied volatility by distance to expiration ranking 6×3 → See all 3,293 queries →