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

2,173 answered market questions

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

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
Daily short-volume file coverage: the two documented truncation days vs their neighbors

Daily short-volume file coverage: the two documented truncation days vs their neighbors

most recentas of ranking 6×2read in context →
Daily short-volume file coverage: the two documented truncation days vs their neighbors — 6 rows by 2 columns, computed from US exchange, SIP and OPRA data.
dtickers_on_file
2026-06-2615052
2026-06-295489
2026-06-3015362
2026-07-0615384
2026-07-074333
2026-07-0815127
the exact SQL behind every number 
SELECT toString(date) AS d,
       uniqExact(ticker) AS tickers_on_file
FROM global_markets.stocks_short_volume
WHERE date IN ('2026-06-26', '2026-06-29', '2026-06-30', '2026-07-06', '2026-07-07', '2026-07-08')
GROUP BY date
ORDER BY date
More from this analysisFINRA Short Interest Data, Explained
Settlement dates per year in the short interest file, 2018–2026 ranking 9×2 → Every 2026 settlement date on file, with the securities each print covers series 13×3 → 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 → See all 2,173 queries →
$