raise_history

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
    payments AS
    (
        SELECT
            toYear(ex_dividend_date) AS div_year,
            ex_dividend_date AS ex_date,
            any(declaration_date) AS declared_date,
            max(toFloat64(cash_amount)) AS amount
        FROM global_markets.stocks_dividends
        WHERE ticker = 'JNJ'
          AND frequency = 4
          AND ex_dividend_date >= '2004-01-01'
          AND ex_dividend_date <  '2027-01-01'
        GROUP BY ex_dividend_date
    ),
    yearly AS
    (
        SELECT
            div_year,
            div_year - 1 AS prior_year,
            round(max(amount), 4) AS quarterly_rate
        FROM payments
        GROUP BY div_year
    ),
    step_up AS
    (
        SELECT
            p.div_year AS div_year,
            arrayElement(['January', 'February', 'March', 'April', 'May', 'June', 'July', 'August', 'September', 'October', 'November', 'December'], toMonth(min(p.declared_date))) AS declared,
            arrayElement(['January', 'February', 'March', 'April', 'May', 'June', 'July', 'August', 'September', 'October', 'November', 'December'], toMonth(min(p.ex_date))) AS goes_ex
        FROM payments AS p
        INNER JOIN yearly AS y ON y.div_year = p.div_year
        WHERE round(p.amount, 4) = y.quarterly_rate
        GROUP BY p.div_year
    )
SELECT
    toString(cur.div_year) AS year,
    cur.quarterly_rate AS quarterly_dividend,
    round((cur.quarterly_rate - prv.quarterly_rate) * 100, 1) AS raise_cents,
    round((cur.quarterly_rate / prv.quarterly_rate - 1) * 100, 2) AS raise_pct,
    s.declared AS declared,
    s.goes_ex AS goes_ex
FROM yearly AS cur
INNER JOIN yearly AS prv ON prv.div_year = cur.prior_year
LEFT JOIN step_up AS s ON s.div_year = cur.div_year
WHERE cur.div_year >= 2006
ORDER BY cur.div_year