2,170 answered market questions

WITH
(
    SELECT max(date)
    FROM global_markets.options_greeks
    WHERE date >= today() - 10
) AS chain_date
SELECT
    toString(toStartOfMonth(expiration_date))                AS expiry_month_start,
    formatDateTime(toStartOfMonth(expiration_date), '%b %Y') AS month_label,
    countDistinct(underlying_symbol)                         AS underlyings_listing
FROM global_markets.options_greeks
WHERE date = chain_date
  AND expiration_date >= chain_date
  AND days_to_expiry <= 430
  AND toDayOfWeek(expiration_date) = 5
  AND toDayOfMonth(expiration_date) BETWEEN 15 AND 21
  AND underlying_symbol NOT IN ('SPCX')
GROUP BY toStartOfMonth(expiration_date)
ORDER BY toStartOfMonth(expiration_date)