woori_test
Tables (15)
balance_sheet_raw
- id — SERIAL
- symbol — VARCHAR(10)
- date — DATE
- raw_json — JSONB
- created_at — TIMESTAMP
cash_flow_raw
- id — SERIAL
- symbol — VARCHAR(10)
- date — DATE
- raw_json — JSONB
- created_at — TIMESTAMP
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_profile_raw
- id — SERIAL
- symbol — VARCHAR(10)
- raw_json — JSONB
- 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
dividends_raw
- id — SERIAL
- symbol — VARCHAR(10)
- date — DATE
- dividend — NUMERIC
- frequency — VARCHAR(10)
- raw_json — JSONB
- created_at — TIMESTAMP
financial_ratios_raw
- id — SERIAL
- symbol — VARCHAR(10)
- date — DATE
- raw_json — JSONB
- created_at — TIMESTAMP
income_statement_raw
- id — SERIAL
- symbol — VARCHAR(10)
- date — DATE
- raw_json — JSONB
- created_at — TIMESTAMP
key_metrics_raw
- id — SERIAL
- symbol — VARCHAR(10)
- date — DATE
- raw_json — JSONB
- created_at — TIMESTAMP
market_cap_raw
- id — SERIAL
- symbol — VARCHAR(10)
- date — DATE
- market_cap — BIGINT
- raw_json — JSONB
- 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
stock_price_raw
- id — SERIAL
- symbol — VARCHAR(10)
- date — DATE
- raw_json — JSONB
- created_at — TIMESTAMP