CoinMarket_Normalization

Tables (4)

candle

  • candle_id — bigint — Primary key — NOT NULL
  • market_code — varchar(20) — Foreign key → market.market_code — NOT NULL
  • unit_code — varchar(10) — Foreign key → candle_unit.unit_code — NOT NULL
  • candle_time — datetime — NOT NULL — 캔들 기준 시각(KST)
  • opening_price — decimal(20, 8) — NOT NULL — 시가
  • high_price — decimal(20, 8) — NOT NULL — 고가
  • low_price — decimal(20, 8) — NOT NULL — 저가
  • trade_price — decimal(20, 8) — NOT NULL — 종가
  • candle_acc_volume — decimal(30, 8) — NOT NULL — 누적 거래량

candle_unit

  • unit_code — varchar(10) — Primary key — NOT NULL — 1m, 5m, 15m, 1h, 1d
  • description — varchar(30) — NOT NULL — 1분봉, 5분봉, 일봉
  • seconds — int — NOT NULL — 단위 환산 초 (60, 300, 86400)

market

  • market_code — varchar(20) — Primary key — NOT NULL — 예: KRW-BTC
  • korean_name — varchar(50) — NOT NULL — 비트코인
  • english_name — varchar(50) — NOT NULL — Bitcoin
  • market_warning — varchar(10) — 유의종목 여부 NONE/CAUTION
  • created_at — datetime
  • updated_at — datetime

ticker_snapshot

  • market_code — varchar(20) — Foreign key → market.market_code — NOT NULL — PK이자 FK (1:1)
  • trade_price — decimal(20, 8) — NOT NULL — 현재가
  • change — varchar(10) — RISE/EVEN/FALL
  • acc_trade_volume_24h — decimal(30, 8) — 24시간 누적 거래량
  • acc_trade_price_24h — decimal(30, 4) — 24시간 누적 거래대금
  • high_price_52w — decimal(20, 8) — 52주 최고가
  • low_price_52w — decimal(20, 8) — 52주 최저가
  • timestamp — bigint — 업비트 타임스탬프(ms)
  • updated_at — datetime