Explore 2,358 answered market questions

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.

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

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 → See all 2,358 queries →