Quantest

테이블 (6)

시고저종거래량 (ohlcv)

  • 날짜 (bar_date) — DATE — 기본 키 — NOT NULL
  • 종목 고유 ID (id) — int — 외래 키 → 주식종목 정보.종목 고유 ID — NOT NULL — increment
  • 시가 (open) — int
  • 고가 (high) — int
  • 저가 (low) — int
  • 종가 (close) — int
  • 거래량 (volume) — bigint

업종 (sectors)

  • 업종고유id (id) — int — 기본 키 — NOT NULL — increment
  • 업종 이름 (name) — TEXT — NOT NULL

주식종목 정보 (stocks)

  • 종목 고유 ID (id) — int — 기본 키 — NOT NULL — increment
  • 티커 심볼 (ticker) — VARCHAR(10) — NOT NULL — unique
  • 종목 이름 (name) — TEXT
  • 업종고유id (sectors_id) — int — 외래 키 → 업종.업종고유id — NOT NULL — increment

지표 (daily_indicators)

  • 날짜 (bar_date) — DATE — 외래 키 → 시고저종거래량.날짜 — NOT NULL
  • 종목 고유 ID (id) — int — 외래 키 → 시고저종거래량.종목 고유 ID — NOT NULL — increment
  • 가격& BOX차트 (price_box_chart) — DOUBLE PRECISION
  • 고저이동평균 (high_low_moving_average) — double
  • 그물망차트 (moving_average_ribbon) — double
  • 대표값(Typical Price) (typical_price) — double
  • 중간값(Median Price) (median_price) — double
  • 이동평균(라인1개) (ma_line_1) — double
  • 이동평균(라인3개) (ma_line_3) — double
  • 이동평균(수평이동) (ma_horizontal) — double
  • 이동평균채널 (ma_channel) — double
  • 일목균형표 (ichi_moky_kinkou_hyo) — double
  • 표준오차밴드 (standard_error_band) — double
  • Alligator (alligator) — double
  • Bollinger Band (bollinger_band) — double
  • DEMA (dema) — double
  • DEMA(simple) (dema_simple) — double
  • Demark (demark) — double
  • Envelope (envelope) — double
  • Heikin-Ashi (heikin_ashi) — double
  • Keltner Channels (keltner_channels) — double
  • LRI (lri) — double
  • McGinley Dynamic (mcginley_dynamic) — double
  • Parabolic SAR (parabolic_sar) — double
  • Percent Channel(분/틱용) (percent_channel) — double
  • Pivot Lines (pivot_lines) — double
  • Price Channel (price_channel) — double
  • Projection Bands (projection_bands) — double
  • Starc Bands (starc_bands) — double
  • TEMA (tema) — double
  • TEMA(simple) (tema_simple) — double
  • Tirone Level (tirone_level) — double
  • VIDYA (vidya) — double
  • VWMA (vwma) — double
  • Weighted Close (weighted_close) — double
  • ZigZag (zigzag) — double
  • Golden Power (golden_power) — double
  • Net Power (net_power) — double
  • Net Power(4개) (net_power_4) — double
  • Trend Power (trend_power) — double
  • Trend Power Buy (trend_power_buy) — double
  • Trend Power Sell (trend_power_sell) — double
  • Binary Wave MACD (binary_wave_macd) — double
  • BPDL Hilo Index (bpdl_hilo_index) — double
  • BPDL Short Trend (bpdl_short_trend) — double
  • BPDL Trend Filter (bpdl_trend_filter) — double
  • CCI (cci) — double
  • Elder-Ray (elder_ray) — double
  • MACD (macd) — double
  • MACD(DEMA) (macd_dema) — double
  • MACD(TEMA) (macd_tema) — double
  • MACD Oscillator (macd_oscillator) — double — 기존 계산과 중복(MACD_Hist)
  • MAO (mao) — double
  • McCellan Oscillator (mccellan_oscillator) — double
  • McCellan Summation (mccellan_summation) — double
  • Momentum (momentum) — double
  • North Price Action Line (north_price_action_line) — double
  • On Balance Price (on_balance_price) — double
  • Price Change Line (price_change_line) — double
  • Price ROC (price_roc) — double
  • … +103

패턴 기록 및 상승/하락 확률 (pattern_records)

  • 날짜 (bar_date) — DATE — 외래 키 → 시고저종거래량.날짜 — NOT NULL
  • 종목 고유 ID (id2) — int — 외래 키 → 시고저종거래량.종목 고유 ID — NOT NULL — increment
  • 패턴 고유 ID (pattern_id) — int — 외래 키 → 패턴 정보.패턴 고유 ID — NOT NULL — increment
  • 방향 따른 확률 (confidence) — numeric

패턴 정보 (patterns)

  • 패턴 고유 ID (id) — int — 기본 키 — NOT NULL — increment
  • 패턴 이름 (name) — varchar(10) — NOT NULL — unique
  • 방향 (direction) — char(1) — NOT NULL — 'U', 'D'