weekly_leaders

Name: weekly_leaders
Creator: Strasmore
Published: 2026-09-11
License: https://www.strasmore.com/terms/

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-09-11, from which-stocks-have-weekly-options.

as of 2026-09-11 ranking 25×4read in context →

weekly_leaders — 25 rows by 4 columns, computed 2026-09-11 from US exchange, SIP and OPRA data.
symbol	contracts_thousands	non_monthly_expirations	expiry_weekdays
SPY	10	36	Mon Tue Wed Thu Fri
QQQ	9.5	36	Mon Tue Wed Thu Fri
MU	7.4	20	Mon Wed Fri
GLD	6.1	32	Mon Tue Wed Thu Fri
SNDK	5.5	8	Fri
AMD	5.2	21	Mon Wed Fri
META	4.9	21	Mon Wed Fri
SMH	4.6	31	Mon Tue Wed Thu Fri
IWM	4.1	35	Mon Tue Wed Thu Fri
TSLA	4.1	21	Mon Wed Fri
SOXL	3.9	18	Mon Wed Fri
ASML	3.2	8	Fri
SLV	3.2	22	Mon Wed Fri
MSFT	3.1	21	Mon Wed Fri
AVGO	3	21	Mon Wed Fri
LITE	2.9	8	Fri
STX	2.9	8	Fri
INTC	2.8	21	Mon Wed Fri
GOOGL	2.7	21	Mon Wed Fri
USO	2.6	15	Wed Fri
DELL	2.5	8	Fri
GS	2.5	8	Fri
NVDA	2.5	20	Mon Wed Fri
LLY	2.4	8	Fri
AAPL	2.3	21	Mon Wed Fri

Rows × columns: 25 × 4
Computed: 2026-09-11
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 weekly_leaders, derived from the stored result.
Column	Type	Range	Notes
`symbol`	text	25 distinct values (AAPL, AMD, ASML…)
`contracts_thousands`	number	2.3 to 10	count
`non_monthly_expirations`	number	8 to 36
`expiry_weekdays`	text	4 distinct values (Fri, Mon Tue Wed Thu Fri, Mon Wed Fri…)

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 2026-09-11, and the query below is what returned them.

the exact SQL behind every number

SELECT
    underlying_symbol                                           AS symbol,
    round(uniqExact(ticker) / 1000, 1)                          AS contracts_thousands,
    uniqExactIf(expiration_date,
        NOT (toDayOfWeek(expiration_date) = 5
             AND toDayOfMonth(expiration_date) BETWEEN 15 AND 21)) AS non_monthly_expirations,
    arrayStringConcat(
        arrayMap(d -> arrayElement(['Mon', 'Tue', 'Wed', 'Thu', 'Fri'], d),
                 arraySort(groupUniqArray(toDayOfWeek(expiration_date)))),
        ' ')                                                    AS expiry_weekdays
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
HAVING non_monthly_expirations > 0
ORDER BY contracts_thousands DESC, symbol
LIMIT 25

Run your own version of this

The same 22 years of US equities and 12 years of options data are queryable in SQL or plain English. A free account runs 100 queries a day and takes no card.

More from this analysiswhich-stocks-have-weekly-options

by_weekday ranking 6×2 → weekly_share ranking 4×2 → aapl_chain series 12×5 → Annualized volatility vs total return, 25 large caps, calmest to wildest (~2 years) ranking 25×3 → SPY options median spread by expiration date, near-the-money strikes only ranking 25×4 → When market headlines publish, by New York clock hour ranking 24×2 → See all 2,191 queries →