Table: finance_quote_daily - Query Finance Quote Daily using SQL

The Finance Quote Daily is a resource in the Finance service that provides detailed financial data for specific tickers on a daily basis. It includes information such as the opening price, closing price, highest price, lowest price, volume, and changes for each day. This data can be used for a variety of financial analysis and trading strategies.

Table Usage Guide

The finance_quote_daily table provides valuable insights into the daily financial performance of specific tickers. As a financial analyst or trader, you can explore detailed financial data through this table, including opening and closing prices, daily highs and lows, volume, and changes. Use it to analyze market trends, evaluate trading strategies, and make informed investment decisions.

Important Notes

You must specify the symbol in the where clause to query this table.
History is limited to the last 121 months (~10 years).
Symbol types are defined in finance_quote.

Examples

Johnson & Johnson daily price history (most recent first)

Analyze the daily closing prices of Johnson & Johnson stocks, listed in reverse chronological order. This can be useful for tracking stock performance over time and making informed investment decisions.

select
  timestamp,
  close
from
  finance_quote_daily
where
  symbol = 'JNJ'
order by
  timestamp desc

select
  timestamp,
  close
from
  finance_quote_daily
where
  symbol = 'JNJ'
order by
  timestamp desc

Top 10 days by volume for Apple

Discover the days when Apple's trading volume was at its highest. This can be beneficial for investors to understand the market activity and make informed decisions.

select
  timestamp,
  volume
from
  finance_quote_daily
where
  symbol = 'AAPL'
order by
  volume desc
limit
  10;

select
  timestamp,
  volume
from
  finance_quote_daily
where
  symbol = 'AAPL'
order by
  volume desc
limit
  10;

Top 10 days by highest closing price for Bitcoin

Discover the dates when Bitcoin had its highest closing prices. This query is useful for understanding market trends and making informed investment decisions.

select
  timestamp,
  close
from
  finance_quote_daily
where
  symbol = 'BTC-USD'
order by
  close desc
limit
  10;

select
  timestamp,
  close
from
  finance_quote_daily
where
  symbol = 'BTC-USD'
order by
  close desc
limit
  10;

Schema for finance_quote_daily

Name	Type	Operators	Description
_ctx	jsonb		Steampipe context in JSON form.
adjusted_close	double precision		Adjusted close price after accounting for any corporate actions.
close	double precision		Last price during the regular trading session.
high	double precision		Highest price during the trading session.
low	double precision		Lowest price during the trading session.
open	double precision		Opening price during the trading session.
sp_connection_name	text	=, !=, ~~, ~~, !~~, !~~	Steampipe connection name.
sp_ctx	jsonb		Steampipe context in JSON form.
symbol	text	=	Symbol to quote.
timestamp	timestamp with time zone		Timestamp of the record.
volume	bigint		Total trading volume (units bought and sold) during the period.

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_daily