AAPL contracts traded into each 2026 expiration date, H1

SELECT
    toString(agg.exp_date)                                                            AS expiration_date,
    concat(formatDateTime(agg.exp_date, '%b '), toString(toDayOfMonth(agg.exp_date))) AS expiry_label,
    multiIf(toDayOfWeek(agg.exp_date) = 5 AND toDayOfMonth(agg.exp_date) BETWEEN 15 AND 21, 'monthly third Friday',
            toDayOfWeek(agg.exp_date) = 5,                                                 'weekly Friday',
            toDayOfWeek(agg.exp_date) = 4 AND toDayOfMonth(agg.exp_date) BETWEEN 14 AND 20, 'Thursday before a third Friday',
                                                                                           'other weekday') AS expiry_class,
    agg.n_contracts                                                                   AS contracts_traded
FROM
(
    SELECT
        toDate(expiration_date) AS exp_date,
        countDistinct(ticker)   AS n_contracts
    FROM global_markets.options_greeks
    WHERE underlying_symbol = 'AAPL'
      AND toDate(expiration_date) >= toDate('2026-01-01')
      AND toDate(expiration_date) <  toDate('2026-07-01')
      AND volume > 0
      AND iv_converged = 1
    GROUP BY exp_date
) AS agg
ORDER BY contracts_traded DESC, agg.exp_date ASC