Skip to main content
By Fruit Stand Team · November 13, 2026 · Comparisons On Snowflake, the alternatives to CRSP that also keep delisted stocks are S&P Global’s Compustat and LSEG’s Quantitative Analytics Database, both licensed by request, like CRSP. For daily US prices without a license negotiation, Fruit Stand’s Historical Stock Prices listing ($100/month) and Snowflake Curated Data are instant, but neither carries the history of delisted stocks. Below is how the listings compare, what you give up without CRSP, how CRSP’s fields map to a price table, and the SQL to rebuild CRSP-style daily and monthly returns.
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: FB was 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.
Compustat and LSEG’s database both keep delisted companies, with their own permanent identifiers. A price table like ours, or Curated Data, has none of the four, so for published research, survivorship-free backtests or anything that needs market cap, stay with CRSP or one of the licensed alternatives.

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.
Outside Snowflake, university library guides point people who can’t get a WRDS account elsewhere: UC San Diego’s recommends Mergent Market Atlas.

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 as stkmthsecuritydata 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 like MthRet is the ratio of month-end adjusted closes:
Each row is labeled with the month’s last calendar day. Coca-Cola’s October 2026 return comes out at 9.29%, and the current month’s row holds the return so far. For a market return in place of CRSP’s value-weighted index, use a total market ETF such as 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.

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.
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.
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.
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.
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.
For daily prices and total returns for every US stock, ETF and mutual fund that trades today, start a free 30-day trial of the Historical Stock Prices listing on the Snowflake Marketplace. The schema is in the dataset docs. Questions? Reach out at contact@fruitstand.dev.