> For the complete documentation index, see [llms.txt](https://docs.coupler.io/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://docs.coupler.io/sources/category/finance-and-accounting/yahoo-finance-price/data-overview.md). # 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. --- # Agent Instructions This documentation is published with GitBook. GitBook is the documentation platform designed so that both humans and AI agents can read, navigate, and reason over technical content effectively. Learn more at gitbook.com. ## Querying This Documentation If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question. Perform an HTTP GET request on the current page URL with the `ask` query parameter, and the optional `goal` query parameter: ``` GET https://docs.coupler.io/sources/category/finance-and-accounting/yahoo-finance-price/data-overview.md?ask=&goal= ``` `ask` is the immediate question: it should be specific, self-contained, and written in natural language. `goal` is optional and describes the broader end goal you are ultimately trying to accomplish on behalf of the user. GitBook uses it to tailor the answer towards what is most useful for that goal. The response will contain a direct answer to the question and relevant excerpts and sources from the documentation. Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.