Table: finance_quote_hourly - Query Finance Quote Hourly data using SQL

Finance Quote Hourly is a data set within the Finance service that provides hourly financial data. It offers a detailed view of financial data changes on an hourly basis, allowing for more granular analysis of financial trends and patterns. This data can be crucial for financial analysts, traders, and anyone interested in financial data analysis.

Table Usage Guide

The finance_quote_hourly table provides insights into hourly financial data. As a financial analyst or trader, explore hourly financial trends and patterns through this table, including price changes, volume changes, and other relevant financial data. Utilize it to uncover detailed information about financial changes, such as sudden spikes or drops, and gain a better understanding of financial market trends.

Important Notes

You must specify the symbol in the where clause to query this table.
History is limited to the last 13 months.
Symbol types are defined in finance_quote.

Examples

Apple hourly price history (most recent first)

Analyze the hourly closing prices of Apple's stock to understand its recent performance trends. This can help in making informed investment decisions by identifying patterns or changes in the stock's value.

select
  timestamp,
  close
from
  finance_quote_hourly
where
  symbol = 'AAPL'
order by
  timestamp desc;

select
  timestamp,
  close
from
  finance_quote_hourly
where
  symbol = 'AAPL'
order by
  timestamp desc;

Hourly prices for Amazon on April 29th, 2020

Explore the fluctuation of Amazon's stock prices on a specific date, April 29th, 2020, by analyzing the closing prices for each hour. This can assist in understanding the stock's performance and volatility throughout that day.

select
  timestamp,
  close
from
  finance_quote_hourly
where
  symbol = 'AMZN'
  and date(timestamp) = '2020-04-29'
order by
  timestamp;

select
  timestamp,
  close
from
  finance_quote_hourly
where
  symbol = 'AMZN'
  and date(timestamp) = '2020-04-29'
order by
  timestamp;

Schema for finance_quote_hourly

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_hourly