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.