STRASMORE/EXPLORE 2,170 QUERIES

The off-exchange peak and trough, bounded (deduped per session)

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×6read in context →
peak date
2026-06-02
peak offex m
86.77
trough date
2026-06-16
trough offex m
43.31
peak minus trough m
43.46
sessions on file
20
Rows × columns
1 × 6
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 off-exchange peak and trough, bounded (deduped per session), derived from the stored result.
ColumnTypeRangeNotes
peak_date date 2026-06-02
peak_offex_m number every row is 86.77
trough_date date 2026-06-16
trough_offex_m number every row is 43.31
peak_minus_trough_m number every row is 43.46
sessions_on_file number every row is 20

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
SELECT
    toString(argMax(date, offex_m)) AS peak_date,
    max(offex_m) AS peak_offex_m,
    toString(argMin(date, offex_m)) AS trough_date,
    min(offex_m) AS trough_offex_m,
    round(max(offex_m) - min(offex_m), 2) AS peak_minus_trough_m,
    count() AS sessions_on_file
FROM (
    SELECT date, round(toFloat64(any(total_volume)) / 1e6, 2) AS offex_m
    FROM global_markets.stocks_short_volume
    WHERE ticker = 'NVDA' AND date >= toDate('2026-06-01') AND date <= toDate('2026-06-30')
    GROUP BY date
)

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 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 The month on one row: open, close, extremes, volume, and their receipts scalar 1×25 See all 2,170 queries →