The week's corporate calendar: with the June 30 filing-index gap on display

Name: The week's corporate calendar: with the June 30 filing-index gap on display
Creator: Strasmore
Published: 2026-07-26
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-26, from Market Recap: Week of June 29, 2026.

as of 2026-07-26 scalar 1×8read in context →

ex div events

2,221

splits

ipos

filings jun29

4,439

filings jun30

filings jul1

4,283

filings jul2

5,203

news articles

778

Rows × columns: 1 × 8
Computed: 2026-07-26
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 week's corporate calendar: with the June 30 filing-index gap on display, derived from the stored result.
Column	Type	Range
`ex_div_events`	number	every row is 2,221
`splits`	number	every row is 47
`ipos`	number	every row is 7
`filings_jun29`	number	every row is 4,439
`filings_jun30`	number	every row is 31
`filings_jul1`	number	every row is 4,283
`filings_jul2`	number	every row is 5,203
`news_articles`	number	every row is 778

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

the exact SQL behind every number

SELECT
    (SELECT count() FROM global_markets.stocks_dividends WHERE ex_dividend_date >= toDate('2026-06-29') AND ex_dividend_date <= toDate('2026-07-02')) AS ex_div_events,
    (SELECT count() FROM global_markets.stocks_splits WHERE execution_date >= toDate('2026-06-29') AND execution_date <= toDate('2026-07-02')) AS splits,
    (SELECT count() FROM global_markets.stocks_ipos WHERE listing_date >= toDate('2026-06-29') AND listing_date <= toDate('2026-07-02')) AS ipos,
    (SELECT uniqExact(accession_number) FROM global_markets.stocks_sec_edgar_index WHERE filing_date = toDate('2026-06-29')) AS filings_jun29,
    (SELECT uniqExact(accession_number) FROM global_markets.stocks_sec_edgar_index WHERE filing_date = toDate('2026-06-30')) AS filings_jun30,
    (SELECT uniqExact(accession_number) FROM global_markets.stocks_sec_edgar_index WHERE filing_date = toDate('2026-07-01')) AS filings_jul1,
    (SELECT uniqExact(accession_number) FROM global_markets.stocks_sec_edgar_index WHERE filing_date = toDate('2026-07-02')) AS filings_jul2,
    (SELECT count() FROM global_markets.stocks_news WHERE published_utc >= toDateTime('2026-06-29 00:00:00') AND published_utc < toDateTime('2026-07-03 00:00:00')) AS news_articles

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: Week of June 29, 2026

The session receipt: four traded days, one Friday closure, verified from the tape scalar 1×3 → This week against the trailing year of weeks: SPY, open-to-close within each week (rank 1 = best; short weeks excluded) scalar 1×5 → Advancers and decliners on the week, with the liquidity filter disclosed scalar 1×5 → Regular-hours dollar volume, week of June 29 (one reused-symbol listing excluded pending entity verification) ranking 8×3 → Contracts traded during the week, by expiry date (single-pass scan; batch-generated) ranking 6×3 → Treasury yields through the week (July 2 print not yet ingested at generation) ranking 5×4 → See all 2,170 queries →