# 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

{% tabs %}
{% tab title="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
  {% endtab %}

{% tab title="Analysts & Researchers" %}

* Pull intraday data (`1m` or `5m` interval) for short-term pattern analysis or backtesting trading strategies
* Combine Yahoo Finance Price data with macroeconomic datasets using Coupler.io's **Join** transformation
* Send price data to AI destinations like ChatGPT or Claude to generate plain-language summaries of recent price movements
* Use `ytd` range with `1d` interval to benchmark a watchlist of stocks against each other year-to-date
  {% endtab %}

{% tab title="Product & Operations" %}

* Track the price of publicly listed competitors or suppliers on a scheduled basis to inform procurement or strategy decisions
* Set up a data flow pulling weekly prices (`1wk` interval) into a shared Google Sheet that stakeholders can view without any finance tooling
* Use Gemini or Perplexity as a destination to ask questions about price trends in natural language
  {% endtab %}
  {% endtabs %}

## 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.