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

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-08-08 · 1×2570 Share of quote updates at the one-cent minimum spread, by half hour (regular hours, ET)series · 2026-08-08 · 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-08-08 · 13×4Preview: a 13-point series, ending lower. Session by session: how often, and by how much, the open ran wider than middaytable · 2026-08-08 · 3×6 Median quoted spread by phase of the trading day, in basis points (ET clock)ranking · 2026-08-08 · 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-08-08 · 3×12 MU: median quoted spread by half hour on July 7, 2026 (ET, regular hours)series · 2026-08-08 · 13×5Preview: a 13-point series, ending lower. MU into July 7, 2026: prior regular-session close, opening print, overnight gapscalar · 2026-08-08 · 1×3984.31
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 2,170 queries →
$