Skip to main content
Guides and behind-the-scenes engineering notes on the datasets we ship through Snowflake.

How to Build a Stock Dashboard With Streamlit in Snowflake

A tested Streamlit in Snowflake app for any US stock or ETF, the SQL to deploy it, and which runtime costs less.

How to Calculate Rolling Returns and Max Drawdown in SQL

Rolling-return distributions, excess returns against SPY in every window, and every drawdown with its recovery date, in Snowflake SQL.

How to Run Sentiment Analysis on Earnings Calls in Snowflake

Score earnings call paragraphs with Snowflake Cortex in SQL, split management from analysts, compare the functions and see what each costs.

How Do I Find Stock Splits and Reverse Splits in Price Data?

SQL that finds every split and reverse split from daily prices, with counts since 2025 and how to rule out spinoffs and bad prints.

How Do I Get Dividend History From Stock Prices in SQL?

Derive ex-dates and dividend amounts for every US stock from adjusted prices in SQL, with split filtering, growth and yield.

How to Calculate Stock Returns From Daily Prices in SQL

Daily, log, cumulative, monthly, annual, annualized and rolling returns in SQL, with tested queries and the mistakes that produce wrong numbers.

Alternatives to CRSP Stock Data on Snowflake, Compared

Which Snowflake listings keep delisted stocks, what you give up without CRSP, how CRSP’s fields map to a price table, and SQL for CRSP-style returns.

Where to Get Preferred Stock Price History, With SQL

Nearly 500 US preferreds with daily prices back to 1972, compared with Tiingo, Yahoo and Curated Data, plus how to translate preferred tickers between sources.

Cybersyn's FRED Tables Are Deprecated: What to Use Instead

What replaced Cybersyn’s FRED tables, a crosswalk from Snowflake Curated Data variables to 22 FRED series IDs, and the SQL to migrate.

How to Compare ETF and Mutual Fund Performance in Snowflake

Rank 18 ETFs and mutual funds side by side by trailing returns in SQL, on a date every fund has. Fees decide the order, not the wrapper.

Where to Get Daily NAV History for US Mutual Funds in SQL

25,721 US mutual funds with daily NAVs back to 1973 in Snowflake, compared with CRSP, Tiingo, yfinance and SEC data, with SQL.

How to Backtest a Trading Strategy in Snowflake SQL

A 50/200-day moving-average crossover in SQL, with T-bill cash, drawdowns and 33 years of SPY and QQQ results.

How to Get Earnings Call Transcripts into Snowflake (3 Ways)

A Marketplace listing, Snowflake’s free public data share, or your own API load, with the SQL to parse transcripts into speaker paragraphs.

What FRED Economic Data Is on the Snowflake Marketplace?

573,411 FRED series by FRED ID, the licensed series left out, and how Snowflake Curated Data compares.

What Financial Datasets Are on the Snowflake Marketplace?

1,269 financial listings from 327 providers: who publishes them, what’s free, and where to start for each kind of data.

Best Polygon.io Alternatives for Daily Historical Prices

Polygon is now Massive, split-adjusted from 2003. Tiingo, EODHD, FirstRate Data, Intrinio and Snowflake for dividend-adjusted history.

Best IEX Cloud Alternatives for Historical Stock Prices

IEX Cloud shut down in 2024. viaNexus, Intrinio, Tiingo, Massive, EODHD and Snowflake, mapped to what you used it for.

Best Alpha Vantage Alternatives for Bulk Historical Prices

Massive, EODHD, FMP, Tiingo, Databento and Snowflake: how each does bulk history, what it costs and which fits which job.

Where to Get End-of-Day Prices for Every US Stock in Bulk

Free files, bulk APIs, flat files and warehouse tables, with prices, history and what bulk really costs.

Is yfinance Still Usable? Alternatives for Historical Prices

We tested yfinance in November 2026: what still works, where it breaks, and the alternatives by volume.

How to Query Earnings Call Transcripts in Snowflake SQL

List a company’s calls, read one in order, split prepared remarks from Q&A and find the analysts.

How to Calculate Inflation-Adjusted Returns in SQL

CPI from FRED joined to adjusted prices, real SPY results, and the missing-month trap.

How to Get the US Treasury Yield Curve in Snowflake

FRED’s DGS series from 1 month to 30 years, pivoted into a curve, with an inversion check.

How to Compare a Fund's Returns With Its Benchmark in SQL

One join on ready-made trailing returns, with real results for three active funds vs. SPY.

How to Get a List of Every US Stock and ETF Ticker in SQL

One query for about 18,200 stocks and 5,960 ETFs, by exchange, with ISINs and status.

Why Don't My Historical Stock Prices Match Yahoo Finance?

Yahoo’s split-adjusted Close, its Adj Close, and after-hours closes, with real side-by-side numbers.

How Snowflake Marketplace Pricing Works for Data Buyers

Listing fees vs. your compute, usage-based and subscription plans, free trials, who can buy and how to cancel.

Alternatives to Snowflake Curated Data for Stock Prices

Fruit Stand, CRSP, EDI, Bloomberg and Bright Data, matched to the reason you’re switching from Curated Data.

Snowflake's Free Stock Prices vs. Paid: What's Different

Snowflake Curated Data’s free stock prices next to official closes: the 3-month lag, after-hours closes and what they do to returns.

Where to Get Trailing Returns for Every US Fund and ETF in Bulk

Licensed feeds, free SEC files, a Snowflake listing, or your own SQL: where to get 1-day to 20-year returns for the whole fund universe.

Where to Get Earnings Call Transcripts in Bulk

S&P Global, LSEG, ROIC.ai, FMP, Snowflake Marketplace listings and free datasets, compared by coverage, history and price.

How to Get FRED Data into Snowflake

Marketplace listing, Snowflake’s Data Utilities app, or a FRED API pipeline: three ways to load FRED series, with code for each.

Stock Price Datasets on the Snowflake Marketplace, Compared

Fruit Stand, Snowflake Curated Data, CRSP, Bloomberg and more, compared by coverage, history, adjusted prices and access.

How to Get Historical Stock Prices into Snowflake

Marketplace listing, COPY INTO from S3, or an API pipeline: three ways to load stock prices into Snowflake, with SQL for each.

Adjusted Close vs. Close: Which Stock Price to Use

How splits and dividends change historical prices, when to use each close, and how to compute total returns in SQL on Snowflake.

Fund and ETF Returns Data on Snowflake, Compared

How Fund Returns compares to other fund and ETF data on Snowflake Marketplace: coverage, pricing, and access model.

How Fund Returns Data Moves from source to Snowflake

How Fruit Stand computes 16 trailing and calendar year return periods, daily and since inception, for 32,000+ funds and ETFs in Snowflake.