Every change in Verizon's quarterly rate since 2015

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
        ex_dividend_date AS ex_date,
        max(toFloat64(cash_amount)) AS rate,
        max(declaration_date) AS declared
    FROM global_markets.stocks_dividends
    WHERE ticker = 'VZ'
      AND ex_dividend_date >= '2015-01-01'
      AND ex_dividend_date <  '2027-01-01'
      AND cash_amount > 0
    GROUP BY ex_dividend_date
),
steps AS
(
    SELECT
        rate,
        min(ex_date) AS first_ex,
        min(declared) AS first_declared
    FROM paid
    GROUP BY rate
)
SELECT
    toString(first_ex) AS step_date,
    concat(monthName(first_declared), ' ', toString(toDayOfMonth(first_declared)), ', ', toString(toYear(first_declared))) AS declared_date,
    round(rate, 4) AS rate_usd,
    round(prior, 4) AS prior_rate_usd,
    round(100 * (rate - prior) / prior, 2) AS increase_pct
FROM
(
    SELECT
        rate,
        first_ex,
        first_declared,
        lagInFrame(rate) OVER (ORDER BY first_ex ASC ROWS BETWEEN 1 PRECEDING AND CURRENT ROW) AS prior
    FROM steps
)
WHERE prior > 0
ORDER BY first_ex