US Market Data

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_diluted" BIGINT,
  "cash_cash_equivalents_short_term_investments" DOUBLE,
  "interbank_assets" DOUBLE,
  "short_long_term_investments" DOUBLE,
  "accounts_notes_receivable" DOUBLE,
  "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,
  "treasury_stock" DOUBLE,
  "retained_earnings" DOUBLE,
  "total_equity" BIGINT,
  "total_liabilities_equity" BIGINT
);

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_diluted" BIGINT,
  "net_income_starting_line" DOUBLE,
  "depreciation_amortization" DOUBLE,
  "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,
  "net_change_in_loans_interbank" DOUBLE,
  "net_cash_from_acquisitions_divestitures" DOUBLE,
  "net_cash_from_investing_activities" BIGINT,
  "dividends_paid" DOUBLE,
  "cash_from_repayment_of_debt" DOUBLE,
  "cash_from_repurchase_of_equity" DOUBLE,
  "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_diluted" BIGINT,
  "revenue" DOUBLE,
  "provision_for_loan_losses" DOUBLE,
  "net_revenue_after_provisions" DOUBLE,
  "total_non_interest_expense" DOUBLE,
  "operating_income_loss" DOUBLE,
  "non_operating_income_loss" DOUBLE,
  "pretax_income_loss" BIGINT,
  "income_tax_expense_benefit_net" DOUBLE,
  "income_loss_from_continuing_operations" BIGINT,
  "net_extraordinary_gains_losses" DOUBLE,
  "net_income" BIGINT,
  "net_income_common" BIGINT
);

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_diluted" DOUBLE,
  "cash_cash_equivalents_short_term_investments" DOUBLE,
  "accounts_notes_receivable" DOUBLE,
  "inventories" DOUBLE,
  "total_current_assets" DOUBLE,
  "property_plant_equipment_net" DOUBLE,
  "long_term_investments_receivables" DOUBLE,
  "other_long_term_assets" DOUBLE,
  "total_noncurrent_assets" DOUBLE,
  "total_assets" BIGINT,
  "payables_accruals" DOUBLE,
  "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,
  "treasury_stock" DOUBLE,
  "retained_earnings" DOUBLE,
  "total_equity" DOUBLE,
  "total_liabilities_equity" BIGINT
);

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_diluted" DOUBLE,
  "net_income_starting_line" DOUBLE,
  "depreciation_amortization" DOUBLE,
  "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,
  "net_change_in_long_term_investment" DOUBLE,
  "net_cash_from_acquisitions_divestitures" DOUBLE,
  "net_cash_from_investing_activities" DOUBLE,
  "dividends_paid" DOUBLE,
  "cash_from_repayment_of_debt" DOUBLE,
  "cash_from_repurchase_of_equity" DOUBLE,
  "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_diluted" DOUBLE,
  "revenue" DOUBLE,
  "cost_of_revenue" DOUBLE,
  "gross_profit" DOUBLE,
  "operating_expenses" DOUBLE,
  "selling_general_administrative" DOUBLE,
  "research_development" DOUBLE,
  "depreciation_amortization" DOUBLE,
  "operating_income_loss" DOUBLE,
  "non_operating_income_loss" DOUBLE,
  "interest_expense_net" DOUBLE,
  "pretax_income_loss_adj" BIGINT,
  "abnormal_gains_losses" DOUBLE,
  "pretax_income_loss" BIGINT,
  "income_tax_expense_benefit_net" DOUBLE,
  "income_loss_from_continuing_operations" BIGINT,
  "net_extraordinary_gains_losses" DOUBLE,
  "net_income" BIGINT,
  "net_income_common" BIGINT
);

CREATE TABLE daily_share_prices (
  "ticker" VARCHAR,
  "date" TIMESTAMP,
  "id" BIGINT,
  "open" DOUBLE,
  "low" DOUBLE,
  "high" DOUBLE,
  "close" DOUBLE,
  "adj_close" DOUBLE,
  "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_diluted" BIGINT,
  "total_investments" DOUBLE,
  "cash_cash_equivalents_short_term_investments" DOUBLE,
  "accounts_notes_receivable" DOUBLE,
  "property_plant_equipment_net" DOUBLE,
  "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,
  "treasury_stock" DOUBLE,
  "retained_earnings" DOUBLE,
  "total_equity" BIGINT,
  "total_liabilities_equity" BIGINT
);

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_diluted" BIGINT,
  "net_income_starting_line" DOUBLE,
  "depreciation_amortization" DOUBLE,
  "non_cash_items" DOUBLE,
  "net_cash_from_operating_activities" BIGINT,
  "change_in_fixed_assets_intangibles" DOUBLE,
  "net_change_in_investments" DOUBLE,
  "net_cash_from_investing_activities" BIGINT,
  "dividends_paid" DOUBLE,
  "cash_from_repayment_of_debt" DOUBLE,
  "cash_from_repurchase_of_equity" DOUBLE,
  "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_diluted" BIGINT,
  "revenue" BIGINT,
  "total_claims_losses" DOUBLE,
  "operating_income_loss" BIGINT,
  "pretax_income_loss" BIGINT,
  "income_tax_expense_benefit_net" DOUBLE,
  "income_loss_from_affiliates_net_of_taxes" DOUBLE,
  "income_loss_from_continuing_operations" BIGINT,
  "net_extraordinary_gains_losses" DOUBLE,
  "net_income" BIGINT,
  "net_income_common" BIGINT
);

CREATE TABLE us_companies (
  "ticker" VARCHAR,
  "id" BIGINT,
  "company_name" VARCHAR,
  "industryid" DOUBLE
);