STRASMORE/EXPLORE 3,094 QUERIES 22Y EQUITIES · 12Y OPTIONS

3,094 answered market questions

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

Upcoming Dividend Payment Dates: Next 2 Weeks
Median days from ex-date to pay date, fixed baskets of twelve names per sector, trailing two yearstable · 2026-10-04 · 7×5 Securities paying a dividend on each day of the next 14 daysseries · 2026-10-04 · 12×4Preview: a 12-point series, ending higher. Dividends paying in the next 14 days, largest names firsttable · 2026-10-04 · 30×8 Days from ex-dividend date to payment date, all cash dividends in the trailing yearranking · 2026-10-04 · 6×4Preview: 6 ranked values, largest first.
Median days from ex-date to pay date, fixed baskets of twelve names per sector, trailing two years

Median days from ex-date to pay date, fixed baskets of twelve names per sector, trailing two years

most recentas of table 7×5read in context →
Median days from ex-date to pay date, fixed baskets of twelve names per sector, trailing two years — 7 rows by 5 columns, computed from US exchange, SIP and OPRA data.
sectormedian_gap_daysshortest_gap_dayslongest_gap_dayspayouts_counted
REITs15835107
Utilities21104196
Tech1433696
Banks and financials21143994
Consumer staples24143693
Healthcare2284296
Energy1795796
the exact SQL behind every number 
SELECT
    sector,
    quantileExact(0.5)(gap_days)   AS median_gap_days,
    min(gap_days)                  AS shortest_gap_days,
    max(gap_days)                  AS longest_gap_days,
    count()                        AS payouts_counted
FROM
(
    SELECT
        multiIf(
            ticker IN ('O', 'PLD', 'AMT', 'SPG', 'WELL', 'PSA', 'EQIX', 'DLR', 'VICI', 'CCI', 'AVB', 'EQR'),      'REITs',
            ticker IN ('DUK', 'SO', 'NEE', 'D', 'AEP', 'XEL', 'ED', 'EXC', 'SRE', 'PEG', 'WEC', 'ETR'),          'Utilities',
            ticker IN ('AAPL', 'MSFT', 'AVGO', 'CSCO', 'ORCL', 'TXN', 'QCOM', 'IBM', 'ADP', 'ACN', 'ADI', 'INTU'), 'Tech',
            ticker IN ('JPM', 'BAC', 'WFC', 'C', 'GS', 'MS', 'USB', 'PNC', 'TFC', 'BLK', 'AXP', 'SCHW'),          'Banks and financials',
            ticker IN ('KO', 'PEP', 'PG', 'WMT', 'COST', 'MDLZ', 'CL', 'KMB', 'PM', 'MO', 'GIS', 'HSY'),          'Consumer staples',
            ticker IN ('JNJ', 'PFE', 'MRK', 'ABBV', 'ABT', 'LLY', 'AMGN', 'BMY', 'MDT', 'GILD', 'CVS', 'UNH'),    'Healthcare',
            ticker IN ('XOM', 'CVX', 'COP', 'EOG', 'SLB', 'KMI', 'WMB', 'OKE', 'PSX', 'VLO', 'MPC', 'DVN'),       'Energy',
            'other')                                         AS sector,
        dateDiff('day', ex_dividend_date, pay_date)          AS gap_days
    FROM global_markets.stocks_dividends
    WHERE ex_dividend_date >= today() - 730
      AND ex_dividend_date <  today()
      AND pay_date > ex_dividend_date
      AND cash_amount > 0
    GROUP BY ticker, ex_dividend_date, pay_date
)
WHERE sector != 'other'
GROUP BY sector
ORDER BY indexOf(['REITs', 'Utilities', 'Tech', 'Banks and financials', 'Consumer staples', 'Healthcare', 'Energy'], sector)
More from this analysisUpcoming Dividend Payment Dates: Next 2 Weeks
Dividends paying in the next 14 days, largest names first table 30×8 → Securities paying a dividend on each day of the next 14 days series 12×4 → Days from ex-dividend date to payment date, all cash dividends in the trailing year ranking 6×4 → VOO distributions per complete calendar year, with the spread between quarters table 11×6 → See all 3,094 queries →
$