turbot/finance

steampipe plugin install financesteampipe plugin install finance

Table: finance_quote

Query prices for any symbol including:

TypeExample Symbol
EquitiesAMZN
International EquitiesWBC.AX
Indexes^FTSE
OptionsAMZN210507C02240000
Foreign exchange pairsAUDUSD=X
Cryptocurrency pairsBTC-USD
FuturesNQ=F
ETFsVTI
Mutual FundsVFIAX

Note: A symbol must be provided in all queries to this table.

Examples

Current price of Amazon stock

select
symbol,
short_name,
regular_market_price
from
finance_quote
where
symbol = 'AMZN'

52 week trading range for Bitcoin

select
symbol,
short_name,
fifty_two_week_low,
fifty_two_week_high
from
finance_quote
where
symbol = 'BTC-USD'

Global exchange quotes for Westpac

select
symbol,
short_name,
regular_market_price,
currency_id,
full_exchange_name,
exchange_timezone_name,
regular_market_time
from
finance_quote
where
symbol in ('WBK', 'WBC.AX', 'WBC.NZ')

.inspect finance_quote

Most recent available quote for the given symbol.

NameTypeDescription
askdouble precisionAsk price.
ask_sizedouble precisionAsk size.
average_daily_volume_10_daybigintAverage daily volume - last 10 days.
average_daily_volume_3_monthbigintAverage daily volume - last 3 months.
biddouble precisionBid price.
bid_sizedouble precisionBid size.
currency_idtextCurrency ID, e.g. AUD, USD.
exchange_idtextExchange ID, e.g. NYQ, CCC.
exchange_timezone_nametextTimezone at the exchange.
exchange_timezone_short_nametextTimezone short name at the exchange.
fifty_day_averagedouble precision50 day average price.
fifty_day_average_changedouble precision50 day average change.
fifty_day_average_change_percentdouble precision50 day average change percentage.
fifty_two_week_highdouble precision52 week high.
fifty_two_week_high_changedouble precision52 week high change.
fifty_two_week_high_change_percentdouble precision52 week high change percentage.
fifty_two_week_lowdouble precision52 week low.
fifty_two_week_low_changedouble precision52 week low change.
fifty_two_week_low_change_percentdouble precision52 week low change percent.
full_exchange_nametextFull exchange name.
gmt_offset_millisecondsbigintGMT offset in milliseconds.
is_tradeablebooleanTrue if the symbol is tradeable.
market_idtextMarket identifier, e.g. us_market.
market_statetextCurrent state of the market, e.g. REGULAR, CLOSED.
post_market_changedouble precisionPost market price change.
post_market_change_percentdouble precisionPost market price change percentage.
post_market_pricedouble precisionPost market price.
post_market_timetimestamp without time zoneTimestamp for post market data.
pre_market_changedouble precisionPre market price change.
pre_market_change_percentdouble precisionPre market price change percentage.
pre_market_pricedouble precisionPre market price.
pre_market_timetimestamp without time zoneTimestamp for pre market data.
quote_delaybigintQuote delay in minutes.
quote_sourcetextQuote source.
quote_typetextQuote type, e.g. EQUITY, CRYPTOCURRENCY.
regular_market_changedouble precisionChange in price since the regular market open.
regular_market_change_percentdouble precisionChange percentage during the regular market session.
regular_market_day_highdouble precisionHigh price for the regular market day.
regular_market_day_lowdouble precisionLow price for the regular market day.
regular_market_opendouble precisionOpening price for the regular market.
regular_market_previous_closedouble precisionClose price of the previous regular market session.
regular_market_pricedouble precisionPrice in the regular market.
regular_market_timetimestamp without time zoneTime when the regular market data was updated.
regular_market_volumebigintTrading volume for the regular market session.
short_nametextShort descriptive name for the entity.
source_intervalbigintSource interval in minutes.
symboltextSymbol to quote.
two_hundred_day_averagedouble precision200 day average price.
two_hundred_day_average_changedouble precision200 day average price change.
two_hundred_day_average_change_percentdouble precision200 day average price change percentage.