> ## Documentation Index
> Fetch the complete documentation index at: https://fruitstand.dev/llms.txt
> Use this file to discover all available pages before exploring further.

# Where to Get Preferred Stock Price History, With SQL

> Where to get daily preferred stock price history: a Snowflake listing with nearly 500 US preferreds back to 1972, plus Tiingo, Yahoo and Curated Data, compared.

*By [Fruit Stand Team](https://fruitstand.dev/about.md) · 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.

> [!NOTE]
>
> 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

| Source | Preferreds | History | How you get it | Price |
| - | - | - | - | - |
| [Historical Stock Prices](https://app.snowflake.com/marketplace/listing/GZTYZTG3LNFA) (Fruit Stand) | 498 active US preferreds, plus stocks, ETFs and funds | Daily, back to 1972 for the oldest | Snowflake table, refreshed daily | \$100/month after a 30-day trial |
| Snowflake Curated Data, free tier | US preferreds under their own ticker spelling | Daily since May 2018, about 3 months behind | Snowflake share | Free |
| [Tiingo](https://www.tiingo.com/about/pricing) | Preferreds through its end-of-day API | Varies by security | API, one ticker per request | Free tier; $30/month individual, $50 internal business |
| [yfinance](https://github.com/ranaroussi/yfinance) | Any preferred Yahoo Finance lists | Varies by security | Unofficial Python library | Free; personal use, throttled |
| [QuantumOnline](https://www.quantumonline.com/) | US exchange-traded preferreds and other income securities | Price charts, no data files | Website, one security per page | Free; quotes and charts need a free registration |

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:

| Source | Ticker |
| - | - |
| Historical Stock Prices listing, Yahoo Finance | `BAC-PL` |
| Nasdaq, StockAnalysis | `BAC.PRL` |
| TradingView | `BAC/PL` |
| Tiingo | `BAC-P-L` |
| Snowflake Curated Data, QuantumOnline | `BAC-L` |
| Bank of America's investor relations page | BAC PrL |

Tiingo documents its format as `{SYMBOL}-P-{SHARE CLASS}` in its
[symbology appendix](https://www.tiingo.com/documentation/appendix/symbology).
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:

```sql theme={null}
select t as ticker,
       regexp_replace(
           upper(regexp_replace(t, '^([A-Z]+)p([A-Z])$', '\\1-P\\2')),
           '^([A-Z]+)( PR|\\.PR|/PR|/P|-P-|-P|-|\\.P)([A-Z])$',
           '\\1-P\\3') as listing_code
from values ('BAC.PRL'), ('BAC/PL'), ('BAC-P-L'), ('BACpL'), ('BAC PRL'), ('BAC-L') v(t);
```

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:

| Measure | Value, Nov 12, 2026 |
| - | -: |
| Active preferreds with prices | 498 |
| Traded in November 2026 | 491 |
| Daily price rows | 1,047,548 |
| With history before 2010 | 54 |
| With history before 2000 | 21 |
| Median history per preferred | 7 years |
| Earliest price | September 22, 1972 |

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

```sql theme={null}
select date, close, adjusted_close, volume
from security_price_history_vw
where exchange_code = 'US' and code = 'JPM-PC'
order by date desc;
```

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:

```sql theme={null}
select s.code, s.name, min(p.date) as first_date, max(p.date) as latest_date,
       max_by(p.close, p.date) as latest_close
from security_vw s
join security_price_history_vw p
    on p.code = s.code and p.exchange_code = s.exchange_code
where s.type = 'Preferred Stock'
  and not s.is_inactive
  and s.code like 'JPM-P%'
group by s.code, s.name
order by s.code;
```

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:

| Ticker | Series | Coupon | Close, Nov 11 | Current yield |
| - | - | -: | -: | -: |
| `JPM-PC` | EE | 6.00% | \$22.75 | 6.59% |
| `JPM-PD` | DD | 5.75% | \$21.25 | 6.76% |
| `JPM-PJ` | GG | 4.75% | \$17.28 | 6.87% |
| `JPM-PK` | JJ | 4.55% | \$16.55 | 6.87% |
| `JPM-PL` | LL | 4.625% | \$16.78 | 6.89% |
| `JPM-PM` | MM | 4.20% | \$15.66 | 6.70% |

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):

| Preferred | Price then | Price now | Price change | Total return |
| - | -: | -: | -: | -: |
| JPMorgan Series EE (`JPM-PC`) | \$27.25 | \$22.75 | −16.5% | +12.5% |
| Morgan Stanley (`MS-PE`) | \$27.65 | \$24.64 | −10.9% | +24.5% |
| Public Storage (`PSA-PH`) | \$27.18 | \$19.79 | −27.2% | −3.9% |
| AT\&T (`T-PA`) | \$26.80 | \$15.84 | −40.9% | −20.1% |
| U.S. Bancorp (`USB-PH`) | \$24.82 | \$16.94 | −31.7% | −7.0% |
| Wells Fargo Series L (`WFC-PL`) | \$1,490.53 | \$1,061.10 | −28.8% | −4.3% |
| iShares Preferred and Income Securities ETF (`PFF`) | \$39.43 | \$28.31 | −28.2% | −3.8% |

The table comes from one query:

```sql theme={null}
with px as (
    select code, date, close, adjusted_close
    from security_price_history_vw
    where exchange_code = 'US'
      and code in ('JPM-PC', 'MS-PE', 'PSA-PH', 'T-PA', 'USB-PH', 'WFC-PL', 'PFF')
      and date >= '2021-12-31'
)
select code,
       min_by(close, date) as start_price,
       max_by(close, date) as end_price,
       round(max_by(close, date) / min_by(close, date) - 1, 3) as price_change,
       round(max_by(adjusted_close, date) / min_by(adjusted_close, date) - 1, 3) as total_return
from px
group by code
order by code;
```

The 30-year yield comes from the [FRED listing](https://fruitstand.dev/datasets/fred-series.md)
(series `DGS30`). For why the adjusted column differs from the raw one, see
[Adjusted Close vs. Close](https://fruitstand.dev/blog/adjusted-close-vs-close.md).

## F.A.Q.

> [accordion] 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.

> [accordion] 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.

> [accordion] 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.

> [accordion] 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.

> [accordion] 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'`.

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](https://app.snowflake.com/marketplace/listing/GZTYZTG3LNFA).
The schema is in the [dataset docs](https://fruitstand.dev/datasets/historical-stock-prices.md).
Questions? Reach out at [contact@fruitstand.dev](mailto:contact@fruitstand.dev).


This documentation is built and hosted on [Mintlify](https://mintlify.com), a developer documentation platform.