Data Overview

The Yahoo Finance Price source returns price history for any publicly traded stock, ETF, or index. You configure which tickers to pull, how granular the data should be, and how far back it should go.

Available entity

Entity	Description
Prices	OHLCV price bars for one or more tickers at a chosen interval and date range

Available fields

Price data

Field	Type	Description
Ticker	String	The stock symbol (e.g., AAPL, MSFT)
Timestamp	DateTime	The date and time of the price bar
Open	Number	Opening price for the interval
High	Number	Highest price during the interval
Low	Number	Lowest price during the interval
Close	Number	Closing price for the interval
Adjusted Close	Number	Close price adjusted for splits and dividends
Volume	Number	Number of shares traded during the interval

Interval options

Interval	Label
1m	1 minute
5m	5 minutes
15m	15 minutes
30m	30 minutes
90m	90 minutes
1h	1 hour
1d	1 day
5d	5 days
1wk	1 week
1mo	1 month
3mo	3 months

Date range options

Range	Label
1d	1 day
5d	5 days
7d	7 days
1mo	1 month
3mo	3 months
6mo	6 months
1y	1 year
2y	2 years
5y	5 years
ytd	Year to date
max	Maximum available history

Common field combinations

• Close + Timestamp — the minimum you need for a price chart or trend line

• Open + Close + Volume — useful for identifying trading sessions with above-average activity

• High + Low + Close — inputs for volatility indicators like ATR or Bollinger Bands

• Adjusted Close — preferred for long-term return calculations because it accounts for splits and dividends

• Ticker + Close + Timestamp — essential when tracking multiple symbols side by side

Use cases by role

Finance teams

• Pull daily closing prices for a portfolio of holdings into Google Sheets or Excel to calculate returns, drawdowns, and correlations

• Use the Append transformation to combine price history from multiple tickers into a single table for portfolio-level analysis

• Send historical price data to BigQuery and join it with your internal transaction records to calculate cost-basis and P&L

• Use the max date range with 1mo intervals to build long-term performance charts in Looker Studio

Analysts & Researchers

Product & Operations

Platform-specific notes

• Intraday intervals (1m through 1h) are only available for recent date ranges — typically the last 7–60 days depending on the interval. Using a long date range with a short interval may return no data or an error.

• The max date range returns the full available history for the ticker, which can be very large for frequently traded stocks — consider using 1mo or 3mo intervals with max to keep row counts manageable.

• Adjusted Close values are recalculated retroactively when splits or dividends occur, so historical values may shift slightly between pulls.

• Yahoo Finance data is sourced from exchanges and may have a 15-minute delay for some markets during trading hours.