US Equity Shares Outstanding Guide                                                                                  


US Equity Shares Outstanding Guide

version 1.0 (Apr 2022)

CONTACT US

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

TABLE OF CONTENTS

INTRODUCTION        4

DATA ORGANIZATION AND FILE FORMAT        4

DAILY UPDATES        6


INTRODUCTION

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.

DATA ORGANIZATION AND FILE FORMAT

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

DAILY UPDATES

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.