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

3,127 answered market questions

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

Is a Covered Put Actually Covered?
One month of a crowded short, January 2021series · 2026-10-06 · 24×4Preview: a 16-point series, roughly flat. Twelve months of dividends a short seller owes, per shareranking · 2026-10-06 · 8×4Preview: 8 ranked values, largest first. Days to cover the reported short interest, household namesranking · 2026-10-06 · 8×3Preview: 8 ranked values, largest first. Best and worst 21-session moves since 2021ranking · 2026-10-06 · 6×3Preview: 6 ranked values, largest first.
One month of a crowded short, January 2021

One month of a crowded short, January 2021

most recentas of series 24×4read in context →
One month of a crowded short, January 2021 — 24 rows by 4 columns, computed from US exchange, SIP and OPRA data.
datedate_labelchange_vs_start_pctwindow_peak_vs_start_pct
2021-01-04Jan 4, 202101914.6
2021-01-05Jan 5, 20210.71914.6
2021-01-06Jan 6, 20216.41914.6
2021-01-07Jan 7, 20214.81914.6
2021-01-08Jan 8, 20212.61914.6
2021-01-11Jan 11, 202115.61914.6
2021-01-12Jan 12, 202115.71914.6
2021-01-13Jan 13, 2021821914.6
2021-01-14Jan 14, 2021131.41914.6
2021-01-15Jan 15, 2021105.81914.6
2021-01-19Jan 19, 2021128.21914.6
2021-01-20Jan 20, 2021126.81914.6
2021-01-21Jan 21, 2021149.41914.6
2021-01-22Jan 22, 2021276.91914.6
2021-01-25Jan 25, 2021345.21914.6
2021-01-26Jan 26, 2021757.91914.6
2021-01-27Jan 27, 20211914.61914.6
2021-01-28Jan 28, 20211022.31914.6
2021-01-29Jan 29, 20211784.11914.6
2021-02-01Feb 1, 20211204.31914.6
2021-02-02Feb 2, 2021421.71914.6
2021-02-03Feb 3, 2021435.71914.6
2021-02-04Feb 4, 2021210.11914.6
2021-02-05Feb 5, 2021269.71914.6
the exact SQL behind every number 
WITH px AS
(
    SELECT
        date,
        toFloat64(close) AS c
    FROM global_markets.stocks_daily_aggs
    WHERE ticker = 'GME'
      AND date >= '2021-01-04'
      AND date <= '2021-02-05'
),
anchor AS
(
    SELECT
        argMin(c, date) AS first_close,
        max(c)          AS peak_close
    FROM px
)
SELECT
    toString(px.date)                                            AS date,
    formatDateTime(px.date, '%b %e, %Y')                         AS date_label,
    round((px.c / anchor.first_close - 1) * 100, 1)               AS change_vs_start_pct,
    round((anchor.peak_close / anchor.first_close - 1) * 100, 1)  AS window_peak_vs_start_pct
FROM px
CROSS JOIN anchor
ORDER BY px.date
More from this analysisIs a Covered Put Actually Covered?
Twelve months of dividends a short seller owes, per share ranking 8×4 → Days to cover the reported short interest, household names ranking 8×3 → Best and worst 21-session moves since 2021 ranking 6×3 → SPY intraday travel: close, high and low against the open, June 1 to July 10, 2026 series 28×5 → See all 3,127 queries →
$