STRASMORE/EXPLORE 3,293 QUERIES

Distinct SPY expiration dates traded each week

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-27, from Does an Expired Option Count as a Day Trade?.

as of series 13×3read in context →
Distinct SPY expiration dates traded each week — 13 rows by 3 columns, computed from US exchange, SIP and OPRA data.
weekweek_labelexpirations_traded
2026-06-01Jun 139
2026-06-08Jun 838
2026-06-15Jun 1535
2026-06-22Jun 2236
2026-06-29Jun 2937
2026-07-06Jul 638
2026-07-13Jul 1337
2026-07-20Jul 2037
2026-07-27Jul 2738
2026-08-03Aug 338
2026-08-10Aug 1038
2026-08-17Aug 1736
2026-08-24Aug 2435
Rows × columns
13 × 3
Period covered
to
Computed
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 Distinct SPY expiration dates traded each week, derived from the stored result.
ColumnTypeRangeNotes
week date 2026-06-01 to 2026-08-24
week_label text 13 distinct values (Aug 10, Aug 17, Aug 24…)
expirations_traded number 35 to 39

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 , and the query below is what returned them.

Run it yourself

This is the exact query behind the result above. Change a ticker, a date or a column and run it against the warehouse — no account, no key. The no-signup tier is smaller than the one this page was computed on; a query that reaches past it comes back saying which plan runs it.

SELECT
    toMonday(date)                            AS week,
    formatDateTime(toMonday(date), '%b %e')   AS week_label,
    countDistinct(expiration_date)            AS expirations_traded
FROM global_markets.options_greeks
WHERE underlying_symbol = 'SPY'
  AND volume > 0
  AND date >= '2026-06-01'
  AND date <  '2026-08-31'
GROUP BY week
ORDER BY week
⌘/Ctrl + Enter

Work with this data in your AI assistant

Opens ready to query, with this page's data. Free, no account.

More from this analysisDoes an Expired Option Count as a Day Trade?
Share of August 2026 options volume expiring within five days, by underlying ranking 6×2 → SPY contract volume by days to expiry, September 2026 ranking 4×3 → Calendar days spanned by each rolling five-session window series 79×3 → AAPL contracts traded into each 2026 expiration date, H1 series 68×4 → Share of monthly volume by 15-minute ET clock slice, SPY and AAPL series 64×3 → SPY expiration dates per weekday, by month, since October 2021 series 61×6 → See all 3,293 queries →