STRASMORE/EXPLORE 3,256 QUERIES 22Y EQUITIES · 12Y OPTIONS

3,256 answered market questions

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

Short Selling Bans Explained: US, Germany, EU
What ESMA measured during the 2020 bans (published estimates, % versus the control group)ranking · 2026-09-15 · 4×2Preview: 4 ranked values, largest first. Every outright short selling ban since 2008, dated to the order that set ittable · 2026-09-15 · 9×5
IPO Quiet Period Rules and Timeline
Days from announced deal to first trade, US listings since January 2025ranking · 2026-08-19 · 7×3Preview: 7 ranked values, largest first. The three clocks, dated, for the largest US listings since January 2025table · 2026-08-19 · 10×7
How to Become a Registered Market Maker
Average quoted spread across six household names, midday July 16 2026ranking · 2026-08-15 · 6×3Preview: 6 ranked values, smallest first. Quoted spread through one session, AAPL and KO, July 16 2026series · 2026-08-15 · 26×3Preview: a 16-point series, ending lower. Venues publishing a bid in AAPL over one half hour, July 16 2026ranking · 2026-08-15 · 16×4Preview: 16 ranked values, largest first. Listed AAPL option contracts by expiration, July 16 2026series · 2026-08-15 · 24×4Preview: a 16-point series, ending lower.
The Vendor Display Rule: SEC Rule 603(c)
Consolidated spread vs single venue spread, AAPL, June 17 2026series · 2026-08-10 · 90×4Preview: a 16-point series, ending lower. Where AAPL trades printed, June 17 2026, 10:00 to 11:30 ETranking · 2026-08-10 · 17×3Preview: 16 ranked values, largest first. Which venue held the national best bid in AAPL, June 17 2026, 10:00 to 11:30 ETranking · 2026-08-10 · 16×3Preview: 16 ranked values, largest first.
What ESMA measured during the 2020 bans (published estimates, % versus the control group)

What ESMA measured during the 2020 bans (published estimates, % versus the control group)

most recentas of ranking 4×2read in context →
What ESMA measured during the 2020 bans (published estimates, % versus the control group) — 4 rows by 2 columns, computed from US exchange, SIP and OPRA data.
measurepublished_effect_pct
Bid-ask spread8
Amihud illiquidity5.8
Volume traded-14.9
Volatility-8.4
the exact SQL behind every number 
SELECT
    measure,
    published_effect_pct
FROM
(
    SELECT 'Bid-ask spread' AS measure, 8.0 AS published_effect_pct, 1 AS display_order
    UNION ALL
    SELECT 'Amihud illiquidity', 5.8, 2
    UNION ALL
    SELECT 'Volume traded', -14.9, 3
    UNION ALL
    SELECT 'Volatility', -8.4, 4
)
ORDER BY display_order
More from this analysisShort Selling Bans Explained: US, Germany, EU
Every outright short selling ban since 2008, dated to the order that set it table 9×5 → Peak multiple: highest print divided by the last close before the squeeze ranking 5×4 → Documented short-seller losses, billions, as estimated at the time table 3×5 → Market value swing: capitalization before the squeeze and at the peak, billions table 2×5 → See all 3,256 queries →
$