STRASMORE/EXPLORE 2,170 QUERIES

The month on one row: open, close, extremes, volume, and their receipts

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 NVDA: NVIDIA's Full June 2026, Tick by Tick.

as of scalar 1×25read in context →
month open
215.77
month close
199.76
month change pct
-7.4
month decline abs pct
7.4
peak close date
2026-06-01
peak close
224.43
month high
235
month high first bar et
2026-06-02 04:00
bars within cent of high
1
high minute trades
9,329
rth month high
232.28
rth high first bar et
2026-06-02 09:59
rth bars near high
1
month low
189.8
month low bar et
2026-06-29 10:17
bars within cent of low
1
low minute trades
43,131
rth month low
189.8
rth minus extended low
0
month shares bn
2.75
month dollar bn
571.9
rth dollar bn
523
rth shares bn
2.52
session days observed
21
spy bars june19
0
Rows × columns
1 × 25
Period covered
Computed
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 The month on one row: open, close, extremes, volume, and their receipts, derived from the stored result.
ColumnTypeRangeNotes
month_open number every row is 215.77 US dollars
month_close number every row is 199.76 US dollars
month_change_pct number every row is -7.4 percent
month_decline_abs_pct number every row is 7.4 percent
peak_close_date date 2026-06-01
peak_close number every row is 224.43 US dollars
month_high number every row is 235 US dollars
month_high_first_bar_et date 2026-06-02
bars_within_cent_of_high number every row is 1 US dollars
high_minute_trades number every row is 9,329 US dollars
rth_month_high number every row is 232.28 US dollars
rth_high_first_bar_et date 2026-06-02
rth_bars_near_high number every row is 1 US dollars
month_low number every row is 189.8 US dollars
month_low_bar_et date 2026-06-29
bars_within_cent_of_low number every row is 1 US dollars
low_minute_trades number every row is 43,131 US dollars
rth_month_low number every row is 189.8 US dollars
rth_minus_extended_low number every row is 0 US dollars
month_shares_bn number every row is 2.75 count
month_dollar_bn number every row is 571.9
rth_dollar_bn number every row is 523
rth_shares_bn number every row is 2.52 count
session_days_observed number every row is 21
spy_bars_june19 number every row is 0

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.

the exact SQL behind every number 
WITH
    (
        SELECT (toString(argMax(et_date, c)), max(c), argMax(c, et_date))
        FROM (
            SELECT
                toDate(toTimeZone(window_start, 'America/New_York')) AS et_date,
                argMax(toFloat64(close), window_start) AS c
            FROM global_markets.delayed_stocks_minute_aggs
            WHERE ticker = 'NVDA'
              AND window_start >= toDateTime('2026-06-01 00:00:00') AND window_start < toDateTime('2026-07-01 00:00:00')
              AND (toHour(window_start) * 60 + toMinute(window_start)) BETWEEN 810 AND 1199
            GROUP BY et_date
        )
    ) AS closes,
    (
        SELECT max(toFloat64(high)) FROM global_markets.delayed_stocks_minute_aggs
        WHERE ticker = 'NVDA'
          AND window_start >= toDateTime('2026-06-01 00:00:00') AND window_start < toDateTime('2026-07-01 00:00:00')
    ) AS hi,
    (
        SELECT min(toFloat64(low)) FROM global_markets.delayed_stocks_minute_aggs
        WHERE ticker = 'NVDA'
          AND window_start >= toDateTime('2026-06-01 00:00:00') AND window_start < toDateTime('2026-07-01 00:00:00')
    ) AS lo,
    (
        SELECT maxIf(toFloat64(high), (toHour(window_start) * 60 + toMinute(window_start)) BETWEEN 810 AND 1199)
        FROM global_markets.delayed_stocks_minute_aggs
        WHERE ticker = 'NVDA'
          AND window_start >= toDateTime('2026-06-01 00:00:00') AND window_start < toDateTime('2026-07-01 00:00:00')
    ) AS rth_hi,
    (
        SELECT minIf(toFloat64(low), (toHour(window_start) * 60 + toMinute(window_start)) BETWEEN 810 AND 1199)
        FROM global_markets.delayed_stocks_minute_aggs
        WHERE ticker = 'NVDA'
          AND window_start >= toDateTime('2026-06-01 00:00:00') AND window_start < toDateTime('2026-07-01 00:00:00')
    ) AS rth_lo,
    (
        SELECT count() FROM global_markets.delayed_stocks_minute_aggs
        WHERE ticker = 'SPY'
          AND window_start >= toDateTime('2026-06-19 00:00:00') AND window_start < toDateTime('2026-06-20 00:00:00')
    ) AS spy_jun19
