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.
| et_minute | minute_open | minute_low | drop_within_minute_usd | shares_m |
|---|---|---|---|---|
| 14:49 | 112.52 | 106.8 | 5.72 | 4.98 |
| 14:48 | 111.31 | 106.01 | 5.3 | 4.75 |
| 15:09 | 113.63 | 108.37 | 5.26 | 3.51 |
| 14:50 | 112.02 | 108.22 | 3.8 | 2.22 |
| 14:45 | 108.69 | 105 | 3.69 | 7.24 |
- Rows × columns
- 5 × 5
- Computed
- Completeness
- No missing values
- Source
- US exchange, SIP and OPRA market data
- Licence
- Strasmore terms · free, no signup
What each column holds
| Column | Type | Range | Notes |
|---|---|---|---|
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 →