Overview
The Historical Stock Prices listing delivers the complete daily end-of-day (EOD) price history for more than 49,000 US stocks, ETFs and mutual funds: 155 million daily price rows, back to 1962 for the oldest stocks, with no files to download and no APIs to call. Start with a free 30-day trial with full use of the data. It’s built for quant researchers, analysts and data teams who need clean daily prices next to their own data in Snowflake for returns, backtests, risk models and dashboards, without writing and maintaining a market data pipeline. Data is standardized into two analytic‑ready views (security reference, daily price history) with raw open, high, low and close alongside split- and dividend-adjusted open, high, low and close, plus automated pipeline quality checks (unique grain, placeholder price removal, corporate-action restatement). You can query, join, backtest and build dashboards right away.Start your free 30-day trial on the Snowflake Marketplace
- Free 30-day trial with full use of both views and every security
- 49,000+ US securities: 17,369 common stocks, 496 preferred stocks, 5,963 ETFs and 25,639 mutual funds
- 155M+ daily price rows, back to each security’s first trading day: 1962 for the oldest stocks, 1973 for mutual funds, 1993 for SPY
- Raw and adjusted OHLC: as-traded open, high, low and close, plus versions adjusted for splits and dividends/distributions
- Refreshed daily by 5:00 AM Pacific, with every security’s full history refetched and restated twice a week
- One format for every asset class, so stocks, ETFs and mutual funds can be analyzed with the same query
- Automated pipeline quality checks (unique grain, placeholder price removal, corporate-action restatement)
What is end-of-day price data?
End-of-day price data records one bar per security per trading day: the open, high, low and close, plus the number of shares traded. Stocks and ETFs trade all day on an exchange, so each bar has a real range. Mutual funds don’t trade intraday: each one publishes a single net asset value (NAV) per share after the market closes, and that NAV is the day’s price. Raw prices show what traded on the day, but they jump on splits and drop on ex-dividend dates. Adjusted prices restate history for every split and dividend since, so a price series stays continuous and can be used to measure total return. This listing carries both. The prices come from a commercial market data provider through its API; Fruit Stand loads, cleans and publishes them in Snowflake. What’s available, at a glance:- Stocks: US common stocks on NYSE, NASDAQ, NYSE American and Cboe, plus OTC stocks (Pink, OTCQB, OTCQX and other OTC tiers)
- Preferred stocks: exchange-listed preferreds, trust preferreds and some baby bonds
- ETFs: US-listed exchange-traded funds and a few exchange-traded commodities
- Mutual funds: daily NAVs for US open-end mutual funds, plus some exchange-traded closed-end funds
- Prices: raw open, high, low, close and volume, and split- and dividend-adjusted open, high, low and close
- Reference data: name, exchange, security type, normalized asset class, ISIN and active/inactive status
Coverage
As of November 2026:exchange to keep or drop them. Half of all securities have history starting in 2013 or later; 2,679 stocks and 3,160 mutual funds have history from before 2000.
Every security is US-listed and priced in US dollars. Securities are keyed by code and exchange_code together, so exchanges outside the US can be added later without breaking existing queries.
Not included: intraday or real-time prices, securities listed outside the US, and price history for securities that have been delisted (see Disclosures).
Schema
The listing’s share has two secure views:security_vw (one row per security) and security_price_history_vw (one row per security per trading day). Join them on code and exchange_code, for example code = 'AAPL' and exchange_code = 'US'.
security_vw
One row per security, including securities that have since dropped off the US symbol list.
asset_class rather than type to filter by stocks, ETFs or mutual funds. The source’s type labels aren’t consistent (mutual funds come as both FUND and Mutual Fund), so asset_class is set from the symbol list each security came from.
security_price_history_vw
One row per (code, exchange_code, date), for each day the security traded.
open, high, low and close are the prices as they traded on that day. adjusted_close is backward-adjusted for every split and dividend/distribution since, so use it for returns, charts and backtests.
adjusted_open, adjusted_high and adjusted_low apply the same day’s adjustment factor to the raw prices: adjusted_open = open * adjusted_close / close, rounded to 4 decimals (null when close is 0). That gives you a full adjusted OHLC bar for every day, so candlestick charts, daily ranges and indicators like ATR stay continuous across splits and ex-dividend dates. They’re calculated in the view from the current adjusted_close, so they’re never out of step with it after a restatement.
volume is adjusted for splits only: after a 4-for-1 split, earlier volumes are multiplied by 4 so share counts are comparable across the split.
Mutual funds priced once a day (exchange = 'NMFQS') have open, high, low and close all equal to the day’s NAV and volume of 0. About 335 securities in the fund asset class are listed on NYSE, NASDAQ, NYSE American or Pink; these trade on an exchange and have real intraday prices and volume.
Example queries
All example output below is real, pulled from the listing on November 20, 2026 at 04:22 UTC, when the latest trading date was November 18, 2026. Each query finished in under 3 seconds on an X-Small warehouse. Run the same queries yourself during the free 30-day trial.Latest closing prices
The most recent close for a stock, an ETF and a mutual fund:Find securities by name
Every active Bank of America preferred stock:Daily price history for one ticker
The last five trading days of SPY:Year-to-date leaders on NASDAQ
The ten best-performing NASDAQ common stocks this year, among those that closed 2025 at $5 or more and averaged at least $50M a day in dollar volume:Annualized volatility comparison
One-year total return and annualized volatility (the standard deviation of daily log returns times the square root of 252) for two ETFs and three stocks:More examples on the blog
- Adjusted Close vs. Close: Which Stock Price to Use
- How to Calculate Stock Returns From Daily Prices in SQL
- How to Calculate Rolling Returns and Max Drawdown in SQL
- How to Backtest a Trading Strategy in Snowflake SQL
- How Do I Find Stock Splits and Reverse Splits in Price Data?
- How Do I Get Dividend History From Stock Prices in SQL?
- Where to Get Daily NAV History for US Mutual Funds in SQL
- How to Get a List of Every US Stock and ETF Ticker in SQL
- Why Don’t My Historical Stock Prices Match Yahoo Finance?
Data Ingestion
Data is ingested into Snowflake with best practices in mind.Security universe
Daily prices
Raw snapshot
Clean and publish
code, exchange_code and date. Placeholder rows are flagged and kept out of security_price_history_vw (see Data Quality), and adjusted open, high and low are derived from the adjusted close in the view.Twice-weekly restatement
Data Quality
- Unique grain: every
(code, exchange_code, date)must be unique in the price history, checked on both the internal table and the published table, and every(code, exchange_code)must be unique in the security reference. If the internal check fails, the run stops before the listing’s tables are updated, and the previous day’s data stays in place. - Required keys:
codeandexchange_codeare checked to never be null in both views, anddatein the price history. - Placeholder price removal: rows where the provider’s adjusted close is 0 (a zero-filled day) or 999,999.9999 (its cap when the backward adjustment overflows) are flagged on every run and excluded from
security_price_history_vwinstead of being passed through as real prices. - Stub row removal: a security’s very first price row is excluded when it sits more than 4 days before the next one, a lone placeholder well ahead of where real trading begins.
- Corporate-action restatement: new splits and dividends trigger a full history refetch for that security, and the twice-weekly full restatement catches anything the incremental path missed.
adjusted_close, adjusted_open, adjusted_high and adjusted_low for past dates change every time a security has a new split or dividend, because the whole history is rescaled. Raw open, high, low and close can also be corrected by the provider. Only the current values are kept; there is no revision history. Use src_updated_at to find rows that changed on incremental days.
Known quirks:
- On the most recent date, some prices can be missing at first. In the November 20 pull, November 18 had 12,036 stock prices against 17,176 the day before; nearly all of the missing ones were OTC stocks. Each run re-pulls the last 5 days, so they fill in on later runs.
- A few tickers carry rows from before the current security existed. For example,
FRDM(an ETF launched in 2019) has flat placeholder prices back to 1984. Check a ticker’s early history before using it in a long backtest. - The
fundasset class includes some exchange-traded closed-end funds as well as open-end mutual funds; filter onexchange = 'NMFQS'for open-end funds only.
Disclosures
Fruit Stand Data LLC is not endorsed by or affiliated with any of the underlying pricing data providers or exchanges. Use contact@fruitstand.dev for questions. Survivorship: the price history covers securities currently on the US symbol list. When a security drops off it stays insecurity_vw with is_inactive = true, but it has no rows in security_price_history_vw (1,114 such securities as of November 2026). Backtests over older periods therefore carry survivorship bias.
No-trade days: when a security has no trades on a given day, no price row is produced for that date. Thinly traded securities can have gaps in their history.
F.A.Q.
Frequently asked questions from our clients.Is there a free trial?
Is there a free trial?
What is end-of-day price data?
What is end-of-day price data?
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?
How is the data obtained?
How is the data obtained?
Why use this listing instead of a market data API?
Why use this listing instead of a market data API?
What does it cost to build this ourselves vs. buy the listing?
What does it cost to build this ourselves vs. buy the listing?
What isn't included?
What isn't included?
security_vw as inactive, without prices). There are no fundamentals, dividend amounts or par values; dividends and splits are reflected only through the adjusted prices.What's the difference between close and adjusted close?
What's the difference between close and adjusted close?
close is the price the security actually closed at that day. adjusted_close restates that price so it’s comparable across splits and dividends: after a 2-for-1 split, for example, every earlier adjusted close is halved, and every dividend lowers the earlier adjusted prices by the payout ratio. Use close to see what traded on a given day, and adjusted_close for returns, charts and backtests. See Adjusted Close vs. Close for a walkthrough.Are open, high and low adjusted too?
Are open, high and low adjusted too?
adjusted_open, adjusted_high, adjusted_low and adjusted_close are all adjusted for splits and dividends/distributions, so you get a complete adjusted OHLC bar for every day. The raw open, high, low and close columns stay as traded. volume is adjusted for splits only.Is this intraday or real-time data?
Is this intraday or real-time data?
Can I request other exchanges or countries to be made available in Snowflake?
Can I request other exchanges or countries to be made available in Snowflake?