DM

Tables (6)

dividend_summary

  • id — SERIAL
  • symbol — VARCHAR(10)
  • dividend_yield — NUMERIC
  • payout_ratio — NUMERIC
  • annual_dividend — NUMERIC
  • created_at — TIMESTAMP

market_overview

  • id — SERIAL
  • symbol — VARCHAR(10)
  • market_cap — BIGINT
  • sector — VARCHAR(50)
  • industry — VARCHAR(50)
  • ranking_within_sector — INT
  • created_at — TIMESTAMP

performance_indicators

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

recent_annual_financials

  • id — SERIAL
  • symbol — VARCHAR(10)
  • year — INT
  • total_assets — NUMERIC
  • total_liabilities — NUMERIC
  • equity — NUMERIC
  • operating_cash_flow — NUMERIC
  • created_at — TIMESTAMP

recent_quarterly_financials

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

stock_price_trends

  • id — SERIAL
  • symbol — VARCHAR(10)
  • average_price — NUMERIC
  • max_price — NUMERIC
  • min_price — NUMERIC
  • volatility — NUMERIC
  • analysis_period — VARCHAR(20)
  • created_at — TIMESTAMP