STRASMORE/EXPLORE 2,309 QUERIES

cross_codes

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-17, from what-does-cross-mean-in-trading.

as of table 13×5read in context →
cross_codes — 13 rows by 5 columns, computed from US exchange, SIP and OPRA data.
code_idcode_nameis_cross_codecode_typewhat_it_marks
9Cross Trade1sale_condition
84Crossed Market1market_condition
8Closing Prints0sale_condition
13Opening0quote_condition
14Closing0quote_condition
15Market Center Official Close0sale_condition
16Market Center Official Open0sale_condition
17Market Center Opening Trade0sale_condition
18Market Center Reopening Trade0sale_condition
19Market Center Closing Trade0sale_condition
25Opening Prints0sale_condition
28Re-Opening Prints0sale_condition
55Opening Reopening Trade Detail0sale_condition
Rows × columns
13 × 5
Computed
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 cross_codes, derived from the stored result.
ColumnTypeRangeNotes
code_id number 8 to 84
code_name text 13 distinct values (Closing, Closing Prints, Cross Trade…)
is_cross_code number 0 to 1
code_type text 3 distinct values
what_it_marks empty 0 of 13 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 , and the query below is what returned them.

the exact SQL behind every number
SELECT
    id                                          AS code_id,
    any(name)                                   AS code_name,
    toUInt8(max(lower(name) LIKE '%cross%'))    AS is_cross_code,
    any(type)                                   AS code_type,
    any(description)                            AS what_it_marks
FROM global_markets.stocks_condition_codes
WHERE asset_class = 'stocks'
  AND (lower(name) LIKE '%cross%'
       OR lower(name) LIKE '%opening%'
       OR lower(name) LIKE '%closing%'
       OR lower(name) LIKE '%official%')
GROUP BY id
ORDER BY is_cross_code DESC, code_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 analysiswhat-does-cross-mean-in-trading
cross_minutes series 7×4 quote_states ranking 3×4 The 2s10s spread, every print of the half table 124×2 The 2s10s spread, every print of the half table 124×2 Every half-year since 1976: the 2y and 10y change, the twist between them, and the half's lowest 2s10s print table 100×7 SPY at one-minute resolution, 2:00–3:30 pm ET on May 6, 2010 table 90×4 See all 2,309 queries →