STRASMORE/EXPLORE 2,170 QUERIES

Opening prints on settlement morning, May 15, 2026: twelve large US constituents

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-03, from Nikkei 225 Options and SQ Settlement.

as of ranking 12×3read in context →
Opening prints on settlement morning, May 15, 2026: twelve large US constituents — 12 rows by 3 columns, computed from US exchange, SIP and OPRA data.
tickeropen_gap_pctopen_to_close_pct
MSFT1.151.86
KO1.09-0.66
WMT0.94-1.62
XOM0.642.72
JPM0.06-0.79
JNJ-0.02-1.75
AAPL-0.090.79
META-0.720.05
GOOGL-1.190.13
AMZN-1.780.65
CAT-2.32-1.19
NVDA-2.54-1.94
Rows × columns
12 × 3
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 Opening prints on settlement morning, May 15, 2026: twelve large US constituents, derived from the stored result.
ColumnTypeRangeNotes
ticker text 12 distinct values (AAPL, AMZN, CAT…)
open_gap_pct number -2.54 to 1.15 percent
open_to_close_pct number -1.94 to 2.72 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 px AS (
    SELECT ticker,
           toDate(toTimeZone(window_start, 'America/New_York')) AS session_date,
           argMin(open, window_start) AS session_open,
           argMax(close, window_start) AS session_close
    FROM global_markets.delayed_stocks_minute_aggs
    WHERE ticker IN ('AAPL','MSFT','NVDA','AMZN','GOOGL','META','JPM','XOM','JNJ','KO','WMT','CAT')
      AND toDate(toTimeZone(window_start, 'America/New_York')) IN (toDate('2026-05-14'), toDate('2026-05-15'))
      AND (toHour(toTimeZone(window_start, 'America/New_York')) * 60
           + toMinute(toTimeZone(window_start, 'America/New_York'))) BETWEEN 570 AND 959
    GROUP BY ticker, session_date
)
SELECT ticker,
       round(100 * (toFloat64(anyIf(session_open, session_date = toDate('2026-05-15')))
                    / toFloat64(anyIf(session_close, session_date = toDate('2026-05-14'))) - 1), 2) AS open_gap_pct,
       round(100 * (toFloat64(anyIf(session_close, session_date = toDate('2026-05-15')))
                    / toFloat64(anyIf(session_open, session_date = toDate('2026-05-15'))) - 1), 2) AS open_to_close_pct
FROM px
GROUP BY ticker
HAVING countIf(session_date = toDate('2026-05-14')) = 1
   AND countIf(session_date = toDate('2026-05-15')) = 1
ORDER BY open_gap_pct DESC

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 analysisNikkei 225 Options and SQ Settlement
Implied vs realized volatility, six heavily traded US underlyings, twelve months to June 30, 2026 ranking 6×4 → Median theta and implied volatility by days to expiry: near-the-money SPY contracts, H1 2026 table 60×4 → SPY implied volatility vs the volatility realized in the following month series 23×5 → SPY on monthly settlement Fridays: the opening gap, and where the session went afterwards series 16×4 → Opening prints against the previous close: settlement Friday vs an ordinary Friday ranking 8×3 → SPY volume by ET clock minute around the open, 13 March vs 20 March 2026 series 46×3 → See all 2,170 queries →