turbot/finance

steampipe plugin install financesteampipe plugin install finance
On This Page
Get Involved

Table: finance_quote_hourly

Historical price data by hour for a given symbol.

Note:

  • A symbol must be provided in all queries to 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)

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

Hourly prices for Amazon on April 29th, 2020

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

.inspect finance_quote_hourly

Hourly historical quotes for a given symbol.

NameTypeDescription
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.
symboltextSymbol to quote.
timestamptimestamp without time zoneTimestamp of the record.
volumebigintTotal trading volume (units bought and sold) during the period.