STRASMORE/EXPLORE 2,170 QUERIES 22Y EQUITIES · 12Y OPTIONS

2,170 answered market questions

every one with its exact SQL, its result and the date it was computed · free, no signup

The 8-4-3 Rule for Mutual Funds, Explained
An illustrative $10,000 SPY stake from year end 2005, marked at each year endranking · 2026-07-31 · 21×3Preview: 16 ranked values, smallest first. Annualized SPY price growth over rolling eight-year windows, by starting year endranking · 2026-07-31 · 14×3Preview: 14 ranked values, smallest first. SPY calendar-year price change vs the 12% assumption, 2006-2025ranking · 2026-07-31 · 20×3Preview: 16 ranked values, smallest first.
What Missing the Best Days Costs
SPY total return since 2016, after removing the best single daysranking · 2026-07-16 · 5×2Preview: 5 ranked values, smallest first. SPY's 20 best and 20 worst days since 2016, counted by yearranking · 2026-07-16 · 11×3Preview: 11 ranked values, smallest first. The ten biggest single-day gains for SPY since 2016ranking · 2026-07-16 · 10×2Preview: 10 ranked values, largest first.
How Markets Recover From Crashes
The S&P 500's underwater curve: worst drawdown from a prior high, by monthseries · 2026-07-16 · 127×2Preview: a 16-point series, ending higher. The S&P 500's underwater record since 2016 (SPY, one scorecard)scalar · 2026-07-16 · 1×634.2 S&P 500 worst intra-year drawdown vs the year's price return, since 2016ranking · 2026-07-16 · 11×3Preview: 11 ranked values, largest first. How far below its high the S&P 500 sits: share of trading days since 2016ranking · 2026-07-16 · 5×2Preview: 5 ranked values, largest first.
Buy When Others Are Fearful: The Data
Average S&P 500 forward return after fearful, greedy, and ordinary days (2024-2026)table · 2026-07-16 · 3×5 News sentiment coverage by year: how many tagged insights, and the share downbeatranking · 2026-07-16 · 3×3Preview: 3 ranked values, smallest first.
An illustrative $10,000 SPY stake from year end 2005, marked at each year end

An illustrative $10,000 SPY stake from year end 2005, marked at each year end

most recentas of ranking 21×3read in context →
An illustrative $10,000 SPY stake from year end 2005, marked at each year end — 21 rows by 3 columns, computed from US exchange, SIP and OPRA data.
yearmultiple_of_startstake_value_usd
2005110000
20061.1411359
20071.1811755
20080.727247
20090.898947
20101.0110100
20111.0110083
20121.1411437
20131.4814816
20141.6516500
20151.6416372
20161.7917947
20172.1421426
20182.0120080
20192.5825842
2020330014
20213.8138125
20223.0730703
20233.8238162
20244.747046
20255.4754740
the exact SQL behind every number 
WITH ye AS (
    SELECT toYear(toTimeZone(window_start, 'America/New_York')) AS year,
           argMax(close, window_start) AS px
    FROM global_markets.delayed_stocks_minute_aggs
    WHERE ticker = 'SPY'
      AND toDate(toTimeZone(window_start, 'America/New_York')) BETWEEN toDate('2005-12-01') AND toDate('2025-12-31')
      AND (toHour(toTimeZone(window_start, 'America/New_York')) * 60
           + toMinute(toTimeZone(window_start, 'America/New_York'))) BETWEEN 570 AND 959
    GROUP BY year
),
base AS (
    SELECT px FROM ye WHERE year = 2005
)
SELECT a.year AS year,
       round(a.px / (SELECT px FROM base), 2) AS multiple_of_start,
       round(10000 * a.px / (SELECT px FROM base), 0) AS stake_value_usd
FROM ye AS a
WHERE a.year >= 2005
ORDER BY year
More from this analysisThe 8-4-3 Rule for Mutual Funds, Explained
SPY calendar-year price change vs the 12% assumption, 2006-2025 ranking 20×3 → Annualized SPY price growth over rolling eight-year windows, by starting year end ranking 14×3 → How a two-decade streak compounds: Microsoft's annual dividend, year by year ranking 22×2 → Dividend growth champions: 20+ straight years of raises, ranked by how many times over the payout grew ranking 20×3 → See all 2,170 queries →
$