ETFs
Tables (12)
Asset (자산)
- TICKER — VARCHAR — Primary key — NOT NULL — AAPL, USD/KRW etc..
- NAME (이름) — VARCHAR
- AssetType (ENUM) — stock, crypto, gold, FOREX
- MarketCap (시가총액) — 제거가능
- additional_info (JSON) — platform, base currency etc..
Asset_Price (자산 가격)
- ID — Primary key — NOT NULL
- TICKER — Foreign key → Asset.TICKER — NOT NULL
- NAME (이름) — VARCHAR
- record_date (일자) — TIMESTAMP
- opening_price (시가) — BIGINT
- highest_price (고가) — BIGINT
- lowest_price (저가) — BIGINT
- closing_price (종가)
- trade_volume (거래량)
CRYPTO_PRICE
- ID — INT — Primary key — NOT NULL
- 종목명 (ticker) — VARCHAR(8) — NOT NULL
- 거래 날짜 (record_date) — TIMESTAMP — NOT NULL
- 플랫폼 (platform) — VARCHAR(20) — NOT NULL — upbit, binance, yfinance
- 시작가 (opening_price) — DECIMAL(10, 2) — NOT NULL
- 최고가 (highest_price) — DECIMAL(10, 2) — NOT NULL
- 최저가 (lowest_price) — DECIMAL(10, 2) — NOT NULL
- 종가 (closing_price) — DECIMAL(10, 2) — NOT NULL
- 거래량 (trade_volume) — BIGINT — NOT NULL
- 생성일 (created_at) — TIMESTAMP
ETF (지수 정보)
- ID — INT — Primary key — NOT NULL
- NAME (이름) — VARCHAR — NOT NULL — QQQ, S&P 500
ETF
- ID — INT — Primary key — NOT NULL — NAME으로 대체 가능
- NAME (이름) — VARCHAR — NOT NULL — QQQ, S&P 500
FOREX
- ID — INT — Primary key — NOT NULL
- Base_Currency (기준 통화) — VARCHAR — KRW
- Target_Currency (대상 통화) — VARCHAR — USD, EUR
- Exchange_Rate (기준 통화 대비 환율) — DECIMAL — 종가
- rate_date (환율이 적용된 날짜)
- highest_exchange_rate (Field) — 고가
- lowest_exchange_rate (Field2)
GOLD (CopyOfCrypto)
- TICKER — VARCHAR — Primary key — NOT NULL — AAPL, USD/KRW etc..
- Platform (VARCHAR) — Bianace, upbit, yfinance
- asset_type (자산 타입) — 현물, 선물
GOLD_PRICE
- ID — Primary key — NOT NULL
- TICKER — VARCHAR — Foreign key → GOLD.TICKER — NOT NULL — AAPL, USD/KRW etc..
- record_date (일자) — TIMESTAMP
- opening_price (시가) — BIGINT
- highest_price (고가) — BIGINT
- lowest_price (저가) — BIGINT
- closing_price (종가)
- trade_volume (거래량)
Sector
- ID — INT — Primary key — NOT NULL
- ETF_ID — INT — Foreign key → ETF.ID — NOT NULL
- TICKER — VARCHAR — Foreign key → Stock.TICKER — NOT NULL — AAPL, USD/KRW etc..
- NAME (섹터명) — VARCHAR — NOT NULL — Communcation Service, ...
- Weight (Field)
Stock (주식 종목)
- TICKER — VARCHAR — Primary key — NOT NULL — AAPL, USD/KRW etc..
- company_name (VARCHAR) — 제거가능
- MarketCap (시가총액) — 제거가능
Stock Price
- ID — Primary key — NOT NULL
- TICKER — VARCHAR — Foreign key → Stock.TICKER — NOT NULL — AAPL, GOOGL
- record_date (일자) — TIMESTAMP
- opening_price (시가) — BIGINT
- highest_price (고가) — BIGINT
- lowest_price (저가) — BIGINT
- closing_price (종가)
- trade_volume (거래량)
sector (섹터)
- ID — INT — Primary key — NOT NULL
- ETF_ID — INT — Foreign key → ETF.ID — NOT NULL
- TICKER — VARCHAR — Foreign key → Asset.TICKER — NOT NULL — AAPL, USD/KRW etc..
- NAME (섹터명) — VARCHAR — NOT NULL — Communcation Service, ...