turbot/finance

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

Table: finance_quote_hourly

Historical price data by day for a given symbol.

Note:

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

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

Top 10 days by volume for Apple

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

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

.inspect finance_quote_daily

Daily 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.