Skip to main content
Version: Upcoming

StockExchImbalance

Description

StockExchImbalance records contain live exchange closing auction imbalance details. Imbalance information can be available from more than one exchange for each ticker. Received directly from exchanges.

Start Dates

US start dates
ExchangeStart Date
NYSE2019-02-11
NYSEArca2019-02-11

Schema Definition

Field NameData TypeDescription
ticker_atstringUnderlying asset type
ticker_tsstringUnderlying ticker source
ticker_tkstringUnderlying ticker
auctionTimetimestampAuction time
auctionTypestringAuction type (Opening, Closing, Halt, IPO, CloseByExt)
exchangestringExchange reporting the imbalance
referencePxfloatReference price
pairedQtyintPaired quantity
totalImbalanceQtyintTotal imbalance quantity
marketImbalanceQtyintMarket imbalance quantity
imbalanceSidestringImbalance side (None, Buy, Sell)
continuousBookClrPxfloatContinuous book clearing price
closingOnlyClrPxfloatClosing only clearing price
ssrFillingPxfloatShort sale restriction filling price
indicativeMatchPxfloatIndicative match price
upperCollarfloatUpper collar price
lowerCollarfloatLower collar price
auctionStatusstringAuction status
freezeStatusstringFreeze status
numExtensionsintNumber of extensions
sourceTimetimestampSource timestamp
netTimestampbigintSR Gateway timestamp in Unix epoch

Differences to V7

  • auctionTime_cst and sourceTime_cst removed (redundant timezone variants)
  • exchange added (populated from the source venue, NYSE or NYSEArca)