Named catalysts on file: news articles and SEC filings per name, Wednesday's close through Thursday's

Name: Named catalysts on file: news articles and SEC filings per name, Wednesday's close through Thursday's
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 9, 2026, The Day in Numbers.

as of 2026-07-26 table 9×5read in context →

Named catalysts on file: news articles and SEC filings per name, Wednesday's close through Thursday's — 9 rows by 5 columns, computed 2026-07-26 from US exchange, SIP and OPRA data.
ticker	overnight_articles	session_articles	sec_filings
AMD	1	2	0
KLAC	0	0	0
LRCX	0	0	0
META	4	7	1
MSFT	6	5	0
MU	6	6	0
NVDA	7	9	0
TER	0	0	0
WDC	0	0	0

Rows × columns: 9 × 5
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 Named catalysts on file: news articles and SEC filings per name, Wednesday's close through Thursday's, derived from the stored result.
Column	Type	Range
`ticker`	text	9 distinct values (AMD, KLAC, LRCX…)
`overnight_articles`	number	0 to 7
`session_articles`	number	0 to 9
`sec_filings`	number	0 to 1
`filings_8k`	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 2026-07-26, and the query below is what returned them.

Run it yourself

This is the exact query behind the result above. Change a ticker, a date or a column and run it against the warehouse — no account, no key. The no-signup tier is smaller than the one this page was computed on; a query that reaches past it comes back saying which plan runs it.

SELECT
    ticker,
    toUInt32(sum(overnight_articles)) AS overnight_articles,
    toUInt32(sum(session_articles)) AS session_articles,
    toUInt32(sum(sec_filings)) AS sec_filings,
    toUInt32(sum(filings_8k)) AS filings_8k
FROM (
    SELECT
        arrayJoin(['AMD', 'KLAC', 'LRCX', 'META', 'MSFT', 'MU', 'NVDA', 'TER', 'WDC']) AS ticker,
        toUInt64(0) AS overnight_articles, toUInt64(0) AS session_articles,
        toUInt64(0) AS sec_filings, toUInt64(0) AS filings_8k
    UNION ALL
    SELECT
        arrayJoin(tickers) AS ticker,
        countIf(published_utc < '2026-07-09 13:30:00') AS overnight_articles,
        countIf(published_utc >= '2026-07-09 13:30:00') AS session_articles,
        toUInt64(0) AS sec_filings, toUInt64(0) AS filings_8k
    FROM global_markets.stocks_news
    WHERE published_utc >= '2026-07-08 20:00:00' AND published_utc < '2026-07-09 20:00:00'
    GROUP BY ticker
    UNION ALL
    SELECT
        ticker, toUInt64(0), toUInt64(0),
        count() AS sec_filings,
        countIf(form_type = '8-K') AS filings_8k
    FROM global_markets.stocks_sec_edgar_index
    WHERE filing_date >= '2026-07-08' AND filing_date <= '2026-07-09'
    GROUP BY ticker
)
WHERE ticker IN ('AMD', 'KLAC', 'LRCX', 'META', 'MSFT', 'MU', 'NVDA', 'TER', 'WDC')
GROUP BY ticker
ORDER BY ticker

SQL to run

SELECT
    ticker,
    toUInt32(sum(overnight_articles)) AS overnight_articles,
    toUInt32(sum(session_articles)) AS session_articles,
    toUInt32(sum(sec_filings)) AS sec_filings,
    toUInt32(sum(filings_8k)) AS filings_8k
FROM (
    SELECT
        arrayJoin(['AMD', 'KLAC', 'LRCX', 'META', 'MSFT', 'MU', 'NVDA', 'TER', 'WDC']) AS ticker,
        toUInt64(0) AS overnight_articles, toUInt64(0) AS session_articles,
        toUInt64(0) AS sec_filings, toUInt64(0) AS filings_8k
    UNION ALL
    SELECT
        arrayJoin(tickers) AS ticker,
        countIf(published_utc < '2026-07-09 13:30:00') AS overnight_articles,
        countIf(published_utc >= '2026-07-09 13:30:00') AS session_articles,
        toUInt64(0) AS sec_filings, toUInt64(0) AS filings_8k
    FROM global_markets.stocks_news
    WHERE published_utc >= '2026-07-08 20:00:00' AND published_utc < '2026-07-09 20:00:00'
    GROUP BY ticker
    UNION ALL
    SELECT
        ticker, toUInt64(0), toUInt64(0),
        count() AS sec_filings,
        countIf(form_type = '8-K') AS filings_8k
    FROM global_markets.stocks_sec_edgar_index
    WHERE filing_date >= '2026-07-08' AND filing_date <= '2026-07-09'
    GROUP BY ticker
)
WHERE ticker IN ('AMD', 'KLAC', 'LRCX', 'META', 'MSFT', 'MU', 'NVDA', 'TER', 'WDC')
GROUP BY ticker
ORDER BY ticker

⌘/Ctrl + Enter

在你的 AI 助手中使用这些数据

打开即可查询，已带上本页数据。免费，无需账号。

Claude ChatGPT Gemini Muse 你自己的智能体

More from this analysisMarket Recap: July 9, 2026, The Day in Numbers

Fourteen chip names: gap at the open vs the rest of the day, July 9 table 14×8 → Top 6 by dollars traded, top 4 by shares traded: July 9 regular hours table 10×6 → Eight declared sector baskets, three names each: July 9 close-over-close, equal-weighted table 8×6 → Eight mega-caps and defensives: gap at the open vs the rest of the day, July 9 table 8×8 → Premarket path, 4:00-9:29 am ET: last premarket print vs Wednesday's close, and the open that followed table 6×8 → SPY / QQQ / DIA / IWM: July 9 vs the July 8 close, regular hours table 4×10 → See all 3,127 queries →