Alpha Vantage API

Build a stock portfolio tracker with historical data

Pull daily stock prices, fundamentals, and earnings data. Track your portfolio's performance over time, calculate rolling returns, and spot trends.

Free API key. 25 requests/day.

Alpha Vantagedocs →

How it works with Loony

Describe it.
Deploy it.
Query it.

Managed database.

Your Alpha Vantage data lives in its own Postgres instance. Zero config. Data accumulates over time.

Scheduled syncs.

Cron jobs run on Loony infra. Every minute on free. Your data stays fresh without you thinking about it.

REST + MCP endpoints.

Query from your agent, your dashboard, or connect BI tools directly. Full OpenAPI spec included.

TerminalSchema
$ "Pull daily closing prices for my watchlist (AAPL, MSFT, GOOG, AMZN, TSLA) from Alpha Vantage. Calculate 30-day and 90-day rolling returns."

✓ Schema validated
✓ Database provisioned
✓ Scripts deployed
✓ Schedules registered

Done.

# Your data is now at:
REST  /data/v1/alpha-vantage/query
MCP   /mcp/v1/alpha-vantage/mcp
SQL   psql $DATABASE_URL

What you get

Alpha Vantage gives you 25 calls a day. Loony makes each one count by storing every response in your database. Over weeks, you build a rich time series without hitting rate limits. Query historical data instantly.

mv_portfolio_performance
  date          date        -- trading day
  symbol        text        -- ticker
  close         numeric     -- closing price
  return_30d    numeric     -- 30-day rolling return %
  return_90d    numeric     -- 90-day rolling return %
  volume        bigint      -- daily volume

Even better together

Pair stock data with Finnhub earnings surprises for event-driven analysis. Add CoinGecko crypto data for a unified portfolio view across asset classes.

Finnhub

Monitor earnings surprises and market news sentiment

CoinGecko

Track crypto prices, sentiment, and market trends

Stop gluing. Start shipping.

Describe your data. Deploy. Query. Done.

API Library →