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
When Is the COT Report Released?
Units versus dollars: seven funds tracking the markets the COT covers, July 2026ranking · 2026-08-04 · 7×4Preview: 7 ranked values, largest first. SPY: the move from Tuesday's close to Friday 3:30 pm ET, week by week, Aug 2025 to Jul 2026series · 2026-08-04 · 48×4Preview: a 16-point series, roughly flat. How far seven markets travel between Tuesday's close and Friday 3:30 pm ET, Aug 2024 to Jul 2026table · 2026-08-04 · 7×5 Where Friday volume sits on the clock: SPY, 15-minute buckets, full Friday sessions over the past yearseries · 2026-08-04 · 26×3Preview: a 16-point series, ending lower.
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
$