US Equity Shares Outstanding Guide
US Equity Shares Outstanding Guide
version 1.0 (Apr 2022)
We are here to help you do great things with our market and reference data. For questions, feedback, and other concerns, you may reach our team of experts using the following contact information:
algoseek customer support
support@algoseek.com
(+1) 646 583 1832
algoseek sales
sales@algoseek.com
(+1) 646 583 1832
DATA ORGANIZATION AND FILE FORMAT 4
Shares outstanding is the number of a company's shares currently held by all its shareholders. The number of shares outstanding (SO), shown on the company's balance sheet under the heading "Capital Stock” is used to calculate key metrics including market capitalization, earnings per share (EPS), and share stakes for regulatory reporting levels.
algoseek captures official SO from stock exchanges and company websites and provides updated values as soon as they have been made available by the official source. The frequency of the official updates varies from daily to annual.
There are two versions of SO data files provided by algoseek: basic and detailed. The basic version includes just the most important information such as the security Ticker, SecId, Effective Date, number of SO, etc. The detailed version is an extension of the Basic version and also includes additional fields such as Name, change of SO, Listing Date, etc.
There are two data aggregation options for this dataset that provide exactly the same data fields:
all: a single CSV file with data for all symbols
SecId: one CSV file with all data per Security ID - a unique security identifier used by algoseek that remains unchanged when the ticker changes
Currently, Shares Outstanding files are updated a couple of times a day.
Note: This dataset doesn’t cover ETNs. It is different from other exchange-traded instruments. ETN is a debt instrument and it doesn't have shares outstanding and doesn't report it to SEC.
In the meantime, ETNs have a similar concept called ETNs outstanding (units) that some vendors provide under the same name as shares outstanding.
Equity Shares Outstanding data is provided in plain-text CSV files. The first row of the CSV file is a fixed header, and then rows of data corresponding to individual events with SO changes. By default, the dataset is organized either by SecId or in a single file. For the SecId-based aggregation, all data for the security with an ID 33449 (AAPL) is stored in a separate CSV file.
Table 1 demonstrates the full list of data fields in the Equity Shares Outstanding Basic file with sample contents for the AAPL symbol.
Table 1: Sample Equity SO Basic Data
SecId | Ticker | CreatedDate | ChangedDate | EffectiveDate | SharesOutstanding |
33449 | AAPL | 20210430 | 20210430 | 20210416 | 16687631000 |
33449 | AAPL | 20210729 | 20210729 | 20210716 | 16530166000 |
33449 | AAPL | 20211101 | 20211101 | 20211015 | 16406397000 |
33449 | AAPL | 20220107 | 20220107 | 20220103 | 16334371000 |
33449 | AAPL | 20220201 | 20220201 | 20220114 | 16319441000 |
Table 2 (below) provides the name, brief description, and data type for each data field (column) in Equity SO Basic CSV file. The same information for the Equity SO Detailed CSV file is available in Table 3.
Table 2: CSV File Fields Schema Basic
Field | Type (Format) | Description |
SecId | integer | algoseek unique security identifier |
Ticker | string | Symbol name |
CreatedDate | string (yyyymmdd) | Trading date when SO event was created |
ChangedDate | string (yyyymmdd[_n]) | Trading date and version number (_n suffix) when SO event was changed |
EffectiveDate | string (yyyymmdd) | Effective date of SO value change |
SharesOutstanding | integer | New shares outstanding figure |
Table 3: CSV File Fields Schema Detailed
Field | Type (Format) | Description |
SecId | integer | algoseek unique security identifier |
Ticker | string | Symbol name |
CreatedDate | string (yyyymmdd) | Trading date when SO event was created |
ChangedDate | string (yyyymmdd[_n]) | Trading date and version number (_n suffix) when SO event was changed |
EffectiveDate | string (yyyymmdd) | Effective date of SO value change |
Name | string | Security name |
SharesOutstanding | integer | New shares outstanding figure |
SharesOutstandingDiff | integer | Change of SO, comparing with the previous figure |
EventId | integer | Unique Event Identifier of SO event |
ListDate | string (yyyymmdd) | Date of Listing |
Status | string | Security Status |
Security can have one of three different statuses (column Status). Table 4 provides all available values for the column Status with descriptions.
Table 4: Status Values
Value | Description |
A | Active |
D | In default |
I | Inactive |
SO files are updated during the whole day starting at 04:00 AM EST. Every time when new data for specific security is available, files so_basic.csv, so_detailed.csv, and file that includes all data for that SecId will be updated.