Every expiration listed on the AAPL chain, with contracts on each date
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-08-26, from Option Expiration Cycles Explained.
| expiry_date | expiration_label | days_out | contract_count |
|---|---|---|---|
| 2026-08-21 | Aug 21, 2026 | 2 | 105 |
| 2026-08-24 | Aug 24, 2026 | 5 | 58 |
| 2026-08-26 | Aug 26, 2026 | 7 | 48 |
| 2026-08-28 | Aug 28, 2026 | 9 | 79 |
| 2026-08-31 | Aug 31, 2026 | 12 | 50 |
| 2026-09-02 | Sep 2, 2026 | 14 | 49 |
| 2026-09-04 | Sep 4, 2026 | 16 | 76 |
| 2026-09-11 | Sep 11, 2026 | 23 | 54 |
| 2026-09-18 | Sep 18, 2026 | 30 | 87 |
| 2026-09-25 | Sep 25, 2026 | 37 | 55 |
| 2026-10-02 | Oct 2, 2026 | 44 | 53 |
| 2026-10-16 | Oct 16, 2026 | 58 | 87 |
| 2026-11-20 | Nov 20, 2026 | 93 | 88 |
| 2026-12-18 | Dec 18, 2026 | 121 | 83 |
| 2027-01-15 | Jan 15, 2027 | 149 | 98 |
| 2027-02-19 | Feb 19, 2027 | 184 | 45 |
| 2027-03-19 | Mar 19, 2027 | 212 | 56 |
| 2027-06-17 | Jun 17, 2027 | 302 | 63 |
| 2027-09-17 | Sep 17, 2027 | 394 | 71 |
| 2027-12-17 | Dec 17, 2027 | 485 | 74 |
| 2028-01-21 | Jan 21, 2028 | 520 | 58 |
| 2028-03-17 | Mar 17, 2028 | 576 | 37 |
| 2028-12-15 | Dec 15, 2028 | 849 | 70 |
- Rows × columns
- 23 × 4
- Period covered
- to
- Computed
- Completeness
- No missing values
- Source
- US exchange, SIP and OPRA market data
- Licence
- Strasmore terms · free, no signup
What each column holds
| Column | Type | Range | Notes |
|---|---|---|---|
expiry_date |
date | 2026-08-21 to 2028-12-15 | |
expiration_label |
text | 23 distinct values (Aug 21, 2026, Aug 24, 2026, Aug 26, 2026…) | |
days_out |
number | 2 to 849 | |
contract_count |
number | 37 to 105 | count |
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.
the exact SQL behind every number
WITH
(
SELECT max(date)
FROM global_markets.options_greeks
WHERE underlying_symbol = 'AAPL'
AND date >= today() - 10
) AS chain_date
SELECT
toString(expiration_date) AS expiry_date,
formatDateTime(expiration_date, '%b %e, %Y') AS expiration_label,
toUInt32(max(days_to_expiry)) AS days_out,
countDistinct(ticker) AS contract_count
FROM global_markets.options_greeks
WHERE underlying_symbol = 'AAPL'
AND date = chain_date
AND expiration_date >= chain_date
GROUP BY expiration_date
ORDER BY expiration_date
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.
More from this analysisOption Expiration Cycles Explained
Third Friday expirations over the next fourteen months, by underlyings listing them
ranking 14×3
→
Monthly expirations beyond 300 days out, by underlyings listing them
ranking 14×2
→
Listed expiration dates, one broad lineup against a thinner chain
ranking 6×4
→
One SPY $600 LEAPS call's price over two years (expired Jan 16 2026)
series 470×2
→
AAPL contracts traded into each 2026 expiration date, H1
series 68×4
→
Weekly average rho: SPY January 2027 calls against a rolling front-month series
series 52×3
→
See all 2,170 queries →