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

Best Stocks for Day Trading Options (Ranked)
Daily options contract volume, SPY vs QQQ vs IWM vs NVDA, last 20 sessionsseries · 2026-11-07 · 20×6Preview: a 16-point series, ending lower. At-the-money spread as a percent of premium, calls expiring next day, Dec 19 2024, 10:00 to 10:30 ETranking · 2026-11-07 · 5×4Preview: 5 ranked values, smallest first. Stock and ETF underlyings ranked by average daily options contract volume, last 20 sessionsranking · 2026-11-07 · 15×4Preview: 15 ranked values, largest first. Share of all options contract volume by liquidity tier, last 20 sessionsranking · 2026-11-07 · 4×3Preview: 4 ranked values, smallest first.
Daily options contract volume, SPY vs QQQ vs IWM vs NVDA, last 20 sessions

Daily options contract volume, SPY vs QQQ vs IWM vs NVDA, last 20 sessions

most recentas of series 20×6read in context →
Daily options contract volume, SPY vs QQQ vs IWM vs NVDA, last 20 sessions — 20 rows by 6 columns, computed from US exchange, SIP and OPRA data.
session_datesession_labelspy_millionsqqq_millionsiwm_millionsnvda_millions
2026-10-12Oct 122.672.250.581.99
2026-10-13Oct 132.992.4611.76
2026-10-14Oct 145.133.961.771.77
2026-10-15Oct 154.393.851.382.58
2026-10-16Oct 165.294.631.491.8
2026-10-19Oct 193.422.920.831.38
2026-10-20Oct 202.912.381.21.63
2026-10-21Oct 213.222.4611.19
2026-10-22Oct 223.613.840.882.34
2026-10-23Oct 232.722.041.081.32
2026-10-26Oct 262.872.360.751.12
2026-10-27Oct 272.722.050.921.39
2026-10-28Oct 282.491.8211.18
2026-10-29Oct 293.112.51.41.44
2026-10-30Oct 305.023.991.432.59
2026-11-02Nov 24.043.291.021.49
2026-11-03Nov 32.352.150.71.46
2026-11-04Nov 43.812.851.321.58
2026-11-05Nov 56.694.741.994.2
2026-11-06Nov 63.572.541.022.14
the exact SQL behind every number
SELECT
    toString(date)                                                         AS session_date,
    concat(formatDateTime(date, '%b'), ' ', toString(toDayOfMonth(date)))  AS session_label,
    round(sumIf(volume, underlying_symbol = 'SPY') / 1e6, 2)               AS spy_millions,
    round(sumIf(volume, underlying_symbol = 'QQQ') / 1e6, 2)               AS qqq_millions,
    round(sumIf(volume, underlying_symbol = 'IWM') / 1e6, 2)               AS iwm_millions,
    round(sumIf(volume, underlying_symbol = 'NVDA') / 1e6, 2)              AS nvda_millions
FROM global_markets.options_greeks
WHERE date IN
    (
        SELECT date
        FROM global_markets.options_greeks
        WHERE date >= today() - 40
        GROUP BY date
        ORDER BY date DESC
        LIMIT 20
    )
  AND underlying_symbol IN ('SPY', 'QQQ', 'IWM', 'NVDA')
  AND volume > 0
GROUP BY date
ORDER BY date
$