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

CREATE TABLE IF NOT EXISTS `holdings_investor` (
  `date` VARCHAR(255) NOT NULL,
  `investorname` VARCHAR(255) NOT NULL,
  `shrholdings` BIGINT,
  `cllholdings` BIGINT,
  `putholdings` BIGINT,
  `wntholdings` BIGINT,
  `dbtholdings` BIGINT,
  `prfholdings` BIGINT,
  `fndholdings` BIGINT,
  `undholdings` 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`, `investorname`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

CREATE INDEX `holdings_investor_investorname_idx` ON `holdings_investor` (`investorname`);