Get new market listings from Databento's corporate actions data

The Databento team is currently working on this article.

Overview

New listings refer to the addition of securities to a stock exchange, allowing them to be publicly traded. This can include initial public offerings (IPOs) of companies entering the public market for the first time, as well as existing companies that choose to list additional securities or switch their listings to a different exchange.

See also

Corporate actions dataset guide for further details.

Requesting new listings

This example demonstrates how to use the Reference client to retrieve all new US market listings for 31st July 2024.

We can query for new listings specifically by filtering for the NLIST (New Listing) event type. Once we obtain the records, we can filter the relevant columns for analysis.

import databento as db # Create a reference client ref_client = db.Reference(key="$YOUR_API_KEY") # Request corporate actions df_raw = ref_client.corporate_actions.get_range( symbols=["ALL_SYMBOLS"], start="2024-07-31", events=["NLIST"], countries=["US"], ) # Drop rows where there is not yet a confirmed symbol or ISIN df = df_raw.dropna(subset=["symbol", "isin"]) # Filter relevant columns columns = [ "event", "operating_mic", "isin", "symbol", "issuer_name", "security_type", ] df = df[columns] df.head(20)

Result

 event operating_mic isin symbol issuer_name security_type event_date 2024-07-31 NLIST OTCM US56564V1199 MAQCW Maquia Capital Acquisition Corp WAR 2024-07-31 NLIST ARCX US31423L5030 FLCC Federated Hermes ETF Trust ETF 2024-07-31 NLIST ARCX US31423L6020 FSCC Federated Hermes ETF Trust ETF 2024-07-31 NLIST ARCX US31423L7010 FLCV Federated Hermes ETF Trust ETF 2024-07-31 NLIST ARCX US31423L8000 FLCG Federated Hermes ETF Trust ETF 2024-07-31 NLIST ARCX US26922B4692 BDIV ETF Series Solutions Trust ETF 2024-07-31 NLIST ARCX US26922B4775 SAWG ETF Series Solutions Trust ETF 2024-07-31 NLIST ARCX US26922B4858 SAWS ETF Series Solutions Trust ETF 2024-07-31 NLIST ARCX US3899301085 BTC Grayscale Bitcoin Mini Trust ETC 2024-07-31 NLIST OTCM US56564V2007 MAQCU Maquia Capital Acquisition Corp STP 2024-07-31 NLIST OTCM KYG9879S1003 YSBIF YSB Inc. EQS 2024-07-31 NLIST OTCM US56564V1017 MAQC Maquia Capital Acquisition Corp EQS 2024-07-31 NLIST OTCM TH0010010013 SUOFF Saha-Union Public Company Ltd EQS 2024-07-31 NLIST OTCM CA09643M1059 BSKCF BluSky Carbon Inc. EQS 2024-08-01 NLIST OTCM ID1000198500 BENGF Barito Renewables Energy Tbk PT EQS 2024-08-01 NLIST OTCM FR0014005AL0 ANFPF Antin Infrastructure Partners EQS 2024-08-01 NLIST ARCX US45783Y1459 IAUG Innovator ETFs Trust ETF 2024-08-01 NLIST BATS US45783Y1376 KAUG Innovator ETFs Trust ETF 2024-08-01 NLIST BATS US45783Y1111 ZAUG Innovator ETFs Trust ETF 2024-08-01 NLIST BATS US00888H5625 AUGU AIM ETF Products Trust ETF