Verizon and AT&T side by side: yield, ten year growth, payout

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
        id,
        any(ticker)                 AS tkr,
        any(ex_dividend_date)       AS ex_date,
        any(toFloat64(cash_amount)) AS amount
    FROM global_markets.stocks_dividends
    WHERE ticker IN ('VZ', 'T')
      AND cash_amount > 0
    GROUP BY id
),
ttm AS
(
    SELECT
        tkr,
        sum(amount) AS ttm_dps
    FROM paid
    WHERE ex_date > today() - 365
      AND ex_date <= today()
    GROUP BY tkr
),
base AS
(
    SELECT
        tkr,
        sum(amount) AS dps_10y_ago
    FROM paid
    WHERE ex_date > today() - 4015
      AND ex_date <= today() - 3650
    GROUP BY tkr
),
val AS
(
    SELECT
        ticker,
        argMax(toFloat64(price), date)              AS px,
        argMax(toFloat64(earnings_per_share), date) AS eps,
        max(date)                                   AS as_of_date
    FROM global_markets.stocks_ratios
    WHERE ticker IN ('VZ', 'T')
      AND date >= today() - 45
      AND price > 0
    GROUP BY ticker
)
SELECT
    v.ticker                                                  AS ticker,
    round(v.px, 2)                                            AS price,
    round(tt.ttm_dps, 4)                                      AS ttm_dps,
    round(100 * tt.ttm_dps / v.px, 2)                         AS trailing_yield_pct,
    round(b.dps_10y_ago, 4)                                   AS dps_10y_ago,
    round(100 * (pow(tt.ttm_dps / b.dps_10y_ago, 0.1) - 1), 2) AS dps_cagr_10y_pct,
    round(100 * tt.ttm_dps / v.eps, 1)                        AS eps_payout_pct,
    formatDateTime(v.as_of_date, '%b %e, %Y')                 AS as_of
FROM val AS v
INNER JOIN ttm AS tt ON tt.tkr = v.ticker
INNER JOIN base AS b ON b.tkr = v.ticker
ORDER BY ticker DESC