STRASMORE/EXPLORE 2,170 QUERIES

Ex-divs, splits, news, and the July 10 SEC filing mix

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

as of scalar 1×16read in context →
ex dividend records
153
reverse splits
6
forward splits
4
fil total
3,137
fil filers
1,780
fil form4
694
fil 424b2
532
fil 8k
150
fil 13f
99
fil 10q
7
skhyv final prospectus
1
fil form4 minus next form
162
news articles
154
news publishers
3
top news ticker
NVDA
top news n
11
Rows × columns
1 × 16
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, news, and the July 10 SEC filing mix, derived from the stored result.
ColumnTypeRangeNotes
ex_dividend_records number every row is 153
reverse_splits number every row is 6
forward_splits number every row is 4
fil_total number every row is 3,137
fil_filers number every row is 1,780
fil_form4 number every row is 694
fil_424b2 number every row is 532
fil_8k number every row is 150
fil_13f number every row is 99
fil_10q number every row is 7
skhyv_final_prospectus number every row is 1
fil_form4_minus_next_form number every row is 162
news_articles number every row is 154
news_publishers number every row is 3
top_news_ticker text 1 distinct value (NVDA)
top_news_n number every row is 11 count

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-10'
    ) AS news,
    (
        SELECT (argMax(t, (n, t)), 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-10'
            )
            WHERE t != 'SPCX'
            GROUP BY t
        )
    ) AS top_news,
    (
        SELECT (count(), uniqExact(cik), countIf(form_type = '4'), countIf(form_type = '424B2'), countIf(form_type = '8-K'), countIf(form_type = '13F-HR'), countIf(form_type = '10-Q'), countIf(form_type = '424B4' AND positionCaseInsensitive(issuer_name, 'hynix') > 0), countIf(form_type = '4') - (SELECT max(n) FROM (SELECT count() AS n FROM global_markets.stocks_sec_edgar_index WHERE filing_date = '2026-07-10' AND form_type != '4' GROUP BY form_type)))
        FROM global_markets.stocks_sec_edgar_index
        WHERE filing_date = '2026-07-10'
    ) AS fil
SELECT
    (SELECT count() FROM global_markets.stocks_dividends WHERE ex_dividend_date = '2026-07-10') AS ex_dividend_records,
    (SELECT countIf(toFloat64(split_from) > toFloat64(split_to)) FROM global_markets.stocks_splits WHERE execution_date = '2026-07-10') AS reverse_splits,
    (SELECT countIf(toFloat64(split_to) > toFloat64(split_from)) FROM global_markets.stocks_splits WHERE execution_date = '2026-07-10') AS forward_splits,
    fil.1 AS fil_total,
    fil.2 AS fil_filers,
    fil.3 AS fil_form4,
    fil.4 AS fil_424b2,
    fil.5 AS fil_8k,
    fil.6 AS fil_13f,
    fil.7 AS fil_10q,
    fil.8 AS skhyv_final_prospectus,
    fil.9 AS fil_form4_minus_next_form,
    news.1 AS news_articles, news.2 AS news_publishers,
    top_news.1 AS top_news_ticker, top_news.2 AS top_news_n

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 10, 2026, The Day in Numbers
SK Hynix's first session: the listing record vs the tape, July 10, 2026 scalar 1×8 → Session verification: first/last SPY bar ET, regular-bar count, holiday receipts, next closure scalar 1×7 → The week of July 13–17: closures, ex-dividends, splits, the monthly expiry, and the short-interest lag scalar 1×8 → Treasury print status: July 9 and July 10 rows on record, and the July 8 curve (latest at authoring) scalar 1×6 → SPY day move in trailing context (~22 sessions, open-to-close) scalar 1×4 → Stocks NBBO update count: July 10 vs July 9, with named-ticker updates (millions) scalar 1×6 → See all 2,170 queries →