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

CREATE TABLE IF NOT EXISTS `daily` (
  `ticker` VARCHAR(255) NOT NULL,
  `date` DATE NOT NULL,
  `lastupdated` DATE,
  `ev` DOUBLE,
  `evebit` DOUBLE,
  `evebitda` DOUBLE,
  `marketcap` DOUBLE,
  `pb` DOUBLE,
  `pe` DOUBLE,
  `ps` DOUBLE,
  PRIMARY KEY (`ticker`, `date`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

CREATE INDEX `daily_date_idx` ON `daily` (`date`);

CREATE INDEX `daily_lastupdated_idx` ON `daily` (`lastupdated`);