Every expiration listed on the AAPL chain, with contracts on each date

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
(
    SELECT max(date)
    FROM global_markets.options_greeks
    WHERE underlying_symbol = 'AAPL'
      AND date >= today() - 10
) AS chain_date
SELECT
    toString(expiration_date)                     AS expiry_date,
    formatDateTime(expiration_date, '%b %e, %Y')  AS expiration_label,
    toUInt32(max(days_to_expiry))                 AS days_out,
    countDistinct(ticker)                         AS contract_count
FROM global_markets.options_greeks
WHERE underlying_symbol = 'AAPL'
  AND date = chain_date
  AND expiration_date >= chain_date
GROUP BY expiration_date
ORDER BY expiration_date