> ## Documentation Index
> Fetch the complete documentation index at: https://fruitstand.dev/llms.txt
> Use this file to discover all available pages before exploring further.

# Alternatives to CRSP Stock Data on Snowflake, Compared

> Alternatives to CRSP stock data on Snowflake compared: Compustat and LSEG keep delisted stocks, Fruit Stand and Curated Data don't. CRSP fields mapped to SQL.

*By [Fruit Stand Team](https://fruitstand.dev/about.md) · 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.

> [!NOTE]
>
> 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

| Listing | Provider | Delisted stocks | History | Refresh | Access |
| - | - | - | - | - | - |
| [CRSP US Stock Database](https://app.snowflake.com/marketplace/listing/GZ1MMZB2UP0E) | CRSP, now part of Morningstar | Yes: 32,000+ active and inactive securities | From December 1925 or July 1962, by version | Monthly | By request |
| [Compustat Financials](https://app.snowflake.com/marketplace/listing/GZT0Z8P3D2R) | S\&P Global | Yes: 80,000+ active and inactive companies | North America back to 1950 | Daily | By request |
| [LSEG Quantitative Analytics Database](https://app.snowflake.com/marketplace/listing/GZTDZWHIL4) | LSEG | Yes, with point-in-time data | Since 1970 | Daily | By request |
| [Morningstar Equity Returns and Statistics](https://app.snowflake.com/marketplace/listing/GZU6Z6T0HSG) | Morningstar | Not listed | Returns since 1962 | Daily | By request |
| [Company Financials, Estimates and Pricing Point-in-Time](https://app.snowflake.com/marketplace/listing/GZU6Z21SA1LJR) | Bloomberg | Not listed | Pricing since 1991 | Daily | By request |
| [Historical Stock Prices](https://app.snowflake.com/marketplace/listing/GZTYZTG3LNFA) | Fruit Stand | No | Back to 1962 for the oldest stocks | Daily | Instant, \$100/month after a 30-day trial |
| [Snowflake Curated Data](https://app.snowflake.com/marketplace/listing/GZTSZ290BV255) | Snowflake | Not listed | Since May 2018 | Free tier 3 months behind; paid tier daily | Instant; free, or \$25,000/year |

"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](https://app.snowflake.com/marketplace/listing/GZU6Z1EX7OQCS),
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](https://ucsd.libguides.com/marketresearch/data_sources) 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:

```sql theme={null}
with wanted (code, company) as (
    select * from values
        ('SIVB', 'SVB Financial'), ('BBBY', 'Bed Bath & Beyond'), ('TWTR', 'Twitter'),
        ('ATVI', 'Activision Blizzard'), ('PXD', 'Pioneer Natural Resources'),
        ('SPLK', 'Splunk'), ('VMW', 'VMware'), ('HES', 'Hess'),
        ('FB', 'Meta Platforms, before 2022'), ('PARA', 'Paramount Global')
)
select w.code, w.company, s.name as listing_name, min(p.date) as first_date
from wanted w
left join security_vw s on s.code = w.code and s.exchange_code = 'US'
left join security_price_history_vw p on p.code = s.code and p.exchange_code = s.exchange_code
group by w.code, w.company, s.name
order by w.code;
```

| Ticker | Company it was | In our listing today |
| - | - | - |
| `ATVI` | Activision Blizzard | Not found |
| `BBBY` | Bed Bath & Beyond | Not found |
| `FB` | Meta Platforms, before 2022 | ProShares S\&P 500 Dynamic Buffer ETF, from June 2025 |
| `HES` | Hess | Not found |
| `PARA` | Paramount Global | Parabolic Technologies, from February 2021 |
| `PXD` | Pioneer Natural Resources | Not found |
| `SIVB` | SVB Financial | Not found |
| `SPLK` | Splunk | Not found |
| `TWTR` | Twitter | Not found |
| `VMW` | VMware | Not found |

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:

| CRSP (CIZ) | What it is | Historical Stock Prices |
| - | - | - |
| `PERMNO` | Permanent security ID | None; `code` and `exchange_code`, plus `isin` in `security_vw` |
| `DlyCalDt` | Trading date | `date` |
| `DlyOpen`, `DlyHigh`, `DlyLow`, `DlyClose` | Daily prices | `open`, `high`, `low`, `close` |
| `DlyPrc` | Closing price; `DlyPrcFlg` marks a bid/ask average on days without a trade | `close`, from trades only |
| `DlyRet` | Total return, with dividends | Computed from `adjusted_close` (below) |
| `DlyRetx` | Price return, without dividends | Not available directly |
| `DlyCumFacPr` | Cumulative price adjustment factor | `adjusted_close / close` |
| `ShrOut`, `DlyCap` | Shares outstanding, market cap | Not available |
| `ShareType`, `SecurityType` | Kind of security | `type` in `security_vw`, such as `Common Stock`, `Preferred Stock` or `ETF` |
| `PrimaryExch` | Primary exchange, in CRSP's security history table | `exchange` in `security_vw` |
| `DlyDelFlg` and delisting fields | Delisting day and reason | `is_inactive` and `inactive_date`, from October 2026 |

## 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`:

```sql theme={null}
select code, date, close,
       adjusted_close / lag(adjusted_close) over (partition by code order by date) - 1 as ret,
       adjusted_close / close as cum_factor
from security_price_history_vw
where exchange_code = 'US' and code = 'KO'
  and date between '2026-09-11' and '2026-09-16'
order by code, date;
```

| Ticker | Date | Close | Total return | `cum_factor` |
| - | - | -: | -: | -: |
| KO | Sep 14 | \$89.35 | +1.20% | 0.99407 |
| KO | Sep 15 | \$88.71 | −0.12% | 1.00000 |
| KO | Sep 16 | \$87.87 | −0.95% | 1.00000 |

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:

```sql theme={null}
with month_end as (
    select code, last_day(date) as month_end, max_by(adjusted_close, date) as adj
    from security_price_history_vw
    where exchange_code = 'US' and code in ('AAPL', 'KO')
      and date >= '2026-05-01'
    group by code, last_day(date)
)
select code, month_end,
       round(adj / lag(adj) over (partition by code order by month_end) - 1, 4) as mth_ret
from month_end
order by code, month_end;
```

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](https://fruitstand.dev/blog/adjusted-close-vs-close.md); for every listing with stock prices,
see [Stock Price Datasets on the Snowflake
Marketplace](https://fruitstand.dev/blog/stock-price-datasets-snowflake-marketplace.md).

## F.A.Q.

> [accordion] 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.

> [accordion] 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.

> [accordion] 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.

> [accordion] 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.

> [accordion] 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.

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](https://app.snowflake.com/marketplace/listing/GZTYZTG3LNFA). The
schema is in the [dataset docs](https://fruitstand.dev/datasets/historical-stock-prices.md).
Questions? Reach out at [contact@fruitstand.dev](mailto:contact@fruitstand.dev).


This documentation is built and hosted on [Mintlify](https://mintlify.com), a developer documentation platform.