Fruit Stand publishes the Historical Stock Prices listing, one of the
options below. The other listings’ details come from their Snowflake
Marketplace entries, read on November 13, 2026. Every query here was run
against our listing that day; the daily returns example was rerun on
November 15, 2026.
The listings at a glance
“By request” means the provider prices and licenses the data through its
sales team; none of the by-request listings shows a price. “Not listed” means the
listing doesn’t say. CRSP’s listing is published twice, once by CRSP and
once by Morningstar,
which completed its acquisition of CRSP on February 2, 2026.
What you give up without CRSP
CRSP is the standard for academic finance because of four things:- Delisted securities. Every security with a primary listing on the NYSE, NYSE American, Nasdaq, NYSE Arca or Cboe BZX is in the data, including those that delisted, with delisting information. Without them, a backtest only sees the companies that survived.
- PERMNO. A permanent ID that follows a security through ticker changes
and is never reused. Tickers are reused:
FBwas Meta until 2022 and is now a ProShares ETF. - Shares outstanding and market cap, so you can build value-weighted portfolios and size deciles.
- Market and size-decile indexes. CRSP’s market indexes joined Morningstar Indexes after the acquisition.
Which fits which job
- Academic research and survivorship-free backtests: CRSP. If you also need fundamentals, Compustat’s prices and financials come from one vendor.
- Global quant research with point-in-time data: LSEG’s Quantitative Analytics Database.
- Daily prices and total returns for stocks that trade today, in SQL, kept current: Fruit Stand’s Historical Stock Prices. It suits dashboards, portfolio tracking, factor prototypes and teaching, where a license negotiation is out of proportion.
- A free sample of recent years: Snowflake Curated Data’s free tier, about three months behind.
What’s missing from a price table without delisted stocks
This query checks ten tickers from companies that were acquired, went bankrupt or changed their ticker in the last few years:
Eight are gone, and two tickers now belong to other securities. Companies
that only changed their ticker keep their history: Meta’s prices start at its
May 2012 IPO under
META, and Booking Holdings’ in 1999 under BKNG. Our
listing marks securities that stop trading as inactive (with
inactive_date) from October 2026 on, so new delistings stay in the data,
but anything that left earlier isn’t there.
If you join a historical list of tickers to a price table like ours, check
first_date against your sample’s dates, so a reused ticker doesn’t attach
a new company’s prices to an old one.
CRSP fields and their equivalents
The December 2024 data was CRSP’s last release in its legacy formats. The Snowflake listing uses the newer Flat File Format 2.0 (CIZ), with tables and fields such asstkmthsecuritydata and MthRet. Here’s how the main daily fields map to
our listing:
Rebuild CRSP-style daily returns
adjusted_close is the close adjusted for splits and dividends, so the
ratio of consecutive adjusted closes is the daily total return, like
DlyRet:
Coca-Cola’s $0.53 dividend went ex on September 15 (its record date, with T+1
settlement). The close fell 0.72% that day, but the total return was only
−0.12%, because the dividend makes up the difference, and `cum_factor` steps
up by 0.593%, which is $0.53 divided by the prior close of $89.35. Like CRSP’s
cumulative factors, the factor here is relative to the latest date, so it’s 1
on the newest row and below 1 before each later dividend.
Rebuild CRSP-style monthly returns
A monthly return likeMthRet is the ratio of month-end adjusted closes:
VTI from the same table. For why adjusted prices differ
from raw ones, see Adjusted Close vs.
Close; for every listing with stock prices,
see Stock Price Datasets on the Snowflake
Marketplace.
F.A.Q.
Is CRSP available on Snowflake?
Is CRSP available on Snowflake?
Yes, as the CRSP US Stock Database, by request. It’s listed by CRSP and by Morningstar, refreshed monthly, in two versions: from December 1925 and from July 1962.
Is there a free alternative to CRSP?
Is there a free alternative to CRSP?
Not one with delisted stocks. Snowflake Curated Data’s free tier has US prices since May 2018, about three months behind. Universities usually get CRSP through WRDS.
Which alternatives include delisted stocks?
Which alternatives include delisted stocks?
On Snowflake, Compustat Financials and LSEG’s Quantitative Analytics Database say they do. Both are licensed by request. Fruit Stand’s listing doesn’t; it marks stocks that stop trading as inactive from October 2026 on.
Can I get CRSP-style returns from adjusted prices?
Can I get CRSP-style returns from adjusted prices?
Total returns, yes: daily and monthly returns from
adjusted_close match the idea of DlyRet and MthRet. Price-only returns (DlyRetx), market cap and delisting returns need CRSP or a similar source.What replaces PERMNO?
What replaces PERMNO?
Nothing in a ticker-keyed table. Our listing carries a ticker’s history through renames, as with
META, but a reused ticker points to the new security. Check first_date or the ISIN when joining older ticker lists.