US Equities ASID Lookup
US Equities ASID Lookup
Production
·
The Equity ASID Lookup is a single data file containing all the listed and delisted equity securities including stocks, ETFs, ETNs, ADRs, stock warrants, preferred stocks, etc., from 2007 to the present with ticker changes and their date ranges. ASID Lookup is a complementary dataset that helps to track pricing history for securities with SecId changes. SecId is algoseek's unique identifier which remains unchanged during a name or ticker changes but can change during a security restructure (for example, reclassification). To link SecIds for specific security after such events algoseek invented a new unique identifier ASID that remains unchanged during the whole life of the security.
Dataset Info
Dataset Name ID
eq_secid_chains_lookup
Algoseek Dataset ID
US1028
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
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
Data Size
1.6 MB / year
Update Size
1.6 MB
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.
USEquityReferenceData.ASIDLookupBase
Update Time
23:30 ET
Database Table
USEquityReferenceData.ASIDLookupBase
Database Schema
USEquityReferenceData
Object Type
Table
Primary Date Column
StartDate
Timestamp Column
--
Internal ID Column
--
Identifier Column
Ticker
Data Fields
Preview Data
| # | name | data type | description |
|---|---|---|---|
| 1 | ASID | Integer | A unique identifier for a security |
| 2 | Ticker | String | Symbol name |
| 3 | StartDate | Date | The start date |
| 4 | EndDate | Date | The end date |
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.
us-equity-secid-chains-lookup
S3 Bucket Name
us-equity-secid-chains-lookup
Update Time
23:30 ET
S3 Bucket Path
equity_asid_lookup.csv
S3 Bucket Path Description
One csv file with SecId chain ID mapped to ticker
S3 Start Year
N/A
S3 End Year
N/A
S3 Bucket Size
1.6 MB / year
Sample Data File
Data Fields
Preview Data
| # | name | data type | description |
|---|---|---|---|
| 1 | ASID | String | Algoseek unique security identifier |
| 2 | LastTicker | String | Current symbol name or the last available |
| 3 | Tickers | String | List of symbol names used. Multiple tickers are separated by a semicolon if the ticker changed |
| 4 | TickersStartToEndDate | String | Start and end dates for each ticker. EndDate is 20991231 when the ticker is still being used |
| 5 | SecIds | String | List of unique security identifiers related to security structure. Multiple SecIds are separated by a semicolon if changed |
| 6 | SecIdsStartToEndDate | String | Start and end dates for each SecId. EndDate is 20991231 when the SecId is still being used |