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

​

The options compared

​

How big is “every US stock”?

​

What bulk costs beyond the price

• Backfilling history. A per-day bulk endpoint gives you one day per request. Thirty years is about 7,500 trading days. On EODHD that’s 7,500 requests at 100 calls each, or 750,000 calls, which is about 8 days at its 100,000-calls-a-day plans. Flat files and warehouse tables skip this step.
• Keeping adjustments current. When a stock splits or pays a dividend, its adjusted history before that date changes. A daily file only gives you the new day, so your stored adjusted prices drift unless you refetch that ticker’s history or apply the adjustment factors yourself. In our own pipeline, any security with a new split or dividend has its full history refetched, and every security is restated twice a week to catch anything missed.
• Delistings and ticker changes. Acquired and delisted companies drop out of daily files, and some sources drop their history too. Is yfinance Still Usable? shows Kenvue’s history disappearing from Yahoo two days after its acquisition closed.
• Licensing. Stooq and Massive’s individual plans are for personal use. For a team or a product, pick a plan licensed for it.
• Loading. Files and APIs end in your own tables, so you also build the loader, the schedule and the checks for duplicates and bad prices.

​

Which should you choose?

• A personal project, free: Stooq’s daily ZIP covers it, within its personal-use terms.
• A one-time history purchase: EODData sells each exchange’s history outright, but it’s split-adjusted only, so calculate dividend-adjusted returns yourself.
• Your own database, updated daily: a per-day bulk API (EODHD or FMP), Massive’s flat files, or Databento if you want the official consolidated close and only need recent years. Budget time for the backfill and for re-adjusting history when corporate actions post.
• Already on Snowflake: a Marketplace listing, such as Fruit Stand’s Historical Stock Prices, gives you the full history as tables, with nothing to load or re-adjust. To weigh it against the other eight stock price listings, including Snowflake Curated Data, CRSP, Bloomberg and EDI, Stock Price Datasets on the Snowflake Marketplace, Compared lines them up on history, update time, columns and price, with a which-listing-for-which-job guide. If you’d rather bring your own files or API into Snowflake, How to Get Historical Stock Prices into Snowflake (3 Ways) walks through each route step by step, with the SQL to check your load.

​

Every US stock in one query

select s.code, s.name, s.asset_class, p.close, p.adjusted_close, p.volume
from security_price_history_vw p
join security_vw s
    on s.code = p.code and s.exchange_code = p.exchange_code
where p.exchange_code = 'US'
  and s.asset_class in ('stock', 'etf')
  and p.date = '2026-11-03'
order by s.code;

​

F.A.Q.