Skip to main content
Try the free 10-fund sample. Query the full return history of VOO, VTI, QQQ, VEA, BND, VUG, PIMIX, VFIAX, IXUS and AEPGX at no cost before you buy access to every fund.

Overview

This product delivers daily trailing and calendar-year total returns for more than 31,000 US mutual funds and ETFs, computed from split- and distribution-adjusted end-of-day prices and ready to query in Snowflake. A free sample of 10 widely held funds and ETFs lets you check the data before you buy. It’s built for fund analysts, advisors, wealth and fintech platforms, and data teams who need fund performance next to their own data in Snowflake: screening, peer comparisons, client reporting and dashboards. It removes the job of pulling prices for tens of thousands of funds, adjusting them for distributions and computing returns over 16 lookback periods every day. Data is standardized into analytic‑ready views (fund reference, trailing returns, calendar-year returns) with automated pipeline quality checks (price validation, return bounds, a YTD-to-calendar-year reconciliation, coverage of every priced fund) so you can query, join, model and build dashboards right away, without building or maintaining your own fund pricing and returns pipeline.

Try the free 10-fund sample on the Snowflake Marketplace

Free sample of 10 funds and ETFs, then $250/month flat rate for all 31,000+ — no pipelines to build.
Pricing: one flat subscription of $250/month, billed monthly in advance through Snowflake. It includes every view, returns for every fund with full history, and every daily refresh. There are no per-query, per-row or per-user fees; your own Snowflake warehouse pays for the queries you run.
  • Free sample: 10 widely held funds and ETFs, with full history, at no cost
  • 31,472 US mutual funds and ETFs with returns: 25,523 mutual funds and 5,949 ETFs, as of November 2026
  • 16 trailing periods per fund per trading day, from 1-day to 20-year plus since inception
  • Calendar-year returns for every year a fund has traded, 423,506 fund-years in all
  • Deep history: back to 1973 for the oldest mutual funds; 17,259 funds have 10+ years and 7,586 have 20+ years
  • 101.7 million rows of daily trailing returns
  • Refreshed every day, starting at 9:00 PM Pacific, with a full rebuild of all history twice a week
  • Automated pipeline quality checks (price validation, return bounds, YTD reconciliation, coverage)
Fruit Stand also publishes FRED economic data, historical stock prices, earnings call transcripts and EIA energy data on the Snowflake Marketplace.

What are trailing and calendar-year returns?

A fund’s total return is how much an investment grew, counting both the change in price (or NAV, for mutual funds) and the dividends and other distributions it paid, as if they were reinvested. It’s the standard way fund fact sheets, Morningstar and the SEC report performance. Raw closing prices miss distributions, which for bond and income funds are most of the return. Returns come in two forms. Trailing returns cover a fixed window ending on a given day, such as the 1-year or 10-year return as of yesterday. Calendar-year returns cover each year from January 1 to December 31, so you can see how a fund did in 2022 versus 2023. What’s available, at a glance:
  • Trailing returns: 1-day, 1-week, 1-month, 3-month, 6-month, YTD and 1-year (cumulative), plus 2-, 3-, 4-, 5-, 7-, 10-, 15- and 20-year and since-inception (annualized)
  • Calendar-year returns: one per fund per year, with the start and end dates used
  • Fund reference data: name, type, exchange, ISIN, active status and the date range each fund has returns for
  • Coverage: US-listed mutual funds (all share classes) and ETFs, priced in US dollars
Prices come from a licensed commercial end-of-day pricing provider; every return is calculated by Fruit Stand. Individual stocks, funds that have stopped trading and fund holdings aren’t included in the returns (see “What isn’t included?” in the FAQ below).

Coverage

As of November 2026 (data through November 18, 2026): Each fund’s history starts at its first available price, not at a fixed date shared by every fund. fund_vw.min_return_date and max_return_date give each fund’s range. The type column is the provider’s label: mutual funds show as either FUND or Mutual Fund, and two exchange-traded commodity products as ETC. The table above groups FUND and Mutual Fund together and counts ETC with ETFs. Funds that have stopped trading (1,010 today) stay in fund_vw with is_inactive = true, but they have no returns: prices are only fetched for active funds, and the twice-weekly full rebuild recomputes returns from those. Another 108 active funds don’t have returns yet.

Schema

The listing has three views. Join them on code, the fund or ETF ticker (for example VFIAX or VOO). The share also includes a semantic view (MUTUAL_FUND_AND_ETF_TRAILING_AND_CALENDAR_YEAR_RETURNS_SV_GZTYZTG3LLO9) and a Cortex agent built on it, for asking questions in plain English with Snowflake Cortex.

fund_vw

One row per fund or ETF, including funds that have stopped trading. During the free sample this view lists every fund; the two returns views show only the 10 sample tickers.

fund_trailing_returns_vw

