Baselight

US Market Data

Dataset of USA companies.

@kaggle.yash16jr_us_market_dataset

Loading...
Loading...

About this Dataset

US Market Data

The dataset contains US market data such as company ticker, industry, daily share prices, cash flow, income statement, balance sheet etc.
The dataset also contains all this information separately for banks and insurance companies.Data ranges from 2017 to 2022-23.

Tables

Bank Balance Sheet

@kaggle.yash16jr_us_market_dataset.bank_balance_sheet
  • 416.01 kB
  • 3,124 rows
  • 27 columns
Loading...
CREATE TABLE bank_balance_sheet (
  "ticker" VARCHAR,
  "report_date" TIMESTAMP,
  "id" BIGINT,
  "currency" VARCHAR,
  "fiscal_year" BIGINT,
  "fiscal_period" VARCHAR,
  "publish_date" TIMESTAMP,
  "restated_date" TIMESTAMP,
  "shares_basic" BIGINT  -- Shares (Basic),
  "shares_diluted" BIGINT  -- Shares (Diluted),
  "cash_cash_equivalents_short_term_investments" DOUBLE  -- Cash, Cash Equivalents \u0026 Short Term Investments,
  "interbank_assets" DOUBLE,
  "short_long_term_investments" DOUBLE  -- Short \u0026 Long Term Investments,
  "accounts_notes_receivable" DOUBLE  -- Accounts \u0026 Notes Receivable,
  "net_loans" DOUBLE,
  "net_fixed_assets" DOUBLE,
  "total_assets" BIGINT,
  "total_deposits" DOUBLE,
  "short_term_debt" DOUBLE,
  "long_term_debt" DOUBLE,
  "total_liabilities" BIGINT,
  "preferred_equity" DOUBLE,
  "share_capital_additional_paid_in_capital" DOUBLE  -- Share Capital \u0026 Additional Paid-In Capital,
  "treasury_stock" DOUBLE,
  "retained_earnings" DOUBLE,
  "total_equity" BIGINT,
  "total_liabilities_equity" BIGINT  -- Total Liabilities \u0026 Equity
);

Bank Cash Flow

@kaggle.yash16jr_us_market_dataset.bank_cash_flow
  • 379.87 kB
  • 3,124 rows
  • 26 columns
Loading...
CREATE TABLE bank_cash_flow (
  "ticker" VARCHAR,
  "report_date" TIMESTAMP,
  "id" BIGINT,
  "currency" VARCHAR,
  "fiscal_year" BIGINT,
  "fiscal_period" VARCHAR,
  "publish_date" TIMESTAMP,
  "restated_date" TIMESTAMP,
  "shares_basic" BIGINT  -- Shares (Basic),
  "shares_diluted" BIGINT  -- Shares (Diluted),
  "net_income_starting_line" DOUBLE,
  "depreciation_amortization" DOUBLE  -- Depreciation \u0026 Amortization,
  "provision_for_loan_losses" DOUBLE,
  "non_cash_items" DOUBLE,
  "change_in_working_capital" DOUBLE,
  "net_cash_from_operating_activities" BIGINT,
  "change_in_fixed_assets_intangibles" DOUBLE  -- Change In Fixed Assets \u0026 Intangibles,
  "net_change_in_loans_interbank" DOUBLE  -- Net Change In Loans \u0026 Interbank,
  "net_cash_from_acquisitions_divestitures" DOUBLE  -- Net Cash From Acquisitions \u0026 Divestitures,
  "net_cash_from_investing_activities" BIGINT,
  "dividends_paid" DOUBLE,
  "cash_from_repayment_of_debt" DOUBLE  -- Cash From (Repayment Of) Debt,
  "cash_from_repurchase_of_equity" DOUBLE  -- Cash From (Repurchase Of) Equity,
  "net_cash_from_financing_activities" DOUBLE,
  "effect_of_foreign_exchange_rates" DOUBLE,
  "net_change_in_cash" BIGINT
);

Bank Income Statement

@kaggle.yash16jr_us_market_dataset.bank_income_statement
  • 296.63 kB
  • 3,124 rows
  • 22 columns
