AI
Tables (5)
company_fundamentals
- ticker — VARCHAR(10) — Foreign key → price_data.ticker — NOT NULL
- date — DATE — Foreign key → price_data.date — NOT NULL
- revenue — NUMERIC(18,6)
- net_income — NUMERIC(18,6)
- total_assets — NUMERIC(18,6)
- total_liabilities — NUMERIC(18,6)
- equity — NUMERIC(18,6)
- EPS — NUMERIC(18,6)
- PE_ratio — NUMERIC(18,6)
macroeconomic_indicators
- date (date2) — DATE — Foreign key → price_data.date — NOT NULL
- cpi — NUMERIC(18,2)
- gdp — NUMERIC(18,2)
- ppi — NUMERIC(18,2)
- jolt — NUMERIC(18,2)
- cci — NUMERIC(18,2)
- interest_rate — NUMERIC(18,2)
- trade_balance — NUMERIC(18,2)
price_data
- ticker — VARCHAR(10) — Primary key — NOT NULL
- date — DATE — Primary key — NOT NULL
- open — NUMERIC(18,6)
- high — NUMERIC(18,6)
- low — NUMERIC(18,6)
- close — NUMERIC(18,6)
- volume — BIGINT
- adjusted_close — NUMERIC(18,6)
- market_type — VARCHAR(50)
short_interest
- ticker — VARCHAR(10) — Foreign key → price_data.ticker — NOT NULL
- date — DATE — Foreign key → price_data.date — NOT NULL
- short_interest — DOUBLE
- short_volume — BIGINT
technical_indicators
- ticker — VARCHAR(10) — Foreign key → price_data.ticker — NOT NULL
- date — DATE — Foreign key → price_data.date — NOT NULL
- RSI — NUMERIC(18,6)
- MACD — NUMERIC(18,6)
- Bollinger_Bands_upper — NUMERIC(18,6)
- Bollinger_Bands_lower — NUMERIC(18,6)
- ATR — NUMERIC(18,6)
- OBV — NUMERIC(18,6)
- Stochastic — NUMERIC(18,6)
- MFI — NUMERIC(18,6)
- MA_5 — NUMERIC(18,6)
- MA_20 — NUMERIC(18,6)
- MA_50 — NUMERIC(18,6)
- MA_200 — NUMERIC(18,6)