Intraday History 1 Minute Intervals
Returns intraday price data aggregated into 1-minute bars using QuoteMedia's data service. This is the finest granularity available.
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 minute |
| High | High price for the minute |
| Low | Low price for the minute |
| Close | Closing price for the minute |
| Volume | Volume for the minute |
Notes
- Most granular intraday data available
- ~390 bars per trading day
- Best for scalping and micro-analysis
- Large data volume - use with caution
Examples
=QM_GetIntradayDataOneMinutes("AAPL")=QM_GetIntradayDataOneMinutes("SPY")=QM_GetIntradayDataOneMinutes("TSLA")Symbol from cell reference
When to Use
- Scalping strategies
- High-frequency analysis
- Micro price pattern analysis
- Precise entry/exit timing
When NOT to Use
| Scenario | Use Instead |
|---|---|
| Need daily data | QM_GetHistory() |
| Need less granular data | 5-min, 15-min, or 1-hour functions |
| Need auto-updating | QM_GetIntradayDataOneMinutesDynamic() |
| Too noisy | Use larger intervals |
Common Issues & FAQ
Q: Why is there so much data? A: 1-minute bars produce ~390 data points per trading day. Consider using larger intervals if this is overwhelming.
Q: My spreadsheet is slow. What can I do? A: 1-minute data is resource-intensive. Consider using 5-minute bars for most day trading needs.
Q: Is 1-minute too granular? A: For most purposes, yes. 5-minute or 15-minute bars are usually sufficient. 1-minute is for scalping and micro-analysis.
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?