Intraday History 1 Hour Intervals

Returns intraday price data aggregated into 1-hour bars using QuoteMedia's data service.

Supported Symbol Formats

Type Format Example
US Stocks SYMBOL AAPL, MSFT
ETFs SYMBOL SPY, QQQ

Parameters

Parameter Type Required Description
Symbol String Yes Stock ticker symbol

Output Columns

Column Description
DateTime Bar timestamp
Open Opening price for the hour
High High price for the hour
Low Low price for the hour
Close Closing price for the hour
Volume Volume for the hour

Notes

  • Each bar represents 1 hour of trading
  • Regular trading day has ~7 hourly bars
  • Least granular intraday data, least noise

Examples

=QM_GetIntradayDataOneHour("AAPL")
Apple hourly bars
=QM_GetIntradayDataOneHour("SPY")
SPY hourly bars
=QM_GetIntradayDataOneHour("MSFT")
Microsoft hourly bars
=QM_GetIntradayDataOneHour(A1)
Symbol from cell reference

When to Use

  • Longer-term intraday analysis
  • Position trading
  • Hourly trend analysis
  • When 5/15-min is too noisy

When NOT to Use

Scenario Use Instead
Need daily data QM_GetHistory()
Need 5-minute bars QM_GetIntradayDataFiveMinutes()
Need 15-minute bars QM_GetIntradayDataFifteenMinutes()
Need auto-updating QM_GetIntradayDataOneHourDynamic()

Common Issues & FAQ

Q: How many hourly bars are in a trading day? A: Regular market hours (9:30 AM - 4:00 PM ET) produce approximately 7 hourly bars.

Q: Why is the data not updating? A: This is a static function. Use QM_GetIntradayDataOneHourDynamic() for auto-updating data.

Q: Is this too coarse for day trading? A: Possibly. Consider 5-minute or 15-minute bars for active day trading.

Get Access to 1 Billion Usable Market data points IN YOUR EXCEL SHEETS WITH EASY TO USE EXCEL FUNCTIONS

Get started today
MarketXLS Excel Add-in Tutorial - How to Use Intraday History 1 Hour Intervals and Other Financial Formulas
▶
How does MarketXLS work?

Related Functions