stock-django

Tables (3)

registered_stock

  • stk_id — varchar(50) — Foreign key → stock_info.stk_id=symbol — NOT NULL
  • end_date — datetime
  • end_price — double
  • start_date — datetime

stock_info

  • stk_id=symbol (stk_id) — varchar(50) — Primary key — NOT NULL
  • stk_name=shortName (stk_name) — varchar(50)
  • address1 — varchar(50)
  • address2 — varchar(50)
  • city — varchar(50)
  • zip — varchar(50)
  • country — varchar(30)
  • phone — varchar(30)
  • fax — varchar(30)
  • website — varchar(50)
  • industry — varchar(30)
  • sector — varchar(30)
  • bs_summary — varchar(1000)
  • payoutRatio — double
  • regularMarketVolume — int
  • averageVolume — int
  • marketCap — bigint
  • currency — varchar(20)
  • enterpriseValue — bigint
  • forwardPE — double
  • profitMargins — double
  • floatShares — bigint
  • earningsQuarterlyGrowth — double
  • pegRatio — double
  • enterpriseToRevenue — double
  • enterpriseToEbitda — double
  • symbol — varchar(30)
  • shortName — varcahr(30)
  • longName — varchar(50)
  • timeZoneFullName — varchar(30)
  • timeZoneShortName — varchar(20)
  • uuid — varchar(50)
  • recommendationKey — varchar(20)
  • totalCash — bigint
  • totalCashPerShare — double
  • ebitda — bigint
  • totalDebt — bigint
  • quickRatio — double
  • currentRatio — double
  • totalRevenue — bigint
  • debtToEquity — double
  • revenuePerShare — double
  • returnOnAssets — double
  • returnOnEquity — double
  • grossProfits — bigint
  • freeCashflow — double
  • operatingCashflow — bigint
  • earningsGrowth — double
  • revenueGrowth — double
  • grossMargins — double
  • ebitdaMargins — double
  • operatingMargins — double
  • financialCurrency — varchar(10

stock_report

  • report_id — int — Primary key — NOT NULL
  • stk_id=symbol (stk_id) — varchar(50) — Foreign key → stock_info.stk_id=symbol — NOT NULL
  • report_date — datetime
  • personal_comment — varchar(1000)
  • end_date — datetime
  • start_date — datetime