📈 Alpha Vantage Public Market Data Scraper

🚀 Export Alpha Vantage market data in seconds. Daily, intraday, FX, crypto, and technical indicators - direct from the public alphavantage.co/query endpoint to CSV, Excel, JSON, or XML.

🕒 Last updated: 2026-05-26 · 📊 10 fields per record · 20+ Alpha Vantage functions · Stocks, FX, Crypto, Indicators · Real-time and historical

The Alpha Vantage Public Market Data Scraper turns the alphavantage.co public REST endpoint into a clean, structured dataset. It calls the /query endpoint with whichever function you select - TIME_SERIES_DAILY, GLOBAL_QUOTE, CURRENCY_EXCHANGE_RATE, SMA, OVERVIEW, and more - parses the JSON response, and flattens it into one row per data point.

You can either bring your own free Alpha Vantage API key (recommended for production - get one for free at alphavantage.co/support/#api-key) or rely on the public demo key (very limited, only specific symbols work).

🎯 Target Audience	💡 Primary Use Cases
📊 Quant analysts	Pull daily/intraday OHLCV for backtesting
💱 FX & crypto traders	Stream exchange-rate quotes into spreadsheets
🏢 Finance teams	Snapshot fundamentals (earnings, balance sheet, cash flow)
🤖 ML engineers	Build market-data training sets
📰 Financial journalists	Verify quotes for stories with one click
👩‍💻 Developers	Mirror Alpha Vantage data into your own DB without writing client code

📋 What the Alpha Vantage Public Market Data Scraper does

• Calls https://www.alphavantage.co/query with the function and parameters you supply.
• Parses the JSON response, locates the time-series block, and flattens each timestamp into a row.
• Cleans Alpha Vantage's verbose keys (1. open → open, 5. volume → volume).
• Casts numeric fields to numbers so they import cleanly into Excel and BI tools.
• Surfaces Alpha Vantage's rate-limit and error notes as a single-row error record instead of crashing.
• Exports as CSV, Excel, JSON, JSONL, XML, RSS, or HTML.

💡 Why it matters: Alpha Vantage is one of the few financial APIs with a generous free tier, but its JSON responses use awkward numbered keys like 1. open and 5. volume that break most data tools. This actor normalizes everything to clean snake_case so the data drops straight into pandas, BigQuery, or a Google Sheet.

🎬 Full Demo

🚧 Coming soon.

⚙️ Input

Field	Type	Required	Description
function	enum	No	Alpha Vantage function: TIME_SERIES_DAILY, GLOBAL_QUOTE, CURRENCY_EXCHANGE_RATE, SMA, OVERVIEW, etc. Default: TIME_SERIES_DAILY.
symbol	string	No	Ticker (e.g. IBM, AAPL, TSLA). Prefill: IBM.
maxItems	integer	No	Free users: 10. Paid users: up to 1,000,000. Prefill: 10.
fromCurrency / toCurrency	string	No	For FX functions. E.g. USD → EUR.
interval	enum	No	For intraday functions: 1min, 5min, 15min, 30min, 60min.
outputsize	enum	No	compact (100 points) or full (full history).
apiKey	secret string	No	Your free Alpha Vantage key. If empty, uses demo (very limited).

Example 1 - IBM daily history:

{
  "function": "TIME_SERIES_DAILY",
  "symbol": "IBM",
  "maxItems": 100,
  "apiKey": "demo"
}

Example 2 - USD/EUR exchange rate:

{
  "function": "CURRENCY_EXCHANGE_RATE",
  "fromCurrency": "USD",
  "toCurrency": "EUR",
  "apiKey": "demo"
}

⚠️ Good to Know: The public demo API key only returns data for a small set of demo symbols (IBM, AAPL, MSFT). For anything else, grab a free key at alphavantage.co/support/#api-key and pass it via the apiKey input. Free Alpha Vantage keys are rate-limited to 25 requests per day.

📊 Output

Each record is a flat object. imageUrl is always first, error is always last.

Field	Type	Description
🔧 function	string	Which Alpha Vantage function was called.
📈 symbol	string	Ticker or pair identifier.
📅 date	string	Date or timestamp of the data point.
🔓 open	number	Open price.
⬆️ high	number	High price.
⬇️ low	number	Low price.
🔒 close	number	Close price.
📊 volume	number	Volume traded.
🕒 scrapedAt	string	When this row was fetched.
❌ error	string	Set if the upstream response was an error/rate-limit.

Sample record (IBM daily):

{
  "function": "TIME_SERIES_DAILY",
  "symbol": "IBM",
  "date": "2026-05-23",
  "open": 263.45,
  "high": 265.92,
  "low": 262.10,
  "close": 264.88,
  "volume": 3812904,
  "scrapedAt": "2026-05-26T13:00:00.000Z",
  "error": null
}

✨ Why choose this Actor

| 🆓 | Works with the free Alpha Vantage tier and the public demo key. | | 🧹 | Strips Alpha Vantage's clunky 1., 2., 3. numeric key prefixes - clean column names ready for BI. | | 🔢 | Auto-casts numeric strings to real numbers so Excel and pandas don't fight you. | | 🛟 | Surfaces Alpha Vantage's rate-limit notes as a clean error record instead of crashing. | | 🔌 | 20+ Alpha Vantage functions exposed - daily, intraday, FX, crypto, indicators, fundamentals. | | 💾 | Push to dataset → instant CSV / Excel / JSON / XML / RSS / HTML export. |

📈 How it compares to alternatives

Approach	Setup time	Clean keys?	Numeric casting?	Rate-limit handling?
Roll your own fetch	30 min +	❌	❌	❌
Python alpha_vantage lib	1 hr install + script	✅	partial	partial
This Actor	5 sec, no install	✅	✅	✅

🚀 How to use

1. Click Try for free.
2. Pick a function and symbol (or leave defaults - TIME_SERIES_DAILY + IBM work with the public demo key).
3. (Optional) Paste your own free Alpha Vantage key in apiKey for higher limits and any symbol.
4. Click Start. Within seconds, your dataset is ready - download as CSV, Excel, JSON, or XML, or pipe to your warehouse.

💼 Business use cases

📊 Backtesting & quant research. Pull TIME_SERIES_DAILY_ADJUSTED for your watchlist into a single CSV, feed pandas, run your strategy.

💼 Treasury / FX hedging. Schedule a daily run of CURRENCY_EXCHANGE_RATE for USD→EUR, USD→GBP, USD→JPY and pipe to your finance dashboard.

📰 Newsroom fact-checking. Reporters can verify a closing price for a story in 30 seconds, no Bloomberg terminal needed.

🤖 ML feature engineering. Build a clean training set of OHLCV + technical indicators (SMA, EMA, RSI, MACD) for any symbol.

🔌 Automating Alpha Vantage Public Market Data Scraper

• Make / Zapier: trigger this actor every market close, push results to Airtable, Google Sheets, or Slack.
• Cron schedule: native Apify scheduler - run every weekday at 16:30 ET to pull end-of-day quotes.
• Webhooks: get a POST to your endpoint the moment a run finishes.
• Pipe to BigQuery / Snowflake / Postgres: native Apify integrations move datasets straight into your warehouse.

🌟 Beyond business use cases

🎓 Education. Teach a finance class? Have students pull their own datasets in seconds instead of paying for Bloomberg seat licenses.

🧪 Personal research. Track your own portfolio's daily moves, compute custom indicators, plot them in your favourite tool.

🤝 Non-profit & open data. Build public dashboards of market sentiment, currency strength, or commodity trends without writing client code.

🧰 Tinkering & prototyping. Spin up a market data feed in 5 seconds to test a new chart library or trading bot idea.

🤖 Ask an AI assistant about this scraper

Pop this README into ChatGPT, Claude, or any AI assistant and ask it to map your specific workflow to the actor's inputs. The schema, examples, and field list above contain everything an LLM needs to design a working pipeline.

❓ Frequently Asked Questions

❓ Do I need an API key? Not strictly - the public demo key works for a few demo symbols (IBM, AAPL, MSFT). For real use, grab a free key at alphavantage.co/support/#api-key.

❓ Is there a rate limit? Yes - Alpha Vantage's free tier is 25 requests/day per key. This actor surfaces rate-limit notes as a clean error record.

❓ Which functions are supported? All 20+ in the dropdown: time series (intraday/daily/weekly/monthly), FX, crypto, technical indicators (SMA, EMA, RSI, MACD), and fundamentals (OVERVIEW, EARNINGS, INCOME_STATEMENT, BALANCE_SHEET, CASH_FLOW).

❓ Can I get intraday data? Yes - set function to TIME_SERIES_INTRADAY or CRYPTO_INTRADAY and pick an interval (1, 5, 15, 30, or 60 min).

❓ Are values cast to numbers? Yes. Alpha Vantage returns everything as strings; this actor auto-casts numeric fields so they import cleanly.

❓ How do you handle rate-limit responses? Alpha Vantage returns a Note or Information field when you hit a limit. We push a single record with error populated instead of throwing.

❓ Can I schedule runs? Yes - use Apify's native scheduler or hook this up to Make / Zapier / cron.

❓ Is this scraping or API? API. Alpha Vantage's /query endpoint is fully public; we're just normalizing the response.

❓ Will the schema change? function, symbol, date, OHLCV, and error are stable. Function-specific fields (e.g. SMA outputs an SMA value) are passed through as-is.

❓ What format can I download? CSV, Excel, JSON, JSONL, XML, RSS, or HTML - straight from the Apify dataset UI.

🔌 Integrate with any app

Apify ships native integrations with Make, Zapier, Slack, Discord, Google Drive, Google Sheets, Gmail, Airbyte, Keboola, Telegram, GitHub, and any REST API or webhook endpoint. Trigger runs from a calendar event, a form submission, a cron job, or pipe results straight into BigQuery, Snowflake, or a Postgres warehouse.

🔗 Recommended Actors

Actor	What it does
ParseForge Yahoo Finance Scraper	Equities, funds, indices, options chains.
ParseForge NBA Stats Scraper	Player and team stats from NBA.com.
ParseForge CurseForge Mods Scraper	Public mod metadata from CurseForge.
ParseForge OurAirports Scraper	Global airport database.

💡 Pro Tip: browse the complete ParseForge collection for 900+ production-grade scrapers across business intelligence, real estate, e-commerce, sports, finance, and public records.

---

Disclaimer: This actor scrapes only publicly available data. ParseForge is not affiliated with, endorsed by, or sponsored by any of the third-party services referenced. Users are responsible for complying with the target site's terms of service and applicable law. Create a free account w/ $5 credit.