STRASMORE/EXPLORE 2,170 QUERIES

The steepest single minutes: biggest open-to-low drops, 2:00–3:30 pm ET

Answered against 22 years of US equities and 12 years of US options data and published with the query that produced it. This result is stored as of 2026-07-26, from The 2010 Flash Crash, Minute by Minute.

as of table 5×5read in context →
The steepest single minutes: biggest open-to-low drops, 2:00–3:30 pm ET — 5 rows by 5 columns, computed from US exchange, SIP and OPRA data.
et_minuteminute_openminute_lowdrop_within_minute_usdshares_m
14:49112.52106.85.724.98
14:48111.31106.015.34.75
15:09113.63108.375.263.51
14:50112.02108.223.82.22
14:45108.691053.697.24
Rows × columns
5 × 5
Computed
Completeness
No missing values
Source
US exchange, SIP and OPRA market data
Licence
Strasmore terms · free, no signup
Formats
JSON · CSV · the SQL below

What each column holds

Column definitions for The steepest single minutes: biggest open-to-low drops, 2:00–3:30 pm ET, derived from the stored result.
ColumnTypeRangeNotes
et_minute text 5 distinct values (14:45, 14:48, 14:49…)
minute_open number 108.69 to 113.63 US dollars
minute_low number 105 to 108.37 US dollars
drop_within_minute_usd number 3.69 to 5.72 US dollars
shares_m number 2.22 to 7.24 count

Computed from Strasmore's warehouse of US exchange, SIP and OPRA market data. Equity prices are delayed; options greeks and implied volatility are end-of-day. This result is stored, not recomputed on load — it is exactly the numbers that were returned on , and the query below is what returned them.

the exact SQL behind every number
SELECT
    formatDateTime(toTimeZone(window_start, 'America/New_York'), '%H:%i') AS et_minute,
    round(toFloat64(open), 2) AS minute_open,
    round(toFloat64(low), 2) AS minute_low,
    round(toFloat64(open) - toFloat64(low), 2) AS drop_within_minute_usd,
    round(toFloat64(volume) / 1e6, 2) AS shares_m
FROM global_markets.delayed_stocks_minute_aggs
WHERE ticker = 'SPY'
  AND window_start >= toDateTime('2010-05-06 18:00:00') AND window_start < toDateTime('2010-05-06 19:30:00')
ORDER BY drop_within_minute_usd DESC
LIMIT 5

Run your own version of this

The same 22 years of US equities and 12 years of options data are queryable in SQL or plain English. A free account runs 100 queries a day and takes no card.

More from this analysisThe 2010 Flash Crash, Minute by Minute
SPY at one-minute resolution, 2:00–3:30 pm ET on May 6, 2010 table 90×4 Crash-window damage by name: low vs the 2:30 pm ET reference table 6×6 The famous casualties on the raw trade tape, 2:30–3:30 pm ET table 4×6 Five famous crash sessions: depth of the low and the bounce off it (SPY) series 5×4 SPY on May 6, 2010: the flash crash day, receipted scalar 1×10 The aftermath: when the May 5 close was reclaimed, and when the panic low broke for real scalar 1×7 See all 2,170 queries →