Equity - Docs

The data dictionary and definitions for Equity

Fields

Parameter	Type	Description
equity_id	int	The Aiera-unique identifier for the associated equity
company_id	int	The Aiera-unique identifier for the parent company
name	str	The official name of the equity/company
common_name	str	The common name of the equity (i.e. Google vs Alphabet)
local_ticker	str	The ticker on the local exchange for the associated equity
mic	str	The Market Identifier Code for the exchange
bloomberg_ticker	str	The Bloomberg identifier for the associated equity
isin	str	The ISIN for the associated equity
permid	str	The PermID for the associated equity
ric	str	The Reuters Instrument Code for the associated equity
sector_id	int	The Aiera-unique identifier for the GICS sector
gics_sector	str	The GICS sector name for the equity
subsector_id	int	The Aiera-unique identifier for the GICS sub-sector
gics_sub_sector	str	The GICS sub-sector name for the equity
primary_equity	bool	Whether the equity is primary for the Aiera-unique company
status *	str	Internal status of the equity
created	datetime	When this equity record was created
modified	datetime	When this equity record was last modified
company_metadata *	obj	JSON object composed of company metadata, like names, urls, etc.

Possibles

status

Option	Description
active	Equity is actively traded
inactive	Equity is inactive
delisted	Equity has been delisted from exchange
merger	Equity involved in a merger
suspended	Trading is suspended

company url_type

Option	Description
filings	URL for company filings
home	URL for company's homepage
ir_events	URL for company's investor relation events
ir_home	URL for company's investor relations homepage
ir_news	URL for company's investor relation news
logo_icon	URL for company's logo image
youtube	URL for company's official YouTube page

company_metadata

{
  "company_metadata": {
    "company_id": 1,
    "common_name": "Amazon",
    "legal_name": "Amazon.com Inc",
    "incorporated_country_code": "US",
    "domiciled_country_code": "US",
    "urls": [
      {
        "url": "https://s3.amazonaws.com/assets.aiera.com/assets/manual-override-1-1723048553.9238625.png",
        "url_type": "logo_icon"
      },
      {
        "url": "https://ir.aboutamazon.com/overview/default.aspx",
        "url_type": "ir_home"
      },
      {
        "url": "https://ir.aboutamazon.com/events/default.aspx",
        "url_type": "ir_events"
      },
      {
        "url": "https://press.aboutamazon.com/press-release-archive",
        "url_type": "ir_news"
      },
      {
        "url": "https://www.amazon.com/",
        "url_type": "home"
      },
      {
        "url": "https://ir.aboutamazon.com/sec-filings/default.aspx",
        "url_type": "filings"
      },
      {
        "url": "https://www.youtube.com/user/amazon",
        "url_type": "youtube"
      }
    ]
  }
}