expirations — 4 answered market questions

The thin end of the screen: funds with the fewest covered weekdays (September 2026)

most recentas of 2026-10-04 ranking 12×3read in context →

The thin end of the screen: funds with the fewest covered weekdays (September 2026) — 12 rows by 3 columns, computed 2026-10-04 from US exchange, SIP and OPRA data.
symbol	weekdays_covered	dated_expiries
INDA	1	1
MDY	1	1
VTI	1	1
ARKK	1	4
EWJ	1	4
GDX	1	4
HYG	1	4
IEF	1	4
IVV	1	4
KWEB	1	4
LQD	1	4
RSP	1	4

the exact SQL behind every number

SELECT
    underlying_symbol                       AS symbol,
    uniqExact(toDayOfWeek(expiration_date)) AS weekdays_covered,
    uniqExact(expiration_date)              AS dated_expiries
FROM global_markets.options_greeks
WHERE date BETWEEN '2026-09-01' AND '2026-09-30'
  AND expiration_date BETWEEN '2026-09-01' AND '2026-09-30'
  AND toDayOfWeek(expiration_date) <= 5
  AND volume > 0
  AND underlying_symbol IN ('SPY','QQQ','IWM','DIA','VOO','IVV','VTI','RSP','MDY',
                            'EEM','EFA','FXI','EWZ','EWJ','KWEB','INDA',
                            'GLD','SLV','GDX','USO','UNG',
                            'TLT','IEF','LQD','HYG',
                            'XLF','XLE','XLK','XLV','XLU','XLI','XLP','XLY','XLB','XRT','KRE',
                            'SMH','XBI','ARKK','IBIT','TQQQ','SQQQ','SOXL','VXX','UVXY')
  AND underlying_symbol NOT IN ('SPCX')
GROUP BY underlying_symbol
ORDER BY weekdays_covered ASC, dated_expiries ASC, symbol
LIMIT 12

More from this analysisWhich ETFs Have 0DTE Options?

Busiest screened funds by option contract volume (September 2026) ranking 12×2 → Every dated expiration for the leading screened fund (September 2026) series 20×5 → ETFs ranked by weekday coverage of dated option expirations (chain as of September 2026) table 15×8 → A 15% cap and 9% buffer, seen from three entry points ranking 21×4 → See all 3,022 queries →