Knowledge Base/What do Massive's stock trade condition codes mean?

What do Massive's stock trade condition codes mean?

The conditions array on a stock trade holds numeric codes describing how it was executed, and those codes decide whether the trade updated a bar's open, close, high, low or volume. A regular trade has no conditions field. This is the reference table for the codes you will meet in practice.

Read this page when a bar you rebuilt from raw trades does not match ours, because the conditions array on a US stock trade is almost always the reason. The table below lists the codes you will meet in practice, with what each one means. For whether a specific code updates a bar, ask /v3/reference/conditions, which returns the rules as data rather than prose.

Applies to

  • Plans: a Stocks subscription for the trades themselves; the conditions endpoint is reference data and is available more widely.
  • Endpoints: conditions on /v3/trades/{ticker} and in the flat files, c on the T WebSocket channel, and /v3/reference/conditions for the update rules.
  • Asset classes: US stocks. Options and futures carry their own condition sets.

How to check what a code does to a bar

The table below defines each code. It does not say whether a code updates a bar, because that answer differs between the consolidated tape and a single venue, and it is published as data:

curl -X GET "https://api.massive.com/v3/reference/conditions?asset_class=stocks&data_type=trade&id=2&apiKey=YOUR_API_KEY"

Response

{
  "results": [
    {
      "id": 2, "type": "sale_condition", "name": "Average Price Trade",
      "update_rules": {
        "consolidated": { "updates_high_low": false, "updates_open_close": false, "updates_volume": true }
      }
    }
  ],
  "status": "OK"
}

Filter on data_type=trade, singular, because the id space is shared with quote conditions and asking for an id without the filter returns both.

The full reference

The full reference below is the complete list of stock trade condition codes, with the definition of each:

TermConditionDefinition
1AcquisitionA transaction made on the Exchange as a result of an Exchange acquisition.
2Average Price TradeA trade where the price reported is based upon an average of the prices for transactions in a security during all or any portion of the trading day.
3Automatic ExecutionA sale condition code that identifies a NYSE trade that has been automatically executed without the potential benefit of price improvement.
4Bunched TradeThe combining of multiple odd-lot or round-lot orders for the same security so that they can all be executed at the same time. All affected clients must agree to the bunching before the order is submitted. Bunched trades may also be referred to as block trades.
5Bunched Sold TradeA bunched trade that is reported late.
7Cash SaleA transaction which requires delivery of securities and payment on the same day the trade takes place.
8Closing PrintsThe Participant Closing Price represents the last qualifying trade paid for a security by a Participant during the trading day.
9Cross TradeIndicates that the trade resulted from a Market Center’s crossing session.
10Derivatively PricedThe transaction that constituted the trade-through was the execution of an order at a price that was not based, directly or indirectly, on the quoted price of the security at the time of execution, and for which the material terms were not reasonably determinable at the time the commitment to execute the order was made (REG NMS 611b7).
11DistributionDistribution stock refers to a large blocks of a security that are carefully sold into the market gradually in smaller blocks so as to inundate the market with sell orders for the security and driving down its price.
12Form T/Extended HoursIdentifies a trade that was executed outside of regular primary market hours and is reported as an extended hours trade.
13Extended Hours (Sold Out Of Sequence)Identifies a trade that takes place outside of regular market hours and is reported as an extended hours trade out of sequence and at a time different from the actual transaction time.
14Intermarket SweepThe transaction that constituted the trade-through was the execution of an order identified as an Intermarket Sweep Order.
15Market Center Official CloseIndicates the ‘Official’ closing value as determined by a Market Center. This transaction report will contain the market center generated closing price.
16Market Center Official OpenIndicates the ‘Official’ opening value as determined by a Market Center. This transaction report will contain the market center generated opening price.
17Market Center Opening TradeThe trade that constituted the trade-through was a single priced opening transaction by the Market Center (REG NMS Rule 611b3).
18Market Center Reopening TradeThe trade that constituted the trade-through was a single priced reopening transaction by the Market Center (REG NMS Rule 611b3).
19Market Center Closing TradeThe transaction that constituted the trade-through was a single priced closing transaction by the Market Center (REG NMS Rule 611b3).
20Next DayA transaction that requires the delivery of securities on the first business day following the trade date.
21Price Variation TradeIndicates a regular market session trade transaction that carries a price that is significantly away from the prevailing consolidated or primary market value at the time of the transaction.
22Prior Reference PriceA sale condition that identifies a trade based on a price at a prior point in time, i.e., more than 90 seconds prior to the time of the trade report. The execution time of the trade will be the time of the prior reference price.
23Rule 155 Trade (AMEX)A Seller’s Option transaction gives the seller the right to deliver the security at any time within a specific period, ranging from not less than two calendar days, to not more than sixty calendar days. A security offered “Seller’s Option” may command a lesser price than if offered “Regular Way”.
24Rule 127 (NYSE Only)“To qualify as a NYSE Rule 127 the trade is executed outside the present quote and meets one or both of the following conditions: 1. has a volume of 10,000 shares or more and/or 2. has a dollar value of $200,000 or more.”
25Opening PrintsThe trading day’s first drawings of a symbol’s candlestick charts.
27Stopped Stock (Regular Trade)A Seller’s Option transaction gives the seller the right to deliver the security at any time within a specific period, ranging from not less than two calendar days, to not more than sixty calendar days. A security offered “Seller’s Option” may command a lesser price than if offered “Regular Way”.
28Re-Opening PrintsThe transaction or group of transactions reported as a result of a single- priced re-opening event by the Market Center.
29SellerA Seller’s Option transaction gives the seller the right to deliver the security at any time within a specific period, ranging from not less than two calendar days, to not more than sixty calendar days. A security offered “Seller’s Option” may command a lesser price than if offered “Regular Way”.
30Sold LastSold Last sale condition modifier is used when a trade prints in sequence but is reported late OR the trade is printed by Amex in conformance to the One or Two Point Rule. A Sold Last transaction should only impact the consolidated last sale price for an issue if the market center reporting the sold last transaction also reported the transaction setting the current last sale price.
32Sold (Out of Sequence)A trade reported to the tape later than it actually occurred, with other trades printing in between.
33Sold (Out of Sequence) and Stopped StockSold Out of Sequence is used when a trade is printed (reported) out of sequence and at a time different from the actual transaction time.
34Split TradeAn execution in two markets when the specialist or Market Maker in the market first receiving the order agrees to execute a portion of it at whatever price is realized in another market to which the balance of the order is forwarded for execution.
35Stock OptionThis is typically the stock portion of a delta neutral option trade executed by an option market maker.
36Yellow Flag Regular TradeMarket Centers will have the ability to identify regular trades being reported during specific events as out of the ordinary by appending a new sale condition code Yellow Flag (“Y”) on each transaction reported to the UTP SIP. The new sale condition “.Y” will be eligible to update all market center and consolidated statistics. In certain instances, the UTP SIP will be required to append the .Y for the market center for trades reported as regular-way (Sale Condition @)
37Odd Lot TradeThe Odd Lot Trade modifier will distinguish a trade resulting from a market center’s execution in increments less than the defined round lot size.
38Corrected Consolidated Close (per listing market)A transaction executed by the Listing Market to establish the official Consolidated Last Price as indicated by the Listing Exchange.
41Trade Thru ExemptThe Trade Through rule is a 20 year-old rule applied to NYSE-listed stocks that states that when a market receives an order, it cannot execute it at a price inferior to any found on another market. In modern electronic markets where trades are executed in milliseconds, this rule can prevent a broker’s ability to meet their “best execution” obligation-because speed provides certainty that the price that is advertised can be accessed.
52Contingent TradeA Sale Condition code used to identify a transaction where the execution of the transaction is contingent upon some event.
53Qualified Contingent TradeA transaction consisting of two or more component orders executed as agent or principal where the execution of one component is contingent upon the execution of all other components at or near the same time and the price is determined by the relationship between the component orders and not the current market price for the security.
59Short Sale Restriction DeactivatedMarks the end of a short sale restriction on a security. Its counterpart, code 60, marks one coming into effect. Both are short sale restriction indicators rather than sale conditions, so they describe the security's state rather than how the trade executed.
60SSR in EffectAny stock that has dropped more than 10% intraday has SSR in effect for that day and the following.

