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

Why Are Spreads Wider at the Open? Real Data
Window guard: the UTC session filter maps to a 9:30 a.m. ET start on both ends of the rolling windowscalar · 2026-10-04 · 1×2570 Share of quote updates at the one-cent minimum spread, by half hour (regular hours, ET)series · 2026-10-04 · 13×4Preview: a 13-point series, ending higher. Median spread each half hour, as a multiple of each name's tightest bucket (regular hours, ET)series · 2026-10-04 · 13×4Preview: a 13-point series, ending lower. Session by session: how often, and by how much, the open ran wider than middaytable · 2026-10-04 · 3×6 Median quoted spread by phase of the trading day, in basis points (ET clock)ranking · 2026-10-04 · 5×4Preview: 5 ranked values, largest first. The opening premium priced: median and 90th-percentile spread at the open (9:30-10:00 ET) vs. midday (12:00-14:00 ET)table · 2026-10-04 · 3×12 MU: median quoted spread by half hour on July 7, 2026 (ET, regular hours)series · 2026-10-04 · 13×5Preview: a 13-point series, ending lower. MU into July 7, 2026: prior regular-session close, opening print, overnight gapscalar · 2026-10-04 · 1×3984.31
What Time Do Options Start Trading?
SPY option volume, minute by minute into the 9:30 openseries · 2026-10-04 · 46×3Preview: a 16-point series, ending higher. US option contract volume by Eastern-time half hourseries · 2026-10-04 · 21×3Preview: a 16-point series, ending higher. Scheduled open and close on every upcoming half dayseries · 2026-10-04 · 2×6Preview: a 2-point series, roughly flat.
The 10:00 AM Rule in Stocks, Tested
Volume and range coverage by half hour of the session, 2023 to 2025series · 2026-09-26 · 13×3Preview: a 13-point series, ending lower. Median quoted spread by five minute bucket, SPY and AAPL, 10 March 2026series · 2026-09-26 · 12×3Preview: a 12-point series, ending lower. First 30 minutes: share of the day's range and volume, 2023 to 2025ranking · 2026-09-26 · 6×3Preview: 6 ranked values, largest first. Average one minute range by ET clock minute, 09:30 to 10:59series · 2026-09-26 · 90×3Preview: a 16-point series, roughly flat. Session coverage behind the long-run panelsranking · 2026-09-26 · 6×4Preview: 6 ranked values, largest first.
Window guard: the UTC session filter maps to a 9:30 a.m. ET start on both ends of the rolling window

Window guard: the UTC session filter maps to a 9:30 a.m. ET start on both ends of the rolling window

most recentas of scalar 1×2read in context →
win start et min
570
win end et min
570
the exact SQL behind every number 
SELECT toHour(toTimeZone(toDateTime(today() - 14) + toIntervalMinute(810), 'America/New_York')) * 60
         + toMinute(toTimeZone(toDateTime(today() - 14) + toIntervalMinute(810), 'America/New_York')) AS win_start_et_min,
       toHour(toTimeZone(toDateTime(today() - 4) + toIntervalMinute(810), 'America/New_York')) * 60
         + toMinute(toTimeZone(toDateTime(today() - 4) + toIntervalMinute(810), 'America/New_York')) AS win_end_et_min
More from this analysisWhy Are Spreads Wider at the Open? Real Data
MU into July 7, 2026: prior regular-session close, opening print, overnight gap scalar 1×3 → Share of quote updates at the one-cent minimum spread, by half hour (regular hours, ET) series 13×4 → Median spread each half hour, as a multiple of each name's tightest bucket (regular hours, ET) series 13×4 → MU: median quoted spread by half hour on July 7, 2026 (ET, regular hours) series 13×5 → See all 3,256 queries →
$