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

2,433 answered market questions

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

Which Stocks Have Weekly Options? How to Tell
Optionable underlyings by expiration pattern, trailing five weeksranking · 2026-09-20 · 4×2Preview: 4 ranked values, largest first. Top 25 weekly-options underlyings by distinct contracts traded, with expiration weekdaysranking · 2026-09-20 · 25×4Preview: 16 ranked values, largest first. Underlyings with a traded expiration on each weekday, trailing five weeksranking · 2026-09-20 · 6×2Preview: 6 ranked values, smallest first. AAPL expirations within 130 days, as of Monday Aug 24, 2026series · 2026-09-20 · 12×5Preview: a 12-point series, ending higher.
Optionable underlyings by expiration pattern, trailing five weeks

Optionable underlyings by expiration pattern, trailing five weeks

most recentas of ranking 4×2read in context →
Optionable underlyings by expiration pattern, trailing five weeks — 4 rows by 2 columns, computed from US exchange, SIP and OPRA data.
bucketunderlyings
A. All underlyings with a traded contract5471
B. Third Friday only (monthly)4784
C. Weekly or quarterly, not every weekday681
D. Weekly, every weekday Mon to Fri6
the exact SQL behind every number 
SELECT
    bucket,
    count()                                                          AS underlyings
FROM
(
    SELECT
        underlying_symbol,
        arrayJoin([
            'A. All underlyings with a traded contract',
            multiIf(non_monthly_dates = 0, 'B. Third Friday only (monthly)',
                    weekdays_used >= 5,    'D. Weekly, every weekday Mon to Fri',
                                           'C. Weekly or quarterly, not every weekday')
        ])                                                           AS bucket
    FROM
    (
        SELECT
            underlying_symbol,
            uniqExactIf(expiration_date,
                NOT (toDayOfWeek(expiration_date) = 5
                     AND toDayOfMonth(expiration_date) BETWEEN 15 AND 21)) AS non_monthly_dates,
            uniqExact(toDayOfWeek(expiration_date))                        AS weekdays_used
        FROM global_markets.options_greeks
        WHERE date >= today() - 35
          AND date < today()
          AND expiration_date < today() + 60
          AND toDayOfWeek(expiration_date) <= 5
          AND volume > 0
          AND underlying_symbol NOT IN ('SPCX')
        GROUP BY underlying_symbol
    )
)
GROUP BY bucket
ORDER BY bucket
More from this analysisWhich Stocks Have Weekly Options? How to Tell
Top 25 weekly-options underlyings by distinct contracts traded, with expiration weekdays ranking 25×4 → Underlyings with a traded expiration on each weekday, trailing five weeks ranking 6×2 → AAPL expirations within 130 days, as of Monday Aug 24, 2026 series 12×5 → SPY contracts traded by strike, July 17 2026 expiry ranking 22×3 → See all 2,433 queries →
$