Skip to main content

QUOTE

Get the latest quote for a given stock. Quote includes price, volume, and other data.

Syntax

=OBB.EQUITY.PRICE.QUOTE(symbol)

Examples

=OBB.EQUITY.PRICE.QUOTE("AAPL")

Parameters

NameTypeDescriptionRequired
symbolTextSymbol to get data for. Multiple comma separated items allowed.True

Data

NameDescription
symbolSymbol representing the entity requested in the data.
asset_typeType of asset - i.e, stock, ETF, etc.
nameName of the company or asset.
exchangeThe name or symbol of the venue where the data is from.
bidPrice of the top bid order.
bid_sizeThis represents the number of round lot orders at the given price. The normal round lot size is 100 shares. A size of 2 means there are 200 shares available at the given price.
bid_exchangeThe specific trading venue where the purchase order was placed.
askPrice of the top ask order.
ask_sizeThis represents the number of round lot orders at the given price. The normal round lot size is 100 shares. A size of 2 means there are 200 shares available at the given price.
ask_exchangeThe specific trading venue where the sale order was placed.
quote_conditionsConditions or condition codes applicable to the quote.
quote_indicatorsIndicators or indicator codes applicable to the participant quote related to the price bands for the issue, or the affect the quote has on the NBBO.
sales_conditionsConditions or condition codes applicable to the sale.
sequence_numberThe sequence number represents the sequence in which message events happened. These are increasing and unique per ticker symbol, but will not always be sequential (e.g., 1, 2, 6, 9, 10, 11).
market_centerThe ID of the UTP participant that originated the message.
participant_timestampTimestamp for when the quote was generated by the exchange.
trf_timestampTimestamp for when the TRF (Trade Reporting Facility) received the message.
sip_timestampTimestamp for when the SIP (Security Information Processor) received the message from the exchange.
last_pricePrice of the last trade.
last_tickWhether the last sale was an up or down tick.
last_sizeSize of the last trade.
last_timestampDate and Time when the last price was recorded.
openThe open price.
highThe high price.
lowThe low price.
closeThe close price.
volumeThe trading volume.
exchange_volumeVolume of shares exchanged during the trading day on the specific exchange.
prev_closeThe previous close price.
changeChange in price from previous close.
change_percentChange in price as a normalized percentage.
year_highThe one year high (52W High).
year_lowThe one year low (52W Low).
is_darkpoolWhether or not the current trade is from a darkpool.
sourceSource of the Intrinio data.
updated_onDate and Time when the data was last updated.
securitySecurity details related to the quote.