GME by half-hour: January 28, 2021 regular session

Name: GME by half-hour: January 28, 2021 regular session
Creator: Strasmore
Published: 2026-07-26
License: https://www.strasmore.com/terms/

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-07-26, from GameStop, Jan 28, 2021: $483 to $112 by Noon.

as of 2026-07-26 series 13×4read in context →

GME by half-hour: January 28, 2021 regular session — 13 rows by 4 columns, computed 2026-07-26 from US exchange, SIP and OPRA data.
et_time	bucket_close	bucket_low	shares_m
09:30	468.49	261.52	6.2
10:00	396.5	369.41	4.4
10:30	264.01	264.01	3.1
11:00	132	112.25	4.5
11:30	255.76	135	6.3
12:00	278.7	250.7	3.9
12:30	239.67	230.01	2.4
13:00	231.47	205.42	2.8
13:30	241.53	226.65	2.3
14:00	229	220.79	1.5
14:30	247.17	215	3.2
15:00	225.46	225.02	2.2
15:30	197.44	197.44	3.5

Rows × columns: 13 × 4
Period covered: 09:30 to 15:30
Computed: 2026-07-26
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 by half-hour: January 28, 2021 regular session, derived from the stored result.
Column	Type	Range	Notes
`et_time`	date	09:30 to 15:30
`bucket_close`	number	132 to 468.49	US dollars
`bucket_low`	number	112.25 to 369.41	US dollars
`shares_m`	number	1.5 to 6.3	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 2026-07-26, and the query below is what returned them.

the exact SQL behind every number

SELECT
    formatDateTime(toStartOfInterval(toTimeZone(window_start, 'America/New_York'), INTERVAL 30 MINUTE), '%H:%i') AS et_time,
    round(toFloat64(argMax(close, window_start)), 2) AS bucket_close,
    round(min(toFloat64(low)), 2) AS bucket_low,
    round(toFloat64(sum(volume)) / 1e6, 1) AS shares_m
FROM global_markets.delayed_stocks_minute_aggs
WHERE ticker = 'GME'
  AND window_start >= toDateTime('2021-01-28 04:00:00') AND window_start < toDateTime('2021-01-28 23:59:00')
  AND (toHour(toTimeZone(window_start, 'America/New_York')) * 60 + toMinute(toTimeZone(window_start, 'America/New_York'))) BETWEEN 570 AND 959
GROUP BY et_time
ORDER BY et_time

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 analysisGameStop, Jan 28, 2021: $483 to $112 by Noon

GME daily close and volume: December 1, 2020 to January 27, 2021 (as-traded prices) series 39×4 → GME daily close and volume: January 29 to February 9, 2021 series 8×4 → GME options trades by session: January 25–28, 2021 series 4×6 → GME reported short interest by settlement date: November 2020 to February 2021 ranking 8×3 → The restricted names on January 28, 2021: prior close vs close (ET regular session) ranking 5×4 → GME on January 28, 2021: receipted (as-traded, pre-2022-split prices) scalar 1×14 → See all 2,170 queries →