What this table leaves out

/v3/reference/conditions?asset_class=stocks&data_type=trade returns 55 records where this table lists 40. The difference is codes you will not see on a live trade today:

  • Three sale conditions the endpoint flags legacy, ids 6, 31 and 55, which no longer print.
  • Ten financial status indicators, ids 62 to 71, and two further short sale restriction indicators, ids 57 and 58. These ride on the same trade data type but describe the security rather than the execution.

One trap worth knowing before you filter on any of these: the id space is shared between trades and quotes, and the same number means different things. Id 19 is Market Center Closing Trade on a trade and Market Maker Quotes Closed on a quote. Pass data_type=trade when you look up a trade code, and read a conditions array against the data type it came from. Quote codes have no single data type to filter on, and data_type=quote returns an empty list, so look a quote code up as How do I look up what a stock quote condition code means? describes.

Related


Was this article helpful?

Modernizing Wall St.

Reimagining financial market data for the 21st century.

Schedule a demo

Talk with our market data experts

Recommended

Can't find the answer you're looking for? Contact our team.
  • Title
    Are all indices available through the basic subscription tier?
    Data Coverage Category

    Data Coverage

    Indices Category

    Indices

    Description
    No, and the ones it withholds are the famous ones: SPX, DJI, RUT and VIX all need a paid Indices tier. Basic still reaches more than 10,000 of the 13,000-odd indices Massive publishes, and NDX and the Nasdaq Composite are among them.
  • Title
    Does Massive offer dark pool data?
    Data Coverage Category

    Data Coverage

    Stocks Category

    Stocks

    Description
    Yes. Off-exchange prints, which include dark pool executions, arrive on the ordinary trades feed and are identified by an exchange ID of 4. There is no separate dark pool endpoint, and no way to tell which individual venue a print came from.
  • Title
    Does Massive offer pre-market and after-hours data?
    FAQ Category

    FAQ

    Stocks Category

    Stocks

    Description
    Yes. Every extended-hours trade and quote is published, from 04:00 to 20:00 Eastern. There is no session parameter, so you select a session with timestamps, and expect far fewer aggregate bars outside regular hours because many extended-hours trades are odd lots that cannot set a price.