rate_changes

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 pay AS
(
    SELECT
        ex_dividend_date                                    AS ex_date,
        ifNull(any(declaration_date), toDate('1970-01-01'))  AS declared,
        toFloat64(any(cash_amount))                          AS amt
    FROM global_markets.stocks_dividends
    WHERE ticker = 'ACN'
      AND cash_amount > 0
      AND ex_dividend_date >= toDate('2013-01-01')
      AND ex_dividend_date <= today()
    GROUP BY ex_dividend_date
),
stepped AS
(
    SELECT
        cur.ex_date                     AS ex_date,
        cur.declared                    AS declared,
        cur.amt                         AS amt,
        argMax(prev.amt, prev.ex_date)  AS prev_amt
    FROM pay AS cur
    CROSS JOIN pay AS prev
    WHERE prev.ex_date < cur.ex_date
    GROUP BY ex_date, declared, amt
)
SELECT
    formatDateTime(ex_date, '%b %Y')     AS rate_from,
    if(declared > toDate('2000-01-01'),
       arrayElement(['January', 'February', 'March', 'April', 'May', 'June',
                     'July', 'August', 'September', 'October', 'November', 'December'],
                    toMonth(declared)),
       'not reported')                   AS declared_in,
    round(prev_amt, 2)                   AS old_rate_usd,
    round(amt, 2)                        AS new_rate_usd,
    round(100 * (amt / prev_amt - 1), 1) AS raise_pct
FROM stepped
WHERE amt > prev_amt
ORDER BY raise_pct DESC, ex_date DESC