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

2,170 answered market questions

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

SK Hynix's Nasdaq Debut, Measured
Debut-day quoted spread by hour: the seasoning process, hour zeroranking · 2026-07-26 · 5×4Preview: 5 ranked values, smallest first. SKHYV day-one off-exchange short volume, with the file-coverage probescalar · 2026-07-26 · 1×521.3 The options tape: SKHYV's day-one silence vs the comparables' clockscalar · 2026-07-26 · 1×30 Memory-sector day one, July 10, 2026: RTH move and dollar volumetable · 2026-07-26 · 4×5 The listing record + the SEC filing trail behind the debutscalar · 2026-07-26 · 1×11158.14 2026 US listings ranked by capital raised (top 8, $B)ranking · 2026-07-26 · 8×4Preview: 8 ranked values, largest first. Debut-day anatomy: the 11:34 IPO cross, day volume, venue split, and the closing crossscalar · 2026-07-26 · 1×7170 SKHYV's first session: July 10, 2026, receiptedscalar · 2026-07-26 · 1×9170
Sector Scorecard H1 2026: Winners and Losers
Eight heavily traded chip and memory names: H1 return, quarter split, H1 dollar volumetable · 2026-07-26 · 8×5 Median quoted spread by sector ETF, one representative session (June 29, 2026), regular hoursranking · 2026-07-26 · 11×4Preview: 11 ranked values, smallest first. The eleven sector ETFs: H1 2026 return, Q1 and Q2 split, and H1 dollar volumetable · 2026-07-26 · 11×5 XLE, XLF, and XLK by month: the H1 2026 rotation at month grainseries · 2026-07-26 · 18×3Preview: a 16-point series, ending lower. Five-name baskets per sector: members up vs down, median, best and worst, H1 2026table · 2026-07-26 · 11×9 Sector ETF dollar volume, Q1 vs Q2 2026: every fund traded less in the recovery quarterranking · 2026-07-26 · 11×4Preview: 11 ranked values, largest first.
NVDA: Sit-Out, Then Surge, Week of July 6
Print-size anatomy and quote census: NVDA, full weekscalar · 2026-07-26 · 1×512.17 NVDA median quoted spread by session, regular hours (bps of midpoint)series · 2026-07-26 · 5×3Preview: a 5-point series, ending higher. FINRA daily short volume, NVDA: with the file-completeness caveatranking · 2026-07-26 · 5×3Preview: 5 ranked values, smallest first. NVDA by session: close, change, shares, dollarsseries · 2026-07-26 · 5×5Preview: a 5-point series, ending higher. NVDA, week of July 6, 2026: open to close, extremes with receipts, volumescalar · 2026-07-26 · 1×14194.51 Rank receipt: NVDA's weekly dollar volume against every other ticker, plus the Friday-only rankscalar · 2026-07-26 · 1×73 NVDA position check as of Friday's close: trailing-year extremes and moving averagesscalar · 2026-07-26 · 1×12210.96 NVDA options, full week: totals, put-call vs trailing baseline, strikes and expiries decodedscalar · 2026-07-26 · 1×1117.28 News-feed attention: articles tagged NVDA during the week, decodedscalar · 2026-07-26 · 1×1186 The week's heaviest tickers by regular-hours dollar volumeranking · 2026-07-26 · 6×2Preview: 6 ranked values, largest first. NVDA vs the chip complex: close-over-close % change by sessionseries · 2026-07-26 · 5×6Preview: a 5-point series, ending lower. NVDA weekly returns, trailing ~26 weeks (open-to-close per week): where this week rankstable · 2026-07-26 · 27×3
Market Recap: Week of July 6, 2026
Next week on the calendar: closures, ex-dividends, and the monthly expiry's pullscalar · 2026-07-26 · 1×40 SPY by session: close, change, and share volume, July 6-10series · 2026-07-26 · 5×4Preview: a 5-point series, ending lower. Options contracts and 0DTE share by session, July 6-10ranking · 2026-07-26 · 5×3Preview: 5 ranked values, smallest first. What the news feed actually carried, verbatim (The Motley Fool, rout day and bounce day)table · 2026-07-26 · 2×3 SEC filings by session and form type, July 6-10table · 2026-07-26 · 5×5 SK Hynix's SEC paper trail into its July 10 US listingtable · 2026-07-26 · 9×2 SK Hynix's US debut: the raise, the delayed open, the close vs offer, and where the first-day tape ranks in 2026scalar · 2026-07-26 · 1×14158.14 Top names by regular-hours dollar volume, full week July 6-10ranking · 2026-07-26 · 6×2Preview: 6 ranked values, largest first. Tuesday's rout: INTC and TER, July 7 close vs July 6 closeranking · 2026-07-26 · 2×2Preview: 2 ranked values, largest first. Daily short-volume file coverage: tickers on file and total short shares, July 6-10ranking · 2026-07-26 · 5×3Preview: 5 ranked values, largest first. Session verification: five sessions, no holiday, next scheduled closurescalar · 2026-07-26 · 1×65 Feed coverage by day: articles tagging NVDA, MU, INTC, TER, July 6-10table · 2026-07-26 · 5×5 The week's corporate calendar: filings, dividends, splits, newsscalar · 2026-07-26 · 1×1018,353 SPY's week in trailing-year context (open-to-close weekly returns, ~53 weeks)scalar · 2026-07-26 · 1×50.82 SPY / QQQ / DIA / IWM: week of July 6 vs the July 2 close, with the prior week's changetable · 2026-07-26 · 4×5 Sector ETFs, full-week change: July 10 close vs July 2 closeranking · 2026-07-26 · 10×2Preview: 10 ranked values, smallest first. Treasury curve: the Friday July 10 print vs the July 2 close, both late receipts on filescalar · 2026-07-26 · 1×67 Weekly movers: ten biggest gainers and decliners, $5M+ traded, in-week splits excludedtable · 2026-07-26 · 20×5 The chip complex's full-week change: July 10 close vs July 2 close, fourteen namesranking · 2026-07-26 · 14×2Preview: 14 ranked values, smallest first. Weekly breadth: July 10 close vs July 2 close, names with $5M+ traded during the weekscalar · 2026-07-26 · 1×43,015
Market Recap: July 9, 2026, The Day in Numbers
Shares per 30-minute ET bucket, regular hours, with % of the day's biggest bucketseries · 2026-07-26 · 13×3Preview: a 13-point series, roughly flat. Top 6 by dollars traded, top 4 by shares traded: July 9 regular hourstable · 2026-07-26 · 10×6 SPY same-day (0DTE) options: contracts by strike distance from the closing priceranking · 2026-07-26 · 5×4Preview: 5 ranked values, largest first. Session verification: first/last SPY bar ET, regular-bar count, holiday receipts, next closurescalar · 2026-07-26 · 1×9885 SPY / QQQ / NVDA / TSLA / MU / SNDK / AVGO: RTH median quoted spread in basis pointsranking · 2026-07-26 · 7×2Preview: 7 ranked values, smallest first. On deck: the next session, its ex-dividend slate, the SPY expiry ladder, and the short-interest clockscalar · 2026-07-26 · 1×80 Ex-divs, splits, SEC filings, news attentionscalar · 2026-07-26 · 1×14127 The week so far: index moves and advancer share for each completed sessionseries · 2026-07-26 · 4×5Preview: a 4-point series, ending lower. Treasury print status: July 9 rows on record, and the July 8 curve (latest at authoring)scalar · 2026-07-26 · 1×61 SPY / QQQ day move in trailing context (~22 sessions)scalar · 2026-07-26 · 1×71.67 SPY's RTH average quoted spread in trailing-month contextscalar · 2026-07-26 · 1×62.071 Eight declared sector baskets, three names each: July 9 close-over-close, equal-weightedtable · 2026-07-26 · 8×6 SPY / QQQ / DIA / IWM: July 9 vs the July 8 close, regular hourstable · 2026-07-26 · 4×10 Eight mega-caps and defensives: gap at the open vs the rest of the day, July 9table · 2026-07-26 · 8×8 Stocks NBBO update count: July 9 vs July 8, with named-ticker updates (millions)scalar · 2026-07-26 · 1×8383.44 Premarket path, 4:00-9:29 am ET: last premarket print vs Wednesday's close, and the open that followedtable · 2026-07-26 · 6×8 Options NBBO tape: total updates vs the stock tape, plus the SPY root slicescalar · 2026-07-26 · 1×36.9 Options tape: prints, contracts, call %, 0DTE share vs Wednesday, top contractsscalar · 2026-07-26 · 1×229.99 Named catalysts on file: news articles and SEC filings per name, Wednesday's close through Thursday'stable · 2026-07-26 · 9×5 Receipts: July 9 green/red counts across the fourteen names, and NVDA's two-day turnscalar · 2026-07-26 · 1×612 Fourteen chip names: gap at the open vs the rest of the day, July 9table · 2026-07-26 · 14×8 Liquid-tape breadth: July 9 advancer share vs July 8, $1M-traded filterscalar · 2026-07-26 · 1×84,263
Market Recap: July 8, 2026, The Day in Numbers
Shares per 30-minute ET bucket, regular hours, with % of the day's biggest bucketseries · 2026-07-26 · 13×3Preview: a 13-point series, roughly flat. Top 6 by dollars traded, top 4 by shares traded: July 8 regular hourstable · 2026-07-26 · 10×6 Session verification: first/last SPY bar ET, regular-bar count, holiday receipts, next closurescalar · 2026-07-26 · 1×8919 SPY / QQQ / NVDA / TSLA / MU / SNDK / AVGO: RTH median quoted spread in basis pointsranking · 2026-07-26 · 7×2Preview: 7 ranked values, smallest first. Ex-divs, splits, SEC filings, news attentionscalar · 2026-07-26 · 1×1381 Treasury yields: July 8 vs July 7, populated maturities + 2s10sranking · 2026-07-26 · 8×3Preview: 8 ranked values, largest first. SPY / QQQ day move in trailing context (close-over-close, ~22 sessions)scalar · 2026-07-26 · 1×70.25 SPY's RTH average quoted spread in trailing-month contextscalar · 2026-07-26 · 1×72.202 SPY / QQQ / DIA / IWM: July 8 vs the July 7 close, regular hourstable · 2026-07-26 · 4×10 Rotation check: eight names, defensives, mega-caps, biotechtable · 2026-07-26 · 8×8 Stocks NBBO update count: July 8 vs July 7, with named-ticker updates (millions)scalar · 2026-07-26 · 1×8530.55 Options NBBO tape: total updates vs the stock tape, plus the SPY root slicescalar · 2026-07-26 · 1×39.62 Options tape: prints, contracts, call %, 0DTE share vs Tuesday, top contractscalar · 2026-07-26 · 1×1410.44 Receipts: July 8 and July 7 green/red counts across the same fourteen namesscalar · 2026-07-26 · 1×612 Fourteen chip names: prior close, day close, day range, dollar volume, low/high minute ETtable · 2026-07-26 · 14×10 Liquid-tape breadth: July 8 advancer share vs July 7, $1M-traded filterscalar · 2026-07-26 · 1×81,821
How Leveraged ETFs Work (and Why They Decay)
Every SOXS reverse split since 2020, and the running consolidation factorseries · 2026-07-15 · 5×3Preview: a 5-point series, ending higher. One semiconductor selloff, four funds: SOXX, USD, SOXL, SOXS on July 13, 2026ranking · 2026-07-15 · 4×2Preview: 4 ranked values, largest first. Growth of $100 in the 1x SOXX vs the 3x SOXL, Jan 2 to Jul 13 2026series · 2026-07-15 · 131×3Preview: a 16-point series, ending higher.
Debut-day quoted spread by hour: the seasoning process, hour zero

