STRASMORE/EXPLORE 2,170 QUERIES

History depth of both FINRA short-sale datasets in this warehouse

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-07-26, from FINRA Short Interest Data, Explained.

as of scalar 1×4read in context →
settlement file start
2017-12-29
settlement prints
206
daily file start
2024-02-06
daily files
618
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 History depth of both FINRA short-sale datasets in this warehouse, derived from the stored result.
ColumnTypeRangeNotes
settlement_file_start date 2017-12-29
settlement_prints number every row is 206
daily_file_start date 2024-02-06
daily_files number every row is 618

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 toString(min(settlement_date)) AS settlement_file_start,
       uniqExact(settlement_date) AS settlement_prints,
       (SELECT toString(min(date)) FROM global_markets.stocks_short_volume) AS daily_file_start,
       (SELECT uniqExact(date) FROM global_markets.stocks_short_volume) AS daily_files
FROM global_markets.stocks_short_interest

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 analysisFINRA Short Interest Data, Explained
Every 2026 settlement date on file, with the securities each print covers series 13×3 → Settlement dates per year in the short interest file, 2018–2026 ranking 9×2 → Daily short-volume file coverage: the two documented truncation days vs their neighbors ranking 6×2 → Percent of reported volume marked short: five large caps on an ordinary day (July 10, 2026) table 5×6 → AAPL in the short interest file: the five most recent settlement prints table 5×5 → The latest FINRA short interest file: one snapshot of the whole market scalar 1×4 → See all 2,170 queries →