VZ payment cadence: days between ex-dates, and ex-date to cash

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