Every dated expiration for the leading screened fund (September 2026)

Run it yourself

This is the exact query behind the result above. Change a ticker, a date or a column and run it against the warehouse — no account, no key. The no-signup tier is smaller than the one this page was computed on; a query that reaches past it comes back saying which plan runs it.

WITH dated AS
(
    SELECT
        underlying_symbol,
        expiration_date,
        sum(volume) AS contracts
    FROM global_markets.options_greeks
    WHERE date BETWEEN '2026-09-01' AND '2026-09-30'
      AND expiration_date BETWEEN '2026-09-01' AND '2026-09-30'
      AND toDayOfWeek(expiration_date) <= 5
      AND volume > 0
      AND underlying_symbol IN ('SPY','QQQ','IWM','DIA','VOO','IVV','VTI','RSP','MDY',
                                'EEM','EFA','FXI','EWZ','EWJ','KWEB','INDA',
                                'GLD','SLV','GDX','USO','UNG',
                                'TLT','IEF','LQD','HYG',
                                'XLF','XLE','XLK','XLV','XLU','XLI','XLP','XLY','XLB','XRT','KRE',
                                'SMH','XBI','ARKK','IBIT','TQQQ','SQQQ','SOXL','VXX','UVXY')
      AND underlying_symbol NOT IN ('SPCX')
    GROUP BY underlying_symbol, expiration_date
),
leader AS
(
    SELECT
        underlying_symbol,
        uniqExact(toDayOfWeek(expiration_date)) AS weekdays_covered,
        sum(contracts)                          AS contracts
    FROM dated
    GROUP BY underlying_symbol
    ORDER BY weekdays_covered DESC, contracts DESC, underlying_symbol
    LIMIT 1
)
SELECT
    toString(expiration_date)                AS expiry_date,
    formatDateTime(expiration_date, '%b %e') AS expiry_label,
    formatDateTime(expiration_date, '%a')    AS weekday,
    any(underlying_symbol)                   AS symbol,
    round(sum(contracts) / 1000, 1)          AS contract_volume_k
FROM dated
WHERE underlying_symbol IN (SELECT underlying_symbol FROM leader)
GROUP BY expiration_date
ORDER BY expiration_date