One row per fund per trading day (code, as_of_date), with one column per trailing period. Returns are decimals: 0.118688 is 11.87%. A period column is null when the fund doesn’t have enough history for it, for example return_10y for a fund launched in 2020.

fund_calendar_year_returns_vw

One row per fund per calendar year (code, calendar_year). The current year’s row is a year-to-date return and matches return_ytd on the latest as_of_date. A fund’s first year is a partial return from its first trading day.

Example queries

All example output below is real, pulled from the listing on November 20, 2026 at 03:23 UTC. Each query finished in under 2.5 seconds on an X-Small warehouse. Returns are decimals (0.118688 = 11.87%). Every fund with returns shown here is in the free sample, so you can run these queries before you buy.

What are a fund’s latest trailing returns?

Which share classes does a fund have?

Find every active Vanguard Total Bond Market fund and ETF by name, with the date each one’s returns start:

How did a fund do in each calendar year?

First 6 of 16 rows: The 2026 row is year to date and equals return_ytd in the first example. All 16 years:

How has a fund’s 1-year return moved over time?

VTI’s trailing 1-year return at each month end since 2016:
Last 5 of 131 rows:

How do funds compare side by side?

Join fund_vw for names and types, and take each fund’s latest row. This puts ETFs and a mutual fund (VFIAX) on the same total-return basis:
VOO (the ETF) and VFIAX (the Admiral mutual fund share class) track the same index, and their 1-, 5- and 10-year returns agree to within 0.04 percentage points. More worked examples on the blog:

Return Calculations

Adjusted closing price: every return is calculated from adjusted closing prices, not raw closes or NAVs. The adjusted close accounts for splits and for dividends and distributions as if reinvested, so returns are total returns. When a fund pays a new distribution or splits, the provider rescales its whole adjusted-close history; the pipeline refetches that fund’s full history and recomputes its returns. Base price: for each period, the base is the last available price on or before the target date. The target is the same day 1 day, 1 week, 1, 3 or 6 months, or 1 to 20 years earlier; December 31 of the prior year for YTD; and the fund’s first price for since-inception. A fund launched this year uses its first price as the YTD base. Cumulative return: the plain percentage change between two adjusted closing prices:
This is used for every calendar-year return and for the 1-day through 1-year trailing periods, including YTD. Annualized return (CAGR): for the 2-year through 20-year periods and since-inception, returns are annualized to a compound annual growth rate so windows of different lengths compare on the same basis:
days_between is the number of calendar days from the base date to the as-of date. Following SEC and Morningstar convention, a span under 365 days is never annualized: a fund less than a year old gets a cumulative return_earliest_available instead. Every return is stored as number(32,6), a fixed-point decimal rounded to 6 places.

Data Ingestion

Data is ingested into Snowflake with best practices in mind, across four chained stages.
1

Fund universe

The list of US-listed ETFs and mutual funds is pulled from the pricing provider each run and loaded into Snowflake. New funds are added, and funds that drop off the list are marked inactive.
2

Price history

End-of-day prices for every active fund are fetched, written to parquet in a dated S3 folder and copied into Snowflake. The provider’s dividend and split feeds for the last 5 days are checked first, and any fund with a new distribution or split has its full price history refetched.
3

Placeholder cleanup

Zero adjusted closes, the provider’s adjustment overflow value (999999.9999), and a lone first price more than 4 days before a fund’s next price are flagged and left out of every return calculation.
4

Returns computation

Once the prices land, trailing and calendar-year returns are recomputed with the formulas above and merged into the listing’s views.
Refresh cadence: the pipeline starts at 9:00 PM Pacific every day and picks up that day’s closing prices and NAVs. On Sunday, Monday, Tuesday, Thursday and Friday it fetches the last 5 days of prices in bulk and recomputes the latest 30 trading days of trailing returns and the current and prior calendar years. On Wednesday and Saturday it refetches every fund’s full price history and rebuilds all returns from scratch. Mutual fund NAVs post on each fund’s own schedule, so some funds can be a day or more behind the latest as_of_date: 31,019 funds had a row for November 18, 2026. Cross-region replication: the listing is replicated to other Snowflake regions by auto-fulfillment daily at 5:00 AM Pacific. For a deeper look at how this pipeline is built (S3 staging, the Snowflake COPY INTO, and the dbt models behind the views), see How Fund Returns Data Moves from source to Snowflake on the blog.

Data Quality

Checks on prices:
  • Positive prices: every close and adjusted close used for returns must be above zero.
  • No placeholder prices: no price at the provider’s 999999.9999 overflow value, and no isolated stub first price, is left in the calculation.
  • One price per fund per day: no duplicate (code, date) prices.
