recsys04-price
테이블 (3)
예측 가격 (pred_prices)
- result_id (id) — INT — 기본 키 — NOT NULL
- pred_date — TIMESTAMP — NOT NULL
- price — DECIMAL(18, 4) — NOT NULL
- feature_ID (feature_id) — INT — 외래 키 → 예측 피쳐.feature_ID — NOT NULL
예측 피쳐 (stock_features)
- feature_ID (id) — INT — 기본 키 — NOT NULL
- 기준일 (base_date) — TIMESTAMP — NOT NULL
- open — DECIMAL(18, 4) — NOT NULL
- close — DECIMAL(18, 4) — NOT NULL
- high — DECIMAL(18, 4) — NOT NULL
- low — DECIMAL(18, 4) — NOT NULL
- ema — DECIMAL(18, 4) — NOT NULL
- volume — DECIMAL(20, 2) — NOT NULL
- wti_close — DECIMAL(18, 4) — NOT NULL
- usdidx_close — DECIMAL(18, 4) — NOT NULL
- rsi — DECIMAL(10, 6) — NOT NULL
- stoch_k — DECIMAL(10, 6) — NOT NULL
- stoch_d — DECIMAL(10, 6) — NOT NULL
- macd — DECIMAL(15, 6) — NOT NULL
- macd_signal — DECIMAL(15, 6) — NOT NULL
- macd_hist — DECIMAL(15, 6) — NOT NULL
- bollinger_pctb — DECIMAL(10, 6) — NOT NULL
- obv — DECIMAL(20, 2) — NOT NULL
- log_return — DECIMAL(10, 6) — NOT NULL
- 생성일 (created_at) — TIMESTAMP — NOT NULL
- 업데이트일 (updated_at) — TIMESTAMP
- 상태 (status) — TINYINT
- stock_ID (stock_id) — INT — 외래 키 → 종목.stock_ID — NOT NULL
종목 (stocks)
- stock_ID (id) — INT — 기본 키 — NOT NULL
- 종목이름 (name) — NOT NULL
- 생성일 (created_at) — TIMESTAMP — NOT NULL
- 업데이트일 (updated_at) — TIMESTAMP
- 상태 (status) — TINYINT