STRASMORE/EXPLORE 2,173 QUERIES 22Y EQUITIES · 12Y OPTIONS

2,173 answered market questions

every one with its exact SQL, its result and the date it was computed · free, no signup

MU: The Biggest Tape of June 2026
The whole MU tape in one row: prints, print sizes, and the quote censusscalar · 2026-07-13 · 1×935.17 Where the contracts landed: call and put volume by strike bucketranking · 2026-07-13 · 16×4Preview: 16 ranked values, smallest first. The spread by session: regular-hours median in cents and basis pointsseries · 2026-07-13 · 21×5Preview: a 16-point series, roughly flat. FINRA off-exchange short volume: MU's June coverage and marked-short shareranking · 2026-07-13 · 16×3Preview: 16 ranked values, smallest first. The June settlement pair: mid-month and month-end short interestscalar · 2026-07-13 · 1×641.59 The 21 sessions: close, close-over-close change, full-day volumeseries · 2026-07-13 · 21×4Preview: a 16-point series, ending higher. The rank receipt: MU's place, its lead over the next name, and the basisscalar · 2026-07-13 · 1×31 June side by side: the memory/storage basket, NVDA, and SPYtable · 2026-07-13 · 6×5 Month-end price of movement: the last at-the-money straddle of Junescalar · 2026-07-13 · 1×72 MU's options market in one row: totals, expiries, the put/call splitscalar · 2026-07-13 · 1×74.69 What June's MU coverage was about: the vendor's own article tags, countedranking · 2026-07-13 · 10×3Preview: 10 ranked values, largest first. June's MU-tagged articles: volume, the top publisher's share, co-tagsscalar · 2026-07-13 · 1×7195 MU's June on one row: open, close, extremes, turnover, and their receiptsscalar · 2026-07-13 · 1×121,009.72 MU's last six reported quarters on file: revenue, net income, diluted EPStable · 2026-07-13 · 6×5 MU's June SEC filings and the session that followed the quarterly 8-Kscalar · 2026-07-13 · 1×111 The whole US tape ranked by June 2026 regular-hours dollar volume (one reused-symbol listing excluded pending entity verification)ranking · 2026-07-13 · 10×3Preview: 10 ranked values, largest first. MU by month: annualized realized volatility, average session range, biggest single-day movetable · 2026-07-13 · 6×6 MU month by month, recomputed live: return, close, and regular-hours turnoverranking · 2026-07-13 · 6×4Preview: 6 ranked values, largest first.
The whole MU tape in one row: prints, print sizes, and the quote census

The whole MU tape in one row: prints, print sizes, and the quote census

most recentas of scalar 1×9read in context →
prints m
35.17
median print shares
8
avg print shares
38.3
odd lot pct of prints
91.7
fractional pct of prints
9.04
nbbo updates m
19.64
clean two sided pct
99.86
crossed updates
16,963
one sided or empty updates
78
the exact SQL behind every number
WITH
    (
        SELECT (round(count() / 1e6, 2),
                round(100.0 * countIf(bid_price > 0 AND ask_price > 0 AND ask_price > bid_price) / count(), 2),
                countIf(bid_price > 0 AND ask_price > 0 AND ask_price < bid_price),
                countIf(bid_price <= 0 OR ask_price <= 0))
        FROM global_markets.cache_stocks_quotes
        WHERE ticker = 'MU'
          AND sip_timestamp >= toDateTime64('2026-06-01 00:00:00', 9) AND sip_timestamp < toDateTime64('2026-07-01 00:00:00', 9)
    ) AS quote_census
SELECT
    round(count() / 1e6, 2) AS prints_m,
    quantileDeterministic(0.5)(toFloat64(size), toUInt64(abs(sequence_number))) AS median_print_shares,
    round(avg(toFloat64(size)), 1) AS avg_print_shares,
    round(100.0 * countIf(size < 100) / count(), 1) AS odd_lot_pct_of_prints,
    round(100.0 * countIf(toFloat64(size) != round(toFloat64(size))) / count(), 2) AS fractional_pct_of_prints,
    quote_census.1 AS nbbo_updates_m,
    quote_census.2 AS clean_two_sided_pct,
    quote_census.3 AS crossed_updates,
    quote_census.4 AS one_sided_or_empty_updates
FROM global_markets.stocks_trades
WHERE ticker = 'MU'
  AND sip_timestamp >= toDateTime64('2026-06-01 00:00:00', 9) AND sip_timestamp < toDateTime64('2026-07-01 00:00:00', 9)
$