STRASMORE/EXPLORE 2,170 QUERIES

The S&P 500's underwater record since 2016 (SPY, one scorecard)

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-16, from How Markets Recover From Crashes.

as of scalar 1×6read in context →
deepest fall pct
34.2
current fall pct
0.6
pct days below high
70
pct days below 5
32
pct days below 10
16
trading days
2,647
Rows × columns
1 × 6
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 S&P 500's underwater record since 2016 (SPY, one scorecard), derived from the stored result.
ColumnTypeRangeNotes
deepest_fall_pct number every row is 34.2 percent
current_fall_pct number every row is 0.6 percent
pct_days_below_high number every row is 70 percent
pct_days_below_5 number every row is 32 percent
pct_days_below_10 number every row is 16 percent
trading_days number every row is 2,647

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 
WITH d AS (
    SELECT toDate(toTimeZone(window_start, 'America/New_York')) AS dt,
           argMax(toFloat64(close), toTimeZone(window_start, 'America/New_York')) AS c
    FROM global_markets.delayed_stocks_minute_aggs
    WHERE ticker = 'SPY' AND window_start >= '2016-01-01'
      AND (toHour(toTimeZone(window_start, 'America/New_York')) * 60
           + toMinute(toTimeZone(window_start, 'America/New_York'))) BETWEEN 570 AND 959
    GROUP BY dt
),
dd AS (
    SELECT dt,
           (c / max(c) OVER (ORDER BY dt ROWS BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW) - 1) * 100 AS ddpct
    FROM d
)
SELECT round(-min(ddpct), 1) AS deepest_fall_pct,
       round(-argMax(ddpct, dt), 1) AS current_fall_pct,
       round(100.0 * countIf(ddpct < -0.5) / count(), 0) AS pct_days_below_high,
       round(100.0 * countIf(ddpct < -5) / count(), 0) AS pct_days_below_5,
       round(100.0 * countIf(ddpct < -10) / count(), 0) AS pct_days_below_10,
       count() AS trading_days
FROM dd

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 analysisHow Markets Recover From Crashes
The S&P 500's underwater curve: worst drawdown from a prior high, by month series 127×2 → S&P 500 worst intra-year drawdown vs the year's price return, since 2016 ranking 11×3 → How far below its high the S&P 500 sits: share of trading days since 2016 ranking 5×2 → SPY's 20 best and 20 worst days since 2016, counted by year ranking 11×3 → The ten biggest single-day gains for SPY since 2016 ranking 10×2 → SPY total return since 2016, after removing the best single days ranking 5×2 → See all 2,170 queries →