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