STRASMORE/EXPLORE 2,170 QUERIES 22Y EQUITIES · 12Y OPTIONS

2,170 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-08-26 · 14×3Preview: 14 ranked values, largest first. Monthly expirations beyond 300 days out, by underlyings listing themranking · 2026-08-26 · 14×2Preview: 14 ranked values, largest first. Listed expiration dates, one broad lineup against a thinner chainranking · 2026-08-26 · 6×4Preview: 6 ranked values, largest first. Every expiration listed on the AAPL chain, with contracts on each dateseries · 2026-08-26 · 23×4Preview: a 16-point series, ending lower.
Who Sets the Ex-Dividend Date? Not the Board
One-time distributions by size: where the ex-date landsranking · 2026-08-22 · 4×4Preview: 4 ranked values, largest first. Regular dividends: ex-date before the record date, or on itseries · 2026-08-22 · 43×5Preview: a 16-point series, ending higher. Board declaration to ex-date to payment, eight household payersranking · 2026-08-22 · 8×4Preview: 8 ranked values, largest first. Ex-date alignment by payout cadence, since T+1 took effectranking · 2026-08-22 · 6×4Preview: 6 ranked values, largest first.
When Did the US Stock Market Start? 1792
Trading sessions by day of the week, calendar year 2019series · 2026-08-08 · 7×3Preview: a 7-point series, roughly flat. Where SPY volume lands inside the day, 30 minute buckets, October 2024series · 2026-08-08 · 32×3Preview: a 16-point series, roughly flat. The single busiest clock minute of the month, October 2024ranking · 2026-08-08 · 5×3Preview: 5 ranked values, largest first. Weekdays with no US equity session, 2014 through 2023ranking · 2026-08-08 · 10×2Preview: 10 ranked values, smallest first.
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 14×3read in context →
Third Friday expirations over the next fourteen months, by underlyings listing them — 14 rows by 3 columns, computed from US exchange, SIP and OPRA data.
expiry_month_startmonth_labelunderlyings_listing
2026-08-01Aug 20263735
2026-09-01Sep 20263689
2026-10-01Oct 20261564
2026-11-01Nov 20261392
2026-12-01Dec 20261960
2027-01-01Jan 20272245
2027-02-01Feb 2027913
2027-03-01Mar 20271462
2027-04-01Apr 202750
2027-05-01May 202772
2027-07-01Jul 202726
2027-08-01Aug 202742
2027-09-01Sep 2027318
2027-10-01Oct 202711
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 14×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 23×4 → SPY contracts traded by strike, July 17 2026 expiry ranking 22×3 → See all 2,170 queries →
$