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'