aapl_chain

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.

Rows × columns

12 × 5

Period covered

2026-08-26 to 2026-12-18

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

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.

SELECT
    toString(expiration_date)                                   AS expiry_date,
    concat(formatDateTime(expiration_date, '%a %b '),
           toString(toDayOfMonth(expiration_date)))              AS expiry_label,
    if(toDayOfWeek(expiration_date) = 5
       AND toDayOfMonth(expiration_date) BETWEEN 15 AND 21,
       'monthly (third Friday)', 'weekly')                      AS series_type,
    min(days_to_expiry)                                         AS dte,
    uniqExact(ticker)                                           AS contracts_traded
FROM global_markets.options_greeks
WHERE underlying_symbol = 'AAPL'
  AND date = toDate('2026-08-24')
  AND days_to_expiry <= 130
  AND volume > 0
GROUP BY expiration_date
ORDER BY expiration_date