STRASMORE/EXPLORE 2,170 QUERIES

The latest FINRA short interest file: one snapshot of the whole market

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 What Is FINRA Short Interest? Days to Cover.

as of scalar 1×4read in context →
latest settlement date
July 31, 2026
tickers reported
22,339
tickers reported fmt
22,339
total shares short b
55.3
Rows × columns
1 × 4
Period covered
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 The latest FINRA short interest file: one snapshot of the whole market, derived from the stored result.
ColumnTypeRangeNotes
latest_settlement_date date July 31, 2
tickers_reported number every row is 22,339
tickers_reported_fmt text 1 distinct value (22,339)
total_shares_short_b number every row is 55.3 count

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 
WITH (SELECT max(settlement_date) FROM global_markets.stocks_short_interest) AS latest
SELECT concat(monthName(latest), ' ', toString(toDayOfMonth(latest)), ', ', toString(toYear(latest))) AS latest_settlement_date,
       count() AS tickers_reported,
       multiIf(count() < 1000, toString(count()),
               concat(toString(intDiv(count(), 1000)), ',', lpad(toString(count() % 1000), 3, '0'))) AS tickers_reported_fmt,
       round(sum(si) / 1e9, 1) AS total_shares_short_b
FROM
(
    SELECT ticker, max(short_interest) AS si
    FROM global_markets.stocks_short_interest
    WHERE settlement_date = latest
    GROUP BY ticker
)

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 analysisWhat Is FINRA Short Interest? Days to Cover
Days to cover across all liquid US tickers, latest settlement (min 1M shares/day) scalar 1×6 → TSLA short interest vs. average daily volume, bi-monthly (last 2 years) series 47×3 → GameStop, Nov 2020 – Mar 2021: short interest, days to cover and the closing price at each settlement series 10×4 → Short interest reporting dates: recent settlements, weekday, coverage and publication lag series 9×5 → Six household names at the latest settlement: shares short, percent of shares outstanding, days to cover table 6×6 → How liquid US stocks distribute by short interest as a percent of shares outstanding ranking 5×4 → See all 2,170 queries →