Alpha Vantage Delisted Stocks

This is how to get all delisted stock symbols from Alpha Vantage.

Delisted stocks API URL

The delisted stocks dataset is available under function=LISTING_STATUS – the same function that gets active listed symbols.

For delisted symbols you need to use an extra parameter state=delisted.

The complete URL is:

https://www.alphavantage.co/query?function=LISTING_STATUS&state=delisted&apikey=...

Add your Alpha Vantage API key at the end. This url does not work with apikey=demo.

Output format and columns

The output is CSV (not JSON). It includes all delisted stocks and ETFs. The columns are:

• symbol
• name = company or fund name
• exchange = e.g. 'NASDAQ', 'NYSE', 'NYSE ARCA', 'BATS'
• assetType = 'Stock' or 'ETF'
• ipoDate
• delistingDate
• status = always 'Delisted'

AV delisted stocks with Python pandas

import pandas as pd

API_KEY = ...  # Your Alpha Vantage API key

DELISTED_CSV_URL = "https://www.alphavantage.co/query?function=LISTING_STATUS&state=delisted&apikey={}"

delisted = pd.read_csv(DELISTED_CSV_URL.format(API_KEY))