2,309 answered market questions

WITH yearly AS (
    SELECT toYear(ex_dividend_date) AS year,
           max(cash_amount) AS top_amount,
           argMax(ex_dividend_date, cash_amount) AS ex_date,
           argMax(declaration_date, cash_amount) AS declared_date
    FROM global_markets.stocks_dividends
    WHERE ticker = 'VZ'
      AND distribution_type = 'recurring'
      AND cash_amount > 0
      AND ex_dividend_date >= toDate('2012-01-01')
      AND ex_dividend_date < toDate('2026-01-01')
    GROUP BY year
),
prior AS (
    SELECT year + 1 AS year,
           top_amount AS prior_top
    FROM yearly
)
SELECT year,
       formatDateTime(yearly.declared_date, '%b %e') AS declared_label,
       formatDateTime(yearly.ex_date, '%b %e') AS ex_date_label,
       round(yearly.top_amount, 4) AS new_quarterly_usd,
       round((yearly.top_amount - prior.prior_top) * 100, 2) AS raise_cents
FROM yearly
INNER JOIN prior USING (year)
WHERE yearly.top_amount > prior.prior_top
  AND yearly.declared_date > toDate('2005-01-01')
ORDER BY year