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, ...