steampipe plugin install finance

Table: finance_quote - Query Finance Quotes using SQL

Finance Quotes is a resource that provides real-time stock prices and related financial details. It allows users to monitor and respond to market trends, making informed investment decisions. It offers a centralized way to set up and manage alerts for various financial resources, including stocks, mutual funds, ETFs, and more.

Table Usage Guide

The finance_quote table provides insights into real-time stock prices and related financial details. As a financial analyst or investor, explore specific details through this table, including stock prices, trading volume, market capitalization, and associated metadata. Utilize it to uncover information about market trends, make informed investment decisions, and monitor your investment portfolio.

Important Notes

  • You must specify the symbol in the where clause to query this table.

Examples

Current price of Amazon stock

Explore the current market value of a specific stock, in this case Amazon, to aid in financial decision making. This can be particularly useful for investors seeking up-to-date information for their portfolio management.

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

52 week trading range for Bitcoin

Analyze the fluctuations in Bitcoin's trading range over the past year. This can provide insights into the cryptocurrency's performance and volatility, helping to inform investment decisions.

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

Global exchange quotes for Westpac

Analyze the settings to understand the market status of Westpac across different exchanges. This is beneficial for tracking the performance of Westpac's shares in real-time, across multiple markets.

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');
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');

Schema for finance_quote

NameTypeOperatorsDescription
_ctxjsonbSteampipe context in JSON form.
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 with 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 with 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 with 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.
sp_connection_nametext=, !=, ~~, ~~*, !~~, !~~*Steampipe connection name.
sp_ctxjsonbSteampipe context in JSON form.
symboltext=Symbol 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.

Export

This table is available as a standalone Exporter CLI. Steampipe exporters are stand-alone binaries that allow you to extract data using Steampipe plugins without a database.

You can download the tarball for your platform from the Releases page, but it is simplest to install them with the steampipe_export_installer.sh script:

/bin/sh -c "$(curl -fsSL https://steampipe.io/install/export.sh)" -- finance

You can pass the configuration to the command with the --config argument:

steampipe_export_finance --config '<your_config>' finance_quote