STRASMORE/EXPLORE 3,256 QUERIES 22Y EQUITIES · 12Y OPTIONS

3,256 answered market questions

every one with its exact SQL, its result and the date it was computed · free, no signup

Option Expiration Cycles Explained
Third Friday expirations over the next fourteen months, by underlyings listing themranking · 2026-10-04 · 13×3Preview: 13 ranked values, largest first. Monthly expirations beyond 300 days out, by underlyings listing themranking · 2026-10-04 · 13×2Preview: 13 ranked values, largest first. Listed expiration dates, one broad lineup against a thinner chainranking · 2026-10-04 · 6×4Preview: 6 ranked values, largest first. Every expiration listed on the AAPL chain, with contracts on each dateseries · 2026-10-04 · 25×4Preview: a 16-point series, ending lower.
Third Friday expirations over the next fourteen months, by underlyings listing them

Third Friday expirations over the next fourteen months, by underlyings listing them

most recentas of ranking 13×3read in context →
Third Friday expirations over the next fourteen months, by underlyings listing them — 13 rows by 3 columns, computed from US exchange, SIP and OPRA data.
expiry_month_startmonth_labelunderlyings_listing
2026-10-01Oct 20263566
2026-11-01Nov 20263270
2026-12-01Dec 20261951
2027-01-01Jan 20272141
2027-02-01Feb 2027892
2027-03-01Mar 20271576
2027-04-01Apr 20271038
2027-05-01May 2027744
2027-07-01Jul 202729
2027-08-01Aug 202743
2027-09-01Sep 2027430
2027-10-01Oct 202713
2027-11-01Nov 202738
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 →
$