PG dividends per share by calendar year, and the year-over-year 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 per_year AS
(
    SELECT
        toYear(ex_dividend_date) AS yr,
        round(sum(amt), 4)       AS dividends_per_share,
        count()                  AS payments
    FROM
    (
        SELECT
            ex_dividend_date,
            max(toFloat64(cash_amount)) AS amt
        FROM global_markets.stocks_dividends
        WHERE ticker = 'PG'
          AND ex_dividend_date >= '2012-01-01'
          AND ex_dividend_date <  '2026-01-01'
        GROUP BY ex_dividend_date
    )
    GROUP BY yr
)
SELECT
    toString(yr) AS year,
    dividends_per_share,
    payments,
    round(if(prev > 0, 100 * (dividends_per_share / prev - 1), 0), 2) AS yoy_change_pct
FROM
(
    SELECT
        yr,
        dividends_per_share,
        payments,
        lagInFrame(dividends_per_share, 1, 0.) OVER (ORDER BY yr ASC
            ROWS BETWEEN 1 PRECEDING AND CURRENT ROW) AS prev
    FROM per_year
)
ORDER BY yr