Listings, splits, and ex-dividend events by month through the quarter

Name: Listings, splits, and ex-dividend events by month through the quarter
Creator: Strasmore
Published: 2026-07-16
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-07-16, from Market Recap: Q2 2026.

as of 2026-07-16 ranking 3×4read in context →

Listings, splits, and ex-dividend events by month through the quarter — 3 rows by 4 columns, computed 2026-07-16 from US exchange, SIP and OPRA data.
m	ipos	splits	ex_divs
2026-04	30	129	3947
2026-05	40	142	4804
2026-06	35	164	6651

Rows × columns: 3 × 4
Computed: 2026-07-16
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 Listings, splits, and ex-dividend events by month through the quarter, derived from the stored result.
Column	Type	Range
`m`	text	3 distinct values (2026-04, 2026-05, 2026-06)
`ipos`	number	30 to 40
`splits`	number	129 to 164
`ex_divs`	number	3,947 to 6,651

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-07-16, and the query below is what returned them.

the exact SQL behind every number

SELECT m, ipos, splits, ex_divs FROM (
    SELECT '2026-04' AS m,
        (SELECT count() FROM global_markets.stocks_ipos WHERE listing_date >= toDate('2026-04-01') AND listing_date <= toDate('2026-04-30')) AS ipos,
        (SELECT count() FROM global_markets.stocks_splits WHERE execution_date >= toDate('2026-04-01') AND execution_date <= toDate('2026-04-30')) AS splits,
        (SELECT count() FROM global_markets.stocks_dividends WHERE ex_dividend_date >= toDate('2026-04-01') AND ex_dividend_date <= toDate('2026-04-30')) AS ex_divs, 1 AS o
    UNION ALL SELECT '2026-05',
        (SELECT count() FROM global_markets.stocks_ipos WHERE listing_date >= toDate('2026-05-01') AND listing_date <= toDate('2026-05-31')),
        (SELECT count() FROM global_markets.stocks_splits WHERE execution_date >= toDate('2026-05-01') AND execution_date <= toDate('2026-05-31')),
        (SELECT count() FROM global_markets.stocks_dividends WHERE ex_dividend_date >= toDate('2026-05-01') AND ex_dividend_date <= toDate('2026-05-31')), 2
    UNION ALL SELECT '2026-06',
        (SELECT count() FROM global_markets.stocks_ipos WHERE listing_date >= toDate('2026-06-01') AND listing_date <= toDate('2026-06-30')),
        (SELECT count() FROM global_markets.stocks_splits WHERE execution_date >= toDate('2026-06-01') AND execution_date <= toDate('2026-06-30')),
        (SELECT count() FROM global_markets.stocks_dividends WHERE ex_dividend_date >= toDate('2026-06-01') AND ex_dividend_date <= toDate('2026-06-30')), 3
) ORDER BY o

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 analysisMarket Recap: Q2 2026

Q2 regular-hours dollar volume, whole tape (one reused-symbol listing excluded pending entity verification) ranking 8×3 → Q2 month by month: April, May, June (SPY and QQQ, recomputed identically) ranking 6×4 → Q2 2026 returns for the four index ETFs, with Q1 recomputed live for contrast ranking 4×4 → The 2s10s spread and the 10-year through Q2, daily table 63×3 → Every second quarter on the tape: SPY and QQQ, recomputed identically by year (session counts shown) table 40×4 → SPY median quoted spread on one labeled sample session per month of the quarter (second Wednesdays) series 3×4 → See all 2,170 queries →