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 per_year AS
(
    SELECT
        toYear(ex_dividend_date)              AS yr,
        round(toFloat64(max(cash_amount)), 4) AS top_rate
    FROM global_markets.stocks_dividends
    WHERE ticker = 'JNJ'
      AND ex_dividend_date >= '2004-01-01'
      AND ex_dividend_date <  '2027-01-01'
    GROUP BY yr
),
stepped AS
(
    SELECT
        yr,
        top_rate,
        lagInFrame(top_rate) OVER (ORDER BY yr ASC ROWS BETWEEN 1 PRECEDING AND CURRENT ROW) AS prior_rate
    FROM per_year
),
streaked AS
(
    SELECT
        yr,
        top_rate,
        prior_rate,
        max(if(prior_rate > 0 AND top_rate > prior_rate, 0, yr))
            OVER (ORDER BY yr ASC ROWS BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW) AS last_flat_year
    FROM stepped
)
SELECT
    year,
    rate_increase_pct,
    consecutive_raise_years
FROM
(
    SELECT
        yr,
        toString(yr)                                                       AS year,
        round(if(prior_rate > 0, (top_rate / prior_rate - 1) * 100, 0), 2) AS rate_increase_pct,
        toUInt16(yr - last_flat_year)                                      AS consecutive_raise_years
    FROM streaked
)
WHERE yr >= 2016
ORDER BY yr