Largest single-session move, open to close, since 2016
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-08-22, from Options Approval Levels: What Each Tier Allows.
| ticker | largest_up_pct | largest_down_pct | largest_up_on |
|---|---|---|---|
| AMD | 25.1 | 12.5 | Apr 22, 2016 |
| AAPL | 15.6 | 7.6 | Apr 9, 2025 |
| NVDA | 15.6 | 11 | Apr 9, 2025 |
| SPY | 11.2 | 5.7 | Apr 9, 2025 |
| MSFT | 10.5 | 5.9 | Apr 9, 2025 |
| KO | 7.1 | 8.7 | Mar 16, 2020 |
- Rows × columns
- 6 × 4
- 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 | 6 distinct values (AAPL, AMD, KO…) | |
largest_up_pct |
number | 7.1 to 25.1 | percent |
largest_down_pct |
number | 5.7 to 12.5 | percent |
largest_up_on |
text | 3 distinct values (Apr 22, 2016, Apr 9, 2025, Mar 16, 2020) |
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
ticker,
round(100 * max(toFloat64(close) / toFloat64(open) - 1), 1) AS largest_up_pct,
round(100 * abs(min(toFloat64(close) / toFloat64(open) - 1)), 1) AS largest_down_pct,
formatDateTime(argMax(date, toFloat64(close) / toFloat64(open)), '%b %e, %Y') AS largest_up_on
FROM global_markets.stocks_daily_aggs
WHERE ticker IN ('AAPL', 'MSFT', 'NVDA', 'AMD', 'KO', 'SPY')
AND date >= '2016-01-01'
AND open > 0
GROUP BY ticker
ORDER BY largest_up_pct DESC
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 analysisOptions Approval Levels: What Each Tier Allows
Every $5 call spread on the same AAPL expiration: risk against maximum gain
ranking 7×3
→
Cash needed to hold 100 shares, six household names
ranking 6×3
→
What a covered call collects across strikes: AAPL, about one month out
table 6×5
→
Forward stock splits at liquid US names, past three years
ranking 12×3
→
Reg T minimum branches for one uncovered AAPL call, by strike (dollars per share)
ranking 12×4
→
Reg T minimum branches for one uncovered AAPL put, by strike (dollars per share)
ranking 11×4
→
See all 2,170 queries →