STRASMORE/EXPLORE 3,293 QUERIES

SPY expiration dates per weekday, by month, since October 2021

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-11-07, from Which Options Expire on Each Weekday.

as of series 61×6read in context →
SPY expiration dates per weekday, by month, since October 2021 — 61 rows by 6 columns, computed from US exchange, SIP and OPRA data.
monthmondaystuesdayswednesdaysthursdaysfridays
2021-1040404
2021-1150404
2021-1240514
2022-0141404
2022-0231404
2022-0340514
2022-0440414
2022-0541404
2022-0631514
2022-0731405
2022-0850504
2022-0931405
2022-1050404
2022-1143514
2022-1234455
2023-0135444
2023-0234444
2023-0344555
2023-0444443
2023-0545544
2023-0634455
2023-0753444
2023-0845554
2023-0934445
2023-1055444
2023-1144544
2023-1234445
2024-0135544
2024-0234454
2024-0344444
2024-0455444
2024-0534555
2024-0644344
2024-0755534
2024-0844455
2024-0944444
2024-1045554
2024-1144435
2024-1255344
2025-0134455
2025-0234444
2025-0354444
2025-0445543
2025-0534455
2025-0654434
2025-0745553
2025-0844445
2025-0945444
2025-1044555
2025-1144434
2025-1255534
2026-0134445
2026-0234444
2026-0355444
2026-0444553
2026-0534445
2026-0655443
2026-0744554
2026-0854444
2026-0935544
2026-1044455
Rows × columns
61 × 6
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 SPY expiration dates per weekday, by month, since October 2021, derived from the stored result.
ColumnTypeRangeNotes
month text 61 distinct values (2021-10, 2021-11, 2021-12…)
mondays number 3 to 5
tuesdays number 0 to 5
wednesdays number 3 to 5
thursdays number 0 to 5
fridays number 3 to 5

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
    formatDateTime(toStartOfMonth(expiration_date), '%Y-%m')            AS month,
    countDistinctIf(expiration_date, toDayOfWeek(expiration_date) = 1) AS mondays,
    countDistinctIf(expiration_date, toDayOfWeek(expiration_date) = 2) AS tuesdays,
    countDistinctIf(expiration_date, toDayOfWeek(expiration_date) = 3) AS wednesdays,
    countDistinctIf(expiration_date, toDayOfWeek(expiration_date) = 4) AS thursdays,
    countDistinctIf(expiration_date, toDayOfWeek(expiration_date) = 5) AS fridays
FROM global_markets.options_greeks
WHERE underlying_symbol = 'SPY'
  AND date >= '2021-10-01'
  AND date < today()
  AND expiration_date >= '2021-10-01'
  AND expiration_date < toStartOfMonth(today())
  AND volume > 0
GROUP BY month
ORDER BY month
⌘/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 analysisWhich Options Expire on Each Weekday
Expiration dates reached, by weekday, trailing year series 5×5 → Option classes grouped by how many weekdays they expired on, trailing quarter ranking 4×2 → AAPL's final half hour on its tightest monthly expiration close since 2025 series 30×5 → SPY options volume by June 2026 expiration date: a new expiry every session series 21×2 → One 0DTE contract, all day: SPY's busiest same-day call and put, July 6, 2026 series 14×4 → SPY's expiration on every trading day: each near-term SPY expiry date, its weekday and volume series 12×4 → See all 3,293 queries →