Year over year change in dividend per share, Verizon and AT&T

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
paid AS
(
    SELECT
        id,
        any(ticker)                 AS tkr,
        any(ex_dividend_date)       AS ex_date,
        any(toFloat64(cash_amount)) AS amount
    FROM global_markets.stocks_dividends
    WHERE ticker IN ('VZ', 'T')
      AND cash_amount > 0
    GROUP BY id
),
yearly AS
(
    SELECT
        toYear(ex_date)           AS year,
        sumIf(amount, tkr = 'VZ') AS vz,
        sumIf(amount, tkr = 'T')  AS t
    FROM paid
    WHERE toYear(ex_date) BETWEEN toYear(today()) - 11 AND toYear(today()) - 1
    GROUP BY year
    HAVING countIf(tkr = 'VZ') > 0 AND countIf(tkr = 'T') > 0
),
prior AS
(
    SELECT
        year + 1 AS year,
        vz       AS prev_vz,
        t        AS prev_t
    FROM yearly
)
SELECT
    y.year                                 AS year,
    round(100 * (y.vz / p.prev_vz - 1), 2) AS vz_change_pct,
    round(100 * (y.t / p.prev_t - 1), 2)   AS t_change_pct
FROM yearly AS y
INNER JOIN prior AS p ON p.year = y.year
ORDER BY year