Checks on returns:
  • Unique grain: exactly one row per fund per as_of_date, and per fund per calendar_year.
  • Return floor: no return below -100%, which a ratio of two positive prices can’t produce.
  • Date order: a return’s base date is never after its as-of or end date.
  • YTD reconciliation: each fund’s latest return_ytd must equal its current-year calendar_year_return. The two are computed by separate SQL, so a mismatch means a bug in one of them.
  • Every priced fund has returns: every fund with a price on the latest date must have a trailing-return row for that date and a calendar-year row for that year.
  • Short-term sanity band: 1-day and 1-week returns beyond ±50% are flagged for review. This one warns instead of failing, because leveraged and inverse funds can move that much.
The return floor, date order, YTD and grain checks run on the newly computed returns before they’re merged into the listing’s tables. If one fails, that run’s merge is skipped and the views keep the previous run’s returns until it’s fixed. The coverage checks run right after each update.

Disclosures

Fruit Stand Data LLC is not endorsed by or affiliated with any of the underlying pricing data providers or the sponsors of the funds in the data. Use of the listing is governed by its standard Snowflake Marketplace terms. Use contact@fruitstand.dev for questions. Price gaps: the base price for each period is the last price on or before the target date. For a fund with gaps in its price history, the base can be older than the period’s name implies; for example, return_1w can span more than 7 calendar days. Placeholder zeros: rows where return_earliest_available or calendar_year_return is exactly 0 are left out of the views, since that value almost always comes from a placeholder price rather than a real return. Revisions: when the provider restates a price, or rescales a fund’s adjusted-close history after a distribution, past returns are recomputed at the next run that covers them: the last 30 trading days on any day, and all history on Wednesday and Saturday. Only current values are kept; earlier versions of a return aren’t stored.

F.A.Q.

Frequently asked questions from our clients.
Yes, a free sample rather than a time-limited trial. Ten widely held funds and ETFs (VOO, VTI, QQQ, VEA, BND, VUG, PIMIX, VFIAX, IXUS and AEPGX) can be queried at no cost, with their full trailing and calendar-year return history, so you can validate the data before you buy. fund_vw lists every fund during the sample, so you can also check coverage. Full access to all 31,000+ funds is $250/month flat. Nothing is charged unless you buy.
Trailing returns measure performance over a fixed window ending on a given day (e.g. the 1-year or 5-year return as of yesterday), with a new row every trading day. Calendar-year returns measure performance within each calendar year (e.g. 2024, 2025), which is useful for year-over-year comparisons.
Trailing periods of 2 years or longer, and since-inception, are annualized (compound annual growth rate), the standard way to compare multi-year performance. The 1-day through 1-year periods, including YTD, and every calendar-year return are cumulative, since annualizing a period under a year can be misleading. See Return Calculations.
Every day. The pipeline starts at 9:00 PM Pacific and picks up that day’s closing prices and NAVs. Five days a week it updates recent returns; on Wednesday and Saturday it rebuilds every fund’s full history.
Replication of refreshes across cloud regions begins at 5:00 AM Pacific each day. If you consume this listing from a Snowflake region other than its primary region, expect each day’s updated data to arrive after that replication run.
Each fund’s history starts at its first available price. The oldest mutual funds go back to 1973, and SPY, the oldest major ETF, to February 1993. The median mutual fund has 13 years of returns; 17,259 funds have 10+ years and 7,586 have 20+ years. fund_vw.min_return_date gives each fund’s start.
End-of-day prices, NAVs, dividends and splits are licensed from a commercial pricing data provider. Fruit Stand computes every return from those adjusted prices in Snowflake.
You can. You’d need a pricing plan that covers 31,000+ funds, daily pulls, a way to catch distributions and splits (which rescale a fund’s whole adjusted history), handling for placeholder prices, and correct base-date and annualization logic for 16 periods. This listing does all of that every day, and the free sample lets you check its numbers against your own first.
Building it yourself means a pricing data subscription, a pipeline to pull daily prices for every US fund and ETF and refetch history after each distribution, return logic for 16 trailing periods plus calendar years, quality checks, and someone to keep it running. That’s weeks of engineering up front and ongoing maintenance after. The listing is $250/month with all of it done.
They stay in fund_vw with is_inactive = true and an inactive_date, but their returns aren’t kept: prices are only fetched for active funds, and the twice-weekly rebuild recomputes returns from those. So the returns views are not survivorship-bias-free. 1,010 inactive funds are listed today.
Individual stocks, returns for funds that have stopped trading, fund holdings, expense ratios, fund categories, risk statistics and non-US funds. Returns don’t account for sales loads or taxes. Daily prices for stocks, ETFs and mutual funds are in our historical stock prices listing.
Yes! Please reach out to contact@fruitstand.dev with the requirements. We are more than happy to make it available.

Try the free 10-fund sample on the Snowflake Marketplace

Query 10 funds and ETFs at no cost, then $250/month flat rate for all 31,000+.