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

CREATE TABLE IF NOT EXISTS `holdings_ticker` (
  `date` VARCHAR(255) NOT NULL,
  `ticker` VARCHAR(255) NOT NULL,
  `name` VARCHAR(255),
  `shrholders` BIGINT,
  `cllholders` BIGINT,
  `putholders` BIGINT,
  `wntholders` BIGINT,
  `dbtholders` BIGINT,
  `prfholders` BIGINT,
  `fndholders` BIGINT,
  `undholders` BIGINT,
  `shrunits` DOUBLE,
  `cllunits` DOUBLE,
  `putunits` DOUBLE,
  `wntunits` DOUBLE,
  `dbtunits` DOUBLE,
  `prfunits` DOUBLE,
  `fndunits` DOUBLE,
  `undunits` DOUBLE,
  `shrvalue` DOUBLE,
  `cllvalue` DOUBLE,
  `putvalue` DOUBLE,
  `wntvalue` DOUBLE,
  `dbtvalue` DOUBLE,
  `prfvalue` DOUBLE,
  `fndvalue` DOUBLE,
  `undvalue` DOUBLE,
  `totalvalue` DOUBLE,
  `percentoftotal` DOUBLE,
  PRIMARY KEY (`date`, `ticker`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

CREATE INDEX `holdings_ticker_ticker_idx` ON `holdings_ticker` (`ticker`);