STRASMORE/EXPLORE 2,249 QUERIES

Every outright short selling ban since 2008, dated to the order that set it

Answered against 22 years of US equities and 12 years of US options data and published with the query that produced it. This result is stored as of 2026-09-15, from Short Selling Bans Explained: US, Germany, EU.

as of table 9×5read in context →
Every outright short selling ban since 2008, dated to the order that set it — 9 rows by 5 columns, computed from US exchange, SIP and OPRA data.
jurisdictioninstrumentin_force_fromin_force_tocalendar_days
United States (SEC)Emergency Order, Release 34-585922008-09-192008-10-0820
Germany (BaFin)General decrees of 18 May 20102010-05-192011-03-31317
Spain (CNMV)SSR Article 202020-03-172020-05-1863
Austria (FMA)SSR Article 202020-03-182020-05-1862
Belgium (FSMA)SSR Article 202020-03-182020-05-1862
France (AMF)SSR Article 202020-03-182020-05-1862
Greece (HCMC)SSR Article 202020-03-182020-05-1862
Italy (CONSOB)SSR Article 202020-03-182020-05-1862
South Korea (FSC)FSC decision of 5 November 20232023-11-062025-03-30511
Rows × columns
9 × 5
Period covered
to
Computed
Completeness
No missing values
Source
US exchange, SIP and OPRA market data
Licence
Strasmore terms · free, no signup
Formats
JSON · CSV · the SQL below

What each column holds

Column definitions for Every outright short selling ban since 2008, dated to the order that set it, derived from the stored result.
ColumnTypeRangeNotes
jurisdiction text 9 distinct values
instrument text 4 distinct values
in_force_from date 2008-09-19 to 2023-11-06
in_force_to date 2008-10-08 to 2025-03-30
calendar_days number 20 to 511

Computed from Strasmore's warehouse of US exchange, SIP and OPRA market data. Equity prices are delayed; options greeks and implied volatility are end-of-day. This result is stored, not recomputed on load — it is exactly the numbers that were returned on , and the query below is what returned them.

the exact SQL behind every number 
WITH bans AS
(
    SELECT 'United States (SEC)' AS jurisdiction, 'Emergency Order, Release 34-58592' AS instrument, '2008-09-19' AS in_force_from, '2008-10-08' AS in_force_to
    UNION ALL
    SELECT 'Germany (BaFin)', 'General decrees of 18 May 2010', '2010-05-19', '2011-03-31'
    UNION ALL
    SELECT 'Spain (CNMV)', 'SSR Article 20', '2020-03-17', '2020-05-18'
    UNION ALL
    SELECT 'Italy (CONSOB)', 'SSR Article 20', '2020-03-18', '2020-05-18'
    UNION ALL
    SELECT 'France (AMF)', 'SSR Article 20', '2020-03-18', '2020-05-18'
    UNION ALL
    SELECT 'Belgium (FSMA)', 'SSR Article 20', '2020-03-18', '2020-05-18'
    UNION ALL
    SELECT 'Austria (FMA)', 'SSR Article 20', '2020-03-18', '2020-05-18'
    UNION ALL
    SELECT 'Greece (HCMC)', 'SSR Article 20', '2020-03-18', '2020-05-18'
    UNION ALL
    SELECT 'South Korea (FSC)', 'FSC decision of 5 November 2023', '2023-11-06', '2025-03-30'
)
SELECT
    jurisdiction,
    instrument,
    in_force_from,
    in_force_to,
    dateDiff('day', toDate(in_force_from), toDate(in_force_to)) + 1 AS calendar_days
FROM bans
ORDER BY toDate(in_force_from), jurisdiction

Run your own version of this

The same 22 years of US equities and 12 years of options data are queryable in SQL or plain English. A free account runs 100 queries a day and takes no card.

More from this analysisShort Selling Bans Explained: US, Germany, EU
What ESMA measured during the 2020 bans (published estimates, % versus the control group) ranking 4×2 → 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 → Peak multiple: highest print divided by the last close before the squeeze ranking 5×4 → SPY at one-minute resolution, 2:00–3:30 pm ET on May 6, 2010 table 90×4 → Highest days to cover, latest settlement: 500k average-volume floor table 12×5 → See all 2,249 queries →