VZ 2026年股息日期、派息与收益率

SELECT
    toString(ex_dividend_date) AS ex_date,
    concat(monthName(ex_dividend_date), ' ', toString(toDayOfMonth(ex_dividend_date)), ', ', toString(toYear(ex_dividend_date))) AS ex_date_label,
    concat(monthName(max(declaration_date)), ' ', toString(toDayOfMonth(max(declaration_date))), ', ', toString(toYear(max(declaration_date)))) AS declared_date,
    concat(monthName(max(record_date)), ' ', toString(toDayOfMonth(max(record_date))), ', ', toString(toYear(max(record_date)))) AS record_date,
    concat(monthName(max(pay_date)), ' ', toString(toDayOfMonth(max(pay_date))), ', ', toString(toYear(max(pay_date)))) AS pay_date,
    round(max(toFloat64(cash_amount)), 4) AS rate_usd,
    if(ex_dividend_date > today(), 'upcoming', 'passed') AS status
FROM global_markets.stocks_dividends
WHERE ticker = 'VZ'
  AND ex_dividend_date >= '2026-01-01'
  AND ex_dividend_date <  '2027-01-01'
  AND cash_amount > 0
GROUP BY ex_dividend_date
ORDER BY ex_dividend_date

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

WITH
months AS
(
    SELECT
        toStartOfMonth(date) AS month_start,
        argMax(toFloat64(close), date) AS px,
        max(date) AS last_session
    FROM global_markets.stocks_daily_aggs
    WHERE ticker = 'VZ'
      AND date >= '2024-10-01'
    GROUP BY month_start
),
paid AS
(
    SELECT
        ex_dividend_date AS ex_date,
        max(toFloat64(cash_amount)) AS amt
    FROM global_markets.stocks_dividends
    WHERE ticker = 'VZ'
      AND ex_dividend_date >= '2023-09-01'
      AND cash_amount > 0
    GROUP BY ex_dividend_date
)
SELECT
    toString(m.month_start) AS month,
    concat(monthName(any(m.last_session)), ' ', toString(toDayOfMonth(any(m.last_session))), ', ', toString(toYear(any(m.last_session)))) AS close_taken_date,
    round(any(m.px), 2) AS close_usd,
    round(100 * sum(p.amt) / any(m.px), 2) AS trailing_yield_pct
FROM months AS m
CROSS JOIN paid AS p
WHERE p.ex_date >  addYears(m.last_session, -1)
  AND p.ex_date <= m.last_session
GROUP BY m.month_start
ORDER BY m.month_start

WITH paid AS
(
    SELECT
        ex_dividend_date AS ex_date,
        max(pay_date) AS pay_on
    FROM global_markets.stocks_dividends
    WHERE ticker = 'VZ'
      AND ex_dividend_date >= '2020-01-01'
      AND ex_dividend_date <  '2027-01-01'
      AND cash_amount > 0
    GROUP BY ex_dividend_date
)
SELECT
    toString(ex_date) AS ex_on,
    concat(monthName(ex_date), ' ', toString(toDayOfMonth(ex_date)), ', ', toString(toYear(ex_date))) AS ex_date_label,
    concat(monthName(pay_on), ' ', toString(toDayOfMonth(pay_on)), ', ', toString(toYear(pay_on))) AS pay_date,
    dateDiff('day', prev_ex, ex_date) AS days_since_prior_ex,
    dateDiff('day', ex_date, pay_on) AS days_ex_to_pay
FROM
(
    SELECT
        ex_date,
        pay_on,
        lagInFrame(ex_date) OVER (ORDER BY ex_date ASC ROWS BETWEEN 1 PRECEDING AND CURRENT ROW) AS prev_ex
    FROM paid
)
WHERE prev_ex >= '2020-01-01'
ORDER BY ex_date