Reported short interest across the same dividend payers
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-08-22, from Payment in Lieu of Dividends, Explained.
| ticker | short_interest_millions | settled_label |
|---|---|---|
| PFE | 161.5 | Jul 31, 2026 |
| AAPL | 141.6 | Jul 31, 2026 |
| MSFT | 81.3 | Jul 31, 2026 |
| KO | 44.8 | Jul 31, 2026 |
| XOM | 42.3 | Jul 31, 2026 |
| PEP | 29.4 | Jul 31, 2026 |
| MRK | 28.3 | Jul 31, 2026 |
| PG | 27.1 | Jul 31, 2026 |
| JNJ | 25.4 | Jul 31, 2026 |
| IBM | 22.3 | Jul 31, 2026 |
| CVX | 20.3 | Jul 31, 2026 |
- Rows × columns
- 11 × 3
- 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 | 11 distinct values (AAPL, CVX, IBM…) | |
short_interest_millions |
number | 20.3 to 161.5 | |
settled_label |
text | 1 distinct value (Jul 31, 2026) |
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
ticker,
round(argMax(short_interest, settlement_date) / 1e6, 1) AS short_interest_millions,
formatDateTime(max(settlement_date), '%b %e, %Y') AS settled_label
FROM global_markets.stocks_short_interest
WHERE ticker IN ('AAPL', 'MSFT', 'JNJ', 'PG', 'KO', 'PEP', 'XOM', 'CVX', 'MRK', 'IBM', 'PFE')
AND settlement_date >= today() - 75
GROUP BY ticker
ORDER BY short_interest_millions 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 analysisPayment in Lieu of Dividends, Explained
PFE short interest by settlement date, Aug 2025 through Jul 2026
series 24×3
→
Ex-dividend events per month across the whole US calendar
series 12×4
→
The most recent regular dividend for eleven household names
table 11×5
→
Days to cover: household names against the most in-demand liquid borrows
ranking 10×2
→
Cash paid per share and payment count, trailing year
ranking 8×3
→
Share of reported KO volume marked short, by session
series 69×3
→
See all 2,170 queries →