STRASMORE/EXPLORE 3,293 QUERIES 22Y EQUITIES · 12Y OPTIONS

3,293 answered market questions

every one with its exact SQL, its result and the date it was computed · free, no signup

When Do VIX Options Expire? The Wednesday Rule
Underlyings with options expiring Wednesday, Sep 2, 2026, ranked by contracts tradedranking · 2026-09-17 · 12×3Preview: 12 ranked values, largest first.
Underlyings with options expiring Wednesday, Sep 2, 2026, ranked by contracts traded

Underlyings with options expiring Wednesday, Sep 2, 2026, ranked by contracts traded

most recentas of ranking 12×3read in context →
Underlyings with options expiring Wednesday, Sep 2, 2026, ranked by contracts traded — 12 rows by 3 columns, computed from US exchange, SIP and OPRA data.
underlyingseries_tradedvolume_thousands
SPY2642022
TSLA1981943.9
NVDA1131831.8
AAPL971635.6
QQQ2251250.1
MU256651.2
AMZN92533.7
META206444.3
IBIT109276.6
INTC112274.8
TLT55216.8
MSFT147196.1
the exact SQL behind every number
SELECT
    underlying_symbol                            AS underlying,
    uniqExact(ticker)                            AS series_traded,
    round(toFloat64(sum(volume)) / 1000, 1)      AS volume_thousands
FROM global_markets.options_greeks
WHERE toDate(expiration_date) = toDate('2026-09-02')
  AND volume > 0
  AND date BETWEEN toDate('2026-08-19') AND toDate('2026-09-02')
  AND underlying_symbol NOT IN ('SPCX')
GROUP BY underlying_symbol
ORDER BY volume_thousands DESC
LIMIT 12
$