Verizon 배당금 인상 이력과 배당왕이 아닌 이유

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

WITH yearly AS (
    SELECT ticker,
           toYear(ex_dividend_date) AS year,
           max(cash_amount) AS top_amount
    FROM global_markets.stocks_dividends
    WHERE ticker IN ('VZ', 'KO', 'JNJ', 'PG', 'MCD', 'MMM')
      AND distribution_type = 'recurring'
      AND cash_amount > 0
      AND ex_dividend_date >= toDate('2001-01-01')
      AND ex_dividend_date < toDate('2026-01-01')
    GROUP BY ticker, year
),
prior AS (
    SELECT ticker,
           year + 1 AS year,
           top_amount AS prior_top
    FROM yearly
),
flagged AS (
    SELECT yearly.ticker AS ticker,
           year,
           yearly.top_amount > prior.prior_top AS raised
    FROM yearly
    INNER JOIN prior USING (ticker, year)
)
SELECT ticker,
       max(year) - greatest(maxIf(year, raised = 0), min(year) - 1) AS consecutive_increase_years,
       toString(min(year)) AS first_year_compared,
       toString(max(year)) AS last_year_compared
FROM flagged
GROUP BY ticker
ORDER BY consecutive_increase_years ASC, ticker ASC

WITH yearly AS (
    SELECT toYear(ex_dividend_date) AS year,
           sum(cash_amount) AS annual
    FROM global_markets.stocks_dividends
    WHERE ticker = 'VZ'
      AND distribution_type = 'recurring'
      AND cash_amount > 0
      AND ex_dividend_date >= toDate('2009-01-01')
      AND ex_dividend_date < toDate('2026-01-01')
    GROUP BY year
),
prior AS (
    SELECT year + 1 AS year,
           annual AS prior_annual
    FROM yearly
)
SELECT year,
       round((yearly.annual - prior.prior_annual) * 100, 2) AS increase_cents,
       round((toFloat64(yearly.annual) / toFloat64(prior.prior_annual) - 1) * 100, 2) AS growth_pct
FROM yearly
INNER JOIN prior USING (year)
WHERE year >= 2010
ORDER BY year

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