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 per_ex AS
(
    SELECT
        ex_dividend_date            AS ex_date,
        max(toFloat64(cash_amount)) AS amount,
        max(declaration_date)       AS declared_on
    FROM global_markets.stocks_dividends
    WHERE ticker = 'HON'
      AND ex_dividend_date >= '2010-01-01'
    GROUP BY ex_date
),
stepped AS
(
    SELECT
        ex_date,
        declared_on,
        amount,
        any(amount) OVER (ORDER BY ex_date ROWS BETWEEN 1 PRECEDING AND 1 PRECEDING) AS prior_amount
    FROM per_ex
)
SELECT
    formatDateTime(ex_date, '%b %Y')            AS effective_from,
    formatDateTime(declared_on, '%b %Y')        AS announced,
    round(prior_amount, 4)                      AS prior_rate,
    round(amount, 4)                            AS new_rate,
    round(100 * (amount / prior_amount - 1), 1) AS increase_pct
FROM stepped
WHERE prior_amount > 0
  AND amount > prior_amount
ORDER BY ex_date