STRASMORE/EXPLORE 2,214 QUERIES

documented_losses

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 3×5read in context →
documented_losses — 3 rows by 5 columns, computed from US exchange, SIP and OPRA data.
episodeloss_low_bnloss_high_bnunitsource
Volkswagen, Oct 20082030EURhedge fund losses, contemporaneous estimates reported Oct 28 to 29, 2008
GameStop, Jan 202119.7519.75USDS3 Partners mark-to-market for January 2021, reported Jan 29
LME nickel, Mar 202288USDTsingshan paper loss at the Mar 8, 2022 peak, as reported that day
Rows × columns
3 × 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 documented_losses, derived from the stored result.
ColumnTypeRangeNotes
episode text 3 distinct values
loss_low_bn number 8 to 20 US dollars
loss_high_bn number 8 to 30 US dollars
unit text 2 distinct values (EUR, USD)
source text 3 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, loss_low_bn, loss_high_bn, unit, source
FROM (
    SELECT 'Volkswagen, Oct 2008' AS episode, 20.0 AS loss_low_bn, 30.0 AS loss_high_bn, 'EUR' AS unit, 'hedge fund losses, contemporaneous estimates reported Oct 28 to 29, 2008' AS source
    UNION ALL
    SELECT 'GameStop, Jan 2021', 19.75, 19.75, 'USD', 'S3 Partners mark-to-market for January 2021, reported Jan 29'
    UNION ALL
    SELECT 'LME nickel, Mar 2022', 8.0, 8.0, 'USD', 'Tsingshan paper loss at the Mar 8, 2022 peak, as reported that day'
) AS ranked
ORDER BY loss_high_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
market_value_swing table 2×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 →