STRASMORE/EXPLORE 2,433 QUERIES

The most recent regular dividend for eleven household names

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-20, from Payment in Lieu of Dividends, Explained.

as of table 11×5read in context →
The most recent regular dividend for eleven household names — 11 rows by 5 columns, computed from US exchange, SIP and OPRA data.
tickercash_per_shareex_date_labelrecord_date_labelpay_date_label
CVX1.78Aug 19, 2026Aug 19, 2026Sep 10, 2026
IBM1.69Aug 10, 2026Aug 10, 2026Sep 10, 2026
PEP1.48Sep 4, 2026Sep 4, 2026Sep 30, 2026
JNJ1.34Aug 25, 2026Aug 25, 2026Sep 8, 2026
PG1.0885Jul 24, 2026Jul 24, 2026Aug 17, 2026
XOM1.03Aug 17, 2026Aug 17, 2026Sep 10, 2026
MSFT0.91Aug 20, 2026Aug 20, 2026Sep 10, 2026
MRK0.85Sep 15, 2026Sep 15, 2026Oct 7, 2026
KO0.53Sep 15, 2026Sep 15, 2026Oct 1, 2026
PFE0.43Jul 24, 2026Jul 24, 2026Sep 1, 2026
AAPL0.27Aug 10, 2026Aug 10, 2026Aug 13, 2026
Rows × columns
11 × 5
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 The most recent regular dividend for eleven household names, derived from the stored result.
ColumnTypeRangeNotes
ticker text 11 distinct values (AAPL, CVX, IBM…)
cash_per_share number 0.27 to 1.78
ex_date_label text 8 distinct values (Aug 10, 2026, Aug 17, 2026, Aug 19, 2026…)
record_date_label text 8 distinct values (Aug 10, 2026, Aug 17, 2026, Aug 19, 2026…)
pay_date_label text 8 distinct values (Aug 13, 2026, Aug 17, 2026, Oct 1, 2026…)

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.

SELECT
    ticker,
    round(toFloat64(argMax(cash_amount, ex_dividend_date)), 4)          AS cash_per_share,
    formatDateTime(max(ex_dividend_date), '%b %e, %Y')                  AS ex_date_label,
    formatDateTime(argMax(record_date, ex_dividend_date), '%b %e, %Y')  AS record_date_label,
    formatDateTime(argMax(pay_date, ex_dividend_date), '%b %e, %Y')     AS pay_date_label
FROM global_markets.stocks_dividends
WHERE ticker IN ('AAPL', 'MSFT', 'JNJ', 'PG', 'KO', 'PEP', 'XOM', 'CVX', 'MRK', 'IBM', 'PFE')
  AND ex_dividend_date <= today()
  AND ex_dividend_date >= today() - 200
GROUP BY ticker
ORDER BY cash_per_share DESC
⌘/Ctrl + Enter
More from this analysisPayment in Lieu of Dividends, Explained
PFE short interest by settlement date, Aug 2025 through Jul 2026 series 24×3 → Ex-dividend events per month across the whole US calendar series 12×4 → Reported short interest across the same dividend payers ranking 11×3 → Share of reported KO volume marked short, by session series 67×3 → Days to cover for two large dividend payers, by settlement date series 47×4 → Days to cover: household names against the most in-demand liquid borrows ranking 10×2 → See all 2,433 queries →