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.

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

  • removed column auctionTime_cst
  • removed column sourceTime_cst
  • new column tradingDate added
  • new column recordNum added
  • new column exchange added
  • recordNum removed from v7
  • tradingDate removed from v7