AAPL quarterly dividend by year, split adjusted, with the annual 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 payouts AS
(
    SELECT
        id,
        any(ex_dividend_date)           AS ex_date,
        any(split_adjusted_cash_amount) AS adjusted
    FROM global_markets.stocks_dividends
    WHERE ticker = 'AAPL'
      AND ex_dividend_date >= toDate('2012-01-01')
      AND ex_dividend_date <= today()
    GROUP BY id
),
by_year AS
(
    SELECT
        toYear(ex_date)                    AS y,
        round(toFloat64(max(adjusted)), 4) AS top_rate
    FROM payouts
    GROUP BY y
),
stepped AS
(
    SELECT
        y,
        top_rate,
        any(top_rate) OVER (ORDER BY y ROWS BETWEEN 1 PRECEDING AND 1 PRECEDING) AS prior_rate
    FROM by_year
)
SELECT
    toString(y)                                 AS year,
    top_rate                                    AS quarterly_dividend_adjusted,
    round(100 * (top_rate / prior_rate - 1), 1) AS raise_pct
FROM stepped
WHERE prior_rate > 0
ORDER BY year