US Market Data
Dataset of USA companies.
@kaggle.yash16jr_us_market_dataset
Dataset of USA companies.
@kaggle.yash16jr_us_market_dataset
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
);
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
);
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)
);
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
);
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
);
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)
);
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
);
CREATE TABLE industries (
"industryid" BIGINT,
"sector" VARCHAR,
"industry" VARCHAR
);
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
);
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
);
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)
);
CREATE TABLE us_companies (
"ticker" VARCHAR,
"id" BIGINT,
"company_name" VARCHAR,
"industryid" DOUBLE
);
Anyone who has the link will be able to view this.