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