Sale conditions that mark protection-rule exceptions

Name: Sale conditions that mark protection-rule exceptions
Creator: Strasmore
Published: 2026-08-20
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-08-20, from What Is a Trade-Through? ISO Orders Explained.

as of 2026-08-20 table 11×3read in context →

Sale conditions that mark protection-rule exceptions — 11 rows by 3 columns, computed 2026-08-20 from US exchange, SIP and OPRA data.
condition_name	tape_code	what_it_marks
Average Price Trade
Derivatively Priced
Extended Hours (Sold Out Of Sequence)
Intermarket Sweep
Intermarket Sweep Order	ISOI	Transaction was the execution of an order identified as an Intermarket Sweep Order. Process like normal transaction.
Late and Out Of Sequence	OSEQ	Transaction is being reported late and is out of sequence; i.e., later transactions have been reported for the particular option contract.
Odd Lot Trade
Opening Trade, Late, and Out Of Sequence	OPEN	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 contra
Prior Reference Price
Sold (Out Of Sequence)
Sold (Out of Sequence) and Stopped Stock

Rows × columns: 11 × 3
Computed: 2026-08-20
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 Sale conditions that mark protection-rule exceptions, derived from the stored result.
Column	Type	Range	Notes
`condition_name`	text	11 distinct values
`tape_code`	text	3 distinct values (ISOI, OPEN, OSEQ)	3 of 11 rows populated
`what_it_marks`	text	3 distinct values	3 of 11 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-08-20, and the query below is what returned them.

the exact SQL behind every number

SELECT
    name                                AS condition_name,
    any(abbreviation)                   AS tape_code,
    substring(any(description), 1, 150) AS what_it_marks
FROM global_markets.stocks_condition_codes
WHERE name ILIKE '%sweep%'
   OR name ILIKE '%derivatively%'
   OR name ILIKE '%prior reference%'
   OR name ILIKE '%odd lot%'
   OR name ILIKE '%average price%'
   OR name ILIKE '%out of sequence%'
GROUP BY name
ORDER BY condition_name
LIMIT 15

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 Is a Trade-Through? ISO Orders Explained

Distinct venues printing AAPL inside the same second, minute by minute series 30×3 → Where 30 minutes of AAPL prints landed, by venue ranking 12×3 → Share of prints by trade size: AAPL against KO ranking 5×4 → Registered US stock exchanges and their participant codes table 18×5 → Consolidated spread vs single venue spread, AAPL, June 17 2026 series 90×4 → AAPL: average NBBO updates per minute by half-hour bucket (ET, 4 a.m. to 8 p.m.) series 32×3 → See all 2,170 queries →