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

Market Recap: June 2026
Short-interest settlements on file: May 29, June 15, and June 30ranking · 2026-07-26 · 3×2Preview: 3 ranked values, smallest first. 21 sessions, verified from the tape (Juneteenth closure receipt included)scalar · 2026-07-26 · 1×321 Treasury yields through June: 10-year, 2-year, and the 2s10s spreadranking · 2026-07-26 · 21×4Preview: 16 ranked values, smallest first. SPY, all 21 June sessions: close and close-over-close changeseries · 2026-07-26 · 21×3Preview: a 16-point series, ending lower. SPY sessions up vs down across the month, one cheap receiptscalar · 2026-07-26 · 1×49 June 2026: open to close, range, and regular-hours turnover for the four index ETFstable · 2026-07-26 · 4×7 June: whole-tape options contract volume and same-day-expiry share (one scan)scalar · 2026-07-26 · 1×31,477.9 June regular-hours dollar volume, whole tape (one reused-symbol listing excluded pending entity verification)ranking · 2026-07-26 · 8×3Preview: 8 ranked values, largest first. Ex-dividend events by day through Juneranking · 2026-07-26 · 22×2Preview: 16 ranked values, largest first. June's corporate calendar: dividends, splits, listings, filings (June 30 index gap disclosed)scalar · 2026-07-26 · 1×66,651 SPY median quoted spread: the June sample session against May's (second Wednesdays)series · 2026-07-26 · 2×4Preview: a 2-point series, ending higher. May, recomputed identically for contrast (one scan)scalar · 2026-07-26 · 1×31,394.6 Monthly returns, January through June 2026, recomputed live (SPY and QQQ)ranking · 2026-07-26 · 12×4Preview: 12 ranked values, largest first. The rank receipt: this June against every prior one (rank 1 = best; self-excluded)scalar · 2026-07-26 · 1×5-1.2 Every June on the tape: SPY, recomputed identically by year (session counts shown)ranking · 2026-07-26 · 23×3Preview: 16 ranked values, smallest first. Advancers vs decliners for June (close vs the last May close), liquidity filter disclosedscalar · 2026-07-26 · 1×44,240
Short-interest settlements on file: May 29, June 15, and June 30

Short-interest settlements on file: May 29, June 15, and June 30

most recentas of ranking 3×2read in context →
Short-interest settlements on file: May 29, June 15, and June 30 — 3 rows by 2 columns, computed from US exchange, SIP and OPRA data.
settlementtickers
2026-05-2921987
2026-06-1522178
2026-06-3022207
the exact SQL behind every number 
SELECT toString(settlement_date) AS settlement, count() AS tickers
FROM global_markets.stocks_short_interest
WHERE settlement_date >= toDate('2026-05-20')
  AND settlement_date <= toDate('2026-06-30')
GROUP BY settlement
ORDER BY settlement
More from this analysisMarket Recap: June 2026
Every June on the tape: SPY, recomputed identically by year (session counts shown) ranking 23×3 → Ex-dividend events by day through June ranking 22×2 → Treasury yields through June: 10-year, 2-year, and the 2s10s spread ranking 21×4 → Monthly returns, January through June 2026, recomputed live (SPY and QQQ) ranking 12×4 → See all 2,170 queries →
$