Yahoo Finance Stock Data Scraper: OHLCV & Quotes

Extract public Yahoo Finance quote metadata and historical OHLCV rows for stocks, ETFs, indices, crypto, forex, and funds for spreadsheets, dashboards, and APIs.

Data fields

FieldTypeDescription
symbolstringYahoo Finance symbol returned for the row.
exchangeNamestring | nullExchange name from quote metadata.
currencystring | nullQuote currency.
regularMarketPricenumber | nullRegular market price from quote metadata.
previousClosenumber | nullPrevious close from quote metadata.
chartPreviousClosenumber | nullPrevious close reported by the chart endpoint.
timezonestring | nullExchange timezone.
rangestringRequested chart range.

Input preview

symbolsTicker symbols
rangeRange
intervalInterval
includeRawTimestampsInclude raw Unix timestamps
maxConcurrencyMaximum concurrency
maxRunSecondsMaximum run time

API and agents

This actor can be run through Apify API, datasets, webhooks, schedules, and the official Apify MCP server.

How this actor works

See example inputs, outputs, API usage, and practical limits before running this actor on Apify.

Open Apify page

Export public Yahoo Finance quote metadata and historical OHLCV price rows for stocks, ETFs, indices, crypto, forex, and funds.

Use this actor when you need a repeatable CSV, JSON, Excel, or API export of market data for spreadsheets, dashboards, backtests, research notebooks, or AI-agent workflows.

At a glance

  • Input: Yahoo Finance symbols such as AAPL, MSFT, SPY, BTC-USD, EURUSD=X, or ^GSPC.
  • Output: Quote metadata plus historical open, high, low, close, adjusted close, volume, dividends, splits, date, exchange, currency, timezone, and source URL.
  • Time controls: Choose Yahoo Finance chart range and interval.
  • Best for: Stock data exports, OHLCV datasets, market dashboards, and Yahoo Finance API alternative workflows.
  • No login required: Uses public Yahoo Finance data.

What can it do?

  • Export Yahoo Finance stock data: Save historical OHLCV rows for public symbols.
  • Collect quote metadata: Add exchange, currency, previous close, regular market price, and timezone context.
  • Build chart datasets: Choose ranges and intervals for daily, weekly, monthly, and intraday-style rows when available.
  • Handle mixed asset classes: Use stocks, ETFs, indices, crypto pairs, forex pairs, and funds in one run.
  • Use as a Yahoo Finance API alternative: Run from the Apify UI, API, schedules, webhooks, or the official Apify MCP server.

Common workflows

  • Investment research: Export OHLCV rows for watchlists and compare price movement over time.
  • Dashboard feeds: Send fresh rows to Google Sheets, BigQuery, a database, or a BI tool.
  • Backtest prep: Collect consistent symbol/date/open/high/low/close/volume rows.
  • Market monitoring: Schedule daily runs for a set of symbols and track latest saved rows.
  • AI-agent analysis: Let an agent fetch recent prices before summarizing a symbol or watchlist.

Input example

{
  "symbols": ["AAPL", "MSFT", "SPY", "BTC-USD"],
  "range": "1mo",
  "interval": "1d",
  "includeRawTimestamps": true,
  "maxConcurrency": 3,
  "maxRunSeconds": 270
}

Output example

{
  "symbol": "AAPL",
  "exchangeName": "NMS",
  "currency": "USD",
  "regularMarketPrice": 212.44,
  "previousClose": 211.18,
  "chartPreviousClose": 210.79,
  "timezone": "America/New_York",
  "range": "1mo",
  "interval": "1d",
  "timestamp": 1783036800,
  "date": "2026-07-02T13:30:00.000Z",
  "open": 211.52,
  "high": 214.12,
  "low": 210.88,
  "close": 212.44,
  "adjustedClose": 212.44,
  "volume": 54210000,
  "dividend": null,
  "splitRatio": null,
  "sourceUrl": "https://finance.yahoo.com/quote/AAPL",
  "scrapedAt": "2026-07-03T10:00:00.000Z"
}

Tips for best results

  • Use Yahoo Finance's exact symbol format, including suffixes like =X, -USD, or leading ^ for indices.
  • Pair short intervals with short ranges; Yahoo limits how much intraday history is available.
  • Keep maxConcurrency moderate for larger watchlists.
  • Use includeRawTimestamps when downstream tools need Unix timestamps.
  • If a bounded run stops before every symbol is processed, copy PENDING_SYMBOLS.symbols into resumeSymbols to continue the remaining work.

Limits and caveats

  • This actor exports public Yahoo Finance data and does not provide investment advice.
  • Some symbols, intervals, or ranges may be unavailable or delayed on Yahoo Finance.
  • Intraday ranges can be limited by Yahoo's public chart endpoint.
  • Yahoo Finance can rate-limit or return a block page. The Actor retries transient responses with bounded backoff, but it does not guarantee every public symbol is available.
  • A partial run keeps saved data and records RUN_SUMMARY plus PENDING_SYMBOLS; a fully empty valid lookup fails instead of returning a misleading empty success.
  • Always verify financial data before using it for trading, compliance, or high-stakes decisions.

API usage

curl "https://api.apify.com/v2/acts/fetch_cat~yahoo-finance-stock-data-scraper/runs?token=$APIFY_TOKEN" \
  -H "Content-Type: application/json" \
  -d '{
    "symbols": ["AAPL", "MSFT", "SPY"],
    "range": "1mo",
    "interval": "1d"
  }'

MCP and AI agents

You can run this actor through the official Apify MCP server at https://mcp.apify.com.

For a focused single-actor tool, use:

https://mcp.apify.com?tools=fetch_cat/yahoo-finance-stock-data-scraper

Agent-friendly inputs are symbols, range, interval, includeRawTimestamps, maxConcurrency, maxRunSeconds, and resumeSymbols.

Support

If a run fails, returns no data, or a field looks wrong, open an issue from the Actor page.

Please include the Apify run ID or run URL, input JSON, one example public URL, query, or input item, what you expected, and what the dataset returned. Small reproducible inputs make parsing or site-layout issues much faster to fix.

Privacy and data handling

This Actor runs with Apify limited permissions and only processes data needed for the documented run. It uses ticker or market inputs and public market-data results to produce the output dataset and sends requests to public Yahoo Finance Stock Data pages/endpoints; results are stored in Apify run storage for your account. FetchCat does not use your inputs or outputs for advertising, does not use them for model training, and does not retain them outside the Apify run except for transient support debugging when you explicitly share run details. You are responsible for using the Actor lawfully, respecting the target site's terms, and avoiding unnecessary personal or sensitive data in inputs.

Common questions

Questions and answers reused from the canonical actor README.

Can I export Yahoo Finance data to CSV or Excel?

Yes. Download the Apify dataset as CSV, Excel, JSON, XML, RSS, or through the Dataset API.

Can I scrape crypto or forex?

Yes, when Yahoo Finance supports the symbol, such as BTC-USD or EURUSD=X.

Why did a symbol return no rows?

The symbol may be invalid, unavailable for that interval/range, delisted, or temporarily blocked by Yahoo. Check RUN_SUMMARY for its diagnostic; no paid error row is created.

Is this real-time market data?

No guarantee. Yahoo Finance public data can be delayed or incomplete depending on the symbol and market.