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

Paper Trading Before Real Money
One session shape: median quoted spread by half-hour bucket, Ford (F), recent completed sessionsseries · 2026-10-04 · 13×3Preview: a 13-point series, ending lower. Five years of sessions: share closing above the open, typical move, and the extremes (SPY, 2021-2025)table · 2026-10-04 · 5×6 What a real fill costs: median quoted spread in bps of the midpoint, regular hours, recent completed sessionsranking · 2026-10-04 · 6×4Preview: 6 ranked values, smallest first.
One session shape: median quoted spread by half-hour bucket, Ford (F), recent completed sessions

One session shape: median quoted spread by half-hour bucket, Ford (F), recent completed sessions

most recentas of series 13×3read in context →
One session shape: median quoted spread by half-hour bucket, Ford (F), recent completed sessions — 13 rows by 3 columns, computed from US exchange, SIP and OPRA data.
et_timespread_bpsquote_updates_m
09:307.990.06
10:007.980.06
10:307.950.04
11:007.880.04
11:308.060.04
12:007.860.05
12:308.050.04
13:008.050.04
13:308.060.03
14:008.040.03
14:308.030.03
15:008.060.03
15:308.080.05
the exact SQL behind every number 
SELECT formatDateTime(toStartOfInterval(toTimeZone(sip_timestamp, 'America/New_York'), INTERVAL 30 MINUTE), '%H:%i') AS et_time,
       round(quantileExactIf(0.5)(toFloat64(ask_price - bid_price) / (toFloat64(ask_price + bid_price) / 2), bid_price > 0 AND ask_price > bid_price) * 10000, 2) AS spread_bps,
       round(count() / 1e6, 2) AS quote_updates_m
FROM global_markets.cache_stocks_quotes
WHERE ticker = 'F'
  AND sip_timestamp >= toDateTime(today() - 10)
  AND sip_timestamp < toDateTime(today() - 3)
  AND (toHour(sip_timestamp) * 60 + toMinute(sip_timestamp)) BETWEEN 810 AND 1199
GROUP BY et_time
ORDER BY et_time
More from this analysisPaper Trading Before Real Money
What a real fill costs: median quoted spread in bps of the midpoint, regular hours, recent completed sessions ranking 6×4 → Five years of sessions: share closing above the open, typical move, and the extremes (SPY, 2021-2025) table 5×6 → SPY realised volatility by month against a 10% target series 72×4 → One symbol's quote messages against the sequence numbers they span series 60×3 → See all 3,256 queries →
$