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