Knowledge Base/How do Massive's feeds handle canceled trades?

How do Massive's feeds handle canceled trades?

Nothing is deleted. REST and the flat files keep a canceled trade, mark it with a correction value and add a separate cancel record, and leave both out of aggregate bars. The WebSocket trade message has no correction field, so a live stream cannot tell you a trade was later canceled.

Massive's feeds handle a canceled trade by keeping it and marking it, never by deleting it, and only REST and the flat files can show you the mark. A cancellation arrives from the exchange or reporting facility as a separate message, often long after the trade, and Massive records it as a second row next to the original. The WebSocket trade stream has no field to carry that, so a system built only on the live stream never learns a trade was canceled.

Applies to

  • Plans: any Stocks subscription with access to trades. Cancellations and corrections are rare events in US equities, reported mostly for off-exchange prints.
  • Endpoints: /v3/trades/{ticker} and the flat-file trade datasets carry a correction value. The T channel on the /stocks WebSocket cluster does not, and neither does the options T channel.
  • Asset classes: US stocks. Options REST trades document the same correction field.

What a canceled trade looks like in REST

A canceled trade looks like two rows in REST, not one. The original stays at the moment it printed and is marked afterwards, and the cancellation is a row of its own, disseminated later, with the same trade id, sequence number, price and size. This is one AAPL trade from 4 September 2026:

curl -X GET "https://api.massive.com/v3/trades/AAPL?timestamp.gte=1788549871493000000&timestamp.lte=1788549877493000000&limit=10000&order=asc&sort=timestamp&apiKey=YOUR_API_KEY"

Response (the original, trimmed; the cancel record comes from the same call made around its own time, 1788554563433711037)

{
  "results": [
    { "id": "454690", "exchange": 4, "trf_id": 202, "price": 321.915, "size": 100,
      "sequence_number": 9454652, "correction": 8,
      "participant_timestamp": 1788549872493000000, "sip_timestamp": 1788549872495404947 },
    { "id": "454690", "exchange": 4, "trf_id": 202, "price": 321.915, "size": 100,
      "sequence_number": 9454652, "correction": 10,
      "participant_timestamp": 1788549872493000000, "sip_timestamp": 1788554563433711037 }
  ]
}

The first row printed at 15:24:32 ET and now carries correction: 8, meaning an original trade that was later canceled. The second is the cancel record itself, correction: 10, disseminated at 16:42:43 ET, 78 minutes later. Both keep the original participant_timestamp, which is how you can tell a late cancel record from a trade that happened at that time.

When the marks appear

The marks appear days after the session, not as it happens. Across every AAPL session from 4 to 18 September the cancel records were there, three to nine a day, while the sessions of 21 and 22 September carried none when checked on the 23rd. A trade pulled from REST for a recent session can therefore gain a correction value later, and a REST bar for that session can still change when it does. For settled history, check again a few days after the session.

How to replay trades as of a past moment

To replay trades as they were known at a past moment, keep only the rows whose sip_timestamp, the time the securities information processor (SIP) received the row, is at or before that moment. /v3/trades has no as-of parameter, but its timestamp filters apply to sip_timestamp, so timestamp.lte set to the moment in nanoseconds returns those rows. A cancel record carries its own later sip_timestamp, so it stays out of a replay that ends before it was disseminated. Corrected trades need one more step, below.

The correction value on an original row is a mark added afterwards, so the row can carry it in a replay that ends before the cancel record was disseminated. In the AAPL example above, from 4 September 2026, a replay that ends at 16:00 ET keeps the trade printed at 15:24:32 and leaves out the cancel record disseminated at 16:42:43, yet the trade's row already shows correction: 8. A replay that drops every marked row therefore also drops trades whose cancellation had not yet been disseminated at that moment.

A corrected trade changes more than its mark. Its original row, correction: 1, carries the corrected data at the original time, and the data as it was first reported sits on the correction record, correction: 12, at the later correction time. A replay that ends before the correction therefore takes the price, size and conditions from the matching 12 record, the one with the same id and sequence number. Without that step, it shows data nobody had at that moment.