SELECT
    round(toFloat64(argMin(open, window_start)), 2) AS month_open,
    closes.3 AS month_close,
    round((closes.3 / toFloat64(argMin(open, window_start)) - 1) * 100, 1) AS month_change_pct,
    round((1 - closes.3 / toFloat64(argMin(open, window_start))) * 100, 1) AS month_decline_abs_pct,
    closes.1 AS peak_close_date,
    round(closes.2, 2) AS peak_close,
    round(hi, 2) AS month_high,
    formatDateTime(toTimeZone(minIf(window_start, toFloat64(high) >= hi - 0.011), 'America/New_York'), '%Y-%m-%d %H:%i') AS month_high_first_bar_et,
    countIf(toFloat64(high) >= hi - 0.011) AS bars_within_cent_of_high,
    argMinIf(transactions, window_start, toFloat64(high) >= hi - 0.011) AS high_minute_trades,
    round(rth_hi, 2) AS rth_month_high,
    formatDateTime(toTimeZone(minIf(window_start, toFloat64(high) >= rth_hi - 0.011 AND (toHour(window_start) * 60 + toMinute(window_start)) BETWEEN 810 AND 1199), 'America/New_York'), '%Y-%m-%d %H:%i') AS rth_high_first_bar_et,
    countIf(toFloat64(high) >= rth_hi - 0.011 AND (toHour(window_start) * 60 + toMinute(window_start)) BETWEEN 810 AND 1199) AS rth_bars_near_high,
    round(lo, 2) AS month_low,
    formatDateTime(toTimeZone(minIf(window_start, toFloat64(low) <= lo + 0.011), 'America/New_York'), '%Y-%m-%d %H:%i') AS month_low_bar_et,
    countIf(toFloat64(low) <= lo + 0.011) AS bars_within_cent_of_low,
    argMin(transactions, toFloat64(low)) AS low_minute_trades,
    round(rth_lo, 2) AS rth_month_low,
    round(rth_lo - lo, 2) AS rth_minus_extended_low,
    round(toFloat64(sum(volume)) / 1e9, 2) AS month_shares_bn,
    round(sum(toFloat64(close) * toFloat64(volume)) / 1e9, 1) AS month_dollar_bn,
    round(sumIf(toFloat64(close) * toFloat64(volume), (toHour(window_start) * 60 + toMinute(window_start)) BETWEEN 810 AND 1199) / 1e9, 1) AS rth_dollar_bn,
    round(sumIf(toFloat64(volume), (toHour(window_start) * 60 + toMinute(window_start)) BETWEEN 810 AND 1199) / 1e9, 2) AS rth_shares_bn,
    uniqExact(toDate(toTimeZone(window_start, 'America/New_York'))) AS session_days_observed,
    spy_jun19 AS spy_bars_june19
FROM global_markets.delayed_stocks_minute_aggs
WHERE ticker = 'NVDA'
  AND window_start >= toDateTime('2026-06-01 00:00:00') AND window_start < toDateTime('2026-07-01 00:00:00')

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 analysisNVDA: NVIDIA's Full June 2026, Tick by Tick
The whole NVDA tape in one row: prints, print sizes, and the quote census scalar 1×10 → The off-exchange peak and trough, bounded (deduped per session) scalar 1×6 → The mid-June short-interest print scalar 1×6 → The rank receipt: NVDA's place, its lead over the next name, and the basis, as checked columns scalar 1×5 → NVDA's options market in one row: totals, expiry structure, flagship contracts scalar 1×18 → The information flow in one row: volume, composition, and co-tags scalar 1×12 → See all 2,170 queries →