QQQ by half-hour: February 24, 2022 regular session

Name: QQQ by half-hour: February 24, 2022 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 Feb 24, 2022: War at the Open, Green by Close.

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

QQQ by half-hour: February 24, 2022 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	325.41	318.26	18.6
10:00	326.04	323.11	13.8
10:30	328.14	324.6	9.5
11:00	329.12	327.3	8
11:30	330.29	327.6	6.1
12:00	328.03	326.93	6
12:30	328.18	327.16	4.7
13:00	328.8	327.76	5.1
13:30	331.72	328.77	7.6
14:00	333.3	330.7	7.6
14:30	335.94	333.29	8.1
15:00	336.89	335.48	7.3
15:30	340.65	336.82	15

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 QQQ by half-hour: February 24, 2022 regular session, derived from the stored result.
Column	Type	Range	Notes
`et_time`	date	09:30 to 15:30
`bucket_close`	number	325.41 to 340.65	US dollars
`bucket_low`	number	318.26 to 336.82	US dollars
`shares_m`	number	4.7 to 18.6	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 = 'QQQ'
  AND window_start >= toDateTime('2022-02-24 04:00:00') AND window_start < toDateTime('2022-02-24 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 analysisFeb 24, 2022: War at the Open, Green by Close

QQQ daily closes, February 22 – March 14, 2022 series 15×4 → 2-year and 10-year Treasury yields, February 18 – March 8, 2022 (%) series 12×3 → QQQ sessions since 2003: intraday low ≤ −3% vs prior close AND close ≥ +1% series 2×4 → Eleven tickers on February 24, 2022: gap, intraday extremes, close (% vs prior close) table 11×6 → After the reversal: when QQQ broke the invasion-day low, and how far it fell scalar 1×10 → QQQ on February 24, 2022: the invasion-day reversal, receipted scalar 1×14 → See all 2,170 queries →