Create_Price_History_Table.sql

CREATE TABLE IF NOT EXISTS `price_data_historical` (
`key_id` varchar(30) NOT NULL PRIMARY KEY,
`ticker` varchar(8) NOT NULL,
`figi` varchar(14) NOT NULL,
`date` datetime NOT NULL,
`open` float NULL,
`high` float NULL,
`low` float NULL,
`close` float NULL,
`volume` float NULL,
`adj_open` float NULL,
`adj_high` float NULL,
`adj_low` float NULL,
`adj_close` float NULL,
`adj_volume` float NULL,
`split_ratio` float NULL,
`adj_factor` float NULL,
`change` float NULL,
`percent_change` float NULL,
`fifty_two_week_high` float NULL,
`fifty_two_week_low` float NULL,
`market_cap` bigint NULL,
`weighted_avg_shares_out` bigint NULL,
`intraperiod` boolean NOT NULL DEFAULT 0,
`last_updated_date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
`last_corp_action_date` timestamp NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;