open_conditions

Name: open_conditions
Creator: Strasmore
Published: 2026-09-18
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-09-18, from nasdaq-opening-cross-explained.

as of 2026-09-18 ranking 14×3read in context →

open_conditions — 14 rows by 3 columns, computed 2026-09-18 from US exchange, SIP and OPRA data.
id	name	description
1	Regular Two-Sided Open
2	Regular One-Sided Open
13	Opening
16	Market Center Official Open
17	Market Center Opening Trade
18	Market Center Reopening Trade
25	Opening Prints
28	Re-Opening Prints
32	No Open No Resume
55	Opening Reopening Trade Detail
205	Opening Trade and Canceled	Transaction was the first one (opening) reported this day for this particular option contract. Although later transactions have been reported, this transaction is now to be canceled.
206	Opening Trade, Late, and Out Of Sequence	Transaction is a late report of the opening trade and is out of sequence; i.e., other transactions have been reported for the particular option contract.
208	Opening Trade and Late	Transaction is a late report of the opening trade, but is in the correct sequence; i.e., no other transactions have been reported for the particular option contract.
210	Reopening Trade	Transaction is a reopening of an option contract in which trading has been previously halted. Prefix appears solely for information; process as a regular transaction.

Rows × columns: 14 × 3
Computed: 2026-09-18
Completeness: Some fields are partly empty — see the columns below
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 open_conditions, derived from the stored result.
Column	Type	Range	Notes
`id`	number	1 to 210
`name`	text	14 distinct values
`description`	text	4 distinct values	4 of 14 rows populated

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

the exact SQL behind every number

SELECT
    id,
    name,
    any(description) AS description
FROM global_markets.stocks_condition_codes
WHERE lower(name) LIKE '%open%'
GROUP BY id, name
ORDER BY id

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 analysisnasdaq-opening-cross-explained

open_minute_share ranking 5×4 → aapl_open_minute_trace series 21×4 → Top 25 weekly-options underlyings by distinct contracts traded, with expiration weekdays ranking 25×4 → Annualized volatility vs total return, 25 large caps, calmest to wildest (~2 years) ranking 25×3 → SPY options median spread by expiration date, near-the-money strikes only ranking 25×4 → Share of prints with a placeholder participant timestamp, one March session per year (IBM and MSFT) ranking 24×4 → See all 2,358 queries →