Every PG quarterly rate increase since 2017, and the size of each step

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.

WITH rates AS
(
    SELECT
        ex_dividend_date,
        max(toFloat64(cash_amount)) AS rate
    FROM global_markets.stocks_dividends
    WHERE ticker = 'PG'
      AND ex_dividend_date >= '2017-01-01'
    GROUP BY ex_dividend_date
),
stepped AS
(
    SELECT
        ex_dividend_date,
        rate,
        lagInFrame(rate, 1, 0.) OVER (ORDER BY ex_dividend_date ASC
            ROWS BETWEEN 1 PRECEDING AND CURRENT ROW) AS prev_rate
    FROM rates
),
raises AS
(
    SELECT
        ex_dividend_date,
        formatDateTime(ex_dividend_date, '%b %Y') AS raise_label,
        round(prev_rate, 4)                       AS prior_quarterly_rate,
        round(rate, 4)                            AS new_quarterly_rate,
        round(100 * (rate / prev_rate - 1), 2)    AS raise_pct
    FROM stepped
    WHERE prev_rate > 0
      AND rate > prev_rate * 1.005
)
SELECT
    toString(ex_dividend_date) AS ex_dividend_date,
    raise_label,
    prior_quarterly_rate,
    new_quarterly_rate,
    raise_pct,
    round(if(isNaN(trailing_avg), 0, trailing_avg), 2) AS prior_five_avg_pct
FROM
(
    SELECT
        ex_dividend_date,
        raise_label,
        prior_quarterly_rate,
        new_quarterly_rate,
        raise_pct,
        avg(raise_pct) OVER (ORDER BY ex_dividend_date ASC
            ROWS BETWEEN 5 PRECEDING AND 1 PRECEDING) AS trailing_avg
    FROM raises
)
ORDER BY ex_dividend_date