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