sector_gap

Name: sector_gap
Creator: Strasmore
Published: 2026-09-18
License: https://www.strasmore.com/terms/

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-18, from upcoming-dividend-payment-dates.

as of 2026-09-18 table 7×5read in context →

sector_gap — 7 rows by 5 columns, computed 2026-09-18 from US exchange, SIP and OPRA data.
sector	median_gap_days	shortest_gap_days	longest_gap_days	payouts_counted
REITs	15	8	35	108
Utilities	21	10	41	96
Tech	14	3	36	96
Banks and financials	21	14	39	94
Consumer staples	24	14	36	93
Healthcare	21	8	42	95
Energy	17	9	57	96

Rows × columns: 7 × 5
Computed: 2026-09-18
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 sector_gap, derived from the stored result.
Column	Type	Range
`sector`	text	7 distinct values
`median_gap_days`	number	14 to 24
`shortest_gap_days`	number	3 to 14
`longest_gap_days`	number	35 to 57
`payouts_counted`	number	93 to 108

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 2026-09-18, and the query below is what returned them.

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)

Run your own version of this

The same 22 years of US equities and 12 years of options data are queryable in SQL or plain English. A free account runs 100 queries a day and takes no card.

More from this analysisupcoming-dividend-payment-dates

pay_calendar table 30×8 → pay_days series 12×4 → gap_buckets ranking 6×4 → The 2s10s spread, every print of the half table 124×2 → The 2s10s spread, every print of the half table 124×2 → Every half-year since 1976: the 2y and 10y change, the twist between them, and the half's lowest 2s10s print table 100×7 → See all 2,358 queries →