steampipe plugin install finance

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

NameTypeOperatorsDescription
_ctxjsonbSteampipe context in JSON form.
adjusted_closedouble precisionAdjusted close price after accounting for any corporate actions.
closedouble precisionLast price during the regular trading session.
highdouble precisionHighest price during the trading session.
lowdouble precisionLowest price during the trading session.
opendouble precisionOpening price during the trading session.
sp_connection_nametext=, !=, ~~, ~~*, !~~, !~~*Steampipe connection name.
sp_ctxjsonbSteampipe context in JSON form.
symboltext=Symbol to quote.
timestamptimestamp with time zoneTimestamp of the record.
volumebigintTotal 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