STRASMORE/EXPLORE 2,214 QUERIES

market_value_swing

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-12, from biggest-short-squeezes-in-history.

as of table 2×5read in context →
market_value_swing — 2 rows by 5 columns, computed from US exchange, SIP and OPRA data.
episodebefore_bnpeak_bnunitsource
Volkswagen, Oct 200860296EUROct 24, 2008 close against the €1,005 print of Oct 28; FT and Reuters reporting
GameStop, Jan 20211.324USDDec 31, 2020 close against the $347.51 close of Jan 27, 2021; NYSE prints
Rows × columns
2 × 5
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 market_value_swing, derived from the stored result.
ColumnTypeRangeNotes
episode text 2 distinct values (GameStop, Jan 2021, Volkswagen, Oct 2008)
before_bn number 1.3 to 60
peak_bn number 24 to 296
unit text 2 distinct values (EUR, USD)
source text 2 distinct values

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 episode, before_bn, peak_bn, unit, source
FROM (
    SELECT 'Volkswagen, Oct 2008' AS episode, 60.0 AS before_bn, 296.0 AS peak_bn, 'EUR' AS unit, 'Oct 24, 2008 close against the €1,005 print of Oct 28; FT and Reuters reporting' AS source
    UNION ALL
    SELECT 'GameStop, Jan 2021', 1.3, 24.0, 'USD', 'Dec 31, 2020 close against the $347.51 close of Jan 27, 2021; NYSE prints'
) AS ranked
ORDER BY peak_bn 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 analysisbiggest-short-squeezes-in-history
documented_losses table 3×5 → peak_multiple ranking 5×4 → The 2s10s spread, every print of the half table 124×2 → The 2s10s spread, every print of the half table 124×2 → Every half-year since 1976: the 2y and 10y change, the twist between them, and the half's lowest 2s10s print table 100×7 → SPY at one-minute resolution, 2:00–3:30 pm ET on May 6, 2010 table 90×4 → See all 2,214 queries →