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