STRASMORE/EXPLORE 3,256 QUERIES

expiry_ladder

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-10-09, from anatomy-of-an-option-contract.

as of series 14×4read in context →
expiry_ladder — 14 rows by 4 columns, computed from US exchange, SIP and OPRA data.
expiry_dateexpiry_labeldays_to_expirystrike_count
2026-10-09Oct 9, 2026171
2026-10-12Oct 12, 2026450
2026-10-14Oct 14, 2026633
2026-10-16Oct 16, 2026859
2026-10-19Oct 19, 20261138
2026-10-21Oct 21, 20261335
2026-10-23Oct 23, 20261560
2026-10-30Oct 30, 20262236
2026-11-06Nov 6, 20262942
2026-11-13Nov 13, 20263634
2026-11-20Nov 20, 20264359
2026-11-27Nov 27, 20265024
2026-12-18Dec 18, 20267162
2027-01-15Jan 15, 20279968
Rows × columns
14 × 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 expiry_ladder, derived from the stored result.
ColumnTypeRangeNotes
expiry_date date 2026-10-09 to 2027-01-15
expiry_label text 14 distinct values (Dec 18, 2026, Jan 15, 2027, Nov 13, 2026…)
days_to_expiry number 1 to 99
strike_count number 24 to 71 US dollars

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
    toString(expiration_date)                                AS expiry_date,
    formatDateTime(toDate(expiration_date), '%b %e, %Y')     AS expiry_label,
    min(days_to_expiry)                                      AS days_to_expiry,
    countDistinct(strike_price)                              AS strike_count
FROM global_markets.options_greeks
WHERE underlying_symbol = 'AAPL'
  AND date =
  (
      SELECT max(date)
      FROM global_markets.options_greeks
      WHERE underlying_symbol = 'AAPL'
  )
GROUP BY expiration_date
ORDER BY expiration_date
LIMIT 14
⌘/Ctrl + Enter

Work with this data in your AI assistant

Opens ready to query, with this page's data. Free, no account.

Claude ChatGPT Gemini Muse Your own agent