STRASMORE/EXPLORE 2,170 QUERIES

The trillion-dollar crossing, receipted: first touch and first close above $404.86

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's May 2023 Earnings: The AI Gap.

as of scalar 1×9read in context →
overnight cap added bn
197
first touch session
2023-05-30
first touch high
419.38
first touch close
401.13
sessions to first touch
3
first close session
2023-06-13
first close usd
410.23
sessions to first close
13
first close cum pct
34.3
Rows × columns
1 × 9
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 trillion-dollar crossing, receipted: first touch and first close above $404.86, derived from the stored result.
ColumnTypeRangeNotes
overnight_cap_added_bn number every row is 197
first_touch_session date 2023-05-30
first_touch_high number every row is 419.38 US dollars
first_touch_close number every row is 401.13 US dollars
sessions_to_first_touch number every row is 3
first_close_session date 2023-06-13
first_close_usd number every row is 410.23 US dollars
sessions_to_first_close number every row is 13 US dollars
first_close_cum_pct number every row is 34.3 percent

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
    daily AS (
        SELECT
            toDate(toTimeZone(window_start, 'America/New_York')) AS et_date,
            argMaxIf(toFloat64(close), window_start, (toHour(toTimeZone(window_start, 'America/New_York')) * 60 + toMinute(toTimeZone(window_start, 'America/New_York'))) BETWEEN 570 AND 959) AS rth_close,
            maxIf(toFloat64(high), (toHour(toTimeZone(window_start, 'America/New_York')) * 60 + toMinute(toTimeZone(window_start, 'America/New_York'))) BETWEEN 570 AND 959) AS rth_high
        FROM global_markets.delayed_stocks_minute_aggs
        WHERE ticker = 'NVDA'
          AND window_start >= toDateTime('2023-05-24 00:00:00') AND window_start < toDateTime('2023-06-20 00:00:00')
        GROUP BY et_date
    ),
    firsts AS (
        SELECT
            minIf(et_date, rth_high >= 404.86) AS ft,
            minIf(et_date, rth_close >= 404.86) AS fc
        FROM daily
    ),
    (SELECT any(rth_close) FROM daily WHERE et_date = toDate('2023-05-24')) AS pre_close,
    (
        SELECT argMinIf(toFloat64(open), window_start, (toHour(toTimeZone(window_start, 'America/New_York')) * 60 + toMinute(toTimeZone(window_start, 'America/New_York'))) BETWEEN 570 AND 959)
        FROM global_markets.delayed_stocks_minute_aggs
        WHERE ticker = 'NVDA'
          AND window_start >= toDateTime('2023-05-25 04:00:00') AND window_start < toDateTime('2023-05-26 00:00:00')
    ) AS may25_open
SELECT
    round((may25_open - pre_close) * 2.47, 0) AS overnight_cap_added_bn,
    toString(any(f.ft)) AS first_touch_session,
    round(anyIf(d.rth_high, d.et_date = f.ft), 2) AS first_touch_high,
    round(anyIf(d.rth_close, d.et_date = f.ft), 2) AS first_touch_close,
    countIf(d.et_date > toDate('2023-05-24') AND d.et_date <= f.ft) AS sessions_to_first_touch,
    toString(any(f.fc)) AS first_close_session,
    round(anyIf(d.rth_close, d.et_date = f.fc), 2) AS first_close_usd,
    countIf(d.et_date > toDate('2023-05-24') AND d.et_date <= f.fc) AS sessions_to_first_close,
    round((anyIf(d.rth_close, d.et_date = f.fc) / pre_close - 1) * 100, 1) AS first_close_cum_pct
FROM daily AS d
CROSS JOIN firsts AS f

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's May 2023 Earnings: The AI Gap
NVDA: May 24, 2023 official close vs May 25 open, the overnight repricing scalar 1×5 → NVDA on May 25, 2023: trading the day after the guidance scalar 1×12 → NVDA daily closes from the pre-gap session through mid-June 2023 series 17×4 → NVDA's ten largest overnight gaps up, 2003-present series 10×4 → May 25, 2023, close to close: the semiconductor complex around NVDA's gap ranking 9×4 → NVDA options: contracts, trades, call share, and premium by session series 7×5 → See all 2,170 queries →