STRASMORE/EXPLORE 2,170 QUERIES

June 30's corporate calendar and information flow, in one row (the filing-index gap on display)

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: June 30, 2026, The Day in Numbers.

as of scalar 1×12read in context →
ex dividend records
704
splits executed
7
ipos listed
2
sec filings
31
insider form4 filings
0
filings 8k
0
ipo names
AACU — Ares Acquisition Corp III; OSPRU — Osprey Acquisition Corp. III
news articles
211
news publishers
3
most covered ticker
NVDA
most covered articles
21
filings prior session
4,439
Rows × columns
1 × 12
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 June 30's corporate calendar and information flow, in one row (the filing-index gap on display), derived from the stored result.
ColumnTypeRangeNotes
ex_dividend_records number every row is 704
splits_executed number every row is 7
ipos_listed number every row is 2
sec_filings number every row is 31
insider_form4_filings number every row is 0
filings_8k number every row is 0
ipo_names text 1 distinct value
news_articles number every row is 211
news_publishers number every row is 3
most_covered_ticker text 1 distinct value (NVDA)
most_covered_articles number every row is 21
filings_prior_session number every row is 4,439

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 
WITH
    (
        SELECT (count(), uniqExact(publisher))
        FROM global_markets.stocks_news
        WHERE toDate(toTimeZone(published_utc, 'America/New_York')) = '2026-06-30'
    ) 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-06-30'
            )
            WHERE t != 'SPCX'
            GROUP BY t
        )
    ) AS top_news
SELECT
    (SELECT count() FROM global_markets.stocks_dividends WHERE ex_dividend_date = '2026-06-30') AS ex_dividend_records,
    (SELECT count() FROM global_markets.stocks_splits WHERE execution_date = '2026-06-30') AS splits_executed,
    (SELECT count() FROM global_markets.stocks_ipos WHERE listing_date = '2026-06-30') AS ipos_listed,
    (SELECT uniqExact(accession_number) FROM global_markets.stocks_sec_edgar_index WHERE filing_date = '2026-06-30') AS sec_filings,
    (SELECT uniqExactIf(accession_number, form_type = '4') FROM global_markets.stocks_sec_edgar_index WHERE filing_date = '2026-06-30') AS insider_form4_filings,
    (SELECT uniqExactIf(accession_number, form_type = '8-K') FROM global_markets.stocks_sec_edgar_index WHERE filing_date = '2026-06-30') AS filings_8k,
    (SELECT arrayStringConcat(groupArray(concat(ticker, ' — ', issuer_name)), '; ') FROM (
        SELECT ticker, issuer_name FROM global_markets.stocks_ipos WHERE listing_date = '2026-06-30' 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 uniqExact(accession_number) FROM global_markets.stocks_sec_edgar_index WHERE filing_date = toDate('2026-06-29')) AS filings_prior_session

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: June 30, 2026, The Day in Numbers
Session check: SPY's observed minute-bar span scalar 1×5 → One row for the whole options day: volume, same-day expiry, SPY's put/call skew by moneyness, the holiday-shifted week scalar 1×20 → SPY's open-to-close move ranked against the trailing month of sessions (rank 1 = biggest absolute move) scalar 1×4 → Advancers vs decliners among tickers with at least $1M traded on June 30 scalar 1×9 → Shares traded per 30-minute bucket, regular hours (billions) series 13×3 → Volume leaders two ways: top 6 by dollars traded, top 4 by shares traded (one reused-symbol listing excluded pending entity verification) table 10×6 → See all 2,170 queries →