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

2,214 answered market questions

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

what-is-an-implied-volatility-index
term_structureseries · 2026-09-12 · 13×5Preview: a 13-point series, ending lower. iv_screenerranking · 2026-09-12 · 6×4Preview: 6 ranked values, largest first. iv30_traceseries · 2026-09-12 · 54×5Preview: a 16-point series, ending higher. bracket_legstable · 2026-09-12 · 2×7
what-happens-after-a-reverse-stock-split
ratio_bucketsranking · 2026-09-12 · 5×3Preview: 5 ranked values, largest first. monthly_countsseries · 2026-09-12 · 24×5Preview: a 16-point series, ending higher. forward_returnsranking · 2026-09-12 · 3×4Preview: 3 ranked values, largest first.
what-are-single-stock-futures
margin_comparisonranking · 2026-09-12 · 4×4Preview: 4 ranked values, largest first. carry_illustrationranking · 2026-09-12 · 5×4Preview: 5 ranked values, smallest first.
the-7-percent-sell-rule
stop_distance_sizingranking · 2026-09-12 · 3×2Preview: 3 ranked values, largest first. recovery_hurdleranking · 2026-09-12 · 6×3Preview: 6 ranked values, smallest first.
mo-dividend-increase-history
spinoff_resetsseries · 2026-09-12 · 16×3Preview: a 16-point series, ending lower. raisesseries · 2026-09-12 · 21×7Preview: a 16-point series, ending lower. payment_calendarseries · 2026-09-12 · 4×6Preview: a 4-point series, ending higher. fcf_coveragetable · 2026-09-12 · 6×5 cadenceseries · 2026-09-12 · 2×5Preview: a 2-point series, ending higher.
how-the-ipo-opening-price-is-set
regular_openseries · 2026-09-12 · 5×2Preview: a 5-point series, ending higher. new_symbolsseries · 2026-09-12 · 10×4Preview: a 10-point series, roughly flat.
fed-call-vs-house-call
margin_call_linestable · 2026-09-12 · 3×5 close_at_65table · 2026-09-12 · 2×7
biggest-short-squeezes-in-history
peak_multipleranking · 2026-09-12 · 5×4Preview: 5 ranked values, largest first. market_value_swingtable · 2026-09-12 · 2×5 documented_lossestable · 2026-09-12 · 3×5
which-stocks-have-weekly-options
weekly_shareranking · 2026-09-11 · 4×2Preview: 4 ranked values, largest first. weekly_leadersranking · 2026-09-11 · 25×4Preview: 16 ranked values, largest first. by_weekdayranking · 2026-09-11 · 6×2Preview: 6 ranked values, smallest first. aapl_chainseries · 2026-09-11 · 12×5Preview: a 12-point series, ending higher.
Weekly Market Recap: The Week in Numbers
Where the volume went: most dollars traded over the past weekranking · 2026-09-11 · 8×2Preview: 8 ranked values, largest first. The eleven S&P 500 sectors over the past weekranking · 2026-09-11 · 11×2Preview: 11 ranked values, largest first. Biggest stock losers over the past weekranking · 2026-09-11 · 7×3Preview: 7 ranked values, smallest first. The major index ETFs over the past weekranking · 2026-09-11 · 4×4Preview: 4 ranked values, largest first. Biggest stock gainers over the past weekranking · 2026-09-11 · 7×3Preview: 7 ranked values, largest first. Daily market breadth: advancers vs decliners each session (names trading $500M+)series · 2026-09-11 · 5×3Preview: a 5-point series, ending higher.
Upcoming Stock Splits Calendar
Upcoming US stock splits: announced, with a future effective datetable · 2026-09-11 · 30×5 Announced upcoming splits by directionranking · 2026-09-11 · 2×2Preview: 2 ranked values, smallest first. Announced stock splits by effective month: forward vs reverseseries · 2026-09-11 · 4×4Preview: a 4-point series, ending lower.
Upcoming Ex-Dividend Dates: Stocks This Week
Three household payers at their last ex-date: prior close, ex-morning open, and the payment for scaleseries · 2026-09-11 · 3×8Preview: a 3-point series, roughly flat. Who goes ex-dividend in the next 14 days: names, cadence and implied yield by size bandtable · 2026-09-11 · 4×5 Names going ex-dividend, day by day: the next seven days of declared recordsseries · 2026-09-11 · 5×5Preview: a 5-point series, roughly flat. Ex-dividend dates by calendar month: three-year average, quarterly vs monthly payersseries · 2026-09-11 · 12×4Preview: a 12-point series, ending higher. Thirteen big dividend and income funds: last ex-date, cadence, and the implied next ex-dateseries · 2026-09-11 · 13×8Preview: a 13-point series, roughly flat. Forward-declared ex-dividend records on file: the receipt behind this calendarscalar · 2026-09-11 · 1×53,915 Every mega-cap ex-dividend event of the past six months: price path from the pre-ex closetable · 2026-09-11 · 5×6 Largest companies going ex-dividend in the next 14 days: amount, pay date, indicated yieldseries · 2026-09-11 · 12×8Preview: a 12-point series, ending higher.
Unusual Options Activity: Last Session
Market-wide options volume by session, with monthly expirations labelledseries · 2026-09-11 · 25×5Preview: a 16-point series, ending higher. Calls or puts: the board's call and put contract volume on the same sessiontable · 2026-09-11 · 10×5 What follows a heavy options session: next-session absolute move vs. the same names on an ordinary daytable · 2026-09-11 · 5×6 What the session's contracts were made of: options volume by days to expiryranking · 2026-09-11 · 6×4Preview: 6 ranked values, largest first. Unusual options activity: last completed session vs. each underlying's own 20-session averagetable · 2026-09-11 · 10×8
stop-orders-on-options
spy_put_traceseries · 2026-09-11 · 10×5Preview: a 10-point series, ending lower. spy_put_daily_movesranking · 2026-09-11 · 4×3Preview: 4 ranked values, smallest first. aapl_contracts_by_volumeranking · 2026-09-11 · 5×3Preview: 5 ranked values, largest first.
Short Squeeze Candidates This Week
Squeeze-shaped mechanics: crowded shorts among liquid names, with a rising priceranking · 2026-09-11 · 12×4Preview: 12 ranked values, largest first. The screened names ranked by short interest against shares outstanding (not float)table · 2026-09-11 · 10×5 Every past screened name, by what it did over the next 30 daysranking · 2026-09-11 · 6×3Preview: 6 ranked values, smallest first. From the whole settlement file down to the screened list, one rule at a timeranking · 2026-09-11 · 4×2Preview: 4 ranked values, largest first. Every input behind this screen, and how many days old it isseries · 2026-09-11 · 3×3Preview: a 3-point series, ending lower. Liquid names at 5+ and 10+ days to cover, settlement by settlementseries · 2026-09-11 · 12×4Preview: a 12-point series, ending higher.
Recent Stock Splits (Forward and Reverse)
Forward vs reverse splits executed in the last 45 daysranking · 2026-09-11 · 2×2Preview: 2 ranked values, largest first. Recent reverse stock splits (shares consolidated), last 30 daysranking · 2026-09-11 · 15×4Preview: 15 ranked values, largest first. Recent forward stock splits (shares multiplied), last 60 days, ETFs excludedranking · 2026-09-11 · 15×4Preview: 15 ranked values, largest first.
Most Shorted Stocks Right Now, Measured
The receipts: universe size, filter bite, median crowding, and list churn at the latest printscalar · 2026-09-11 · 1×522,567 Largest short positions by shares: latest settlement, liquid namesranking · 2026-09-11 · 10×4Preview: 10 ranked values, largest first. Crowding leaders vs. their own price: about one month of sessionsseries · 2026-09-11 · 4×5Preview: a 4-point series, ending higher. GME through the January 2021 squeeze: the same three columns, settlement by settlementseries · 2026-09-11 · 10×4Preview: a 10-point series, ending lower. Today's top-3 crowding leaders, traced back eight settlementsseries · 2026-09-11 · 8×4Preview: a 8-point series, ending higher. Biggest days-to-cover increases, latest settlement vs. the prior printranking · 2026-09-11 · 8×4Preview: 8 ranked values, largest first. Highest days to cover among liquid names: latest settlement on filetable · 2026-09-11 · 10×5
Stock Market Holidays 2026–2027: NYSE & Nasdaq
Upcoming US stock market holidays and early closesseries · 2026-09-11 · 12×6Preview: a 12-point series, ending higher. Recently-passed weekday closures, recovered from the SPY tapeseries · 2026-09-11 · 3×3Preview: a 3-point series, roughly flat. Regular trading sessions over the trailing yearscalar · 2026-09-11 · 1×3251 The closure calendar ahead, at a glancescalar · 2026-09-11 · 1×610
Is the Stock Market Open Today?
This calendar year's closures: already passed (counted from the tape) plus still ahead (from the calendar)table · 2026-09-11 · 2×5 SPY across recent weekends and holiday weekends: Friday's close vs. the reopening printseries · 2026-09-11 · 10×6Preview: a 10-point series, ending lower. Every upcoming NYSE closure and early close on the calendar feed, with a countdownseries · 2026-09-11 · 12×6Preview: a 12-point series, ending higher. Unscheduled closures on the tape: zero regular-session bars on an ordinary weekdayseries · 2026-09-11 · 5×4Preview: a 5-point series, roughly flat. Market status computed at this page's refresh: weekday check, holiday check, and the ET clockscalar · 2026-09-11 · 1×70 The most recent session on the tape: bar count, same-day SPY options prints, and the last half-day observedscalar · 2026-09-11 · 1×6211 Weekdays in the trailing year when stocks traded but no Treasury yield printedtable · 2026-09-11 · 2×2
how-long-can-you-hold-a-short-position
maintenance_margin_scheduleranking · 2026-09-11 · 9×3Preview: 9 ranked values, smallest first. borrow_fee_daily_costranking · 2026-09-11 · 7×3Preview: 7 ranked values, smallest first.
Highest Implied Volatility Stocks Right Now
SPY, the same measurement: the market's calm benchmarkscalar · 2026-09-11 · 1×314.1 ATM implied volatility across every actively traded underlying, latest sessionscalar · 2026-09-11 · 1×5940 Highest ATM implied volatility: liquid single names and funds, latest sessiontable · 2026-09-11 · 12×5
Dividend Increases & Cuts This Week
Increases against cuts, by week of declaration (complete weeks only)series · 2026-09-11 · 26×4Preview: a 16-point series, roughly flat. Payers across their own share split: the raw change against the split-adjusted changeseries · 2026-09-11 · 9×7Preview: a 9-point series, ending lower. Increases, cuts and the typical raise this calendar year, by company size (bands use today's market value)table · 2026-09-11 · 4×6 Dividend increases declared in the last 7 days, largest companies first (capped at 12 rows)series · 2026-09-11 · 5×8Preview: a 5-point series, ending lower. Dividend cuts declared in the last 90 days, the deepest 14 first (one week is too thin for a table)series · 2026-09-11 · 14×6Preview: a 14-point series, ending higher.
Biggest Stock Gainers and Losers This Week
Biggest stock losers this week (names trading $1B+, leveraged/inverse ETFs excluded)ranking · 2026-09-11 · 10×4Preview: 10 ranked values, smallest first. The four major index ETFs this week, for contextranking · 2026-09-11 · 4×2Preview: 4 ranked values, largest first. Biggest stock gainers this week (names trading $1B+, leveraged/inverse ETFs excluded)ranking · 2026-09-11 · 10×4Preview: 10 ranked values, largest first.
Biggest Stock Movers This Month
The window and the screened universe behind every board on this pagescalar · 2026-09-11 · 1×521 Where every screened company landed: monthly returns by bucketranking · 2026-09-11 · 6×2Preview: 6 ranked values, largest first. Eight household mega-cap names over the same windowranking · 2026-09-11 · 8×2Preview: 8 ranked values, largest first. Biggest stock losers this month (companies trading $1B+ over the window)ranking · 2026-09-11 · 10×3Preview: 10 ranked values, smallest first. The four major index trackers across the same window, rebased to the first openseries · 2026-09-11 · 21×5Preview: a 16-point series, ending lower. Biggest stock gainers this month (companies trading $1B+ over the window)ranking · 2026-09-11 · 10×3Preview: 10 ranked values, largest first.
Biggest Stock Gainers & Losers of 2026
Excluded from the boards: 2026 splits large enough to fake a year-to-date moveseries · 2026-09-11 · 13×5Preview: a 13-point series, ending higher. The screen, stage by stage: how many names survive each filterranking · 2026-09-11 · 5×2Preview: 5 ranked values, largest first.
page 1 of 23
documented_losses

documented_losses

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
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
$