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.
| code_id | code_name | is_cross_code | code_type | what_it_marks |
|---|---|---|---|---|
| 9 | Cross Trade | 1 | sale_condition | |
| 84 | Crossed Market | 1 | market_condition | |
| 8 | Closing Prints | 0 | sale_condition | |
| 13 | Opening | 0 | quote_condition | |
| 14 | Closing | 0 | quote_condition | |
| 15 | Market Center Official Close | 0 | sale_condition | |
| 16 | Market Center Official Open | 0 | sale_condition | |
| 17 | Market Center Opening Trade | 0 | sale_condition | |
| 18 | Market Center Reopening Trade | 0 | sale_condition | |
| 19 | Market Center Closing Trade | 0 | sale_condition | |
| 25 | Opening Prints | 0 | sale_condition | |
| 28 | Re-Opening Prints | 0 | sale_condition | |
| 55 | Opening Reopening Trade Detail | 0 | sale_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
What each column holds
| Column | Type | Range | Notes |
|---|---|---|---|
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 →