Alpha Vantage Delisted Stocks

Published: 19 Feb 2023

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:

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 = pd.read_csv(DELISTED_CSV_URL.format(API_KEY))

By remaining on this website or using its content, you confirm that you have read and agree with the Terms of Use Agreement.

We are not liable for any damages resulting from using this website. Any information may be inaccurate or incomplete. See full Limitation of Liability.

Content may include affiliate links, which means we may earn commission if you buy on the linked website. See full Affiliate and Referral Disclosure.

We use cookies and similar technology to improve user experience and analyze traffic. See full Cookie Policy.

See also Privacy Policy on how we collect and handle user data.

© 2024 FinTut