Intraday History 5 Minute Intervals
Returns intraday price data aggregated into 5-minute 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 5-min period |
| High | High price for the 5-min period |
| Low | Low price for the 5-min period |
| Close | Closing price for the 5-min period |
| Volume | Volume for the 5-min period |
Notes
- Data is for current/recent trading day
- Each bar represents 5 minutes of trading
- Useful for short-term analysis and day trading
Examples
=QM_GetIntradayDataFiveMinutes("AAPL")=QM_GetIntradayDataFiveMinutes("SPY")=QM_GetIntradayDataFiveMinutes("TSLA")Symbol from cell reference
When to Use
- Day trading analysis
- Short-term technical analysis
- Building intraday charts
- Monitoring price action
When NOT to Use
Common Issues & FAQ
Q: How much intraday data is available? A: Typically current trading day data. For multiple days of intraday data, use the Dynamic version with RecordCount parameter.
Q: Why is the data not updating?
A: This is a static function. Use QM_GetIntradayDataFiveMinutesDynamic() for auto-updating data.
Q: What are market hours for the data? A: Data covers regular market hours (9:30 AM - 4:00 PM ET). Pre/post market data may or may not be included.
Get Access to 1 Billion Usable Market data points IN YOUR EXCEL SHEETS WITH EASY TO USE EXCEL FUNCTIONS
Get started today
▶
How does MarketXLS work?