STRASMORE/EXPLORE 2,170 QUERIES

The week's corporate calendar: filings, dividends, splits, news

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 July 6, 2026.

as of scalar 1×10read in context →
filings week
18,353
filings friday
3,137
monday minus next busiest
1,288
monday over friday form4
3.6
min daily 424b2
487
max daily 424b2
679
ex dividends week
560
reverse splits week
30
forward splits week
9
news week
981
Rows × columns
1 × 10
Computed
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: filings, dividends, splits, news, derived from the stored result.
ColumnTypeRangeNotes
filings_week number every row is 18,353
filings_friday number every row is 3,137
monday_minus_next_busiest number every row is 1,288
monday_over_friday_form4 number every row is 3.6
min_daily_424b2 number every row is 487
max_daily_424b2 number every row is 679
ex_dividends_week number every row is 560
reverse_splits_week number every row is 30
forward_splits_week number every row is 9
news_week number every row is 981

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

the exact SQL behind every number 
SELECT
    (SELECT count() FROM global_markets.stocks_sec_edgar_index WHERE filing_date >= '2026-07-06' AND filing_date <= '2026-07-10') AS filings_week,
    (SELECT count() FROM global_markets.stocks_sec_edgar_index WHERE filing_date = '2026-07-10') AS filings_friday,
    toInt64((SELECT count() FROM global_markets.stocks_sec_edgar_index WHERE filing_date = '2026-07-06'))
        - toInt64((SELECT max(c) FROM (SELECT count() AS c FROM global_markets.stocks_sec_edgar_index WHERE filing_date > '2026-07-06' AND filing_date <= '2026-07-10' GROUP BY filing_date))) AS monday_minus_next_busiest,
    (SELECT round(countIf(form_type = '4' AND filing_date = '2026-07-06') / countIf(form_type = '4' AND filing_date = '2026-07-10'), 1) FROM global_markets.stocks_sec_edgar_index WHERE filing_date >= '2026-07-06' AND filing_date <= '2026-07-10') AS monday_over_friday_form4,
    (SELECT min(c) FROM (SELECT count() AS c FROM global_markets.stocks_sec_edgar_index WHERE filing_date >= '2026-07-06' AND filing_date <= '2026-07-10' AND form_type = '424B2' GROUP BY filing_date)) AS min_daily_424b2,
    (SELECT max(c) FROM (SELECT count() AS c FROM global_markets.stocks_sec_edgar_index WHERE filing_date >= '2026-07-06' AND filing_date <= '2026-07-10' AND form_type = '424B2' GROUP BY filing_date)) AS max_daily_424b2,
    (SELECT count() FROM global_markets.stocks_dividends WHERE ex_dividend_date >= '2026-07-06' AND ex_dividend_date <= '2026-07-10') AS ex_dividends_week,
    (SELECT countIf(toFloat64(split_from) > toFloat64(split_to)) FROM global_markets.stocks_splits WHERE execution_date >= '2026-07-06' AND execution_date <= '2026-07-10') AS reverse_splits_week,
    (SELECT countIf(toFloat64(split_to) > toFloat64(split_from)) FROM global_markets.stocks_splits WHERE execution_date >= '2026-07-06' AND execution_date <= '2026-07-10') AS forward_splits_week,
    (SELECT count() FROM global_markets.stocks_news WHERE toDate(toTimeZone(published_utc, 'America/New_York')) >= '2026-07-06'
        AND toDate(toTimeZone(published_utc, 'America/New_York')) <= '2026-07-10') AS news_week

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 July 6, 2026
Next week on the calendar: closures, ex-dividends, and the monthly expiry's pull scalar 1×4 → SK Hynix's US debut: the raise, the delayed open, the close vs offer, and where the first-day tape ranks in 2026 scalar 1×14 → Session verification: five sessions, no holiday, next scheduled closure scalar 1×6 → SPY's week in trailing-year context (open-to-close weekly returns, ~53 weeks) scalar 1×5 → Treasury curve: the Friday July 10 print vs the July 2 close, both late receipts on file scalar 1×6 → Weekly breadth: July 10 close vs July 2 close, names with $5M+ traded during the week scalar 1×4 → See all 2,170 queries →