cat_annual_raises

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 yearly AS
(
    SELECT
        toYear(ex_dividend_date) AS y,
        count()                  AS payments,
        round(sum(amount), 2)    AS paid
    FROM
    (
        SELECT
            ex_dividend_date,
            max(toFloat64(cash_amount)) AS amount
        FROM global_markets.stocks_dividends
        WHERE ticker = 'CAT'
          AND ex_dividend_date >= '2006-01-01'
          AND ex_dividend_date <  '2026-01-01'
        GROUP BY ex_dividend_date
    )
    GROUP BY y
),
stepped AS
(
    SELECT
        y,
        paid,
        payments,
        lagInFrame(paid) OVER (ORDER BY y ASC ROWS BETWEEN 1 PRECEDING AND CURRENT ROW) AS prior_paid
    FROM yearly
)
SELECT
    toString(y)                                                    AS year,
    paid                                                           AS paid_per_share_usd,
    payments                                                       AS payment_count,
    if(prior_paid > 0, round(100 * (paid / prior_paid - 1), 1), 0) AS growth_vs_prior_pct,
    sum(if(prior_paid > 0 AND paid < prior_paid, 1, 0))
        OVER (ORDER BY y ASC ROWS BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW) AS prior_year_declines_count
FROM stepped
WHERE y >= 2007
ORDER BY y ASC