Weekdays with a traded expiration: SPY, QQQ and IWM, trailing five weeks

Name: Weekdays with a traded expiration: SPY, QQQ and IWM, trailing five weeks
Creator: Strasmore
Published: 2026-09-15
License: https://www.strasmore.com/terms/

Answered against 22 years of US equities and 12 years of US options data and published with the query that produced it. This result is stored as of 2026-09-15, from Options Expiry Days in India: NSE and BSE.

as of 2026-09-15 ranking 3×4read in context →

Weekdays with a traded expiration: SPY, QQQ and IWM, trailing five weeks — 3 rows by 4 columns, computed 2026-09-15 from US exchange, SIP and OPRA data.
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

Rows × columns: 3 × 4
Computed: 2026-09-15
Completeness: No missing values
Source: US exchange, SIP and OPRA market data
Licence: Strasmore terms · free, no signup
Formats: JSON · CSV · the SQL below

What each column holds

Column definitions for Weekdays with a traded expiration: SPY, QQQ and IWM, trailing five weeks, derived from the stored result.
Column	Type	Range
`symbol`	text	3 distinct values (IWM, QQQ, SPY)
`weekdays_with_expiry`	number	every row is 5
`expiration_dates`	number	53 to 54
`expiry_weekdays`	text	1 distinct value (Mon Tue Wed Thu Fri)

Computed from Strasmore's warehouse of US exchange, SIP and OPRA market data. Equity prices are delayed; options greeks and implied volatility are end-of-day. This result is stored, not recomputed on load — it is exactly the numbers that were returned on 2026-09-15, and the query below is what returned them.

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

Run your own version of this

The same 22 years of US equities and 12 years of options data are queryable in SQL or plain English. A free account runs 100 queries a day and takes no card.