STRASMORE/EXPLORE 2,173 QUERIES 22Y EQUITIES · 12Y OPTIONS

2,173 answered market questions

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

American vs European Options Explained
Index roots vs ETF roots: contracts traded on July 6, 2026, with exercise styleranking · 2026-07-31 · 8×3Preview: 8 ranked values, largest first. July 6, 2026: contracts traded per 15 minutes, S&P 500 index options vs SPY optionsseries · 2026-07-31 · 27×3Preview: a 16-point series, ending lower.
Index roots vs ETF roots: contracts traded on July 6, 2026, with exercise style

Index roots vs ETF roots: contracts traded on July 6, 2026, with exercise style

most recentas of ranking 8×3read in context →
Index roots vs ETF roots: contracts traded on July 6, 2026, with exercise style — 8 rows by 3 columns, computed from US exchange, SIP and OPRA data.
productexercise_stylecontracts_mm
SPYAmerican style, share settled12.1
QQQAmerican style, share settled6.88
SPXWEuropean style, cash settled3.65
IWMAmerican style, share settled1.35
SPXEuropean style, cash settled0.19
NDXPEuropean style, cash settled0.08
RUTEuropean style, cash settled0.03
NDXEuropean style, cash settled0
the exact SQL behind every number 
SELECT root AS product,
       transform(root,
                 ['SPX', 'SPXW', 'NDX', 'NDXP', 'RUT', 'SPY', 'QQQ', 'IWM'],
                 ['European style, cash settled', 'European style, cash settled',
                  'European style, cash settled', 'European style, cash settled',
                  'European style, cash settled', 'American style, share settled',
                  'American style, share settled', 'American style, share settled'],
                 'Other') AS exercise_style,
       round(sum(volume) / 1e6, 2) AS contracts_mm
FROM (
    SELECT substring(ticker, 3, length(ticker) - 17) AS root,
           toFloat64(volume) AS volume
    FROM global_markets.options_minute_aggs
    WHERE window_start >= toDateTime('2026-07-06 08:00:00')
      AND window_start < toDateTime('2026-07-07 04:00:00')
      AND toDate(toTimeZone(window_start, 'America/New_York')) = toDate('2026-07-06')
)
WHERE root IN ('SPX', 'SPXW', 'NDX', 'NDXP', 'RUT', 'SPY', 'QQQ', 'IWM')
GROUP BY product, exercise_style
ORDER BY contracts_mm DESC
More from this analysisAmerican vs European Options Explained
July 6, 2026: contracts traded per 15 minutes, S&P 500 index options vs SPY options series 27×3 → SPY: widest open print to close print gaps on monthly expiration Fridays since 2021 ranking 12×4 → Opening prints on settlement morning, May 15, 2026: twelve large US constituents ranking 12×3 → Opening prints against the previous close: settlement Friday vs an ordinary Friday ranking 8×3 → See all 2,173 queries →
$