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

CREATE TABLE IF NOT EXISTS `funds` (
  `ticker` VARCHAR(255) NOT NULL,
  `date` DATE NOT NULL,
  `open` DOUBLE,
  `high` DOUBLE,
  `low` DOUBLE,
  `close` DOUBLE,
  `volume` DOUBLE,
  `closeadj` DOUBLE,
  `closeunadj` DOUBLE,
  `lastupdated` DATE,
  PRIMARY KEY (`ticker`, `date`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

CREATE INDEX `funds_date_idx` ON `funds` (`date`);

CREATE INDEX `funds_lastupdated_idx` ON `funds` (`lastupdated`);