Historical price data by hour for a given symbol.
symbolmust be provided in all queries to this table.
- History is limited to the last 13 months.
- Symbol types are defined in finance_quote.
Apple hourly price history (most recent first)
selecttimestamp,closefromfinance_quote_hourlywheresymbol = 'AAPL'order bytimestamp desc
Hourly prices for Amazon on April 29th, 2020
selecttimestamp,closefromfinance_quote_hourlywheresymbol = 'AMZN'and date(timestamp) = '2020-04-29'order bytimestamp
Hourly historical quotes for a given symbol.
|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.|
|symbol||text||Symbol to quote.|
|timestamp||timestamp without time zone||Timestamp of the record.|
|volume||bigint||Total trading volume (units bought and sold) during the period.|