Options Expiry Days in India: NSE and BSE
Weekdays with a traded expiration: SPY, QQQ and IWM, trailing five weeksranking ·
2026-09-15 · 3×4
Weekdays with a traded expiration: SPY, QQQ and IWM, trailing five weeks
Weekdays with a traded expiration: SPY, QQQ and IWM, trailing five weeks
| symbol | weekdays_with_expiry | expiration_dates | expiry_weekdays |
|---|---|---|---|
| SPY | 5 | 54 | Mon Tue Wed Thu Fri |
| IWM | 5 | 53 | Mon Tue Wed Thu Fri |
| QQQ | 5 | 53 | Mon Tue Wed Thu Fri |
the exact SQL behind every number
SELECT
underlying_symbol AS symbol,
uniqExact(toDayOfWeek(expiration_date)) AS weekdays_with_expiry,
uniqExact(expiration_date) AS expiration_dates,
trimBoth(concat(
if(has(groupUniqArray(toDayOfWeek(expiration_date)), 1), 'Mon ', ''),
if(has(groupUniqArray(toDayOfWeek(expiration_date)), 2), 'Tue ', ''),
if(has(groupUniqArray(toDayOfWeek(expiration_date)), 3), 'Wed ', ''),
if(has(groupUniqArray(toDayOfWeek(expiration_date)), 4), 'Thu ', ''),
if(has(groupUniqArray(toDayOfWeek(expiration_date)), 5), 'Fri ', ''))) AS expiry_weekdays
FROM global_markets.options_greeks
WHERE date >= today() - 35
AND date < today()
AND volume > 0
AND underlying_symbol IN ('SPY', 'QQQ', 'IWM')
AND toDayOfWeek(expiration_date) <= 5
GROUP BY underlying_symbol
ORDER BY expiration_dates DESC, symbol
Related queries
Top 25 weekly-options underlyings by distinct contracts traded, with expiration weekdays
ranking 25×4
→
Annualized volatility vs total return, 25 large caps, calmest to wildest (~2 years)
ranking 25×3
→
SPY options median spread by expiration date, near-the-money strikes only
ranking 25×4
→
Share of prints with a placeholder participant timestamp, one March session per year (IBM and MSFT)
ranking 24×4
→
See all 2,249 queries →