Dividend raises by declaration month: US recurring quarterly payers, July 2015 to July 2026

WITH quarterly AS (
    SELECT ticker,
           ex_dividend_date,
           round(max(toFloat64(cash_amount)), 4) AS amount,
           max(declaration_date) AS declared
    FROM global_markets.stocks_dividends
    WHERE distribution_type = 'recurring'
      AND frequency = 4
      AND cash_amount > 0
      AND declaration_date > toDate('2015-06-30')
      AND ex_dividend_date >= toDate('2015-07-01')
      AND ex_dividend_date <= toDate('2026-07-31')
    GROUP BY ticker, ex_dividend_date
),
stepped AS (
    SELECT ticker,
           declared,
           amount,
           ex_dividend_date,
           lagInFrame(amount, 1) OVER (PARTITION BY ticker ORDER BY ex_dividend_date ASC
                                       ROWS BETWEEN 1 PRECEDING AND CURRENT ROW) AS prior_amount,
           lagInFrame(ex_dividend_date, 1) OVER (PARTITION BY ticker ORDER BY ex_dividend_date ASC
                                       ROWS BETWEEN 1 PRECEDING AND CURRENT ROW) AS prior_ex_date
    FROM quarterly
)
SELECT formatDateTimeInJodaSyntax(declared, 'MMM') AS month_label,
       count() AS raises,
       uniqExact(ticker) AS companies
FROM stepped
WHERE prior_amount > 0
  AND amount > prior_amount * 1.005
  AND dateDiff('day', prior_ex_date, ex_dividend_date) BETWEEN 45 AND 200
GROUP BY month_label
ORDER BY raises DESC