3,293 answered market questions

WITH quarterly AS
(
    SELECT
        ex_dividend_date            AS ex_date,
        toFloat64(max(cash_amount)) AS rate
    FROM global_markets.stocks_dividends
    WHERE ticker = 'XOM'
      AND frequency = 4
      AND ex_dividend_date >= '2005-01-01'
      AND ex_dividend_date <= today()
    GROUP BY ex_dividend_date
),
stepped AS
(
    SELECT
        ex_date,
        rate,
        lagInFrame(rate) OVER (ORDER BY ex_date ASC
            ROWS BETWEEN 1 PRECEDING AND 1 PRECEDING) AS prev_rate
    FROM quarterly
)
SELECT
    toYear(ex_date)                                     AS year,
    round(sum(rate), 4)                                 AS paid_per_share_usd,
    count()                                             AS payments,
    countIf(prev_rate > 0 AND rate > prev_rate)         AS raises_declared
FROM stepped
WHERE toYear(ex_date) >= 2006
  AND toYear(ex_date) < toYear(today())
GROUP BY year
ORDER BY year ASC