STRASMORE/EXPLORE 2,170 QUERIES

July 7's corporate calendar and information flow, in one row

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

as of scalar 1×15read in context →
ex dividend records
80
splits executed
7
reverse splits
5
forward splits
2
ipos listed
1
sec filings
2,438
insider form4 filings
463
filings 8k
173
news articles
215
news publishers
3
most covered ticker
NVDA
most covered is nvda
1
most covered articles
17
most covered lead over next
4
crnx articles
0
Rows × columns
1 × 15
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 July 7's corporate calendar and information flow, in one row, derived from the stored result.
ColumnTypeRangeNotes
ex_dividend_records number every row is 80
splits_executed number every row is 7
reverse_splits number every row is 5
forward_splits number every row is 2
ipos_listed number every row is 1
sec_filings number every row is 2,438
insider_form4_filings number every row is 463
filings_8k number every row is 173
news_articles number every row is 215
news_publishers number every row is 3
most_covered_ticker text 1 distinct value (NVDA)
most_covered_is_nvda number every row is 1
most_covered_articles number every row is 17
most_covered_lead_over_next number every row is 4
crnx_articles number every row is 0

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-07-07'
    ) AS news,
    (
        SELECT (argMax(t, n), max(n), max(n) - arraySort(x -> -x, groupArray(n))[2])
        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-07'
            )
            WHERE t != 'SPCX'
            GROUP BY t
        )
    ) AS top_news
SELECT
    (SELECT count() FROM global_markets.stocks_dividends WHERE ex_dividend_date = '2026-07-07') AS ex_dividend_records,
    (SELECT count() FROM global_markets.stocks_splits WHERE execution_date = '2026-07-07') AS splits_executed,
    (SELECT countIf(toFloat64(split_from) > toFloat64(split_to)) FROM global_markets.stocks_splits WHERE execution_date = '2026-07-07') AS reverse_splits,
    (SELECT countIf(toFloat64(split_to) > toFloat64(split_from)) FROM global_markets.stocks_splits WHERE execution_date = '2026-07-07') AS forward_splits,
    (SELECT count() FROM global_markets.stocks_ipos WHERE listing_date = '2026-07-07') AS ipos_listed,
    (SELECT uniqExact(accession_number) FROM global_markets.stocks_sec_edgar_index WHERE filing_date = '2026-07-07') AS sec_filings,
    (SELECT uniqExactIf(accession_number, form_type = '4') FROM global_markets.stocks_sec_edgar_index WHERE filing_date = '2026-07-07') AS insider_form4_filings,
    (SELECT uniqExactIf(accession_number, form_type = '8-K') FROM global_markets.stocks_sec_edgar_index WHERE filing_date = '2026-07-07') AS filings_8k,
    news.1 AS news_articles,
    news.2 AS news_publishers,
    top_news.1 AS most_covered_ticker,
    if(top_news.1 = 'NVDA', 1, 0) AS most_covered_is_nvda,
    top_news.2 AS most_covered_articles,
    top_news.3 AS most_covered_lead_over_next,
    (SELECT countIf(has(tickers, 'CRNX')) FROM global_markets.stocks_news
     WHERE toDate(toTimeZone(published_utc, 'America/New_York')) = '2026-07-07') AS crnx_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: July 7, 2026, The Day in Numbers
SPY's option quotes on July 7: the whole root, and the near-the-money same-day touch through the air pocket against a midday control scalar 1×13 → Session check: SPY's observed minute-bar span, the holiday table, and the next closure on the calendar scalar 1×8 → One row for the whole options day: volume, call share, 0DTE, and the two contracts that bracketed SPY's close scalar 1×24 → QQQ and SPY: July 7 ranked against the trailing month of sessions (rank 1 = biggest absolute move) scalar 1×7 → SPY's update-weighted average quoted spread: July 7 ranked against the trailing month (rank 1 = tightest) scalar 1×7 → The whole equity NBBO stream: July 7 vs July 6 update counts scalar 1×5 → See all 2,170 queries →