short_interest_us
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-22, from can-german-retail-investors-short-stocks.
| ticker | reported_for | days_to_cover | shares_short |
|---|---|---|---|
| PFE | Aug 31 | 4.33 | 151.5M |
| T | Aug 31 | 4.25 | 125.3M |
| AAPL | Aug 31 | 3.53 | 139.7M |
| MSFT | Aug 31 | 3.18 | 74.5M |
| KO | Aug 31 | 2.67 | 39.3M |
| F | Aug 31 | 2.53 | 99M |
| NVDA | Aug 31 | 2.14 | 298.3M |
| INTC | Aug 31 | 1.69 | 152.2M |
- Rows × columns
- 8 × 4
- Computed
- Completeness
- No missing values
- Source
- US exchange, SIP and OPRA market data
- Licence
- Strasmore terms · free, no signup
What each column holds
| Column | Type | Range | Notes |
|---|---|---|---|
ticker |
text | 8 distinct values (AAPL, F, INTC…) | |
reported_for |
text | 1 distinct value (Aug 31) | |
days_to_cover |
number | 1.69 to 4.33 | |
shares_short |
text | 8 distinct values (125.3M, 139.7M, 151.5M…) |
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.
Run it yourself
This is the exact query behind the result above. Change a ticker, a date or a column and run it against the warehouse — no account, no key. The no-signup tier is smaller than the one this page was computed on; a query that reaches past it comes back saying which plan runs it.
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