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: 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)
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
Coverage
As of November 2026 (data through November 18, 2026):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 oncode, 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%.
return_10y for a fund launched in 2020.
fund_calendar_year_returns_vw
One row per fund per calendar year (code, calendar_year).
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?
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:How do funds compare side by side?
Joinfund_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:
- How to Compare ETF and Mutual Fund Performance in Snowflake
- How to Compare a Fund’s Returns With Its Benchmark in SQL
- How to Calculate Rolling Returns and Max Drawdown in SQL
- Where to Get Trailing Returns for Every US Fund and ETF in Bulk
- Where to Get Daily NAV History for US Mutual Funds in SQL
- How to Calculate Stock Returns From Daily Prices in SQL
- Fund and ETF Returns Data on Snowflake, Compared
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: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.Fund universe
Price history
Placeholder cleanup
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.Returns computation
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.9999overflow value, and no isolated stub first price, is left in the calculation. - One price per fund per day: no duplicate
(code, date)prices.
- Unique grain: exactly one row per fund per
as_of_date, and per fund percalendar_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_ytdmust equal its current-yearcalendar_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.
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.Is there a free trial?
Is there a free trial?
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.What's the difference between trailing returns and calendar-year returns?
What's the difference between trailing returns and calendar-year returns?
Why are some returns annualized and others aren't?
Why are some returns annualized and others aren't?
How often is the data refreshed?
How often is the data refreshed?
When does replication across cloud regions happen?
When does replication across cloud regions happen?
How far back does the historical data go?
How far back does the historical data go?
fund_vw.min_return_date gives each fund’s start.How is the data obtained?
How is the data obtained?
Why not compute returns from a pricing API myself?
Why not compute returns from a pricing API myself?
What does it cost to build this ourselves vs. buy the listing?
What does it cost to build this ourselves vs. buy the listing?
Are funds that closed or merged included?
Are funds that closed or merged included?
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.What isn't included?
What isn't included?
Can I request additional funds or ETFs to be made available in Snowflake?
Can I request additional funds or ETFs to be made available in Snowflake?