Debut-day quoted spread by hour: the seasoning process, hour zero

most recentas of ranking 5×4read in context →
Debut-day quoted spread by hour: the seasoning process, hour zero — 5 rows by 4 columns, computed from US exchange, SIP and OPRA data.
et_hourmed_spread_bpsquote_updatestwo_sided_updates
11109716596654
125.88990189290
135.24698046964
145.34348943482
154.14968549616
the exact SQL behind every number 
SELECT
    toHour(toTimeZone(sip_timestamp, 'America/New_York')) AS et_hour,
    round(quantileDeterministicIf(0.5)((toFloat64(ask_price) - toFloat64(bid_price)) / ((toFloat64(ask_price) + toFloat64(bid_price)) / 2) * 10000, toUInt64(toUnixTimestamp64Micro(sip_timestamp)), bid_price > 0 AND ask_price > bid_price), 1) AS med_spread_bps,
    count() AS quote_updates,
    countIf(bid_price > 0 AND ask_price > bid_price) AS two_sided_updates
FROM global_markets.cache_stocks_quotes
WHERE ticker = 'SKHYV'
  AND sip_timestamp >= toDateTime64('2026-07-10 13:30:00', 9) AND sip_timestamp < toDateTime64('2026-07-10 20:00:00', 9)
  AND (toHour(sip_timestamp) * 60 + toMinute(sip_timestamp)) BETWEEN 810 AND 1199
GROUP BY et_hour
HAVING countIf(bid_price > 0 AND ask_price > bid_price) > 0
ORDER BY et_hour
More from this analysisSK Hynix's Nasdaq Debut, Measured
2026 US listings ranked by capital raised (top 8, $B) ranking 8×4 → Memory-sector day one, July 10, 2026: RTH move and dollar volume table 4×5 → SKHYV day-one off-exchange short volume, with the file-coverage probe scalar 1×5 → The options tape: SKHYV's day-one silence vs the comparables' clock scalar 1×3 → See all 2,170 queries →
$