DW

Tables (6)

company_key_metrics

  • id — SERIAL
  • symbol — VARCHAR(10)
  • date — DATE
  • roe — NUMERIC
  • roa — NUMERIC
  • debt_to_equity — NUMERIC
  • profitability_index — NUMERIC
  • created_at — TIMESTAMP

company_profiles

  • id — SERIAL
  • symbol — VARCHAR(10)
  • company_name — VARCHAR(255)
  • sector — VARCHAR(50)
  • industry — VARCHAR(50)
  • ceo — VARCHAR(100)
  • description — TEXT
  • created_at — TIMESTAMP

dividend_metrics

  • id — SERIAL
  • symbol — VARCHAR(10)
  • date — DATE
  • dividend_yield_ttm — NUMERIC
  • payout_ratio_ttm — NUMERIC
  • annual_dividend — NUMERIC
  • dividend_frequency — VARCHAR(10)
  • created_at — TIMESTAMP

market_price_cap_data

  • id — SERIAL
  • symbol — VARCHAR(10)
  • date — DATE
  • close_price — NUMERIC
  • high_price — NUMERIC
  • low_price — NUMERIC
  • volume — BIGINT
  • market_cap — BIGINT
  • created_at — TIMESTAMP

recent_5qs_financial_data

  • id — SERIAL
  • symbol — VARCHAR(10)
  • quarter — VARCHAR(10)
  • revenue — NUMERIC
  • net_income — NUMERIC
  • eps — NUMERIC
  • total_assets — NUMERIC
  • total_liabilities — NUMERIC
  • operating_cash_flow — NUMERIC
  • free_cash_flow — NUMERIC
  • created_at — TIMESTAMP

recent_5ys_financial_data

  • id — SERIAL
  • symbol — VARCHAR(10)
  • year — INT
  • revenue — NUMERIC
  • net_income — NUMERIC
  • eps — NUMERIC
  • total_assets — NUMERIC
  • total_liabilities — NUMERIC
  • operating_cash_flow — NUMERIC
  • free_cash_flow — NUMERIC
  • created_at — TIMESTAMP