Options Expiry Days in India: NSE and BSE
Weekdays with a traded expiration: SPY, QQQ and IWM, trailing five weeksranking ·
2026-10-17 · 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 |
|---|---|---|---|
| IWM | 5 | 56 | Mon Tue Wed Thu Fri |
| SPY | 5 | 56 | Mon Tue Wed Thu Fri |
| QQQ | 5 | 54 | 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
Forward and reverse splits by year, US corporate action records
ranking 11×3
→
Whole-number split sizes since 2015, and the face value each implies
ranking 8×3
→
Recent US large-cap splits, restated as an Indian face value cut
ranking 5×4
→
Rule 204 close-out deadline for a short-sale fail, by trade date (US sessions, trailing weeks)
series 16×6
→
See all 3,293 queries →