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.
Poor Man's Covered Call: How the Trade Works
Dividend cash paid on 100 shares over the trailing yearranking · 2026-08-22 · 6×3Preview: 6 ranked values, largest first.
What Is Option Rho? The Interest Rate Greek
Weekly average rho: SPY January 2027 calls against a rolling front-month seriesseries · 2026-08-07 · 52×3Preview: a 16-point series, ending higher. Average SPY option rho by time to expiration, indexed to the front monthranking · 2026-08-07 · 6×4Preview: 6 ranked values, smallest first. Average rho on long-dated SPY options, by strike against the share priceranking · 2026-08-07 · 7×4Preview: 7 ranked values, largest first. Start-to-end change in Treasury yields by calendar year, in basis pointsranking · 2026-08-07 · 13×3Preview: 13 ranked values, smallest first.
What Are LEAPS? Long-Dated Options
SPY, the call's delta, and its implied volatility at four life stagesseries · 2026-07-16 · 4×4Preview: a 4-point series, ending higher. One SPY $600 LEAPS call's price over two years (expired Jan 16 2026)series · 2026-07-16 · 470×2Preview: a 16-point series, ending higher. Theta (daily decay) against days to expiry, across the call's lifeseries · 2026-07-16 · 4×3Preview: a 4-point series, ending lower.
Deep ITM LEAPS: Stock Replacement
One deep-ITM LEAPS vs 100 shares: cost, leverage, and deltaseries · 2026-07-16 · 3×7Preview: a 3-point series, ending higher. SPY vs the LEAPS call, both indexed to 100 in early June 2025series · 2026-07-16 · 33×3Preview: a 16-point series, ending higher. The LEAPS call's delta climbing toward 1 as it goes deep in the moneyseries · 2026-07-16 · 33×2Preview: a 16-point series, ending higher. Time value as a share of premium, and daily theta, month by monthseries · 2026-07-16 · 8×3Preview: a 8-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 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 →
$