Every 121-day window around a Coca-Cola ex-dividend 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.

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