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

NVDA: NVIDIA's Full June 2026, Tick by Tick
The whole NVDA tape in one row: prints, print sizes, and the quote censusscalar · 2026-07-26 · 1×1055.64 Where the contracts landed: call and put volume by strike buckettable · 2026-07-26 · 19×5 The spread by session: regular-hours median and time-weighted average (bps)series · 2026-07-26 · 21×5Preview: a 16-point series, roughly flat. FINRA off-exchange short volume by session: marked-short share and reported volumeseries · 2026-07-26 · 20×4Preview: a 16-point series, ending higher. The off-exchange peak and trough, bounded (deduped per session)scalar · 2026-07-26 · 1×686.77 The mid-June short-interest printscalar · 2026-07-26 · 1×6310.13 The 21 sessions: regular-hours close, close-over-close change, full-day volumeseries · 2026-07-26 · 21×5Preview: a 16-point series, ending lower. The rank receipt: NVDA's place, its lead over the next name, and the basis, as checked columnsscalar · 2026-07-26 · 1×54 Options session by session: contracts, the call/put split, and the put/call ratioseries · 2026-07-26 · 21×7Preview: a 16-point series, ending lower. NVDA's options market in one row: totals, expiry structure, flagship contractsscalar · 2026-07-26 · 1×1821 The information flow in one row: volume, composition, and co-tagsscalar · 2026-07-26 · 1×12642 The month on one row: open, close, extremes, volume, and their receiptsscalar · 2026-07-26 · 1×25215.77 NVDA fundamentals census: balance sheets, income statements, cash flowsscalar · 2026-07-26 · 1×383 The whole US tape ranked by June 2026 regular-hours dollar volumeranking · 2026-07-26 · 12×4Preview: 12 ranked values, largest first. The five-session slide, bounded: every claim in the streak sentence as a checked columnscalar · 2026-07-26 · 1×65 The trailing six months, recomputed live: turnover, shares, and month returnranking · 2026-07-26 · 6×4Preview: 6 ranked values, smallest first.
The whole NVDA tape in one row: prints, print sizes, and the quote census

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

most recentas of scalar 1×10read in context →
prints m
55.64
median print shares
5
avg print shares
72.9
odd lot pct of prints
84.6
fractional pct of prints
32.91
nbbo updates m
55.7
clean two sided pct
99.35
locked updates
329,679
crossed updates
33,941
one sided or empty updates
63
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 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 = 'NVDA'
          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 locked_updates,
    quote_census.4 AS crossed_updates,
    quote_census.5 AS one_sided_or_empty_updates
FROM global_markets.stocks_trades
WHERE ticker = 'NVDA'
  AND sip_timestamp >= toDateTime64('2026-06-01 00:00:00', 9) AND sip_timestamp < toDateTime64('2026-07-01 00:00:00', 9)
$