ODCS v3.2.0Draft · 0.1.0licensed-dataequityusanalytics

US Equities Buy/Sell Pressure and Retail Indicators Minute Bar

One row per ticker per trading minute with volume and trade-count splits, spread statistics and probabilistic estimates of retail buy/sell activity (sub-penny TRF prints and odd-lot trades), plus derived pressure, ratio, net-flow, imbalance and sentiment indicators (37 columns).

37 columns in delivery order · file or table name eq_ret_indic_1min. Types are ODCS logical types; the format line shows how values are written.

Schema columns with type, key role and description
ColumnTypeKeyDescription
DatedateyyyymmddKey 1 · RequiredTrading date of the bar (yyyymmdd); also the trading day of the file the row came from.

Missing values: Never · Source: vendor guide and sample

TickerstringKey 2 · RequiredSymbol name of the security. The guide documents no other identifier or symbology for these files.

Missing values: Never · Source: vendor guide and sample

TimeBarStarttimeHH:MMKey 3 · RequiredBar start time in ET; HH:MM for a minute bar (Table 1).

Missing values: Never · Source: vendor guide and sample

OpenBarTimetimeHH:MM:SS.mmmuuunnnNanosecond timestamp of the bar open, i.e. the bar start (e.g. 11:03:00.000000000 for a minute bar).

Missing values: Never · Source: vendor guide and sample

MinSpreadnumberRequiredSmallest NBBO bid-ask spread in the bar; a crossed market or negative back-quote spread is floored to 0.

Unit: USD · Missing values: Never · Source: vendor guide and sample

MaxSpreadnumberRequiredLargest NBBO bid-ask spread seen in the bar.

Unit: USD · Missing values: Never · Source: vendor guide and sample

ExchangeVolumeintegeri64Shares traded on public exchanges only, excluding FINRA/TRF-reported trades. 0 when none.

Unit: shares · Missing values: 0 · Source: vendor guide and sample

FinraVolumeintegeri64Shares in FINRA/TRF-reported trades (dark pools, broker-dealer internalization, OTC); 0 when none.

Unit: shares · Missing values: 0 · Source: vendor guide and sample

TotalVolumeintegeri64Total shares traded in the bar across public exchanges and FINRA/TRF (Volume + FinraVolume).

Unit: shares · Missing values: Blank · Source: vendor guide and sample

TotalTradesintegeri64Total number of trades in the bar (exchange plus FINRA/TRF where the dataset carries both).

Unit: count · Missing values: 0 · Source: vendor guide and sample

TotalQuoteCountintegeri64Total count of top-of-book bid and ask updates from public exchanges during the bar.

Unit: count · Missing values: Blank · Source: vendor guide and sample

ExchangeTradeCountintegeri64Number of trades on public exchanges in the bar.

Unit: count · Missing values: Blank · Source: vendor guide and sample

FinraTradeCountintegeri64Number of FINRA/TRF-reported trades in the bar.

Unit: count · Missing values: Blank · Source: vendor guide and sample

OddLotTradeCountintegeri64Number of odd-lot (under 100 shares) trades during the bar.

Unit: count · Missing values: Blank · Source: vendor guide and sample

OddLotTotalSharesintegeri64Total shares traded in odd-lot trades during the bar.

Unit: shares · Missing values: Blank · Source: vendor guide and sample

RelativeSpreadAveragenumberMean over the bar's trades of max(ask - bid, 0) / midpoint, using the last NBBO before each trade (unitless fraction).

Missing values: Blank · Source: vendor guide and sample

TradeCumulDistributionToBidstring10 colon-separated cumulative integers (thresholds 0:0.05:0.1:0.2:0.4:0.6:0.8:0.9:0.95:1)Ten colon-separated cumulative share totals by trade position from bid (0) to ask (1) at thresholds 0, .05, .1, .2, .4, .6, .8, .9, .95, 1.

Missing values: Blank · Source: vendor guide and sample

RetailTRFBuySizeintegeri64Estimated retail buy shares: TRF trades priced just below a round penny (sub-penny fraction in (0.6, 1)); blank when none.

