-- Sharadar table schema: metrics (MySQL)
-- As of 2026-08-02
-- https://api.sharadar.com/v1.0/schema/metrics?format=mysql

CREATE TABLE IF NOT EXISTS `metrics` (
  `ticker` VARCHAR(255) NOT NULL,
  `date` DATE NOT NULL,
  `lastupdated` DATE,
  `beta1y` DOUBLE,
  `beta5y` DOUBLE,
  `dividendyieldforward` DOUBLE,
  `dividendyieldtrailing` DOUBLE,
  `high52w` DOUBLE,
  `high5y` DOUBLE,
  `low52w` DOUBLE,
  `low5y` DOUBLE,
  `ma200d` DOUBLE,
  `ma200w` DOUBLE,
  `ma50d` DOUBLE,
  `ma50w` DOUBLE,
  `price` DOUBLE,
  `return1y` DOUBLE,
  `return5y` DOUBLE,
  `returnytd` DOUBLE,
  `volume` BIGINT,
  `volumeavg1m` BIGINT,
  `volumeavg3m` BIGINT,
  PRIMARY KEY (`ticker`, `date`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

CREATE INDEX `metrics_date_idx` ON `metrics` (`date`);

CREATE INDEX `metrics_lastupdated_idx` ON `metrics` (`lastupdated`);