US Equities Security Master File

US Equities Security Master File
Production
·

Data Class

Equity

Data Type

Reference

Delivery Method

CSV, SQL

Vendor

algoseek

Region

US

Documentation

Open Link

The US Equities Security Master File provides summary information such as industry, sector and listing status, track name and ticker changes, and cross-reference all major industry identifiers like FIGI and ISIN.

It encompasses all the listed and delisted equity securities, including stocks, ETFs, ETNs, ADRs, stock warrants, preferred stocks, etc., from 2007 to present, and is organized based on algoseek's unique identifier called Security ID (SecId), which remains consistent in the event of name or ticker changes. 

US Equities Security Master File is organized as a single file and updated daily. Lookup Files are available for converting Ticker and other identifiers to SecId.

Browse by tags:

Reference Data Security Master Identifiers FIGI ISIN Security Identification Ticker Changes Sector Classification
Dataset Info
Dataset Name ID
eq_sec_master
Algoseek Dataset ID
US1027
Data Format
Reference
Data Class
Equity
Data Type
Reference
Time Granularity
Event
Region
US
Universe
All stocks, ETFs/ETNs from US exchanges
Version
1.0
Update Frequency Options
End of day
 Introductory Demo Info
Start Date
01/01/2023
End Date
12/31/2023
Access Methods
SQL
Description
One year of data (2023) for the full universe of symbols
 Historical Info
Data Size
7.1 MB / year
Update Size
5.1 KB
Update Frequency
1 Day
Start Date
2007-01-01
End Date
Ongoing

SQL (ArdaDB)

Easily connect to your data using SQL with a database connection. No complex setup, just instant access to your data - run queries, retrieve insights, and manage data effortlessly. Secure, fast, and built for developers, analysts, and teams who need reliable access without the hassle.
Delivery Info
Update Time
01:30 ET
Database Table
USEquityReferenceData.SecMasterBase
Database Schema
USEquityReferenceData
Object Type
Table
Primary Date Column
--
Timestamp Column
--
Internal ID Column
SecId
Identifier Column
--
Data Fields
Preview Data
# name data type description
1 SecId Integer A unique identifier for a security
2 ASID Integer A unique identifier for a security
3 ListStatus String Current list status (D = Delisted. L = Listed)
4 SecurityDescription String Current type of security
5 Sic Integer Current Standard Industrial Classification code
6 Sector String Current SIC Sector
7 Industry String Current SIC Industry
8 SEDOL String Current Stock Exchange Daily Official List
9 Ticker List(String) List of symbol names used
10 TickerStartToEndDate List(String) Start and end dates for each ticker
11 Name List(String) List of security names used
12 NameStartToEndDate List(String) Start and end dates for each name
13 ISIN List(String) List of ISIN codes used
14 ISINStartToEndDate List(String) Start and end dates for each ISIN
15 USIdentifier List(String) List of USIdentifiers for US securities used
16 USIdentifierStartToEndDate List(String) Start and end dates for each USIdentifier
17 PrimaryExchange List(String) List of Primary Exchanges used
18 PrimaryExchangeStartToEndDate List(String) Start and end dates for each Primary Exchange
19 FIGI List(String) List of Financial Instrument Global Identifier codes used

CSV (S3)

Easily connect to your data stored in S3 and access CSV files without hassle. Streamline data retrieval with fast, secure, and scalable access, whether for analytics, processing, or integration.
Delivery Info
S3 Bucket Name
us-equity-master-sec-file
Update Time
01:30 ET
S3 Bucket Path
equity_security_master.csv
S3 Bucket Path Description
One csv master file and two folders with daily backups and daily changes
S3 Start Year
N/A
S3 End Year
N/A
S3 Bucket Size
7.1 MB / year
Sample Data File
A few sample records
Data Fields
Preview Data
# name data type description
1 SecId Integer algoseek unique security identifier
2 Tickers String List of symbol names used. If security had its ticker changed, the field will have multiple tickers separated by a semicolon ';'
3 TickersStartToEndDate String Start and end dates for each ticker. EndDate = 20991231 when the ticker is still being used
4 Name String List of security names used. If security had its name changed, the field will have multiple tickers separated by a semicolon ';'
5 NameStartToEndDate String Start and end dates for each name. EndDate = 20991231 when the name is still being used
6 ISIN String List of ISIN codes used. If security had its ISIN changed, the field will have multiple tickers separated by a semicolon ';'
7 ISINStartToEndDate String Start and end dates for each ISIN. EndDate = 20991231 when the ISIN is still being used
8 ListStatus String Current list status. D = Delisted. L = Listed
9 SecurityDescription String Current Security Description
10 USIdentifier String List of USIdentifiers for US securities used. If security had its USIdentifier changed, the field will have multiple identifiers separated by a semicolon ';'
11 USIdentifierStartToEndDate String Start and end dates for each USIdentifier. EndDate = 20991231 when the USIdentifier is still being used
12 PrimaryExchange String The last trade price for the underlying security before the current trade. Empty if no trade price is available
13 PrimaryExchangeStartToEndDate String Start and end dates for each Primary Exchange. EndDate = 20991231 when the Primary Exchange is still being used
14 SEDOL String Current Stock Exchange Daily Official List
15 Sic Integer Current Standard Industrial Classification code
16 Sector String Current SIC Sector
17 Industry String Current SIC Industry
18 FIGI String Financial Instrument Global Identifier. If security had its FIGI changed, the field will have multiple exchange names separated by a semicolon ';'