July 2's corporate calendar and information flow, in one row (including the eight splits behind one fake screener move)

Name: July 2's corporate calendar and information flow, in one row (including the eight splits behind one fake screener move)
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: July 2, 2026, The Day in Numbers.

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

ex dividend records

322

splits executed

forward splits

reverse splits

split records

CRWD 4-for-1; FBIP 4-for-1; FNCSF 110-for-100; GMEX 1-for-9; GTCDF 1-for-5; SMTOY 8-for-1; UBYH 1-for-10; VLNT 10-for-1

ipos listed

sec filings

5,203

insider form4 filings

2,109

filings 8k

258

ipo names

MIACU — Meridian3 Industrials Acquisition Corp.; VIIU — Viking Acquisition Corp. II

news articles

201

news publishers

most covered ticker

NVDA

most covered articles

crwd split from

crwd split to

crwd prev close

772.45

crwd day close

193.67

crwd dollar m

1,473.51

split names with bars

Rows × columns: 1 × 20
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 July 2's corporate calendar and information flow, in one row (including the eight splits behind one fake screener move), derived from the stored result.
Column	Type	Range	Notes
`ex_dividend_records`	number	every row is 322
`splits_executed`	number	every row is 8
`forward_splits`	number	every row is 5
`reverse_splits`	number	every row is 3
`split_records`	text	1 distinct value
`ipos_listed`	number	every row is 2
`sec_filings`	number	every row is 5,203
`insider_form4_filings`	number	every row is 2,109
`filings_8k`	number	every row is 258
`ipo_names`	text	1 distinct value
`news_articles`	number	every row is 201
`news_publishers`	number	every row is 3
`most_covered_ticker`	text	1 distinct value (NVDA)
`most_covered_articles`	number	every row is 18
`crwd_split_from`	number	every row is 1
`crwd_split_to`	number	every row is 4
`crwd_prev_close`	number	every row is 772.45	US dollars
`crwd_day_close`	number	every row is 193.67	US dollars
`crwd_dollar_m`	number	every row is 1,473.51
`split_names_with_bars`	number	every row is 2

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

WITH
    (
        SELECT (count(), uniqExact(publisher))
        FROM global_markets.stocks_news
        WHERE toDate(toTimeZone(published_utc, 'America/New_York')) = '2026-07-02'
    ) AS news,
    (
        SELECT (argMax(t, n), max(n))
        FROM (
            SELECT t, count() AS n
            FROM (
                SELECT arrayJoin(tickers) AS t
                FROM global_markets.stocks_news
                WHERE toDate(toTimeZone(published_utc, 'America/New_York')) = '2026-07-02'
            )
            WHERE t != 'SPCX'
            GROUP BY t
        )
    ) AS top_news,
    (
        SELECT (count(), countIf(split_to > split_from), countIf(split_to < split_from),
                arrayStringConcat(groupArray(concat(ticker, ' ', toString(split_to), '-for-', toString(split_from))), '; '))
        FROM global_markets.stocks_splits
        WHERE execution_date = '2026-07-02' AND ticker NOT IN ('SPCX')
    ) AS splits
SELECT
    (SELECT count() FROM global_markets.stocks_dividends WHERE ex_dividend_date = '2026-07-02') AS ex_dividend_records,
    splits.1 AS splits_executed,
    splits.2 AS forward_splits,
    splits.3 AS reverse_splits,
    splits.4 AS split_records,
    (SELECT count() FROM global_markets.stocks_ipos WHERE listing_date = '2026-07-02') AS ipos_listed,
    (SELECT uniqExact(accession_number) FROM global_markets.stocks_sec_edgar_index WHERE filing_date = '2026-07-02') AS sec_filings,
    (SELECT uniqExactIf(accession_number, form_type = '4') FROM global_markets.stocks_sec_edgar_index WHERE filing_date = '2026-07-02') AS insider_form4_filings,
    (SELECT uniqExactIf(accession_number, form_type = '8-K') FROM global_markets.stocks_sec_edgar_index WHERE filing_date = '2026-07-02') AS filings_8k,
    (SELECT arrayStringConcat(groupArray(concat(ticker, ' — ', issuer_name)), '; ') FROM (
        SELECT ticker, issuer_name FROM global_markets.stocks_ipos WHERE listing_date = '2026-07-02' ORDER BY ticker
    )) AS ipo_names,
    news.1 AS news_articles,
    news.2 AS news_publishers,
    top_news.1 AS most_covered_ticker,
    top_news.2 AS most_covered_articles,
    (SELECT any(split_from) FROM global_markets.stocks_splits WHERE ticker = 'CRWD' AND execution_date = '2026-07-02') AS crwd_split_from,
    (SELECT any(split_to) FROM global_markets.stocks_splits WHERE ticker = 'CRWD' AND execution_date = '2026-07-02') AS crwd_split_to,
    (SELECT round(toFloat64(argMax(close, window_start)), 2) FROM global_markets.delayed_stocks_minute_aggs
     WHERE ticker = 'CRWD' AND window_start >= '2026-07-01 13:30:00' AND window_start < '2026-07-01 20:00:00') AS crwd_prev_close,
    (SELECT round(toFloat64(argMax(close, window_start)), 2) FROM global_markets.delayed_stocks_minute_aggs
     WHERE ticker = 'CRWD' AND window_start >= '2026-07-02 13:30:00' AND window_start < '2026-07-02 20:00:00') AS crwd_day_close,
    (SELECT round(sum(toFloat64(close) * toFloat64(volume)) / 1e6, 2) FROM global_markets.delayed_stocks_minute_aggs
     WHERE ticker = 'CRWD' AND window_start >= '2026-07-02 13:30:00' AND window_start < '2026-07-02 20:00:00') AS crwd_dollar_m,
    (SELECT count() FROM (
        SELECT ticker FROM global_markets.delayed_stocks_minute_aggs
        WHERE ticker IN (SELECT ticker FROM global_markets.stocks_splits WHERE execution_date = '2026-07-02')
          AND window_start >= '2026-07-02 13:30:00' AND window_start < '2026-07-02 20:00:00'
        GROUP BY ticker
    )) AS split_names_with_bars

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: July 2, 2026, The Day in Numbers

Session check: SPY's observed minute-bar span, and the July 3 closure on the tape scalar 1×6 → One row for the whole options day: volume, same-day expiry, the holiday-shifted week, and the July monthly scalar 1×19 → After the holiday: the next session, its ex-dividends and splits, the next scheduled closure, and the short-interest lag scalar 1×9 → The receipt: the July 2 treasury print is on file scalar 1×2 → SPY and QQQ ranked against the trailing month of sessions (rank 1 = biggest absolute move) scalar 1×7 → Was liquidity unusual? SPY's regular-hours median spread vs the trailing month of sessions scalar 1×6 → See all 2,170 queries →