STRASMORE/EXPLORE 2,549 QUERIES

t_levels

Answered against 22 years of US equities and 12 years of US options data and published with the query that produced it. This result is stored as of 2026-09-24, from vz-vs-t-dividend.

as of table 8×5read in context →
t_levels — 8 rows by 5 columns, computed from US exchange, SIP and OPRA data.
level_startlevel_start_labelquarterly_dpsquarters_paidlatest_ex_label
2014-01-08Jan 20140.464Oct 2014
2015-01-07Jan 20150.474Oct 2015
2016-01-06Jan 20160.484Oct 2016
2017-01-06Jan 20170.494Oct 2017
2018-01-09Jan 20180.54Oct 2018
2019-01-09Jan 20190.514Oct 2019
2020-01-09Jan 20200.529Jan 2022
2022-04-13Apr 20220.277518Jul 2026
Rows × columns
8 × 5
Period covered
to
Computed
Completeness
No missing values
Source
US exchange, SIP and OPRA market data
Licence
Strasmore terms · free, no signup
Formats
JSON · CSV · the SQL below

What each column holds

Column definitions for t_levels, derived from the stored result.
ColumnTypeRangeNotes
level_start date 2014-01-08 to 2022-04-13
level_start_label text 8 distinct values (Apr 2022, Jan 2014, Jan 2015…)
quarterly_dps number 0.2775 to 0.52
quarters_paid number 4 to 18
latest_ex_label text 8 distinct values (Jan 2022, Jul 2026, Oct 2014…)

Computed from Strasmore's warehouse of US exchange, SIP and OPRA market data. Equity prices are delayed; options greeks and implied volatility are end-of-day. This result is stored, not recomputed on load — it is exactly the numbers that were returned on , and the query below is what returned them.

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(ex_dividend_date)       AS ex_date,
        any(toFloat64(cash_amount)) AS amount
    FROM global_markets.stocks_dividends
    WHERE ticker = 'T'
      AND cash_amount > 0
      AND ex_dividend_date >= toDate('2014-01-01')
    GROUP BY id
)
SELECT
    toString(min(ex_date))                AS level_start,
    formatDateTime(min(ex_date), '%b %Y') AS level_start_label,
    round(amount, 4)                      AS quarterly_dps,
    count()                               AS quarters_paid,
    formatDateTime(max(ex_date), '%b %Y') AS latest_ex_label
FROM paid
GROUP BY amount
ORDER BY min(ex_date)
⌘/Ctrl + Enter

Work with this data in your AI assistant

Opens ready to query, with this page's data. Free, no account.

More from this analysisvz-vs-t-dividend
compare table 2×8 → dps_growth ranking 10×3 → annual_dps ranking 10×3 → fcf_payout ranking 7×3 → dividend_calendar series 5×8 → The 2s10s spread, every print of the half table 124×2 → See all 2,549 queries →