Which Options Expire on Each Weekday
SPY expiration dates per weekday, by month, since October 2021series ·
2026-10-04 · 60×6
Expiration dates reached, by weekday, trailing yearseries ·
2026-10-04 · 5×5
Option classes grouped by how many weekdays they expired on, trailing quarterranking ·
2026-10-04 · 4×2
Equity vs Index Put/Call Ratio: What's High?
The total is a call-volume-weighted blend of the two bucketsranking ·
2026-10-04 · 11×4
The same equity ratio, computed with and without ETF optionsseries ·
2026-10-04 · 22×4
Single-stock bucket vs ETF bucket, session by sessionseries ·
2026-10-04 · 33×6
Put/call volume ratio by underlying, trailing 60 sessionstable ·
2026-10-04 · 12×5
GLD Implied Volatility, Explained
Average implied volatility by delta bucket, trailing twelve monthsranking ·
2026-09-23 · 5×3
25 delta call minus put implied volatility, in volatility pointsseries ·
2026-09-23 · 60×5
Percentile range of daily ATM implied volatility, five year windowranking ·
2026-09-23 · 5×3
Monthly at-the-money 30 day implied volatility: GLD vs SPYseries ·
2026-09-23 · 60×4
SPY expiration dates per weekday, by month, since October 2021
SPY expiration dates per weekday, by month, since October 2021
| month | mondays | tuesdays | wednesdays | thursdays | fridays |
|---|---|---|---|---|---|
| 2021-10 | 4 | 0 | 4 | 0 | 4 |
| 2021-11 | 5 | 0 | 4 | 0 | 4 |
| 2021-12 | 4 | 0 | 5 | 1 | 4 |
| 2022-01 | 4 | 1 | 4 | 0 | 4 |
| 2022-02 | 3 | 1 | 4 | 0 | 4 |
| 2022-03 | 4 | 0 | 5 | 1 | 4 |
| 2022-04 | 4 | 0 | 4 | 1 | 4 |
| 2022-05 | 4 | 1 | 4 | 0 | 4 |
| 2022-06 | 3 | 1 | 5 | 1 | 4 |
| 2022-07 | 3 | 1 | 4 | 0 | 5 |
| 2022-08 | 5 | 0 | 5 | 0 | 4 |
| 2022-09 | 3 | 1 | 4 | 0 | 5 |
| 2022-10 | 5 | 0 | 4 | 0 | 4 |
| 2022-11 | 4 | 3 | 5 | 1 | 4 |
| 2022-12 | 3 | 4 | 4 | 5 | 5 |
| 2023-01 | 3 | 5 | 4 | 4 | 4 |
| 2023-02 | 3 | 4 | 4 | 4 | 4 |
| 2023-03 | 4 | 4 | 5 | 5 | 5 |
| 2023-04 | 4 | 4 | 4 | 4 | 3 |
| 2023-05 | 4 | 5 | 5 | 4 | 4 |
| 2023-06 | 3 | 4 | 4 | 5 | 5 |
| 2023-07 | 5 | 3 | 4 | 4 | 4 |
| 2023-08 | 4 | 5 | 5 | 5 | 4 |
| 2023-09 | 3 | 4 | 4 | 4 | 5 |
| 2023-10 | 5 | 5 | 4 | 4 | 4 |
| 2023-11 | 4 | 4 | 5 | 4 | 4 |
| 2023-12 | 3 | 4 | 4 | 4 | 5 |
| 2024-01 | 3 | 5 | 5 | 4 | 4 |
| 2024-02 | 3 | 4 | 4 | 5 | 4 |
| 2024-03 | 4 | 4 | 4 | 4 | 4 |
| 2024-04 | 5 | 5 | 4 | 4 | 4 |
| 2024-05 | 3 | 4 | 5 | 5 | 5 |
| 2024-06 | 4 | 4 | 3 | 4 | 4 |
| 2024-07 | 5 | 5 | 5 | 3 | 4 |
| 2024-08 | 4 | 4 | 4 | 5 | 5 |
| 2024-09 | 4 | 4 | 4 | 4 | 4 |
| 2024-10 | 4 | 5 | 5 | 5 | 4 |
| 2024-11 | 4 | 4 | 4 | 3 | 5 |
| 2024-12 | 5 | 5 | 3 | 4 | 4 |
| 2025-01 | 3 | 4 | 4 | 5 | 5 |
| 2025-02 | 3 | 4 | 4 | 4 | 4 |
| 2025-03 | 5 | 4 | 4 | 4 | 4 |
| 2025-04 | 4 | 5 | 5 | 4 | 3 |
| 2025-05 | 3 | 4 | 4 | 5 | 5 |
| 2025-06 | 5 | 4 | 4 | 3 | 4 |
| 2025-07 | 4 | 5 | 5 | 5 | 3 |
| 2025-08 | 4 | 4 | 4 | 4 | 5 |
| 2025-09 | 4 | 5 | 4 | 4 | 4 |
| 2025-10 | 4 | 4 | 5 | 5 | 5 |
| 2025-11 | 4 | 4 | 4 | 3 | 4 |
| 2025-12 | 5 | 5 | 5 | 3 | 4 |
| 2026-01 | 3 | 4 | 4 | 4 | 5 |
| 2026-02 | 3 | 4 | 4 | 4 | 4 |
| 2026-03 | 5 | 5 | 4 | 4 | 4 |
| 2026-04 | 4 | 4 | 5 | 5 | 3 |
| 2026-05 | 3 | 4 | 4 | 4 | 5 |
| 2026-06 | 5 | 5 | 4 | 4 | 3 |
| 2026-07 | 4 | 4 | 5 | 5 | 4 |
| 2026-08 | 5 | 4 | 4 | 4 | 4 |
| 2026-09 | 3 | 5 | 5 | 4 | 4 |
the exact SQL behind every number
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
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
→
See all 3,256 queries →