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:
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 insecurity_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
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:
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:
DGS30). For why the adjusted column differs from the raw one, see
Adjusted Close vs. Close.
F.A.Q.
Is there free preferred stock price history?
Is there free preferred stock price history?
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.
Why can't I find my preferred's ticker?
Why can't I find my preferred's ticker?
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.Does the data include redeemed preferreds?
Does the data include redeemed preferreds?
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.
Does the data include coupon, par value or call dates?
Does the data include coupon, par value or call dates?
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.
Are preferreds in the same table as common stock?
Are preferreds in the same table as common stock?
Yes. Stocks, preferreds, ETFs and mutual funds share
security_price_history_vw. Filter security_vw on type = 'Preferred Stock'.