VZ monthly close and trailing twelve month dividend yield

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
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