Stock Price Datasets on the Snowflake Marketplace, Compared

​

The listings at a glance

​

Universe: what each listing covers

​

Columns: which prices each listing includes

​

Price and free trials

​

Which listing fits which job

• Full US coverage, including mutual funds, kept current: Historical Stock Prices. Stocks, ETFs and mutual fund NAVs share one table and one schema. Adjusted open, high, low and close are restated whenever a split or dividend posts, so returns and backtests stay correct.
• Free data for prototyping, where a 3-month delay is fine: Snowflake Curated Data (Free). It’s a good way to explore a schema or build a proof of concept. Move to the paid tier, or another listing, before anything depends on recent prices.
• Academic research and survivorship-bias-free backtests: CRSP. It includes delisted securities and goes back to 1925, which no other listing here does. It’s licensed by request and refreshed monthly, so it suits research more than daily pipelines.
• Global coverage: Bloomberg’s point-in-time dataset covers 100,000+ companies worldwide. It’s by request, so expect an enterprise sales process.
• Prices next to fundamentals: the SEC Financial Analytics Kit pairs a year of prices with 10-K and 10-Q metrics. That’s useful when the question is about fundamentals, less so for long price history.
• Intraday trades and quotes: none of the listings above are intraday. Look at NYSE Daily TAQ or BMLL’s Level 1 and Level 2 quotes instead.

​

Snowflake Curated Data’s prices aren’t the official close

• Open is the pre-market open, not the 9:30 AM opening price.
• Close is the after-hours close, not the 4:00 PM official close.
• Volume counts only trades executed on Nasdaq, not consolidated volume across all exchanges.

-- Snowflake Curated Data: one row per ticker, date and variable
select ticker, date, value as post_market_close
from public_data.stock_price_timeseries
where ticker = 'AAPL'
  and variable_name = 'Post-Market Close'
order by date desc
limit 5;

-- Fruit Stand Historical Stock Prices: one row per security per day
select code, date, close, adjusted_close, volume
from security_price_history_vw
where code = 'AAPL'
  and exchange_code = 'US'
order by date desc
limit 5;

​

What to check before you subscribe

1. Coverage. Check whether you need ETFs, mutual funds, small caps or non-US listings, not just large-cap stocks.
2. History. Check how far back each security goes, and whether history starts at a fixed year or at each security’s listing date.
3. Price definitions. Check whether open and close are regular-hours prices, and whether adjusted prices are included and restated when corporate actions post. See Adjusted Close vs. Close for why this matters.
4. Delisted securities. If you backtest over long periods, you need delisted names to avoid survivorship bias. Of the listings above, only CRSP says it includes them. Fruit Stand’s Historical Stock Prices covers securities currently listed.
5. Freshness. Check when each day’s data lands, and whether the free tier is delayed.
6. Terms. Check whether you can start instantly with a trial or need to request access and go through procurement.

​

F.A.Q.