securities

6 securities types: 1 a sibling also accepts and reads alike, 4 that decompose into parts, 2 in Meridian's open data.

6 types

The 6 securities types

Each type's first registry sample, against every sibling's rule

Type	Sample	Also accepted by
FIGI figi · VARCHAR	BBG000BLNQ16	isin
CUSIP cusip · VARCHAR	037833100	—
ISIN isin · VARCHAR	US0378331005	—
LEI lei · VARCHAR	529900T8BM49AURSDO55	—
SEDOL sedol · VARCHAR	0263494	—
Stock Ticker ticker · VARCHAR	AAPL	—

Which securities type is it?

2 of 6 securities types accept it, and read it alike.

Type	Reads it as
FIGI `figi`	BBG000BLNQ16
ISIN `isin`	BBG000BLNQ16

In Meridian's open data

LEIgleif.leiedgar_gleif.lei
Stock Tickeredgar.tickeredgar_gleif.ticker

Use it

CLI · DuckDB

$ printf '%s\n' 'BBG000BLNQ16' 'BBG000B9XRY4' > column.txt
$ finetype infer -f column.txt --mode column

SELECT ft_profile(v) FROM (VALUES ('BBG000BLNQ16'), ('BBG000B9XRY4')) t(v);

After BBG000B9XRY4, 2 types remain: figi, isin.

securities

The 6 securities types

Which securities type is it?

In Meridian's open data

Use it

Type Registry