What the correction values mean

What the correction values mean comes in pairs, one for the original and one for the record that changed it. These are the values seen across full sessions of AAPL and TSLA:

ValueRowMeaning
Absent in REST, 0 in flat filesNormal tradeNothing changed
8OriginalThe trade was later canceled
10Cancel recordThe cancellation, disseminated later
1OriginalThe trade was later corrected; the row keeps its original time and now carries the corrected data
12Correction recordThe original, incorrect data, disseminated later at the correction time

A correction does not always change the price or size. In the TSLA pair on 4 September the record arrived 39 minutes after the trade with the same price and size, and what changed was one of the conditions.

To reproduce Massive's own aggregate bars from trades, leave out every row that carries a correction value, which in the flat files means a value other than 0. Recomputing five minute bars that between them held all four values, the bar volume matched the unmarked trades exactly every time, and none of the marked rows was counted, including the cancel and correction records.

Where each feed stands

Where each feed stands on cancellations comes down to whether it has a field to carry them:

FeedShows the correction?What you get
REST /v3/tradesYes, the correction valueBoth rows, marked
Flat filesYes, a correction columnBoth rows, marked, in the daily file
WebSocket T channel, stocks and optionsNo such fieldThe trade as it printed, with no later mark

The WebSocket carries a trade the moment it prints, before anyone could know it will be canceled, and its message has no field that could carry the change afterwards. So a system that builds its own history from the stream keeps trades the exchange later canceled. If that matters, reconcile against REST or the flat file once the session is a few days old; before the marks arrive, REST agrees with the stream.

How aggregate bars are affected

Aggregate bars are affected differently on REST and on the stream. REST bars leave canceled and corrected rows out once the marks have arrived, so the REST bar is the one to trust for any session more than a few days old. Live bars on the WebSocket are held for 15 minutes so that late trades can be added and the bar rebroadcast, but that window is for late trades, and cancellations usually arrive well after it: the AAPL cancel above came 78 minutes after its trade, another AAPL cancel that session came 33 minutes after, and the TSLA correction came 39 minutes after. A live bar that included a trade canceled later is not corrected on the stream, which is why it can disagree with the REST bar for the same minute.

How rare they are

How rare they are is easy to overstate from one page of results, because the trades endpoint returns the newest rows first and a single page covers only the end of the day. Across whole sessions that had settled, meaning the marks had arrived:

SessionTradesCanceledCorrected
AAPL, 4 Sep 2026908,13440
AAPL, 11 Sep 20261,002,63190
AAPL, 15 Sep 2026688,36630
AAPL, 16 Sep 2026638,26631
AAPL, 17 Sep 2026669,46230
AAPL, 18 Sep 2026682,05541
TSLA, 4 Sep 20261,528,64331

That is roughly one in 100,000 to 400,000 trades, and every settled session checked had at least one. Page through the whole day with next_url, and use a session that is a few days old, before concluding anything about a ticker: a recent session shows none because the marks have not arrived yet, not because nothing was canceled.

Cancellations are not condition codes

Cancellations are not condition codes, so filtering conditions will not find a canceled trade. The stocks conditions reference returns 94 codes and none marks a trade as canceled. One, 38, Corrected Consolidated Close, is easy to mistake for one: it is the listing market's print that sets the official closing price, not a flag on a trade that was corrected.

A trade with no conditions field is a regular trade with no special sale condition; the conditions reference has no code for a regular sale. REST leaves the field out rather than sending an empty array, and the flat files leave the conditions column blank.

If you see an error

A trade you expected to be missing is not a bug. A canceled trade stays in REST and the flat files with correction: 8, next to a cancel record with correction: 10.

A row whose sip_timestamp is long after its participant_timestamp and which carries correction: 10 or 12 is a cancel or correction record, not a trade that happened late.

A minute bar from REST that disagrees with the one you stored from the WebSocket usually means a trade arrived after the 15-minute window or was canceled later. In both cases take the REST value, but a cancellation reaches REST only a few days after the session, so a comparison made the next morning can still agree with the live bar.

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.