text: DROP TABLE IF EXISTS `USDCAD_D1`;
  CREATE TABLE IF NOT EXISTS `USDCAD_D1`(
  `id` int(5) NOT NULL,
  `corner` varchar(15) NOT NULL,
  `time` varchar(30) NOT NULL);
  ALTER TABLE `USDCAD_D1` ADD PRIMARY KEY (`id`);
  ALTER TABLE `USDCAD_D1` MODIFY `id` int(5) NOT NULL AUTO_INCREMENT;
  INSERT INTO `USDCAD_D1` (`corner`,`time`) VALUES('0.00000000','2015.10.27 00:00');
  INSERT INTO `USDCAD_D1` (`corner`,`time`) VALUES('0.00000000','2015.10.26 00:00');
  INSERT INTO `USDCAD_D1` (`corner`,`time`) VALUES('0.00000000','2015.10.23 00:00');
  INSERT INTO `USDCAD_D1` (`corner`,`time`) VALUES('0.00000000','2015.10.22 00:00');
  INSERT INTO `USDCAD_D1` (`corner`,`time`) VALUES('0.00000000','2015.10.21 00:00');
  INSERT INTO `USDCAD_D1` (`corner`,`time`) VALUES('0.00000000','2015.10.20 00:00');
  INSERT INTO `USDCAD_D1` (`corner`,`time`) VALUES('0.00000000','2015.10.19 00:00');
  INSERT INTO `USDCAD_D1` (`corner`,`time`) VALUES('0.00000000','2015.10.16 00:00');
  INSERT INTO `USDCAD_D1` (`corner`,`time`) VALUES('1.28308000','2015.10.15 00:00');
  INSERT INTO `USDCAD_D1` (`corner`,`time`) VALUES('0.00000000','2015.10.14 00:00');
  INSERT INTO `USDCAD_D1` (`corner`,`time`) VALUES('0.00000000','2015.10.13 00:00');
  INSERT INTO `USDCAD_D1` (`corner`,`time`) VALUES('0.00000000','2015.10.12 00:00');
  INSERT INTO `USDCAD_D1` (`corner`,`time`) VALUES('0.00000000','2015.10.09 00:00');
  INSERT INTO `USDCAD_D1` (`corner`,`time`) VALUES('0.00000000','2015.10.08 00:00');
  INSERT INTO `USDCAD_D1` (`corner`,`time`) VALUES('0.00000000','2015.10.07 00:00');
  INSERT INTO `USDCAD_D1` (`corner`,`time`) VALUES('0.00000000','2015.10.06 00:00');
  INSERT INTO `USDCAD_D1` (`corner`,`time`) VALUES('0.00000000','2015.10.05 00:00');
  INSERT INTO `USDCAD_D1` (`corner`,`time`) VALUES('0.00000000','2015.10.02 00:00');
  INSERT INTO `USDCAD_D1` (`corner`,`time`) VALUES('0.00000000','2015.10.01 00:00');
  INSERT INTO `USDCAD_D1` (`corner`,`time`) VALUES('0.00000000','2015.09.30 00:00');
  INSERT INTO `USDCAD_D1` (`corner`,`time`) VALUES('1.34560000','2015.09.29 00:00');
  INSERT INTO `USDCAD_D1` (`corner`,`time`) VALUES('0.00000000','2015.09.28 00:00');
  INSERT INTO `USDCAD_D1` (`corner`,`time`) VALUES('0.00000000','2015.09.25 00:00');
  INSERT INTO `USDCAD_D1` (`corner`,`time`) VALUES('0.00000000','2015.09.24 00:00');
  INSERT INTO `USDCAD_D1` (`corner`,`time`) VALUES('0.00000000','2015.09.23 00:00');
  INSERT INTO `USDCAD_D1` (`corner`,`time`) VALUES('0.00000000','2015.09.22 00:00');
  INSERT INTO `USDCAD_D1` (`corner`,`time`) VALUES('0.00000000','2015.09.21 00:00');
  INSERT INTO `USDCAD_D1` (`corner`,`time`) VALUES('1.30113000','2015.09.18 00:00');
  INSERT INTO `USDCAD_D1` (`corner`,`time`) VALUES('0.00000000','2015.09.17 00:00');
  INSERT INTO `USDCAD_D1` (`corner`,`time`) VALUES('0.00000000','2015.09.16 00:00');
  INSERT INTO `USDCAD_D1` (`corner`,`time`) VALUES('0.00000000','2015.09.15 00:00');
  INSERT INTO `USDCAD_D1` (`corner`,`time`) VALUES('0.00000000','2015.09.14 00:00');
  INSERT INTO `USDCAD_D1` (`corner`,`time`) VALUES('0.00000000','2015.09.11 00:00');
  INSERT INTO `USDCAD_D1` (`corner`,`time`) VALUES('0.00000000','2015.09.10 00:00');
  INSERT INTO `USDCAD_D1` (`corner`,`time`) VALUES('0.00000000','2015.09.09 00:00');
  INSERT INTO `USDCAD_D1` (`corner`,`time`) VALUES('0.00000000','2015.09.08 00:00');
  INSERT INTO `USDCAD_D1` (`corner`,`time`) VALUES('0.00000000','2015.09.07 00:00');
  INSERT INTO `USDCAD_D1` (`corner`,`time`) VALUES('0.00000000','2015.09.04 00:00');
  INSERT INTO `USDCAD_D1` (`corner`,`time`) VALUES('0.00000000','2015.09.03 00:00');
  INSERT INTO `USDCAD_D1` (`corner`,`time`) VALUES('0.00000000','2015.09.02 00:00');
  INSERT INTO `USDCAD_D1` (`corner`,`time`) VALUES('0.00000000','2015.09.01 00:00');
  INSERT INTO `USDCAD_D1` (`corner`,`time`) VALUES('0.00000000','2015.08.31 00:00');
  INSERT INTO `USDCAD_D1` (`corner`,`time`) VALUES('0.00000000','2015.08.28 00:00');
  INSERT INTO `USDCAD_D1` (`corner`,`time`) VALUES('0.00000000','2015.08.27 00:00');
  INSERT INTO `USDCAD_D1` (`corner`,`time`) VALUES('0.00000000','2015.08.26 00:00');
  INSERT INTO `USDCAD_D1` (`corner`,`time`) VALUES('1.33530000','2015.08.25 00:00');
  INSERT INTO `USDCAD_D1` (`corner`,`time`) VALUES('0.00000000','2015.08.24 00:00');
  INSERT INTO `USDCAD_D1` (`corner`,`time`) VALUES('0.00000000','2015.08.21 00:00');
  INSERT INTO `USDCAD_D1` (`corner`,`time`) VALUES('0.00000000','2015.08.20 00:00');
  INSERT INTO `USDCAD_D1` (`corner`,`time`) VALUES('0.00000000','2015.08.19 00:00');
  INSERT INTO `USDCAD_D1` (`corner`,`time`) VALUES('0.00000000','2015.08.18 00:00');
  INSERT INTO `USDCAD_D1` (`corner`,`time`) VALUES('0.00000000','2015.08.17 00:00');
  INSERT INTO `USDCAD_D1` (`corner`,`time`) VALUES('0.00000000','2015.08.14 00:00');
  INSERT INTO `USDCAD_D1` (`corner`,`time`) VALUES('0.00000000','2015.08.13 00:00');
  INSERT INTO `USDCAD_D1` (`corner`,`time`) VALUES('0.00000000','2015.08.12 00:00');
  INSERT INTO `USDCAD_D1` (`corner`,`time`) VALUES('0.00000000','2015.08.11 00:00');
  INSERT INTO `USDCAD_D1` (`corner`,`time`) VALUES('0.00000000','2015.08.10 00:00');
  INSERT INTO `USDCAD_D1` (`corner`,`time`) VALUES('0.00000000','2015.08.07 00:00');
  INSERT INTO `USDCAD_D1` (`corner`,`time`) VALUES('0.00000000','2015.08.06 00:00');
  INSERT INTO `USDCAD_D1` (`corner`,`time`) VALUES('0.00000000','2015.08.05 00:00');
  INSERT INTO `USDCAD_D1` (`corner`,`time`) VALUES('0.00000000','2015.08.04 00:00');
  INSERT INTO `USDCAD_D1` (`corner`,`time`) VALUES('0.00000000','2015.08.03 00:00');
  INSERT INTO `USDCAD_D1` (`corner`,`time`) VALUES('0.00000000','2015.07.31 00:00');
  INSERT INTO `USDCAD_D1` (`corner`,`time`) VALUES('0.00000000','2015.07.30 00:00');
  INSERT INTO `USDCAD_D1` (`corner`,`time`) VALUES('0.00000000','2015.07.29 00:00');
  INSERT INTO `USDCAD_D1` (`corner`,`time`) VALUES('0.00000000','2015.07.28 00:00');
  INSERT INTO `USDCAD_D1` (`corner`,`time`) VALUES('0.00000000','2015.07.27 00:00');
  INSERT INTO `USDCAD_D1` (`corner`,`time`) VALUES('0.00000000','2015.07.24 00:00');
  INSERT INTO `USDCAD_D1` (`corner`,`time`) VALUES('0.00000000','2015.07.23 00:00');
  INSERT INTO `USDCAD_D1` (`corner`,`time`) VALUES('0.00000000','2015.07.22 00:00');
  INSERT INTO `USDCAD_D1` (`corner`,`time`) VALUES('0.00000000','2015.07.21 00:00');
  INSERT INTO `USDCAD_D1` (`corner`,`time`) VALUES('0.00000000','2015.07.20 00:00');
  INSERT INTO `USDCAD_D1` (`corner`,`time`) VALUES('0.00000000','2015.07.17 00:00');
  INSERT INTO `USDCAD_D1` (`corner`,`time`) VALUES('0.00000000','2015.07.16 00:00');
  INSERT INTO `USDCAD_D1` (`corner`,`time`) VALUES('0.00000000','2015.07.15 00:00');
  INSERT INTO `USDCAD_D1` (`corner`,`time`) VALUES('0.00000000','2015.07.14 00:00');
  INSERT INTO `USDCAD_D1` (`corner`,`time`) VALUES('0.00000000','2015.07.13 00:00');
  INSERT INTO `USDCAD_D1` (`corner`,`time`) VALUES('0.00000000','2015.07.10 00:00');
  INSERT INTO `USDCAD_D1` (`corner`,`time`) VALUES('0.00000000','2015.07.09 00:00');
  INSERT INTO `USDCAD_D1` (`corner`,`time`) VALUES('0.00000000','2015.07.08 00:00');
  INSERT INTO `USDCAD_D1` (`corner`,`time`) VALUES('0.00000000','2015.07.07 00:00');
  INSERT INTO `USDCAD_D1` (`corner`,`time`) VALUES('0.00000000','2015.07.06 00:00');
  INSERT INTO `USDCAD_D1` (`corner`,`time`) VALUES('0.00000000','2015.07.03 00:00');
  INSERT INTO `USDCAD_D1` (`corner`,`time`) VALUES('0.00000000','2015.07.02 00:00');
  INSERT INTO `USDCAD_D1` (`corner`,`time`) VALUES('0.00000000','2015.07.01 00:00');
  INSERT INTO `USDCAD_D1` (`corner`,`time`) VALUES('0.00000000','2015.06.30 00:00');
  INSERT INTO `USDCAD_D1` (`corner`,`time`) VALUES('0.00000000','2015.06.29 00:00');
  INSERT INTO `USDCAD_D1` (`corner`,`time`) VALUES('0.00000000','2015.06.26 00:00');
  INSERT INTO `USDCAD_D1` (`corner`,`time`) VALUES('0.00000000','2015.06.25 00:00');
  INSERT INTO `USDCAD_D1` (`corner`,`time`) VALUES('0.00000000','2015.06.24 00:00');
  INSERT INTO `USDCAD_D1` (`corner`,`time`) VALUES('0.00000000','2015.06.23 00:00');
  INSERT INTO `USDCAD_D1` (`corner`,`time`) VALUES('0.00000000','2015.06.22 00:00');
  INSERT INTO `USDCAD_D1` (`corner`,`time`) VALUES('0.00000000','2015.06.19 00:00');
  INSERT INTO `USDCAD_D1` (`corner`,`time`) VALUES('1.21298000','2015.06.18 00:00');
  INSERT INTO `USDCAD_D1` (`corner`,`time`) VALUES('0.00000000','2015.06.17 00:00');
  INSERT INTO `USDCAD_D1` (`corner`,`time`) VALUES('0.00000000','2015.06.16 00:00');
  INSERT INTO `USDCAD_D1` (`corner`,`time`) VALUES('0.00000000','2015.06.15 00:00');
  INSERT INTO `USDCAD_D1` (`corner`,`time`) VALUES('0.00000000','2015.06.12 00:00');
  INSERT INTO `USDCAD_D1` (`corner`,`time`) VALUES('0.00000000','2015.06.11 00:00');
  INSERT INTO `USDCAD_D1` (`corner`,`time`) VALUES('0.00000000','2015.06.10 00:00');
  
  