The famous casualties on the raw trade tape, 2:30–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.
| ticker | lowest_print | highest_print | penny_prints | hundred_k_prints | prints |
|---|---|---|---|---|---|
| AAPL | 199.25 | 100000 | 0 | 2 | 97158 |
| ACN | 0.01 | 41.53 | 43 | 0 | 10912 |
| BID | 27.85 | 100000 | 0 | 2 | 8015 |
| PG | 39.37 | 62.59 | 0 | 0 | 56242 |
- Rows × columns
- 4 × 6
- 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 |
|---|---|---|---|
ticker |
text | 4 distinct values (AAPL, ACN, BID…) | |
lowest_print |
number | 0.01 to 199.25 | |
highest_print |
number | 41.53 to 100,000 | |
penny_prints |
number | 0 to 43 | |
hundred_k_prints |
number | 0 to 2 | |
prints |
number | 8,015 to 97,158 |
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.
Run it yourself
This is the exact query behind the result above. Change a ticker, a date or a column and run it against the warehouse — no account, no key. The no-signup tier is smaller than the one this page was computed on; a query that reaches past it comes back saying which plan runs it.
SELECT
ticker,
round(min(toFloat64(price)), 2) AS lowest_print,
round(max(toFloat64(price)), 2) AS highest_print,
countIf(toFloat64(price) <= 0.05) AS penny_prints,
countIf(toFloat64(price) >= 99999) AS hundred_k_prints,
count() AS prints
FROM global_markets.stocks_trades
WHERE ticker IN ('ACN', 'AAPL', 'BID', 'PG')
AND sip_timestamp >= toDateTime('2010-05-06 18:30:00') AND sip_timestamp < toDateTime('2010-05-06 19:30:00')
GROUP BY ticker
ORDER BY ticker ASC
Work with this data in your AI assistant
Opens ready to query, with this page's data. Free, no account.