STRASMORE/EXPLORE 2,170 QUERIES

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.

as of series 23×4read in context →
Every expiration listed on the AAPL chain, with contracts on each date — 23 rows by 4 columns, computed from US exchange, SIP and OPRA data.
expiry_dateexpiration_labeldays_outcontract_count
2026-08-21Aug 21, 20262105
2026-08-24Aug 24, 2026558
2026-08-26Aug 26, 2026748
2026-08-28Aug 28, 2026979
2026-08-31Aug 31, 20261250
2026-09-02Sep 2, 20261449
2026-09-04Sep 4, 20261676
2026-09-11Sep 11, 20262354
2026-09-18Sep 18, 20263087
2026-09-25Sep 25, 20263755
2026-10-02Oct 2, 20264453
2026-10-16Oct 16, 20265887
2026-11-20Nov 20, 20269388
2026-12-18Dec 18, 202612183
2027-01-15Jan 15, 202714998
2027-02-19Feb 19, 202718445
2027-03-19Mar 19, 202721256
2027-06-17Jun 17, 202730263
2027-09-17Sep 17, 202739471
2027-12-17Dec 17, 202748574
2028-01-21Jan 21, 202852058
2028-03-17Mar 17, 202857637
2028-12-15Dec 15, 202884970
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
Formats
JSON · CSV · the SQL below

What each column holds

Column definitions for Every expiration listed on the AAPL chain, with contracts on each date, derived from the stored result.
ColumnTypeRangeNotes
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 →