Unit: shares · Missing values: Blank · Source: vendor guide and sample

RetailTRFSellSizeintegeri64Estimated retail sell shares: TRF trades priced just above a round penny (sub-penny fraction in (0, 0.4)); blank when none.

Unit: shares · Missing values: Blank · Source: vendor guide and sample

RetailOddLotBuySizeintegeri64Estimated retail buy shares from odd-lot exchange trades priced above the NBBO midpoint.

Unit: shares · Missing values: Blank · Source: vendor guide and sample

RetailOddLotSellSizeintegeri64Estimated retail sell shares from odd-lot exchange trades priced below the NBBO midpoint.

Unit: shares · Missing values: Blank · Source: vendor guide and sample

TRFRetailPressnumberTRF retail pressure: (RetailTRFBuySize + RetailTRFSellSize) / TotalVolume.

Missing values: Blank · Source: vendor guide and sample

OddLotPressnumberOdd-lot pressure: (RetailOddLotBuySize + RetailOddLotSellSize) / TotalVolume.

Missing values: Blank · Source: vendor guide and sample

TRFRetailOddLotPressnumberCombined pressure: (TRF retail buy+sell + odd-lot retail buy+sell) / TotalVolume.

Missing values: Blank · Source: vendor guide and sample

OddLotTRFRetailRationumberOdd-lot retail size divided by (TRF retail size + odd-lot retail size), buys plus sells.

Missing values: Blank · Source: vendor guide and sample

TRFRetailBuySellRationumberRetailTRFBuySize / RetailTRFSellSize.

Missing values: Blank · Source: vendor guide and sample

OddLotBuySellRationumberRetailOddLotBuySize / RetailOddLotSellSize.

Missing values: Blank · Source: vendor guide and sample

TRFRetailOddLotBuySellRationumber(RetailTRFBuySize + RetailOddLotBuySize) / (RetailTRFSellSize + RetailOddLotSellSize).

Missing values: Blank · Source: vendor guide and sample

RelNetTRFRetailFlownumber(TRF retail buy - sell) / (buy + sell); positive means retail buying pressure, range -1 to 1.

Missing values: Blank · Source: vendor guide and sample

RelNetOddLotFlownumber(odd-lot retail buy - sell) / (buy + sell); positive means buying pressure, range -1 to 1.

Missing values: Blank · Source: vendor guide and sample

RelNetTRFRetailOddLotFlownumberCombined TRF-retail plus odd-lot net flow: (buys - sells) / (buys + sells); range -1 to 1.

Missing values: Blank · Source: vendor guide and sample

TRFRetImbalancenumberTRF retail buy share = RetailTRFBuySize / (RetailTRFBuySize + RetailTRFSellSize); near 1 buy-dominant, near 0 sell-dominant.

Missing values: Blank · Source: vendor guide and sample

OddLotImbalancenumberOdd-lot retail buy share = RetailOddLotBuySize / (buy + sell); near 1 buy-dominant, near 0 sell-dominant.

Missing values: Blank · Source: vendor guide and sample

TRFRetOddLotImbalancenumberCombined TRF-retail plus odd-lot buy share of total retail size; near 1 buy-dominant, near 0 sell-dominant.

Missing values: Blank · Source: vendor guide and sample

TRFRetSentimentnumberMoving average of RelNetTRFRetailFlow (a rolling sentiment gauge; window length is described inconsistently in the guide).

Missing values: Blank · Source: vendor guide and sample

OddLotSentimentnumberMoving average of RelNetOddLotFlow (a rolling sentiment gauge; window length is described inconsistently in the guide).

Missing values: Blank · Source: vendor guide and sample

TRFRetOddLotSentimentnumberMoving average of RelNetTRFRetailOddLotFlow (a rolling sentiment gauge; window length is described inconsistently in the guide).

Missing values: Blank · Source: vendor guide and sample

Contracts follow the Open Data Contract Standard (Bitol, LF AI & Data).

Vendor names are trademarks of their owners.