Loading...
CREATE TABLE bank_income_statement (
  "ticker" VARCHAR,
  "report_date" TIMESTAMP,
  "id" BIGINT,
  "currency" VARCHAR,
  "fiscal_year" BIGINT,
  "fiscal_period" VARCHAR,
  "publish_date" TIMESTAMP,
  "restated_date" TIMESTAMP,
  "shares_basic" BIGINT  -- Shares (Basic),
  "shares_diluted" BIGINT  -- Shares (Diluted),
  "revenue" DOUBLE,
  "provision_for_loan_losses" DOUBLE,
  "net_revenue_after_provisions" DOUBLE,
  "total_non_interest_expense" DOUBLE,
  "operating_income_loss" DOUBLE  -- Operating Income (Loss),
  "non_operating_income_loss" DOUBLE  -- Non-Operating Income (Loss),
  "pretax_income_loss" BIGINT  -- Pretax Income (Loss),
  "income_tax_expense_benefit_net" DOUBLE  -- Income Tax (Expense) Benefit, Net,
  "income_loss_from_continuing_operations" BIGINT  -- Income (Loss) From Continuing Operations,
  "net_extraordinary_gains_losses" DOUBLE  -- Net Extraordinary Gains (Losses),
  "net_income" BIGINT,
  "net_income_common" BIGINT  -- Net Income (Common)
);

Company Balance Sheet

@kaggle.yash16jr_us_market_dataset.company_balance_sheet
  • 8.65 MB
  • 57,613 rows
  • 30 columns
Loading...
CREATE TABLE company_balance_sheet (
  "ticker" VARCHAR,
  "report_date" TIMESTAMP,
  "id" BIGINT,
  "currency" VARCHAR,
  "fiscal_year" BIGINT,
  "fiscal_period" VARCHAR,
  "publish_date" TIMESTAMP,
  "restated_date" TIMESTAMP,
  "shares_basic" DOUBLE  -- Shares (Basic),
  "shares_diluted" DOUBLE  -- Shares (Diluted),
  "cash_cash_equivalents_short_term_investments" DOUBLE  -- Cash, Cash Equivalents \u0026 Short Term Investments,
  "accounts_notes_receivable" DOUBLE  -- Accounts \u0026 Notes Receivable,
  "inventories" DOUBLE,
  "total_current_assets" DOUBLE,
  "property_plant_equipment_net" DOUBLE  -- Property, Plant \u0026 Equipment, Net,
  "long_term_investments_receivables" DOUBLE  -- Long Term Investments \u0026 Receivables,
  "other_long_term_assets" DOUBLE,
  "total_noncurrent_assets" DOUBLE,
  "total_assets" BIGINT,
  "payables_accruals" DOUBLE  -- Payables \u0026 Accruals,
  "short_term_debt" DOUBLE,
  "total_current_liabilities" DOUBLE,
  "long_term_debt" DOUBLE,
  "total_noncurrent_liabilities" DOUBLE,
  "total_liabilities" DOUBLE,
  "share_capital_additional_paid_in_capital" DOUBLE  -- Share Capital \u0026 Additional Paid-In Capital,
  "treasury_stock" DOUBLE,
  "retained_earnings" DOUBLE,
  "total_equity" DOUBLE,
  "total_liabilities_equity" BIGINT  -- Total Liabilities \u0026 Equity
);

Company Cash Flow

@kaggle.yash16jr_us_market_dataset.company_cash_flow
  • 4.97 MB
  • 57,614 rows
  • 28 columns
Loading...
CREATE TABLE company_cash_flow (
  "ticker" VARCHAR,
  "report_date" TIMESTAMP,
  "id" BIGINT,
  "currency" VARCHAR,
  "fiscal_year" BIGINT,
  "fiscal_period" VARCHAR,
  "publish_date" TIMESTAMP,
  "restated_date" TIMESTAMP,
  "shares_basic" DOUBLE  -- Shares (Basic),
  "shares_diluted" DOUBLE  -- Shares (Diluted),
  "net_income_starting_line" DOUBLE,
  "depreciation_amortization" DOUBLE  -- Depreciation \u0026 Amortization,
  "non_cash_items" DOUBLE,
  "change_in_working_capital" DOUBLE,
  "change_in_accounts_receivable" DOUBLE,
  "change_in_inventories" DOUBLE,
  "change_in_accounts_payable" DOUBLE,
  "change_in_other" DOUBLE,
  "net_cash_from_operating_activities" DOUBLE,
  "change_in_fixed_assets_intangibles" DOUBLE  -- Change In Fixed Assets \u0026 Intangibles,
  "net_change_in_long_term_investment" DOUBLE,
  "net_cash_from_acquisitions_divestitures" DOUBLE  -- Net Cash From Acquisitions \u0026 Divestitures,
  "net_cash_from_investing_activities" DOUBLE,
  "dividends_paid" DOUBLE,
  "cash_from_repayment_of_debt" DOUBLE  -- Cash From (Repayment Of) Debt,
  "cash_from_repurchase_of_equity" DOUBLE  -- Cash From (Repurchase Of) Equity,
  "net_cash_from_financing_activities" DOUBLE,
  "net_change_in_cash" BIGINT
);

