Fruit StandFruit Stand
  • Pricing
  • Documentation
  • API Reference
  • Pricing
Getting Started
    IntroductionQuickstart & recipesMCP setup
The Data
Using the API
Policies
Links
    Fruit Stand homeSnowflake Marketplace (bulk)
powered by Zuplo
Getting Started

Fruit Stand Fund Returns API

Clean, ready-to-use trailing and calendar-year total returns for roughly 32,000 US mutual funds and ETFs — computed from adjusted end-of-day pricing and refreshed daily. Available as a REST API and as a hosted MCP server, both authenticated with the same API key.

No pipelines to build, no pricing data to clean — just point lookups that return the numbers you'd otherwise spend weeks computing.

Get a free API key

What's covered

  • Universe: ~32,000 US-listed mutual funds and ETFs.
  • Trailing returns: every period from 1-day through 20-year, plus YTD and since-inception. Periods under 2 years are cumulative; 2 years and longer are annualized (CAGR).
  • Calendar-year returns: annual total return broken out year by year, back to each fund's inception.
  • Survivorship-bias-free: delisted and inactive funds keep their full return history.
  • Freshness: recomputed daily on trading days as new end-of-day pricing arrives.

Get started

  1. Sign in and get a key

    Sign in to the portal and create an API key from your account. Send it as a bearer token:

    TerminalCode
    curl https://api.fruitstand.dev/v1/funds/SPY \ -H "Authorization: Bearer YOUR_API_KEY"
  2. Look up returns

    Latest trailing returns for a fund (add ?as_of=YYYY-MM-DD for a historical snapshot):

    TerminalCode
    curl https://api.fruitstand.dev/v1/funds/SPY/trailing-returns \ -H "Authorization: Bearer YOUR_API_KEY"

    Calendar-year returns (add ?year=YYYY for a specific year):

    TerminalCode
    curl https://api.fruitstand.dev/v1/funds/SPY/calendar-returns \ -H "Authorization: Bearer YOUR_API_KEY"
  3. Pull many funds at once

    Need returns for a whole watchlist? The batch endpoints take up to 100 funds in a single call:

    TerminalCode
    curl https://api.fruitstand.dev/v1/trailing-returns/batch \ -H "Authorization: Bearer YOUR_API_KEY" \ -H "Content-Type: application/json" \ -d '{"codes": ["SPY", "QQQ", "VTI"]}'
  4. Use it from an MCP client

    Point any MCP client (Claude, etc.) at https://api.fruitstand.dev/mcp with your key as a bearer token. It exposes six tools — searchFunds, getFund, getTrailingReturns, batchTrailingReturns, getCalendarReturns, batchCalendarReturns — so an assistant can pull fund returns directly into a conversation.

See the full API Reference for every endpoint and field, and Pricing for plans. Need the entire dataset in bulk instead of a metered API? It's also on the Snowflake Marketplace.

Last modified on September 8, 2026
Quickstart & recipes
On this page
  • What's covered
  • Get started