STRASMORE/EXPLORE 3,256 QUERIES 22Y EQUITIES · 12Y OPTIONS

3,256 answered market questions

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

How Long a Market Order Takes to Fill
Venue timestamp to consolidated feed, in microsecondsranking · 2026-10-02 · 5×3Preview: 5 ranked values, smallest first. Median quoted spread in basis points, same sessionranking · 2026-10-02 · 5×3Preview: 5 ranked values, largest first. Prints in a pinned 30-minute window, five household namesranking · 2026-10-02 · 5×4Preview: 5 ranked values, largest first. Seconds between prints, by how often a name tradesranking · 2026-10-02 · 5×3Preview: 5 ranked values, largest first.
What Exchange Colocation Costs Per Month
Quote updates in one hour, five names, 10:00 to 11:00 ET on 10 June 2026ranking · 2026-09-30 · 5×3Preview: 5 ranked values, largest first. SPY quote updates per millisecond, 10:00 to 10:05 ET on 10 June 2026ranking · 2026-09-30 · 5×3Preview: 5 ranked values, largest first. SPY trade messages per second by half hour, 10 June 2026series · 2026-09-30 · 32×3Preview: a 16-point series, roughly flat.
Mass Cancels and Purge Ports Explained
AAPL quoted spread in basis points, first hour of April 7, 2025series · 2026-09-30 · 60×3Preview: a 16-point series, ending lower. AAPL quote updates per second, volatile session vs quiet sessionseries · 2026-09-30 · 54×4Preview: a 16-point series, ending lower. How far AAPL travelled in each ten-minute bucket, same two sessionsseries · 2026-09-30 · 54×3Preview: a 16-point series, ending lower. Distinct option contracts that printed a trade on April 7, 2025ranking · 2026-09-30 · 5×2Preview: 5 ranked values, largest first.
How Exchange Speed Bumps Work
Average spacing between national best quote updates, one fixed hourranking · 2026-09-28 · 5×3Preview: 5 ranked values, largest first. Quote messages per minute against distinct best-bid prices (NVDA)series · 2026-09-28 · 60×3Preview: a 16-point series, ending lower. Which venues held the best bid, half-hour slice (AAPL)ranking · 2026-09-28 · 16×4Preview: 16 ranked values, largest first.
Latency Models in HFT Backtests Explained
Trade prints per second through one full session, ET clockseries · 2026-09-24 · 78×2Preview: a 16-point series, ending lower. How long a top of book quote survives, by latency budgetranking · 2026-09-24 · 9×2Preview: 9 ranked values, smallest first. Average distance the mid price travels over each latency horizonranking · 2026-09-24 · 4×2Preview: 4 ranked values, smallest first. Share of quotes replaced within 5 ms and 50 ms, by symbolranking · 2026-09-24 · 5×3Preview: 5 ranked values, largest first.
Market Data Timestamps: SIP vs Exchange Clocks
Off exchange AAPL prints by reporting delay, 10 June 2026ranking · 2026-08-14 · 5×3Preview: 5 ranked values, largest first. The same twelve prints, ranked by venue clock and by tape clocktable · 2026-08-14 · 12×7 SIP receive lag by venue, AAPL, 10 June 2026 (microseconds)ranking · 2026-08-14 · 11×4Preview: 11 ranked values, largest first. Prints that change bar when you switch clocks, by bar lengthranking · 2026-08-14 · 4×3Preview: 4 ranked values, largest first.
PCAP Market Data: How Market Replay Works
Trade prints per second across the electronic day, June 10 2026series · 2026-08-12 · 64×3Preview: a 16-point series, roughly flat. One minute of AAPL quotes, second by second, 09:30 ET on June 10 2026series · 2026-08-12 · 60×3Preview: a 16-point series, roughly flat. Quote messages per trade, 09:30 to 10:00 ET on June 10 2026ranking · 2026-08-12 · 5×3Preview: 5 ranked values, largest first. AAPL quote clocks, SIP stamp minus exchange stamp, 09:30 to 11:00 ET on June 10 2026series · 2026-08-12 · 9×4Preview: a 9-point series, ending higher.
SIP Feeds vs Direct Exchange Feeds
Which venues sat on the bid side of the quote record, KO on June 16, 2026ranking · 2026-08-09 · 17×3Preview: 16 ranked values, largest first. Quote update traffic across five household tickers, 10:00 to 11:00 a.m. ET on June 16, 2026table · 2026-08-09 · 5×5 US equity exchanges that feed the consolidated tapetable · 2026-08-09 · 18×4 Venue clock to consolidated tape clock, KO quotes on June 16, 2026series · 2026-08-09 · 15×4Preview: a 15-point series, roughly flat.
Venue timestamp to consolidated feed, in microseconds

Venue timestamp to consolidated feed, in microseconds

most recentas of ranking 5×3read in context →
Venue timestamp to consolidated feed, in microseconds — 5 rows by 3 columns, computed from US exchange, SIP and OPRA data.
symbolmedian_report_microsecondsp95_report_microseconds
AAPL458464971
MSFT558442909
SPY608357114
NVDA7392487876
KO94509501996
the exact SQL behind every number 
SELECT
    ticker AS symbol,
    round(quantileDeterministic(0.5)(
        toFloat64(dateDiff('microsecond', participant_timestamp, sip_timestamp)),
        cityHash64(ticker, sequence_number)), 0)  AS median_report_microseconds,
    round(quantileDeterministic(0.95)(
        toFloat64(dateDiff('microsecond', participant_timestamp, sip_timestamp)),
        cityHash64(ticker, sequence_number)), 0)  AS p95_report_microseconds
FROM global_markets.stocks_trades
WHERE ticker IN ('SPY', 'NVDA', 'AAPL', 'MSFT', 'KO')
  AND sip_timestamp >= toDateTime('2026-09-16 14:00:00', 'UTC')
  AND sip_timestamp <  toDateTime('2026-09-16 14:30:00', 'UTC')
  AND participant_timestamp >  toDateTime('2026-09-16 00:00:00', 'UTC')
  AND participant_timestamp <= sip_timestamp
GROUP BY ticker
HAVING count() > 100
ORDER BY median_report_microseconds
More from this analysisHow Long a Market Order Takes to Fill
Median quoted spread in basis points, same session ranking 5×3 → Prints in a pinned 30-minute window, five household names ranking 5×4 → Seconds between prints, by how often a name trades ranking 5×3 → Quoted spread across six household names, 11:00 to 11:30 a.m. ET on Sep 16, 2026 ranking 6×3 → See all 3,256 queries →
$