STRASMORE/EXPLORE 2,707 QUERIES 22Y EQUITIES · 12Y OPTIONS

2,707 answered market questions

every one with its exact SQL, its result and the date it was computed · free, no signup

Substitute Payments and Your 1099
One quarterly dividend on 1,000 shares, at a qualified rate versus an ordinary ratetable · 2026-09-27 · 8×6 Calendar days from ex-dividend date to payable date, most recent dividendranking · 2026-09-27 · 8×4Preview: 8 ranked values, largest first. Days to cover at each short interest settlement, AAPL against KOtable · 2026-09-27 · 36×3 Share of reported volume marked short, trailing four monthsranking · 2026-09-27 · 8×3Preview: 8 ranked values, largest first.
One quarterly dividend on 1,000 shares, at a qualified rate versus an ordinary rate

One quarterly dividend on 1,000 shares, at a qualified rate versus an ordinary rate

most recentas of table 8×6read in context →
One quarterly dividend on 1,000 shares, at a qualified rate versus an ordinary rate — 8 rows by 6 columns, computed from US exchange, SIP and OPRA data.
tickerex_dividend_ongross_paymentafter_tax_qualifiedafter_tax_ordinarygap_dollars
CVXAug 19, 2026178015131352.8160.2
JNJAug 25, 2026134011391018.4120.6
PGJul 24, 20261088.5925.22827.2697.96
XOMAug 17, 20261030875.5782.892.7
MSFTAug 20, 2026910773.5691.681.9
VZJul 10, 2026707.5601.38537.763.68
KOSep 15, 2026530450.5402.847.7
AAPLAug 10, 2026270229.5205.224.3
the exact SQL behind every number 
SELECT
    ticker,
    formatDateTime(max(ex_dividend_date), '%b %e, %Y')                    AS ex_dividend_on,
    round(1000 * toFloat64(argMax(cash_amount, ex_dividend_date)), 2)     AS gross_payment,
    round(1000 * toFloat64(argMax(cash_amount, ex_dividend_date)) * 0.85, 2) AS after_tax_qualified,
    round(1000 * toFloat64(argMax(cash_amount, ex_dividend_date)) * 0.76, 2) AS after_tax_ordinary,
    round(1000 * toFloat64(argMax(cash_amount, ex_dividend_date)) * 0.09, 2) AS gap_dollars
FROM global_markets.stocks_dividends
WHERE ticker IN ('AAPL', 'MSFT', 'KO', 'JNJ', 'XOM', 'CVX', 'VZ', 'PG')
  AND ex_dividend_date >= today() - 200
  AND ex_dividend_date <= today()
  AND cash_amount > 0
GROUP BY ticker
ORDER BY gross_payment DESC
More from this analysisSubstitute Payments and Your 1099
Days to cover at each short interest settlement, AAPL against KO table 36×3 → Calendar days from ex-dividend date to payable date, most recent dividend ranking 8×4 → Share of reported volume marked short, trailing four months ranking 8×3 → The most recent regular dividend for eleven household names table 11×5 → See all 2,707 queries →
$