Company Income Statement

@kaggle.yash16jr_us_market_dataset.company_income_statement
  • 6.38 MB
  • 57,612 rows
  • 28 columns
Loading...
CREATE TABLE company_income_statement (
  "ticker" VARCHAR,
  "report_date" TIMESTAMP,
  "id" BIGINT,
  "currency" VARCHAR,
  "fiscal_year" BIGINT,
  "fiscal_period" VARCHAR,
  "publish_date" TIMESTAMP,
  "restated_date" TIMESTAMP,
  "shares_basic" DOUBLE  -- Shares (Basic),
  "shares_diluted" DOUBLE  -- Shares (Diluted),
  "revenue" DOUBLE,
  "cost_of_revenue" DOUBLE,
  "gross_profit" DOUBLE,
  "operating_expenses" DOUBLE,
  "selling_general_administrative" DOUBLE  -- Selling, General \u0026 Administrative,
  "research_development" DOUBLE  -- Research \u0026 Development,
  "depreciation_amortization" DOUBLE  -- Depreciation \u0026 Amortization,
  "operating_income_loss" DOUBLE  -- Operating Income (Loss),
  "non_operating_income_loss" DOUBLE  -- Non-Operating Income (Loss),
  "interest_expense_net" DOUBLE  -- Interest Expense, Net,
  "pretax_income_loss_adj" BIGINT  -- Pretax Income (Loss), Adj.,
  "abnormal_gains_losses" DOUBLE  -- Abnormal Gains (Losses),
  "pretax_income_loss" BIGINT  -- Pretax Income (Loss),
  "income_tax_expense_benefit_net" DOUBLE  -- Income Tax (Expense) Benefit, Net,
  "income_loss_from_continuing_operations" BIGINT  -- Income (Loss) From Continuing Operations,
  "net_extraordinary_gains_losses" DOUBLE  -- Net Extraordinary Gains (Losses),
  "net_income" BIGINT,
  "net_income_common" BIGINT  -- Net Income (Common)
);

Daily Share Prices

@kaggle.yash16jr_us_market_dataset.daily_share_prices
  • 80.27 MB
  • 4,720,666 rows
  • 11 columns
Loading...
CREATE TABLE daily_share_prices (
  "ticker" VARCHAR,
  "date" TIMESTAMP,
  "id" BIGINT,
  "open" DOUBLE,
  "low" DOUBLE,
  "high" DOUBLE,
  "close" DOUBLE,
  "adj_close" DOUBLE  -- Adj. Close,
  "dividend" DOUBLE,
  "volume" BIGINT,
  "shares_outstanding" DOUBLE
);

Industries

@kaggle.yash16jr_us_market_dataset.industries
  • 4.75 kB
  • 74 rows
  • 3 columns
Loading...
CREATE TABLE industries (
  "industryid" BIGINT,
  "sector" VARCHAR,
  "industry" VARCHAR
);

Insurance Balance Sheet

@kaggle.yash16jr_us_market_dataset.insurance_balance_sheet
  • 165.56 kB
  • 1,305 rows
  • 26 columns
