Concepts › Signals › Signal catalog
Profile catalog
Who and what the security is: categorical classification and identity data. Lookup information, not signals.
Classification
Categorical facts: sector, industry, SIC, exchange, country, currency, asset class and sub-class.
| Column | Type | Description |
|---|---|---|
asset_class | text | Asset class of the ticker: stocks, rates, crypto, or fx. |
asset_type | text | Asset class. One of `equity`, `etf`, or `crypto`. |
country | text | ISO country code of the issuer. |
currency_name | text | Currency the prices are quoted in (`usd`, `eur`, `gbp`, etc.). Effectively always `usd` for US-listed equities. |
exchange | text | Primary listing exchange, human-readable name — e.g. `NASDAQ`, `NYSE`, `NYSE Arca`, `Cboe BZX`, `NYSE American`. See `exchange_mic` for the raw ISO 10383 code. Null for a small number of delisted/edge names. |
exchange_mic | text | Primary listing exchange as an ISO 10383 **MIC code**: `XNAS` = NASDAQ, `XNYS` = NYSE, `ARCX` = NYSE Arca, `BATS` = Cboe BZX, `XASE` = NYSE American. The `?exchange=` filter accepts either this code or the human name. |
industry | text | GICS industry within the sector. |
sector | text | GICS sector. One of: Technology, Healthcare, Financials, Consumer Discretionary, Consumer Staples, Energy, Industrials, Materials, Utilities, Real Estate, Communication Services. |
sic_code | text | SIC code — the SEC's Standard Industrial Classification for the company's industry. |
sic_description | text | Plain-text label for the company's SIC industry code. |
ticker_category | text | Sub-class within an asset class, e.g. treasury_curve or policy_rate. |
Identifiers & reference
Which company this is: name, IDs (CIK, FIGI), listing status, contact, branding, employees.
| Column | Type | Description |
|---|---|---|
address_address1 | text | Company headquarters street address. |
address_city | text | Company headquarters city. |
address_postal_code | text | Company headquarters postal code. |
address_state | text | Company headquarters state or region. |
branding_icon_url | text | URL of the company's square icon image. |
branding_logo_url | text | URL of the company's logo image. |
cik | text | SEC Central Index Key — the company's identifier in EDGAR filings. |
composite_figi | text | Composite FIGI — Bloomberg's cross-exchange security identifier. |
description | text | Business description of the company. |
homepage_url | text | Company homepage URL. |
inactive_at | timestamp without time zone | When the ticker was marked inactive. |
inactive_reason | text | Why the ticker was marked inactive (e.g. delisted, stale data). |
list_date | text | Date the symbol was first listed on its exchange. |
name | text | Company or asset display name. |
phone_number | text | Company contact phone number. |
round_lot | integer | Standard trading lot size for the symbol. |
share_class_figi | text | Share-class FIGI — Bloomberg identifier for this specific share class. |
ticker_root | text | Root symbol — the base ticker without class or suffix modifiers. |
total_employees | integer | Number of full-time employees as last reported. Useful for size-based filters ("small-cap by employee count"). |
active | state | Ticker is actively traded — not delisted or halted.active = true |