2,170 answered market questions

SELECT
    toString(x.ex_date)                       AS ex_date,
    formatDateTime(x.ex_date, '%b %e, %Y')    AS ex_date_label,
    formatDateTime(x.ex_date - 60, '%b %e')   AS window_opens,
    formatDateTime(x.ex_date + 60, '%b %e')   AS window_closes,
    121                                       AS calendar_days_in_window,
    countDistinct(s.date)                     AS trading_sessions_in_window
FROM
(
    SELECT DISTINCT ex_dividend_date AS ex_date
    FROM global_markets.stocks_dividends
    WHERE ticker = 'KO'
      AND cash_amount > 0
      AND ex_dividend_date >= '2023-01-01'
      AND ex_dividend_date <= today() - 61
) AS x
CROSS JOIN
(
    SELECT date
    FROM global_markets.stocks_daily_aggs
    WHERE ticker = 'SPY'
      AND date >= '2022-10-01'
      AND date <= today()
) AS s
WHERE s.date >= x.ex_date - 60
  AND s.date <= x.ex_date + 60
GROUP BY x.ex_date
ORDER BY x.ex_date