STRASMORE/EXPLORE 2,170 QUERIES 22Y EQUITIES · 12Y OPTIONS

2,170 answered market questions

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

When Is Short Interest Released?
The short interest release schedule: recent FINRA settlement dates and names reportedseries · 2026-08-22 · 16×2Preview: a 16-point series, ending lower. Measured publication lag: settlement date vs the day the file first arrived hereseries · 2026-08-22 · 10×3Preview: a 10-point series, ending lower. The publication lag in one row: fastest, median and slowest across incrementally-delivered settlementsscalar · 2026-08-22 · 1×410 Day-of-month and the gap between consecutive settlement dates: the twice-monthly cadenceseries · 2026-08-22 · 16×3Preview: a 16-point series, ending lower. The current state of the release cycle: the newest print on file and the settlement still pendingscalar · 2026-08-22 · 1×631
What Is FINRA Short Interest? Days to Cover
TSLA short interest vs. average daily volume, bi-monthly (last 2 years)series · 2026-08-22 · 47×3Preview: a 16-point series, ending higher. Short interest reporting dates: recent settlements, weekday, coverage and publication lagseries · 2026-08-22 · 9×5Preview: a 9-point series, roughly flat. How liquid US stocks distribute by short interest as a percent of shares outstandingranking · 2026-08-22 · 5×4Preview: 5 ranked values, largest first. The latest FINRA short interest file: one snapshot of the whole marketscalar · 2026-08-22 · 1×422,339 GameStop, Nov 2020 – Mar 2021: short interest, days to cover and the closing price at each settlementseries · 2026-08-22 · 10×4Preview: a 10-point series, ending higher. Days to cover across all liquid US tickers, latest settlement (min 1M shares/day)scalar · 2026-08-22 · 1×62,632 Six household names at the latest settlement: shares short, percent of shares outstanding, days to covertable · 2026-08-22 · 6×6
Short Interest vs Short Volume: The Difference
Data points per dataset: AAPL, last 60 daysranking · 2026-08-22 · 2×2Preview: 2 ranked values, smallest first. Highest days to cover, latest settlement date (min 1M shares/day traded)ranking · 2026-08-22 · 10×3Preview: 10 ranked values, largest first. AAPL daily short volume ratio (last ~60 days)series · 2026-08-22 · 33×2Preview: a 16-point series, roughly flat. AAPL short interest vs. average daily volume, bi-monthly (last 2 years)series · 2026-08-22 · 47×3Preview: a 16-point series, roughly flat. AAPL days to cover at each settlement date (last 2 years)series · 2026-08-22 · 47×3Preview: a 16-point series, roughly flat.
FINRA Margin Debt Statistics, Explained
Largest month-over-month declines in SPY month-end closesranking · 2026-08-22 · 10×2Preview: 10 ranked values, smallest first. What the market does between the month-end as-of date and a third-week releaseseries · 2026-08-22 · 21×5Preview: a 16-point series, ending lower. Month-end closes that set a new high for the window, by year (SPY)ranking · 2026-08-22 · 21×4Preview: 16 ranked values, largest first. How far SPY travels between month end and the third-week release windowranking · 2026-08-22 · 6×3Preview: 6 ranked values, largest first.
Reg T Margin vs Portfolio Margin Explained
SPY realized volatility and worst session, by calendar yearranking · 2026-08-09 · 20×4Preview: 16 ranked values, smallest first. SPY daily moves and drawdown, February to April 2020series · 2026-08-09 · 45×4Preview: a 16-point series, ending lower. Worst one-session and five-session declines since January 2015ranking · 2026-08-09 · 6×3Preview: 6 ranked values, smallest first. Average implied volatility by strike distance from spot, SPY, May to June 2026ranking · 2026-08-09 · 9×3Preview: 9 ranked values, largest first.
FINRA Short Interest Data, Explained
Daily short-volume file coverage: the two documented truncation days vs their neighborsranking · 2026-07-26 · 6×2Preview: 6 ranked values, smallest first. Percent of reported volume marked short: five large caps on an ordinary day (July 10, 2026)table · 2026-07-26 · 5×6 History depth of both FINRA short-sale datasets in this warehousescalar · 2026-07-26 · 1×4206 Every 2026 settlement date on file, with the securities each print coversseries · 2026-07-26 · 13×3Preview: a 13-point series, ending higher. Settlement dates per year in the short interest file, 2018–2026ranking · 2026-07-26 · 9×2Preview: 9 ranked values, smallest first. AAPL in the short interest file: the five most recent settlement printstable · 2026-07-26 · 5×5
The short interest release schedule: recent FINRA settlement dates and names reported

The short interest release schedule: recent FINRA settlement dates and names reported

most recentas of series 16×2read in context →
The short interest release schedule: recent FINRA settlement dates and names reported — 16 rows by 2 columns, computed from US exchange, SIP and OPRA data.
settlement_datenames_reported
2026-07-3122339
2026-07-1522373
2026-06-3022207
2026-06-1522178
2026-05-2921987
2026-05-1521894
2026-04-3021820
2026-04-1521757
2026-03-3121678
2026-03-1321587
2026-02-2721576
2026-02-1321528
2026-01-3021373
2026-01-1521262
2025-12-3121200
2025-12-1521105
the exact SQL behind every number
SELECT settlement_date,
       count() AS names_reported
FROM global_markets.stocks_short_interest
GROUP BY settlement_date
ORDER BY settlement_date DESC
LIMIT 16
$