annual

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.

SELECT
    toString(y)                      AS year,
    dps                              AS dividend_per_share,
    payments                         AS payments_in_year,
    round(100 * (dps / prev - 1), 1) AS yoy_growth_pct
FROM
(
    SELECT
        y,
        dps,
        payments,
        lagInFrame(dps, 1) OVER (ORDER BY y ASC ROWS BETWEEN 1 PRECEDING AND CURRENT ROW) AS prev
    FROM
    (
        SELECT
            toYear(ex_date)                  AS y,
            round(toFloat64(sum(amount)), 4) AS dps,
            count()                          AS payments
        FROM
        (
            SELECT
                ex_dividend_date AS ex_date,
                max(cash_amount) AS amount
            FROM global_markets.stocks_dividends
            WHERE ticker = 'AAPL'
              AND currency = 'USD'
              AND ex_dividend_date >= '2015-01-01'
              AND toYear(ex_dividend_date) < toYear(today())
            GROUP BY ex_dividend_date
        )
        GROUP BY y
    )
)
WHERE prev > 0
ORDER BY y