STRASMORE/EXPLORE 2,170 QUERIES

June's MU-tagged articles: volume, the top publisher's share, co-tags

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-13, from MU: The Biggest Tape of June 2026.

as of scalar 1×7read in context →
june articles
195
publishers
4
top publisher
The Motley Fool
top publisher pct
59
nvda co articles
86
sndk co articles
32
intc co articles
21
Rows × columns
1 × 7
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's MU-tagged articles: volume, the top publisher's share, co-tags, derived from the stored result.
ColumnTypeRangeNotes
june_articles number every row is 195
publishers number every row is 4
top_publisher text 1 distinct value (The Motley Fool)
top_publisher_pct number every row is 59 percent
nvda_co_articles number every row is 86
sndk_co_articles number every row is 32
intc_co_articles number every row is 21

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 (JSONExtractString(any(publisher), 'name'), count())
        FROM global_markets.stocks_news
        WHERE has(tickers, 'MU')
          AND published_utc >= toDateTime('2026-06-01 00:00:00') AND published_utc < toDateTime('2026-07-01 04:00:00')
        GROUP BY JSONExtractString(publisher, 'name') ORDER BY count() DESC LIMIT 1
    ) AS top_pub
SELECT
    count() AS june_articles,
    uniqExact(JSONExtractString(publisher, 'name')) AS publishers,
    top_pub.1 AS top_publisher,
    round(100.0 * top_pub.2 / count(), 0) AS top_publisher_pct,
    countIf(has(tickers, 'NVDA')) AS nvda_co_articles,
    countIf(has(tickers, 'SNDK')) AS sndk_co_articles,
    countIf(has(tickers, 'INTC')) AS intc_co_articles
FROM global_markets.stocks_news
WHERE has(tickers, 'MU')
  AND published_utc >= toDateTime('2026-06-01 00:00:00') AND published_utc < toDateTime('2026-07-01 04:00:00')

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 analysisMU: The Biggest Tape of June 2026
The whole MU tape in one row: prints, print sizes, and the quote census scalar 1×9 → The June settlement pair: mid-month and month-end short interest scalar 1×6 → The rank receipt: MU's place, its lead over the next name, and the basis scalar 1×3 → Month-end price of movement: the last at-the-money straddle of June scalar 1×7 → MU's options market in one row: totals, expiries, the put/call split scalar 1×7 → MU's June on one row: open, close, extremes, turnover, and their receipts scalar 1×12 → See all 2,170 queries →