
Dataset Name: ciq_financials_quarterly
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.Quarterly 10-Q 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 Expenses 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 |