gme_tape
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.
| date | day_label | close_change_pct | high_low_range_pct | volume_millions |
|---|---|---|---|---|
| 2021-01-19 | 1月19日 | 10.9 | 24.2 | 301 |
| 2021-01-20 | 1月20日 | -0.6 | 14.2 | 134.7 |
| 2021-01-21 | 1月21日 | 10 | 20.9 | 228.7 |
| 2021-01-22 | 1月22日 | 51.1 | 81.4 | 789.5 |
| 2021-01-25 | 1月25日 | 18.1 | 160.4 | 718.5 |
| 2021-01-26 | 1月26日 | 92.7 | 87 | 716.7 |
| 2021-01-27 | 1月27日 | 134.8 | 52.6 | 378.8 |
| 2021-01-28 | 1月28日 | -44.3 | 330.3 | 237.4 |
| 2021-01-29 | 1月29日 | 67.9 | 65.6 | 203.9 |
| 2021-02-01 | 2月1日 | -30.8 | 51.9 | 150.7 |
| 2021-02-02 | 2月2日 | -60 | 112.9 | 314.3 |
| 2021-02-03 | 2月3日 | 2.7 | 33 | 172.5 |
| 2021-02-04 | 2月4日 | -42.1 | 71.6 | 250.3 |
| 2021-02-05 | 2月5日 | 19.2 | 85.9 | 326.4 |
- Rows × columns
- 14 × 5
- Period covered
- to
- Computed
- Completeness
- No missing values
- Source
- US exchange, SIP and OPRA market data
- Licence
- Strasmore terms · free, no signup
What each column holds
| Column | Type | Range | Notes |
|---|---|---|---|
date |
date | 2021-01-19 to 2021-02-05 | |
day_label |
text | 14 distinct values (1月19日, 1月20日, 1月21日…) | |
close_change_pct |
number | -60 to 134.8 | percent |
high_low_range_pct |
number | 14.2 to 330.3 | percent |
volume_millions |
number | 134.7 to 789.5 | count |
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 date,
day_label,
close_change_pct,
high_low_range_pct,
volume_millions
FROM
(
SELECT
date AS d,
concat(toString(toMonth(date)), '月', toString(toDayOfMonth(date)), '日') AS day_label,
round((toFloat64(close) / lagInFrame(toFloat64(close))
OVER (ORDER BY date ROWS BETWEEN 1 PRECEDING AND CURRENT ROW) - 1) * 100, 1) AS close_change_pct,
round((toFloat64(high) / toFloat64(low) - 1) * 100, 1) AS high_low_range_pct,
round(volume / 1e6, 1) AS volume_millions
FROM global_markets.stocks_daily_aggs
WHERE ticker = 'GME'
AND date BETWEEN '2021-01-11' AND '2021-02-05'
)
WHERE d >= '2021-01-19'
ORDER BY d
このデータをAIアシスタントで使う
このページのデータで、すぐにクエリできる状態で開きます。無料、アカウント不要。