JNJ dividend raises: declaration date, old rate, new rate, 2016 to 2026

WITH quarterly AS (
    SELECT ex_dividend_date,
           round(max(toFloat64(cash_amount)), 4) AS amount,
           max(declaration_date) AS declared
    FROM global_markets.stocks_dividends
    WHERE ticker = 'JNJ'
      AND 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 ex_dividend_date
),
stepped AS (
    SELECT declared,
           amount,
           ex_dividend_date,
           lagInFrame(amount, 1) OVER (ORDER BY ex_dividend_date ASC
                                       ROWS BETWEEN 1 PRECEDING AND CURRENT ROW) AS prior_amount,
           lagInFrame(ex_dividend_date, 1) OVER (ORDER BY ex_dividend_date ASC
                                       ROWS BETWEEN 1 PRECEDING AND CURRENT ROW) AS prior_ex_date
    FROM quarterly
)
SELECT toYear(declared) AS year,
       formatDateTimeInJodaSyntax(declared, 'MMM d') AS declared_on,
       round(prior_amount, 4) AS old_quarterly_usd,
       round(amount, 4) AS new_quarterly_usd,
       round(100 * (amount / prior_amount - 1), 1) AS raise_pct
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
ORDER BY year