Announce something here

ciq_financials_last_known
Contact Sales Team

ciq_financials_last_known by CloudQuant

Dataset Name: ciq_financials_last_known


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.

Current 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
companyname string The Company’s Name. May be formal/legal name or some derivative of the company's name.
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.
Security Type string Security Type classification
Trading Status string The status of the security. Active is a currently tradable security
Security Start Date string The date that the security started trading. All dates have time of 00:00:00
Is Depositary Receipt bool Is Depositary Receipt
Exchange string Exchange Identifier for the data source. This may contain the Market Identifier Code (MIC), or and exchange nmemonic (eg. NYSE, TSE, ASX...) or a dataset specific code provided by the data vendor.
city string City of the company
state/province string State or province of the company
country string Country of the company
countryId string Capital IQ's contry identifier. This field is useful for referencing data from Capital IQ that may contain a numeric code for the country.
phone number string Primary phone number
isin string International Securities Identification Number. An international code which identifies a securities issue
MC Pricing Date string Market Cap pricing date
Market Cap double Market Cap
Total Enterprise Value double Total Enterprise Value
Shares Outstanding double Shares outstanding refer to a company's stock currently held by all its shareholders, including share blocks held by institutional investors and restricted shares owned by the company’s officers and insiders.
First Recorded PE Pricing Date string First Recorded PE Pricing Date
First Recorded Price Close double First Recorded Price Close
PE Pricing Date string The date that the price earnings ratio was calculated.
Price Close double Previous Close as provided by Capital IQ
Filing Date string Filining date with the regulator
Calendar Year int Calendar Year
Period End Date string Period End Date
Form Type string The type of document used for the update (e.g. Interim, Annual, 10-K, 10-Q, etc.)
Accession Number string A unique SEC or SEDAR identifier that identifies a document
Average Market Cap double Average Market Capitalization. The average aggregate market value of a company represented in a dollar amount.
Total Shares Outstanding on Filing Date double Total Shares Outstanding on Filing Date
Total Common Shares Outstanding double Total Common Shares Outstanding
Common Shares Outstanding double Common Shares Outstanding
Class A Common Shares Outstanding double Class A Common Shares Outstanding
Class B Common Shares Outstanding double Class B Common Shares Outstanding
Book Value / Share double Book Value / Share
Period Last PE Ratio double Period Last PE Ratio
Total Employees double Total number of employees
Free Cash Flow / Share double Free Cash Flow / Share
Working Capital double Working Capital = the money available to meet the companies short-term obligations.
Basic Earnings Per Share - Total double Basic Earnings Per Share - Total
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.
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.
Common Dividends Paid double Common Dividends Paid
Sales double The Sales for the company
Cost Of Revenues double Cost Of Revenues
EBT, Excl. Unusual Items double This item represents EBT Before Non Recurring Items and is arrived at after adjusting, the following, to Operating Profit (OPIN)
Earnings Before Xtra Ord. Item & Accounting Change double This item represents Earnings Before Extra Ordinary Item & Accounting Changes and is arrived at after adjusting Earnings Of Discontinued Operations (DO) to Earnings From Continuing Operations (ECOIN).
Earnings From Continuing Operations double An income statement figure indicating the net income that a firm brings in from ongoing business activities. These activities are expected to continue into the next reporting period. It typically excludes non-recurring and non-operating items
Net EPS - Diluted double Net Earnings per Share (EPS) - Diluted
Net EPS - Basic double Net Earnings per Share (EPS) - Basic
Gross Profit double This item represents the Total Revenue (TRIN) minus Cost Of Goods Sold, Total (COGST).
Net Income - (IS) double This item represents Net Income (Loss) Before Pref. Dividend and is arrived at after adjusting Extraordinary Item & Accounting Change (EIACX) to Earnings Before Extra Ord. Item & Acc. Ch. (EBXAIN).
Net Income to Common Incl Extra Items double This item represents the Net Income (Loss) available to common stock holders and is arrived after adjusting preferred stock dividends and other adjustments to Net Income (Loss) Before Pref. Dividend (NIIN).
Unusual Items, Total double Unusual Items, Total
Operating Income double This item represents the difference between the Total Revenues (TRIN) and the Total Operating costs during the given fiscal year.
Total Revenues double The total amount received from the sale of products or services of an acquirer company during a given period
Cost of Goods Sold, Total double This item represents the cost incurred on all raw materials and work in process, manufacturing expenses and costs incurred which can be directly attributable to generate the main revenues of the company.
Interest And Investment Income double This item represents the interest and investment income derived from investments made out of surplus funds.
Income Tax Expense double This item represents provision (refund) for income taxes reported by the company in Income Statement by way of deduction from earnings before taxes.
Merger & Related Restructuring Charges double This item represents any expenses incurred by a company to merge with or to acquire other company .
Interest Expense, Total double This item represents the interest expense (net of capitalized interest) incurred by the company on the debt taken. This item also includes debt procurement costs, and dividend paid by parent company on the preferred stock of its subsidiary or on trust pre
Other Non Operating Income (Expenses) double This item represents any other income (expense), which is not directly attributable to the operating activities of the company.
Restructuring Charges double This item represents costs incurred to restructure or realign operations of a company or to refocus its business strategy or to streamline operations or to cut costs or to improve operating efficiency or to increase profitability.
R&D Expenses double This item represents the costs incurred by a company on development of a new product, innovation relating to technology formulation, process development, or on the process undertaken in upgrading the existing product or service line. Research and developm
Selling General & Admin Expenses, Total double This item represents all costs incurred towards selling, general and administrative expense. It includes advertising, marketing, administrative, plan contributions, delivery and distribution, storage, general and other indirect production related expendit
Revenues double This item represents the total revenues that are earned as a result of the company's primary activities. This is the main source of income to the company.
Cost of Goods Sold double This item represents the cost incurred on all raw materials and work in process, manufacturing expenses and other costs directly attributable to manufacture of finished goods. These expenses are available at the start of the expenses block.
Salaries And Other Employee Benefits double This item represents the salaries and other benefits provided to the employees.
Service Revenues double This item represents the revenues that are earned by providing services to customers by the company as a primary activity. This is one of the main sources of income to the company.
Merger & Restructuring Charges double Merger & Restructuring Charges
Net Interest Expenses double Net Interest Expense means interest expense minus interest income, excluding in either case capitalized interest, but including payments in the nature of interest under capital leases if and to the extent characterized as such in accordance with GAAP
Net Income Before Preferred Dividend - (As Reported) double Net Income Before Preferred Dividend - (As Reported)
Total Cash And Short Term Investments double Total cash and Short Term Investments signify the sum of target cash and any investments with maturities of one year or less.
Total Common Equity double The term defines the capital received from investors in exchange for stock (paid-in capital), donated capital, and retained earnings. This is equal to total assets minus liabilities, preferred stock, and intangible assets.
Total Assets double Total Assets as an acquirer security represents the acquirer?s assets, such as real estate, equipment, inventory, contract rights, leases, patents, and trademarks.
Total Current Assets double This item represents assets which are expected to be converted into cash or used in the production of revenue within a period of one year.
Total Current Liabilities double This item represents the sub total of all the current liabilities of a company.
Total Liabilities And Equity double This item represents the sum total of all the liabilities, preferred equity and common shareholders equity.
Total Long-Term Liabilities double This item represents the sum of all the long-term liabilities of the company.
Accrued Expenses, Total double This item represents expenses which are already incurred, but for which payment is to be made in the subsequent accounting period. Accrued expenses may be of recurring nature or non-recurring nature.
Accounts Payable, Total double This item represents trade payables for the purchase of materials and supplies to be used in the production of goods or in providing of services and are due in customary trade terms within one year or within the normal operating cycle of the company.
Accounts Receivable, Total double This item represents net amounts due from customers on account of credit sales or services rendered in the ordinary course of business.
Inventory double This item represents a company's merchandise held for sale. It also includes raw materials and
Long-Term Debt double This item represents loan amounts, which are to be repaid in full, usually with interest, that are not currently payable within one year or within the operating cycle of the business.
Minority Interest double Minority Interest signifies the equity of the minority shareholders in a company's subsidiaries.
Unearned Revenue Current, Total double This item represents revenues, which are received in the current period but, which are considered likely to be recognized as revenues in the immediately succeeding accounting period.
Accrued Expenses double This item represents expenses already incurred, but for which payment is to be made in the subsequent accounting period. Accrued expenses may be of recurring nature or non-recurring nature.
Accounts Payable double This item represents trade payables for the purchase of materials and supplies to be used in the production of goods or in providing of services and are due in customary trade terms within one year or within the normal operating cycle of the company.
Accounts Receivable double This item represents net amounts due from customers on account of credit sales or services rendered in the ordinary course of business.
Common Shares Issued double This item represents the Number of Common Shares issued by the firm at the end of a period as reported in the Annual and Quarterly Balance Sheet. It is the sum of Common Shares Outstanding plus Common Shares in Treasury
Common Stock, Total double This item represents the securities of equity ownership with voting rights and dividends and having a residuary right to the company's assets in the event of liquidation.
Common Shares In Treasury double This item represents the Number of Common Shares repurchased OR reacquired by the Corporation (from market or directly from stockholders) at the end of a period as reported in the Annual and Quarterly Balance Sheet
Goodwill double This item represents the excess of purchase price paid over the fair market value of net assets acquired, net of any write downs for impairment in value.
Retained Earnings double This item represents the amount of accumulated earnings of a company which has been neither distributed to the shareholders nor apportioned for any specific purpose. If however in case of consistent losses there will be debit balance in this account repre
Shares Outstanding on Filing Date double This item represents the number of common shares outstanding as on the day of filing the annual or quarterly report with SEC. This is the Latest shares data for as reported in Annual or Quarterly Balance Sheet. This data is fully adjusted for all Common S
Treasury Stock double This item represents the common stock reacquired by a company issued by it earlier, which has neither been cancelled nor re-issued.
Total Equity double Total equity is the amount invested in a company by investors in exchange for stock, plus all subsequent earnings of the business, minus all subsequent dividends paid out.
Total Assets (As Reported) double Total assets refers to the total amount of assets owned by a person or entity. Assets are items of economic value, which are expended over time to yield a benefit for the owner. If the owner is a business, these assets are usually recorded in the accounti
Current Portion of Long-Term Debt double Current Portion of Long-Term Debt
Cash from Operations double This item represents net cash used or generated in operating activities, during the stated period of time.
Long-Term Debt Issued double This item represents cash inflows on issuance of any debt that is long-term in nature.
Long-Term Debt Repaid double This item represents cash outflow towards repayment of long-term debt.
Dividend Per Share double This item represents the Gross dividend per Common share declared in the form of Cash.
Basic Weighted Average Shares Outstanding double This item represents the number of basic weighted average shares outstanding during the period (used by the company as denominator in calculating Basic earnings per share/ADS).
Receivables Turnover (Average Receivables) double This number indicates how quickly customers are paying in the business. The greater the number of times Receivables Turnover during the period, the shorter the time between Sales and Cash collection.
ADR ratio double It represents the no of companys common equity shares equivalent to one American Depository Receipt.
Current Ratio double This ratio represents Current Assets total, DIVIDED by Current Liabilities - Total
EBITDA Margin % double This ratio shows the percentage of EBITDA to Total Revenues.
EBIT Margin % double This ratio shows the percentage of Earnings Before Interest and Taxes to Total Revenues.
Gross Profit Margin % double This ratio shows the percentage of Gross Profit to Total Revenue.
Inventory Turnover (Average Inventory) double This Ratio indicates how often a Business Inventory turns over during the course of the year. This Ratio represents Total Revenue DIVIDED by Average of the Inventory.
Net Income Margin % double It shows the return on sales after providing for income taxes.
Quick Ratio double This ratio represents cash, cash equivalents and Receivables-total that are expected to be realized in the next 12 months , DIVIDED by Current Liabilities - Total.
EBIAT Ratio double This ratio shows the sum of operating income and income (loss) on equity investment net of income tax.
Total Debt double This data item represents the Total Debt of the company. Formula = LPCT + CLTD + CCL + LTDT + LCL + FDCDT + FDLTDT + TPST + FHLB Debt - LT [Banks Template] Where LPCT = Short Term Borrowings CLTD = Current Portion of Long Term Debt CCL = Current Portion o
Return on Assets double This ratio shows percentage of Returns to Total Assets of the company.
Income From Continuing Operations Margin % double This ratio shows percentage of Earnings from Continuing Operations to Total Revenues.
Net Debt / EBITDA double This ratio shows how much EBITDA is of Net Debt.
Effective Tax Rate - (Ratio) double Effective Tax Rate
Payout Ratio double Payout Ratio
Cash Per Share - (Ratio) double Cash Per Share
Revenue Per Share double Revenue Per Share
EBITA Margin double EBITA Margin
Normalized Net Income Margin double Normalized Net Income Margin
Unlevered Free Cash Flow Margin double Unlevered Free Cash Flow Margin
Gross Profit (As Reported) double Gross Profit (As Reported)
Unsecured Debt double Unsecured Debt
Return on Common Equity double Return on Common Equity
Fair Value of Assets double Fair Value of Assets
Fixed Rate Debt double Fixed Rate Debt
Variable Rate Debt double Variable Rate Debt
Fixed Rate Debt (% of Total Debt) double Fixed Rate Debt (% of Total Debt)
Net Working Capital / Total Revenue double Net Working Capital / Total Revenue
Net Working Capital / Total Assets double Net Working Capital / Total Assets
Management Rate of Return (%) double Management Rate of Return (%)
Current Assets / Short Term Debt double Current Assets / Short Term Debt
Intangible Assets/Revenue (x) double Intangible Assets/Revenue (x)
Working Capital Turnover double Working Capital Turnover
Current Assets / Total Assets double Current Assets / Total Assets
Last Close Market Cap / Total Revenue double Last Close Market Cap / Total Revenue
Last Closing Shares Short double Last Closing Shares Short
Working Capital / Share double Working Capital / Share
PE Ratio double The price-to-earnings ratio (P/E ratio) is the ratio for valuing a company that measures its current share price relative to its per-share earnings (EPS).
PS Ratio double The price-to-sales (P/S) ratio is a valuation ratio that compares a company's stock price to its revenues. It is an indicator of the value that financial markets have placed on each dollar of a company's sales or revenues.
TEV to EBIT Ratio double Total Enterprise Value to EBIT Ratio
Free Cash Flow Yield double Free Cash Flow Yield
Free Cash Flow Ratio double Free Cash Flow Ratio
Book Value Yield double Book Value Yield
PB Ratio double PB Ratio
Sales / Share double Sales per Share


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.