STRASMORE/EXPLORE 2,549 QUERIES

gme_short_interest

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-24, from what-is-a-gamma-squeeze.

as of series 18×4read in context →
gme_short_interest — 18 rows by 4 columns, computed from US exchange, SIP and OPRA data.
settlement_datesettle_labelshort_interest_millionsdays_to_cover
2020-10-152020年10月15日70.33.55
2020-10-302020年10月30日66.88.11
2020-11-132020年11月13日67.514.05
2020-11-302020年11月30日688.72
2020-12-152020年12月15日68.16.89
2020-12-312020年12月31日71.26.14
2021-01-152021年1月15日61.82.1
2021-01-292021年1月29日21.41
2021-02-122021年2月12日16.51
2021-02-262021年2月26日14.21
2021-03-152021年3月15日10.21
2021-03-312021年3月31日10.71
2021-04-152021年4月15日11.11.13
2021-04-302021年4月30日11.82.11
2021-05-142021年5月14日123.15
2021-05-282021年5月28日121.45
2021-06-152021年6月15日9.71
2021-06-302021年6月30日8.21.56
Rows × columns
18 × 4
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 gme_short_interest, derived from the stored result.
ColumnTypeRangeNotes
settlement_date date 2020-10-15 to 2021-06-30
settle_label text 18 distinct values (2020年10月15日, 2020年10月30日, 2020年11月13日…)
short_interest_millions number 8.2 to 71.2
days_to_cover number 1 to 14.05

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.

Run it yourself

This is the exact query behind the result above. Change a ticker, a date or a column and run it against the warehouse — no account, no key. The no-signup tier is smaller than the one this page was computed on; a query that reaches past it comes back saying which plan runs it.

SELECT
    toString(d)                                                       AS settlement_date,
    concat(toString(toYear(d)), '年',
           toString(toMonth(d)), '月',
           toString(toDayOfMonth(d)), '日')                            AS settle_label,
    short_interest_millions,
    days_to_cover
FROM
(
    SELECT
        settlement_date                       AS d,
        round(max(short_interest) / 1e6, 1)   AS short_interest_millions,
        round(max(days_to_cover), 2)          AS days_to_cover
    FROM global_markets.stocks_short_interest
    WHERE ticker = 'GME'
      AND settlement_date BETWEEN '2020-10-01' AND '2021-06-30'
    GROUP BY settlement_date
)
ORDER BY d
⌘/Ctrl + Enter

このデータをAIアシスタントで使う

このページのデータで、すぐにクエリできる状態で開きます。無料、アカウント不要。