Option Expiration Cycles Explained
Third Friday expirations over the next fourteen months, by underlyings listing themranking ·
2026-10-04 · 13×3
Monthly expirations beyond 300 days out, by underlyings listing themranking ·
2026-10-04 · 13×2
Listed expiration dates, one broad lineup against a thinner chainranking ·
2026-10-04 · 6×4
Every expiration listed on the AAPL chain, with contracts on each dateseries ·
2026-10-04 · 25×4
LEAPS vs Margin Loan: The Financing Cost
Parity-implied financing rate by expiry, deep ITM AAPL strikesranking ·
2026-10-04 · 10×4
AAPL LEAPS calls and puts at matching strikes, one recent sessiontable ·
2026-10-04 · 5×9
Implied financing rate at each AAPL LEAPS strike, versus the 1-year Treasurytable ·
2026-10-04 · 5×5
AAPL dividends in the twelve months before the pricing sessionseries ·
2026-10-04 · 4×3
Poor Man's Covered Call: How the Trade Works
Dividend cash paid on 100 shares over the trailing yearranking ·
2026-09-26 · 6×3
What Is Option Rho? The Interest Rate Greek
Weekly average rho: SPY January 2027 calls against a rolling front-month seriesseries ·
2026-08-07 · 52×3
Average SPY option rho by time to expiration, indexed to the front monthranking ·
2026-08-07 · 6×4
Average rho on long-dated SPY options, by strike against the share priceranking ·
2026-08-07 · 7×4
Start-to-end change in Treasury yields by calendar year, in basis pointsranking ·
2026-08-07 · 13×3
What Are LEAPS? Long-Dated Options
SPY, the call's delta, and its implied volatility at four life stagesseries ·
2026-07-16 · 4×4
One SPY $600 LEAPS call's price over two years (expired Jan 16 2026)series ·
2026-07-16 · 470×2
Theta (daily decay) against days to expiry, across the call's lifeseries ·
2026-07-16 · 4×3
Deep ITM LEAPS: Stock Replacement
One deep-ITM LEAPS vs 100 shares: cost, leverage, and deltaseries ·
2026-07-16 · 3×7
SPY vs the LEAPS call, both indexed to 100 in early June 2025series ·
2026-07-16 · 33×3
The LEAPS call's delta climbing toward 1 as it goes deep in the moneyseries ·
2026-07-16 · 33×2
Time value as a share of premium, and daily theta, month by monthseries ·
2026-07-16 · 8×3
Third Friday expirations over the next fourteen months, by underlyings listing them
Third Friday expirations over the next fourteen months, by underlyings listing them
| expiry_month_start | month_label | underlyings_listing |
|---|---|---|
| 2026-10-01 | Oct 2026 | 3566 |
| 2026-11-01 | Nov 2026 | 3270 |
| 2026-12-01 | Dec 2026 | 1951 |
| 2027-01-01 | Jan 2027 | 2141 |
| 2027-02-01 | Feb 2027 | 892 |
| 2027-03-01 | Mar 2027 | 1576 |
| 2027-04-01 | Apr 2027 | 1038 |
| 2027-05-01 | May 2027 | 744 |
| 2027-07-01 | Jul 2027 | 29 |
| 2027-08-01 | Aug 2027 | 43 |
| 2027-09-01 | Sep 2027 | 430 |
| 2027-10-01 | Oct 2027 | 13 |
| 2027-11-01 | Nov 2027 | 38 |
the exact SQL behind every number
WITH
(
SELECT max(date)
FROM global_markets.options_greeks
WHERE date >= today() - 10
) AS chain_date
SELECT
toString(toStartOfMonth(expiration_date)) AS expiry_month_start,
formatDateTime(toStartOfMonth(expiration_date), '%b %Y') AS month_label,
countDistinct(underlying_symbol) AS underlyings_listing
FROM global_markets.options_greeks
WHERE date = chain_date
AND expiration_date >= chain_date
AND days_to_expiry <= 430
AND toDayOfWeek(expiration_date) = 5
AND toDayOfMonth(expiration_date) BETWEEN 15 AND 21
AND underlying_symbol NOT IN ('SPCX')
GROUP BY toStartOfMonth(expiration_date)
ORDER BY toStartOfMonth(expiration_date)
More from this analysisOption Expiration Cycles Explained
Monthly expirations beyond 300 days out, by underlyings listing them
ranking 13×2
→
Listed expiration dates, one broad lineup against a thinner chain
ranking 6×4
→
Every expiration listed on the AAPL chain, with contracts on each date
series 25×4
→
SPY contracts traded by strike, July 17 2026 expiry
ranking 22×3
→
See all 3,256 queries →