yearly
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-09-20, from bullish-vs-bearish-meaning.
| year | up_day_pct | down_day_pct | year_move_pct |
|---|---|---|---|
| 2008 | 49.8 | 50.2 | -38.3 |
| 2022 | 43 | 56.6 | -19.5 |
| 2018 | 52.6 | 46.6 | -6.3 |
| 2015 | 48 | 52 | -0.8 |
| 2011 | 52.8 | 47.2 | -0.2 |
| 2005 | 54 | 44.8 | 3 |
| 2007 | 54.6 | 45 | 3.2 |
| 2004 | 55.6 | 43.3 | 8.6 |
| 2003 | 60.3 | 39.7 | 9.1 |
| 2016 | 54 | 45.6 | 9.6 |
| 2014 | 58.3 | 41.7 | 11.3 |
| 2026 | 51.4 | 48.6 | 11.7 |
| 2010 | 56.3 | 43.7 | 12.8 |
| 2012 | 55.2 | 44.4 | 13.5 |
| 2006 | 54.6 | 45.4 | 13.7 |
| 2020 | 57.7 | 42.3 | 16.2 |
| 2025 | 56.8 | 43.2 | 16.4 |
| 2017 | 56.2 | 43.4 | 19.4 |
| 2024 | 58.7 | 41.3 | 23.3 |
| 2009 | 54.8 | 45.2 | 23.5 |
| 2023 | 56 | 43.6 | 24.3 |
| 2021 | 57.9 | 42.1 | 27 |
| 2019 | 59.1 | 40.9 | 28.8 |
| 2013 | 57.5 | 41.7 | 29.7 |
- Rows × columns
- 24 × 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 |
|---|---|---|---|
year |
number | 2,003 to 2,026 | |
up_day_pct |
number | 43 to 60.3 | percent |
down_day_pct |
number | 39.7 to 56.6 | percent |
year_move_pct |
number | -38.3 to 29.7 | percent |
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.
WITH bars AS
(
SELECT
date,
toFloat64(any(close)) AS close_price
FROM global_markets.stocks_daily_aggs
WHERE ticker = 'SPY'
AND close > 0
GROUP BY date
),
moves AS
(
SELECT
date,
close_price,
lagInFrame(close_price, 1) OVER (ORDER BY date ROWS BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW) AS prev_close
FROM bars
)
SELECT
toYear(date) AS year,
round(100 * countIf(close_price > prev_close) / count(), 1) AS up_day_pct,
round(100 * countIf(close_price < prev_close) / count(), 1) AS down_day_pct,
round(100 * (argMax(close_price, date) / argMin(prev_close, date) - 1), 1) AS year_move_pct
FROM moves
WHERE prev_close > 0
GROUP BY year
ORDER BY year_move_pct ASC