STRASMORE/EXPLORE 2,170 QUERIES

Ex-divs, splits, SEC filings, news attention

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

as of scalar 1×14read in context →
ex dividend records
127
splits executed
6
reverse splits
5
forward splits
1
fil 424b2
606
fil form4
623
fil 8k
149
fil total
2,981
news articles
184
news publishers
3
top news ticker
NVDA
top news n
20
top news lead over next
8
top news is nvda
1
Rows × columns
1 × 14
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 Ex-divs, splits, SEC filings, news attention, derived from the stored result.
ColumnTypeRangeNotes
ex_dividend_records number every row is 127
splits_executed number every row is 6
reverse_splits number every row is 5
forward_splits number every row is 1
fil_424b2 number every row is 606
fil_form4 number every row is 623
fil_8k number every row is 149
fil_total number every row is 2,981
news_articles number every row is 184
news_publishers number every row is 3
top_news_ticker text 1 distinct value (NVDA)
top_news_n number every row is 20 count
top_news_lead_over_next number every row is 8
top_news_is_nvda number every row is 1

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-09'
    ) AS news,
    (
        SELECT (argMax(t, (n, t)), 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-09'
            )
            WHERE t != 'SPCX'
            GROUP BY t
        )
    ) AS top_news
SELECT
    (SELECT count() FROM global_markets.stocks_dividends WHERE ex_dividend_date = '2026-07-09') AS ex_dividend_records,
    (SELECT count() FROM global_markets.stocks_splits WHERE execution_date = '2026-07-09') AS splits_executed,
    (SELECT countIf(toFloat64(split_from) > toFloat64(split_to)) FROM global_markets.stocks_splits WHERE execution_date = '2026-07-09') AS reverse_splits,
    (SELECT countIf(toFloat64(split_to) > toFloat64(split_from)) FROM global_markets.stocks_splits WHERE execution_date = '2026-07-09') AS forward_splits,
    (SELECT countIf(form_type = '424B2') FROM global_markets.stocks_sec_edgar_index WHERE filing_date = '2026-07-09') AS fil_424b2,
    (SELECT countIf(form_type = '4') FROM global_markets.stocks_sec_edgar_index WHERE filing_date = '2026-07-09') AS fil_form4,
    (SELECT countIf(form_type = '8-K') FROM global_markets.stocks_sec_edgar_index WHERE filing_date = '2026-07-09') AS fil_8k,
    (SELECT count() FROM global_markets.stocks_sec_edgar_index WHERE filing_date = '2026-07-09') AS fil_total,
    news.1 AS news_articles, news.2 AS news_publishers,
    top_news.1 AS top_news_ticker, top_news.2 AS top_news_n, top_news.3 AS top_news_lead_over_next,
    if(top_news.1 = 'NVDA', 1, 0) AS top_news_is_nvda

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 9, 2026, The Day in Numbers
Session verification: first/last SPY bar ET, regular-bar count, holiday receipts, next closure scalar 1×9 → On deck: the next session, its ex-dividend slate, the SPY expiry ladder, and the short-interest clock scalar 1×8 → Treasury print status: July 9 rows on record, and the July 8 curve (latest at authoring) scalar 1×6 → SPY / QQQ day move in trailing context (~22 sessions) scalar 1×7 → SPY's RTH average quoted spread in trailing-month context scalar 1×6 → Stocks NBBO update count: July 9 vs July 8, with named-ticker updates (millions) scalar 1×8 → See all 2,170 queries →