Skip to main content
By Fruit Stand Team · November 12, 2026 · Comparisons For daily preferred stock price history in SQL, Fruit Stand’s Historical Stock Prices listing on the Snowflake Marketplace has nearly 500 active US preferreds in the same table as common stocks, with history back to 1972 for the oldest. For a few tickers, Tiingo’s API or Yahoo Finance work, as long as you use each one’s ticker spelling. Below is how the options compare, how to translate preferred tickers between sources, and the SQL to pull a preferred’s history, compare an issuer’s series and measure total return.
Fruit Stand publishes the Historical Stock Prices listing, one of the options below. Every query here was run on November 12, 2026, against our listing and Snowflake Curated Data’s free tier. Other providers’ details were checked on their own pages the same day.

The options at a glance

QuantumOnline is the reference for a preferred’s terms: par value, coupon, call date and whether dividends are cumulative. It doesn’t offer bulk price history, so most people pair it with one of the price sources above.

Which source fits which job

  • Every US preferred’s daily prices in SQL, kept current: the Historical Stock Prices listing. Preferreds sit next to the issuer’s common stock, so one query compares them.
  • A free, delayed look at recent years: Curated Data’s free tier. Its prices start in May 2018, lag about three months, and its volume counts Nasdaq trades only. On August 12, 2026, it showed 135 shares of Bank of America’s Series L traded, against 11,283 on all exchanges.
  • A handful of tickers in Python: Tiingo, or yfinance for personal use.
  • Coupon, par and call dates: QuantumOnline or the issuer’s own investor relations page.

Preferred tickers aren’t spelled the same anywhere

The same security, Bank of America’s 7.25% Series L preferred, goes by a different ticker at nearly every source: Tiingo documents its format as {SYMBOL}-P-{SHARE CLASS} in its symbology appendix. If you’re matching a list of preferreds from another source, convert them first. This query turns each spelling above into the listing’s format:
All six rows return BAC-PL. Nasdaq-listed preferreds are the exception: they usually carry a five-letter ticker ending in P, such as Fortress Biotech’s FBIOP, and most sources spell them the same way.

What’s in the Historical Stock Prices listing

Preferreds are in security_vw with type = 'Preferred Stock', and their prices are in security_price_history_vw, one row per security per day: The longest histories belong to utility preferreds issued decades ago: Pacific Gas and Electric’s 5% first preferred (PCG-PC) has prices from September 1972, and Consumers Energy’s CMS-PB from February 1973. Most bank and REIT preferreds were issued since 2018, so their history is shorter. The label is broader than straight preferred stock. It also covers trust preferreds, a few exchange-traded notes such as Ford’s 6.20% notes due 2059 (F-PB), and a few share classes, such as Moog’s Class B. The listing also keeps 290 inactive preferred entries; most are older spellings of active tickers with no prices, so filter on not is_inactive.

Get a preferred’s price history

On November 12, the latest row was November 11, with JPMorgan’s Series EE (JPM-PC) at $22.75 on 360,776 shares. close is the traded price. adjusted_close adds back dividends, for total return.

Compare an issuer’s preferreds

Most issuers have several series outstanding. This lists JPMorgan’s, with each one’s first and latest price:
It returns six series. Adding each one’s coupon, from JPMorgan’s dividend announcements, shows why they trade at such different prices. All six were issued at $25: Current yield is the annual dividend, the coupon times $25, divided by the price. Prices range from $15.66 to $22.75, but the yields sit within 0.3 points of each other: the market prices each series to about the same yield, so the lower the coupon, the lower the price. QuantumOnline lists Series EE's first call date as March 21, 2024, so JPMorgan can now redeem it at $25. Don’t assume every preferred was issued at $25, though. Some trade near $10, and Bank of America’s and Wells Fargo’s Series L convertibles trade above $1,000, so check the par value before comparing prices across issuers.

Price change isn’t total return

A preferred’s price moves with interest rates, and its dividend is most of what an investor earns, so the price alone can look worse than the return. From December 31, 2021, to November 11, 2026, while the 30-year Treasury yield rose from 1.90% to 5.31% (at the end of October 2026): The table comes from one query:
The 30-year yield comes from the FRED listing (series DGS30). For why the adjusted column differs from the raw one, see Adjusted Close vs. Close.

F.A.Q.

For a few tickers, yes: yfinance (personal use) and Tiingo’s free tier. Snowflake Curated Data’s free tier has preferreds back to May 2018, about three months behind. For every US preferred in SQL, the Historical Stock Prices listing has a 30-day free trial.
Usually it’s spelled differently at that source. BAC-PL, BAC.PRL, BAC/PL, BAC-P-L and BAC-L are all the same security. Convert the ticker to the source’s format, or search the issuer’s name.
Not their history. The listing covers preferreds that still trade; series that were redeemed before they were added aren’t in it, so backtests across all preferreds carry survivorship bias.
No, only prices and volume. Take the terms from QuantumOnline or the issuer’s prospectus, and join them in by ticker, as in the JPMorgan example above.
Yes. Stocks, preferreds, ETFs and mutual funds share security_price_history_vw. Filter security_vw on type = 'Preferred Stock'.
To query daily prices for every US preferred stock in SQL, start a free 30-day trial of the Historical Stock Prices listing on the Snowflake Marketplace. The schema is in the dataset docs. Questions? Reach out at contact@fruitstand.dev.