2,309 answered market questions

WITH yearly AS (
    SELECT toYear(ex_dividend_date) AS year,
           sum(cash_amount) AS annual,
           count() AS payments
    FROM global_markets.stocks_dividends
    WHERE ticker = 'VZ'
      AND distribution_type = 'recurring'
      AND cash_amount > 0
      AND ex_dividend_date >= toDate('2005-01-01')
      AND ex_dividend_date < toDate('2026-01-01')
    GROUP BY year
),
base AS (
    SELECT annual AS first_annual
    FROM yearly
    ORDER BY year ASC
    LIMIT 1
)
SELECT yearly.year AS year,
       round(yearly.annual, 4) AS annual_dividend_usd,
       yearly.payments AS payments,
       round((toFloat64(yearly.annual) / toFloat64(base.first_annual) - 1) * 100, 1) AS pct_above_first_year
FROM yearly
CROSS JOIN base
ORDER BY year