Announce something here

ciq_financials_annual

ciq_financials_annual by CloudQuant

Dataset Name: ciq_financials_annual


Group: financials
Vendor: CloudQuant
Symbol Set: US Equities
Asset Class: Equity
Data Update Time(s): Every 15 Min
Data Update Frequency: intraday

Only Available To Properly Licenced Researchers

Important Licensing Dataset Notes

This dataset is only available to data analysts, and Traders who have worked with CloudQuant to set up the proper licensing. Please contact Sales directly at Sales@CloudQuant.com to inquire about this dataset.

Annual 10-K or equivalent financial reports on public traded companies

Data Contained in this Dataset

Column Type Description
_seq uint Internal sequence number used to keep data rows in order
timestamp string Timestamp of the Data - America/New York Time.
muts uint64 Microseconds Unix Timestamp. An integer representation of a timestamp with microsecond precision that can be compared directly to other timestamps.
symbol string Trading Symbol or Ticker
companyid int The Capital IQ unique company identifier. This field is useful for referencing data from Capital IQ that may contain a numeric code for the company.
exchangename string Exchange or Market place name
companyname string The Company’s Name. May be formal/legal name or some derivative of the company's name.
tradingitemstatusname string Status of the Trading Security
filingdate string Filing Date
periodenddate string Last Date of Period (Quarter/Year)
calendarquarter int Calendar Quarter
calendaryear int Celendar Year
fiscalyear int Fiscal year (ie 2017 2018 2019 2020 2021)
fiscalquarter int The company's fiscal quarter
formtype string Regulatory Form Type (eg 10-K, 10-Q)
isocode string ISO Currency Code
nummonths string Number of months in the data element
CF D&A - D&A for EBITDA double CF D&A - D&A for EBITDA
Calculated Inter-Period % - Common Equity, 1 Yr. Growth % double Calculated Inter-Period % - Common Equity, 1 Yr. Growth %
Calculated Inter-Period % - Earnings From Cont. Operations, 1 Y double Calculated Inter-Period % - Earnings From Cont. Operations, 1 Y
Calculated Inter-Period % - Net Income, 1 Yr. Growth % double Calculated Inter-Period % - Net Income, 1 Yr. Growth %
Calculated Inter-Period % - Normalized Net Income, 1 Yr. Growth double Calculated Inter-Period % - Normalized Net Income, 1 Yr. Growth
Calculated Inter-Period % - Return On Equity % double Calculated Inter-Period % - Return On Equity %
Calculated Inter-Period % - Return on Assets double Calculated Inter-Period % - Return on Assets
Calculated Inter-Period % - Return on Common Equity double Calculated Inter-Period % - Return on Common Equity
Calculated Inter-Period % - Tangible Book Value, 1 Yr. Growth % double Calculated Inter-Period % - Tangible Book Value, 1 Yr. Growth %
Calculated Inter-Period Ratio - Number of Days in a Period double Calculated Inter-Period Ratio - Number of Days in a Period
Calculated Intra-Period % - EBIT Margin % double Calculated Intra-Period % - EBIT Margin %
Calculated Intra-Period % - EBITA Margin double Calculated Intra-Period % - EBITA Margin
Calculated Intra-Period % - Gross Profit Margin % double Calculated Intra-Period % - Gross Profit Margin %
Calculated Intra-Period % - Income From Continuing Operations M double Calculated Intra-Period % - Income From Continuing Operations M
Calculated Intra-Period % - Net Avail. For Common Margin % double Calculated Intra-Period % - Net Avail. For Common Margin %
Calculated Intra-Period % - Net Income Margin % double Calculated Intra-Period % - Net Income Margin %
Calculated Intra-Period % - Normalized Net Income Margin double Calculated Intra-Period % - Normalized Net Income Margin
Calculated Intra-Period % - Recurring Earnings/Total Assets (%) double Calculated Intra-Period % - Recurring Earnings/Total Assets (%)
Calculated Intra-Period % - Return on Capital (%) double Calculated Intra-Period % - Return on Capital (%)
Calculated Intra-Period % - SG&A Margin double Calculated Intra-Period % - SG&A Margin
Calculated Intra-Period % - Total Debt / Total Liabilities % double Calculated Intra-Period % - Total Debt / Total Liabilities %
Calculated Intra-Period % - Total Debt to Capital (%) double Calculated Intra-Period % - Total Debt to Capital (%)
Calculated Intra-Period % - Total Liabilities / Total Assets double Calculated Intra-Period % - Total Liabilities / Total Assets
Calculated Intra-Period Ratio - Current Assets / Total Assets double Calculated Intra-Period Ratio - Current Assets / Total Assets
Calculated Intra-Period Ratio - Current Ratio double Calculated Intra-Period Ratio - Current Ratio
Calculated Intra-Period Ratio - Net Working Capital / Total Ass double Calculated Intra-Period Ratio - Net Working Capital / Total Ass
Calculated Intra-Period Ratio - Quick Ratio double Calculated Intra-Period Ratio - Quick Ratio
Cash Flow - Cash from Financing double Cash Flow - Cash from Financing
Cash Flow - Cash from Operations (As Reported) double Cash Flow - Cash from Operations (As Reported)
Cash Flow - Cash from Operations double Cash Flow - Cash from Operations
Cash Flow - Net Change in Cash double Cash Flow - Net Change in Cash
Cash Flow - Net Income - (CF) double Cash Flow - Net Income - (CF)
Cash Flow - Other Non-Cash Items, Total double Cash Flow - Other Non-Cash Items, Total
Earnings Per Share - Basic EPS - Continuing Operations double Earnings Per Share - Basic EPS - Continuing Operations
Earnings Per Share - Basic Earnings Per Share - Total double Earnings Per Share - Basic Earnings Per Share - Total
Earnings Per Share - Diluted EPS - Continuing Operations double Earnings Per Share - Diluted EPS - Continuing Operations
Earnings Per Share - Net EPS - Basic double Earnings Per Share - Net EPS - Basic
Earnings Per Share - Net EPS - Diluted double Earnings Per Share - Net EPS - Diluted
Earnings Per Share - Normalized Basic EPS double Earnings Per Share - Normalized Basic EPS
Earnings Per Share - Normalized Diluted EPS double Earnings Per Share - Normalized Diluted EPS
IQ Added - Ratios - Average BS Shout double IQ Added - Ratios - Average BS Shout
IQ Added - Ratios - Average Stock Price Date - Begin Date double IQ Added - Ratios - Average Stock Price Date - Begin Date
IQ Added - Ratios - Average Stock Price Date - End Date double IQ Added - Ratios - Average Stock Price Date - End Date
IQ Added - Ratios - Average Volume double IQ Added - Ratios - Average Volume
IQ Added - Ratios - Period Last BS Shout double IQ Added - Ratios - Period Last BS Shout
IQ Added - Ratios - Period Last Market Cap / Total Revenue double IQ Added - Ratios - Period Last Market Cap / Total Revenue
IQ Added - Ratios - Period Last PE Ratio double IQ Added - Ratios - Period Last PE Ratio
IQ Added - Ratios - Period Last Price / Book Value double IQ Added - Ratios - Period Last Price / Book Value
IQ Added - Ratios - Period Last Volume double IQ Added - Ratios - Period Last Volume
IQ Added - Share Price/Count Related - Average 52 Week High double IQ Added - Share Price/Count Related - Average 52 Week High
IQ Added - Share Price/Count Related - Average 52 Week Low double IQ Added - Share Price/Count Related - Average 52 Week Low
IQ Added - Share Price/Count Related - Period Last 52 Week High double IQ Added - Share Price/Count Related - Period Last 52 Week High
IQ Added - Share Price/Count Related - Period Last 52 Week Low double IQ Added - Share Price/Count Related - Period Last 52 Week Low
IQ Added - Share Price/Count Related - Period Last Stock Price double IQ Added - Share Price/Count Related - Period Last Stock Price
IQ Added - TEV/Capital - Average Market Cap double TEV/Capital - Average Market Cap
IQ Added - TEV/Capital - Average Period Stock Price double TEV/Capital - Average Period Stock Price
IQ Added - TEV/Capital - Average TEV double TEV/Capital - Average TEV
IQ Added - TEV/Capital - Average Volume Weighted Stock Price double TEV/Capital - Average Volume Weighted Stock Price
IQ Added - TEV/Capital - Period Last Market Cap double TEV/Capital - Period Last Market Cap
IQ Added - TEV/Capital - Period Last TEV double TEV/Capital - Period Last TEV
Income Statement - Cost Of Revenues double Income Statement - Cost Of Revenues. The term cost of revenue refers to the total cost of manufacturing and delivering a product or service to consumers.
Income Statement - Cost of Goods Sold, Total double Cost of Goods Sold, Total. Cost of goods sold (COGS) refers to the direct costs of producing the goods sold by a company. This amount includes the cost of the materials and labor directly used to create the good. It excludes indirect expenses, such as distribution costs and sales force costs.
Income Statement - Diluted Net Income double Income Statement - Diluted Net Income
Income Statement - EBIAT Ratio double Income Statement - EBIAT Ratio
Income Statement - EBIT (Excl. SBC and Incl. Equity Inc. from A double Income Statement - EBIT (Excl. SBC and Incl. Equity Inc. from A
Income Statement - EBIT (Excl. SBC) double Income Statement - EBIT (Excl. SBC)
Income Statement - EBIT (Incl. Equity Inc. from Affiliates) double Income Statement - EBIT (Incl. Equity Inc. from Affiliates)
Income Statement - EBIT double Earnings before interest and taxes (EBIT) is an indicator of a company's profitability. EBIT can be calculated as revenue minus expenses excluding tax and interest. EBIT is also referred to as operating earnings, operating profit, and profit before interest and taxes.
Income Statement - EBITA (Excl. SBC and Incl. Equity Inc. from double Income Statement - EBITA (Excl. SBC and Incl. Equity Inc. from
Income Statement - EBITA (Excl. SBC) double Income Statement - EBITA (Excl. SBC)
Income Statement - EBITA (Incl. Equity Inc. from Affiliates) double Income Statement - EBITA (Incl. Equity Inc. from Affiliates)
Income Statement - EBITA double Earnings before interest, taxes, and amortization (EBITA) is a measure of company profitability used by investors. It is helpful for the comparison of one company to another in the same line of business. In some cases, it also can provide a more accurate view of the company’s real performance over time.
Income Statement - EBITDA (Incl. Equity Inc. from Affiliates, L double Income Statement - EBITDA (Incl. Equity Inc. from Affiliates, L
Income Statement - EBITDA double EBITDA, or earnings before interest, taxes, depreciation, and amortization, is an alternate measure of profitability to net income. By stripping out the non-cash depreciation and amortization expense as well as taxes and debt costs dependent on the capital structure, EBITDA attempts to represent cash profit generated by the company’s operations.
Income Statement - EBT, Excl. Unusual Items double Income Statement - EBT, Excl. Unusual Items
Income Statement - EBT, Incl. Unusual Items double Income Statement - EBT, Incl. Unusual Items
Income Statement - Earnings Before Tax (As Reported) double Earnings Before Tax (As Reported). Earnings before tax (EBT) is a measure of financial performance. It reveals a company's earnings before taxes are deducted, is calculated by subtracting all expenses excluding taxes from revenue, and appears as a line item in the income statement.
Income Statement - Earnings Before Xtra Ord. Item & Accounting double Income Statement - Earnings Before Xtra Ord. Item & Accounting
Income Statement - Earnings From Continuing Operations double Earnings From Continuing Operations. Income from continuing operations is also known as operating income. A multistep income statement reports income from continuing operations separately from non-operating income. A business must consistently generate earnings from operations to succeed in the long term.
Income Statement - Earnings to Parent before Extraordinary Item double Earnings to Parent before Extraordinary Item
Income Statement - Gross Profit double Income Statement - Gross Profit
Income Statement - Net Income - (IS) double Income Statement - Net Income - (IS)
Income Statement - Net Income Before Preferred Dividend - (As R double Income Statement - Net Income Before Preferred Dividend - (As R
Income Statement - Net Income to Common Excl. Extra Items double Income Statement - Net Income to Common Excl. Extra Items
Income Statement - Net Income to Common Incl Extra Items double Income Statement - Net Income to Common Incl Extra Items
Income Statement - Net Income to Company double Income Statement - Net Income to Company
Income Statement - Net Interest Expenses double Income Statement - Net Interest Expenses
Income Statement - Normalized Net Income double Income Statement - Normalized Net Income
Income Statement - Operating Income double Income Statement - Operating Income
Income Statement - Other Operating Expenses, Total double Income Statement - Other Operating Expenses, Total
Income Statement - Revenues double Income Statement - Revenues
Income Statement - Selling General & Admin Expenses (Summary Su double Selling General & Admin Expense from Income Statement
Income Statement - Selling General & Admin Expenses, Total double Selling General & Admin Expenses, Total from Income Statement
Income Statement - Total Operating Expenses double Income Statement - Total Operating Expenses
Income Statement - Total Revenues double Income Statement - Total Revenues
Non-Financial - As Reported Balance Sheet Date double Non-Financial - As Reported Balance Sheet Date
Non-Financial - As Reported Period End, Cash Flow double Non-Financial - As Reported Period End, Cash Flow
Non-Financial - As Reported Period End, Income Statement double Non-Financial - As Reported Period End, Income Statement
Weighted Average Shares - Basic Weighted Average Shares Outstan double Weighted Average Shares - Basic Weighted Average Shares Outstan
Weighted Average Shares - Diluted Weighted Average Shares Outst double Weighted Average Shares - Diluted Weighted Average Shares Outst
balance_sheet string JSON of all Balance Sheet data elements
cash_flow string JSON of all cash flow data elements
earnings_per_share string JSON of all EPS data elements
income_statement string JSON of all income statement data elements
calculated_intra_period_percent string JSON of calculated intra-period percent data elements
calculated_intra_period_ratio string JSON of CIQ calculated intra-period ratios
other string JSON of other financial data elements


Important Dataset Notes

This dataset is not available for direct online purchase. Please contact sales directly at sales@CloudQuant.com. The data is available through our normal sales department who can provide you with current pricing and a quote for accessing this valuable dataset. This may be due to a number of reasons such as dataset intended use, size of the company (or investment fund) using the dataset, or for simple legal requirements that CloudQuant needs to ensure are in place prior to licensing the dataset to you.