Loading...
CREATE TABLE insurance_balance_sheet (
  "ticker" VARCHAR,
  "report_date" TIMESTAMP,
  "id" BIGINT,
  "currency" VARCHAR,
  "fiscal_year" BIGINT,
  "fiscal_period" VARCHAR,
  "publish_date" TIMESTAMP,
  "restated_date" TIMESTAMP,
  "shares_basic" BIGINT  -- Shares (Basic),
  "shares_diluted" BIGINT  -- Shares (Diluted),
  "total_investments" DOUBLE,
  "cash_cash_equivalents_short_term_investments" DOUBLE  -- Cash, Cash Equivalents \u0026 Short Term Investments,
  "accounts_notes_receivable" DOUBLE  -- Accounts \u0026 Notes Receivable,
  "property_plant_equipment_net" DOUBLE  -- Property, Plant \u0026 Equipment, Net,
  "total_assets" BIGINT,
  "insurance_reserves" DOUBLE,
  "short_term_debt" DOUBLE,
  "long_term_debt" DOUBLE,
  "total_liabilities" BIGINT,
  "preferred_equity" DOUBLE,
  "policyholders_equity" VARCHAR,
  "share_capital_additional_paid_in_capital" DOUBLE  -- Share Capital \u0026 Additional Paid-In Capital,
  "treasury_stock" DOUBLE,
  "retained_earnings" DOUBLE,
  "total_equity" BIGINT,
  "total_liabilities_equity" BIGINT  -- Total Liabilities \u0026 Equity
);

Insurance Cash Flow

@kaggle.yash16jr_us_market_dataset.insurance_cash_flow
  • 139.17 kB
  • 1,305 rows
  • 23 columns
Loading...
CREATE TABLE insurance_cash_flow (
  "ticker" VARCHAR,
  "report_date" TIMESTAMP,
  "id" BIGINT,
  "currency" VARCHAR,
  "fiscal_year" BIGINT,
  "fiscal_period" VARCHAR,
  "publish_date" TIMESTAMP,
  "restated_date" TIMESTAMP,
  "shares_basic" BIGINT  -- Shares (Basic),
  "shares_diluted" BIGINT  -- Shares (Diluted),
  "net_income_starting_line" DOUBLE,
  "depreciation_amortization" DOUBLE  -- Depreciation \u0026 Amortization,
  "non_cash_items" DOUBLE,
  "net_cash_from_operating_activities" BIGINT,
  "change_in_fixed_assets_intangibles" DOUBLE  -- Change In Fixed Assets \u0026 Intangibles,
  "net_change_in_investments" DOUBLE,
  "net_cash_from_investing_activities" BIGINT,
  "dividends_paid" DOUBLE,
  "cash_from_repayment_of_debt" DOUBLE  -- Cash From (Repayment Of) Debt,
  "cash_from_repurchase_of_equity" DOUBLE  -- Cash From (Repurchase Of) Equity,
  "net_cash_from_financing_activities" DOUBLE,
  "effect_of_foreign_exchange_rates" DOUBLE,
  "net_change_in_cash" BIGINT
);

Insurance Income Statement

@kaggle.yash16jr_us_market_dataset.insurance_income_statement
  • 118.48 kB
  • 1,305 rows
  • 20 columns
Loading...
CREATE TABLE insurance_income_statement (
  "ticker" VARCHAR,
  "report_date" TIMESTAMP,
  "id" BIGINT,
  "currency" VARCHAR,
  "fiscal_year" BIGINT,
  "fiscal_period" VARCHAR,
  "publish_date" TIMESTAMP,
  "restated_date" TIMESTAMP,
  "shares_basic" BIGINT  -- Shares (Basic),
  "shares_diluted" BIGINT  -- Shares (Diluted),
  "revenue" BIGINT,
  "total_claims_losses" DOUBLE  -- Total Claims \u0026 Losses,
  "operating_income_loss" BIGINT  -- Operating Income (Loss),
  "pretax_income_loss" BIGINT  -- Pretax Income (Loss),
  "income_tax_expense_benefit_net" DOUBLE  -- Income Tax (Expense) Benefit, Net,
  "income_loss_from_affiliates_net_of_taxes" DOUBLE  -- Income (Loss) From Affiliates, Net Of Taxes,
  "income_loss_from_continuing_operations" BIGINT  -- Income (Loss) From Continuing Operations,
  "net_extraordinary_gains_losses" DOUBLE  -- Net Extraordinary Gains (Losses),
  "net_income" BIGINT,
  "net_income_common" BIGINT  -- Net Income (Common)
);

Us Companies

@kaggle.yash16jr_us_market_dataset.us_companies
  • 147.53 kB
  • 4,829 rows
  • 4 columns
Loading...
CREATE TABLE us_companies (
  "ticker" VARCHAR,
  "id" BIGINT,
  "company_name" VARCHAR,
  "industryid" DOUBLE
);

Share link

Anyone who has the link will be able to view this.