STRASMORE/EXPLORE 3,293 QUERIES 22Y EQUITIES · 12Y OPTIONS

3,293 answered market questions

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

Can German Retail Investors Short Stocks?
Aggregate short interest with no holder named: days to cover, household US namesranking · 2026-10-11 · 8×4Preview: 8 ranked values, largest first. What a put costs to hold: premium and daily decay by time to expiry (AAPL, Q3 2025)ranking · 2026-10-11 · 5×3Preview: 5 ranked values, smallest first. A minus one fund against its index, month by month (SPY vs SH, 2025)series · 2026-10-11 · 12×4Preview: a 12-point series, ending lower. Barrier touches: intraday high versus closing print, NVDA, Q3 2025table · 2026-10-11 · 10×5
Short Positions in German Stocks: Bundesanzeiger
Illustrative: four published positions and the Short-Quote they add up toranking · 2026-09-13 · 5×2Preview: 5 ranked values, smallest first.
Aggregate short interest with no holder named: days to cover, household US names

Aggregate short interest with no holder named: days to cover, household US names

most recentas of ranking 8×4read in context →
Aggregate short interest with no holder named: days to cover, household US names — 8 rows by 4 columns, computed from US exchange, SIP and OPRA data.
tickerreported_fordays_to_covershares_short
PFESep 304.41150.2M
KOSep 303.2653.2M
TSep 303.15124.4M
AAPLSep 303.03120.8M
NVDASep 302.82311.4M
FSep 302.61132.8M
MSFTSep 302.5561.1M
INTCSep 301.39167.2M
the exact SQL behind every number
SELECT
    ticker,
    formatDateTime(max(settlement_date), '%b %e')                                  AS reported_for,
    round(argMax(days_to_cover, settlement_date), 2)                               AS days_to_cover,
    concat(toString(round(argMax(short_interest, settlement_date) / 1e6, 1)), 'M') AS shares_short
FROM global_markets.stocks_short_interest
WHERE ticker IN ('AAPL', 'MSFT', 'NVDA', 'KO', 'INTC', 'F', 'PFE', 'T')
  AND ticker NOT IN ('SPCX')
  AND settlement_date >= today() - 120
GROUP BY ticker
ORDER BY days_to_cover DESC
$