Latest complete session, half-hour path: closes, lows, and volume

Name: Latest complete session, half-hour path: closes, lows, and volume
Creator: Strasmore
Published: 2026-08-20
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-08-20, from SPCX: SpaceX Stock Price Decline From Peak.

as of 2026-08-20 series 7×4read in context →

Latest complete session, half-hour path: closes, lows, and volume — 7 rows by 4 columns, computed 2026-08-20 from US exchange, SIP and OPRA data.
et_time	close_px	bucket_low	vol_m
09:30	139.68	139.16	0.12
10:00	139.89	139.55	0.29
10:30	139.7	139.7	0.13
11:00	139.52	139.41	0.12
11:30	139.39	139.32	0.13
12:00	139.52	139.34	0.24
12:30	139.31	139.22	0.24

Rows × columns: 7 × 4
Period covered: 09:30 to 12:30
Computed: 2026-08-20
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 Latest complete session, half-hour path: closes, lows, and volume, derived from the stored result.
Column	Type	Range	Notes
`et_time`	date	09:30 to 12:30
`close_px`	number	139.31 to 139.89	US dollars
`bucket_low`	number	139.16 to 139.7	US dollars
`vol_m`	number	0.12 to 0.29

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-08-20, and the query below is what returned them.

the exact SQL behind every number

WITH latest_session AS (
    SELECT max(d) AS latest_d
    FROM (
        SELECT toDate(toTimeZone(window_start, 'America/New_York')) AS d
        FROM global_markets.delayed_stocks_minute_aggs
        WHERE ticker = 'SPCX'
          AND window_start >= '2026-06-12 00:00:00' AND window_start < now()
          AND (toHour(toTimeZone(window_start, 'America/New_York')) * 60 + toMinute(toTimeZone(window_start, 'America/New_York'))) BETWEEN 570 AND 959
        GROUP BY d
        HAVING count() >= 150
    )
)
SELECT
    formatDateTime(toTimeZone(toStartOfInterval(window_start, INTERVAL 30 MINUTE), 'America/New_York'), '%H:%i') AS et_time,
    round(toFloat64(argMax(close, window_start)), 2) AS close_px,
    round(toFloat64(min(low)), 2) AS bucket_low,
    round(toFloat64(sum(volume)) / 1e6, 2) AS vol_m
FROM global_markets.delayed_stocks_minute_aggs
WHERE ticker = 'SPCX'
  AND window_start >= '2026-06-12 00:00:00' AND window_start < now()
  AND toDate(toTimeZone(window_start, 'America/New_York')) = (SELECT latest_d FROM latest_session)
  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 analysisSPCX: SpaceX Stock Price Decline From Peak

Regular-hours session scoreboard: open, close, low, high, volume for every SPCX session since listing series 47×7 → Stock quote spread and depth by session: the four weeks from listing and the trailing three series 33×5 → SPY vs SPCX open-to-close, regular hours, trailing three weeks series 15×4 → Put/call volume ratio by session, trailing three weeks series 15×5 → Options quote spread and size at the touch, the sessions on file in the past week and a half series 4×6 → Latest session on file: the busiest SPCX option contracts by volume table 10×5 → See all 2,170 queries →