text: DROP TABLE IF EXISTS `NZDUSD_MN1`;
  CREATE TABLE IF NOT EXISTS `NZDUSD_MN1`(
  `id` int(5) NOT NULL,
  `open` varchar(30) NOT NULL,
  `high` varchar(30) NOT NULL,
  `close` varchar(30) NOT NULL,
  `low` varchar(30) NOT NULL,
  `time` varchar(30) NOT NULL);
  ALTER TABLE `NZDUSD_MN1` ADD PRIMARY KEY (`id`);
  ALTER TABLE `NZDUSD_MN1` MODIFY `id` int(5) NOT NULL AUTO_INCREMENT;
  INSERT INTO `NZDUSD_MN1`(`open`,`high`,`close`,`low`,`time`) VALUES('0.63966','0.67391','0.66674','0.63822','2015.10.01 00:00');
  INSERT INTO `NZDUSD_MN1`(`open`,`high`,`close`,`low`,`time`) VALUES('0.63314','0.64552','0.63948','0.62351','2015.09.01 00:00');
  INSERT INTO `NZDUSD_MN1`(`open`,`high`,`close`,`low`,`time`) VALUES('0.66041','0.67071','0.63350','0.62587','2015.08.01 00:00');
  INSERT INTO `NZDUSD_MN1`(`open`,`high`,`close`,`low`,`time`) VALUES('0.67621','0.68091','0.66000','0.64969','2015.07.01 00:00');
  INSERT INTO `NZDUSD_MN1`(`open`,`high`,`close`,`low`,`time`) VALUES('0.70831','0.72292','0.67621','0.67463','2015.06.01 00:00');
  INSERT INTO `NZDUSD_MN1`(`open`,`high`,`close`,`low`,`time`) VALUES('0.76143','0.76218','0.70924','0.70785','2015.05.01 00:00');
  INSERT INTO `NZDUSD_MN1`(`open`,`high`,`close`,`low`,`time`) VALUES('0.74673','0.77432','0.76100','0.73903','2015.04.01 00:00');
  INSERT INTO `NZDUSD_MN1`(`open`,`high`,`close`,`low`,`time`) VALUES('0.75497','0.76953','0.74670','0.71892','2015.03.01 00:00');
  INSERT INTO `NZDUSD_MN1`(`open`,`high`,`close`,`low`,`time`) VALUES('0.72507','0.76120','0.75632','0.71747','2015.02.01 00:00');
  INSERT INTO `NZDUSD_MN1`(`open`,`high`,`close`,`low`,`time`) VALUES('0.77566','0.78883','0.72745','0.72137','2015.01.01 00:00');
  INSERT INTO `NZDUSD_MN1`(`open`,`high`,`close`,`low`,`time`) VALUES('0.78165','0.79102','0.77938','0.76080','2014.12.01 00:00');
  INSERT INTO `NZDUSD_MN1`(`open`,`high`,`close`,`low`,`time`) VALUES('0.77694','0.79738','0.78369','0.76594','2014.11.01 00:00');
  INSERT INTO `NZDUSD_MN1`(`open`,`high`,`close`,`low`,`time`) VALUES('0.78073','0.80335','0.77828','0.77141','2014.10.01 00:00');
  INSERT INTO `NZDUSD_MN1`(`open`,`high`,`close`,`low`,`time`) VALUES('0.83486','0.83899','0.78072','0.77082','2014.09.01 00:00');
  INSERT INTO `NZDUSD_MN1`(`open`,`high`,`close`,`low`,`time`) VALUES('0.84969','0.85349','0.83636','0.83102','2014.08.01 00:00');
  INSERT INTO `NZDUSD_MN1`(`open`,`high`,`close`,`low`,`time`) VALUES('0.87550','0.88346','0.84976','0.84624','2014.07.01 00:00');
  INSERT INTO `NZDUSD_MN1`(`open`,`high`,`close`,`low`,`time`) VALUES('0.84875','0.87934','0.87549','0.84014','2014.06.01 00:00');
  INSERT INTO `NZDUSD_MN1`(`open`,`high`,`close`,`low`,`time`) VALUES('0.86160','0.87790','0.84900','0.84506','2014.05.01 00:00');
  INSERT INTO `NZDUSD_MN1`(`open`,`high`,`close`,`low`,`time`) VALUES('0.86683','0.87452','0.86161','0.85137','2014.04.01 00:00');
  INSERT INTO `NZDUSD_MN1`(`open`,`high`,`close`,`low`,`time`) VALUES('0.83541','0.86964','0.86680','0.83422','2014.03.01 00:00');
  INSERT INTO `NZDUSD_MN1`(`open`,`high`,`close`,`low`,`time`) VALUES('0.80998','0.84248','0.83835','0.80510','2014.02.01 00:00');
  INSERT INTO `NZDUSD_MN1`(`open`,`high`,`close`,`low`,`time`) VALUES('0.82157','0.84320','0.80846','0.80615','2014.01.01 00:00');
  INSERT INTO `NZDUSD_MN1`(`open`,`high`,`close`,`low`,`time`) VALUES('0.81527','0.83340','0.82267','0.81165','2013.12.01 00:00');
  INSERT INTO `NZDUSD_MN1`(`open`,`high`,`close`,`low`,`time`) VALUES('0.82549','0.84142','0.81346','0.80839','2013.11.01 00:00');
  INSERT INTO `NZDUSD_MN1`(`open`,`high`,`close`,`low`,`time`) VALUES('0.83052','0.85428','0.82551','0.81922','2013.10.01 00:00');
  INSERT INTO `NZDUSD_MN1`(`open`,`high`,`close`,`low`,`time`) VALUES('0.77608','0.84351','0.82943','0.77372','2013.09.01 00:00');
  INSERT INTO `NZDUSD_MN1`(`open`,`high`,`close`,`low`,`time`) VALUES('0.79829','0.81628','0.77270','0.77213','2013.08.01 00:00');
  INSERT INTO `NZDUSD_MN1`(`open`,`high`,`close`,`low`,`time`) VALUES('0.77078','0.81055','0.79829','0.76873','2013.07.01 00:00');
  INSERT INTO `NZDUSD_MN1`(`open`,`high`,`close`,`low`,`time`) VALUES('0.79639','0.81369','0.77487','0.76826','2013.06.01 00:00');
  INSERT INTO `NZDUSD_MN1`(`open`,`high`,`close`,`low`,`time`) VALUES('0.85641','0.85820','0.79444','0.79385','2013.05.01 00:00');
  INSERT INTO `NZDUSD_MN1`(`open`,`high`,`close`,`low`,`time`) VALUES('0.83584','0.86758','0.85624','0.83509','2013.04.01 00:00');
  INSERT INTO `NZDUSD_MN1`(`open`,`high`,`close`,`low`,`time`) VALUES('0.82460','0.83950','0.83680','0.81613','2013.03.01 00:00');
  INSERT INTO `NZDUSD_MN1`(`open`,`high`,`close`,`low`,`time`) VALUES('0.83858','0.85330','0.82470','0.82230','2013.02.01 00:00');
  INSERT INTO `NZDUSD_MN1`(`open`,`high`,`close`,`low`,`time`) VALUES('0.83516','0.84583','0.83861','0.82122','2013.01.01 00:00');
  INSERT INTO `NZDUSD_MN1`(`open`,`high`,`close`,`low`,`time`) VALUES('0.82060','0.84740','0.82640','0.81540','2012.12.01 00:00');
  INSERT INTO `NZDUSD_MN1`(`open`,`high`,`close`,`low`,`time`) VALUES('0.82230','0.83080','0.82080','0.80520','2012.11.01 00:00');
  INSERT INTO `NZDUSD_MN1`(`open`,`high`,`close`,`low`,`time`) VALUES('0.82860','0.83360','0.82220','0.81000','2012.10.01 00:00');
  INSERT INTO `NZDUSD_MN1`(`open`,`high`,`close`,`low`,`time`) VALUES('0.81140','0.83550','0.83010','0.80800','2012.09.01 00:00');
  INSERT INTO `NZDUSD_MN1`(`open`,`high`,`close`,`low`,`time`) VALUES('0.80840','0.82220','0.80140','0.80000','2012.08.01 00:00');
  INSERT INTO `NZDUSD_MN1`(`open`,`high`,`close`,`low`,`time`) VALUES('0.80130','0.81200','0.80850','0.78070','2012.07.01 00:00');
  INSERT INTO `NZDUSD_MN1`(`open`,`high`,`close`,`low`,`time`) VALUES('0.75283','0.80399','0.80100','0.74536','2012.06.01 00:00');
  INSERT INTO `NZDUSD_MN1`(`open`,`high`,`close`,`low`,`time`) VALUES('0.81825','0.81870','0.75283','0.74555','2012.05.01 00:00');
  INSERT INTO `NZDUSD_MN1`(`open`,`high`,`close`,`low`,`time`) VALUES('0.82364','0.83166','0.81824','0.80860','2012.04.01 00:00');
  INSERT INTO `NZDUSD_MN1`(`open`,`high`,`close`,`low`,`time`) VALUES('0.83390','0.84044','0.81855','0.80569','2012.03.01 00:00');
  INSERT INTO `NZDUSD_MN1`(`open`,`high`,`close`,`low`,`time`) VALUES('0.82660','0.84700','0.83400','0.82120','2012.02.01 00:00');
  INSERT INTO `NZDUSD_MN1`(`open`,`high`,`close`,`low`,`time`) VALUES('0.77750','0.83000','0.82650','0.77590','2012.01.01 00:00');
  INSERT INTO `NZDUSD_MN1`(`open`,`high`,`close`,`low`,`time`) VALUES('0.78020','0.78770','0.77780','0.74600','2011.12.01 00:00');
  INSERT INTO `NZDUSD_MN1`(`open`,`high`,`close`,`low`,`time`) VALUES('0.80720','0.81060','0.78030','0.73690','2011.11.01 00:00');
  INSERT INTO `NZDUSD_MN1`(`open`,`high`,`close`,`low`,`time`) VALUES('0.76230','0.82410','0.80740','0.74680','2011.10.01 00:00');
  INSERT INTO `NZDUSD_MN1`(`open`,`high`,`close`,`low`,`time`) VALUES('0.85250','0.85450','0.76210','0.76060','2011.09.01 00:00');
  INSERT INTO `NZDUSD_MN1`(`open`,`high`,`close`,`low`,`time`) VALUES('0.87890','0.88430','0.85240','0.79640','2011.08.01 00:00');
  INSERT INTO `NZDUSD_MN1`(`open`,`high`,`close`,`low`,`time`) VALUES('0.82790','0.87940','0.87870','0.81090','2011.07.01 00:00');
  INSERT INTO `NZDUSD_MN1`(`open`,`high`,`close`,`low`,`time`) VALUES('0.82280','0.83180','0.82780','0.79710','2011.06.01 00:00');
  INSERT INTO `NZDUSD_MN1`(`open`,`high`,`close`,`low`,`time`) VALUES('0.80960','0.82620','0.82290','0.77540','2011.05.01 00:00');
  INSERT INTO `NZDUSD_MN1`(`open`,`high`,`close`,`low`,`time`) VALUES('0.76110','0.81070','0.80910','0.75800','2011.04.01 00:00');
  INSERT INTO `NZDUSD_MN1`(`open`,`high`,`close`,`low`,`time`) VALUES('0.75210','0.76460','0.76100','0.71150','2011.03.01 00:00');
  INSERT INTO `NZDUSD_MN1`(`open`,`high`,`close`,`low`,`time`) VALUES('0.77240','0.78230','0.75220','0.74270','2011.02.01 00:00');
  INSERT INTO `NZDUSD_MN1`(`open`,`high`,`close`,`low`,`time`) VALUES('0.77600','0.77920','0.77270','0.75250','2011.01.01 00:00');
  INSERT INTO `NZDUSD_MN1`(`open`,`high`,`close`,`low`,`time`) VALUES('0.74240','0.78140','0.77910','0.73420','2010.12.01 00:00');
  INSERT INTO `NZDUSD_MN1`(`open`,`high`,`close`,`low`,`time`) VALUES('0.76550','0.79750','0.74250','0.73960','2010.11.01 00:00');
  INSERT INTO `NZDUSD_MN1`(`open`,`high`,`close`,`low`,`time`) VALUES('0.73390','0.76500','0.76230','0.73270','2010.10.01 00:00');
  INSERT INTO `NZDUSD_MN1`(`open`,`high`,`close`,`low`,`time`) VALUES('0.69900','0.74160','0.73370','0.69860','2010.09.01 00:00');
  INSERT INTO `NZDUSD_MN1`(`open`,`high`,`close`,`low`,`time`) VALUES('0.72690','0.73550','0.69920','0.69460','2010.08.01 00:00');
  INSERT INTO `NZDUSD_MN1`(`open`,`high`,`close`,`low`,`time`) VALUES('0.68480','0.73950','0.72550','0.67920','2010.07.01 00:00');
  INSERT INTO `NZDUSD_MN1`(`open`,`high`,`close`,`low`,`time`) VALUES('0.68160','0.71600','0.68490','0.65710','2010.06.01 00:00');
  INSERT INTO `NZDUSD_MN1`(`open`,`high`,`close`,`low`,`time`) VALUES('0.72910','0.73230','0.68150','0.65590','2010.05.01 00:00');
  INSERT INTO `NZDUSD_MN1`(`open`,`high`,`close`,`low`,`time`) VALUES('0.71070','0.73250','0.72700','0.69630','2010.04.01 00:00');
  INSERT INTO `NZDUSD_MN1`(`open`,`high`,`close`,`low`,`time`) VALUES('0.69810','0.71770','0.71080','0.68500','2010.03.01 00:00');
  INSERT INTO `NZDUSD_MN1`(`open`,`high`,`close`,`low`,`time`) VALUES('0.70020','0.71480','0.69820','0.68050','2010.02.01 00:00');
  INSERT INTO `NZDUSD_MN1`(`open`,`high`,`close`,`low`,`time`) VALUES('0.72410','0.74400','0.70130','0.70120','2010.01.01 00:00');
  INSERT INTO `NZDUSD_MN1`(`open`,`high`,`close`,`low`,`time`) VALUES('0.71570','0.73190','0.72580','0.69710','2009.12.01 00:00');
  INSERT INTO `NZDUSD_MN1`(`open`,`high`,`close`,`low`,`time`) VALUES('0.71570','0.75220','0.71580','0.70230','2009.11.01 00:00');
  INSERT INTO `NZDUSD_MN1`(`open`,`high`,`close`,`low`,`time`) VALUES('0.72290','0.76350','0.71770','0.70770','2009.10.01 00:00');
  INSERT INTO `NZDUSD_MN1`(`open`,`high`,`close`,`low`,`time`) VALUES('0.68480','0.73120','0.72300','0.66830','2009.09.01 00:00');
  INSERT INTO `NZDUSD_MN1`(`open`,`high`,`close`,`low`,`time`) VALUES('0.66030','0.68980','0.68470','0.65890','2009.08.01 00:00');
  INSERT INTO `NZDUSD_MN1`(`open`,`high`,`close`,`low`,`time`) VALUES('0.64550','0.66320','0.66150','0.61930','2009.07.01 00:00');
  INSERT INTO `NZDUSD_MN1`(`open`,`high`,`close`,`low`,`time`) VALUES('0.64100','0.65930','0.64520','0.61510','2009.06.01 00:00');
  INSERT INTO `NZDUSD_MN1`(`open`,`high`,`close`,`low`,`time`) VALUES('0.56300','0.64160','0.63980','0.56270','2009.05.01 00:00');
  INSERT INTO `NZDUSD_MN1`(`open`,`high`,`close`,`low`,`time`) VALUES('0.55870','0.59820','0.56310','0.54830','2009.04.01 00:00');
  INSERT INTO `NZDUSD_MN1`(`open`,`high`,`close`,`low`,`time`) VALUES('0.49920','0.58010','0.55890','0.48930','2009.03.01 00:00');
  INSERT INTO `NZDUSD_MN1`(`open`,`high`,`close`,`low`,`time`) VALUES('0.50830','0.54450','0.50050','0.49600','2009.02.01 00:00');
  INSERT INTO `NZDUSD_MN1`(`open`,`high`,`close`,`low`,`time`) VALUES('0.58800','0.60340','0.50760','0.50450','2009.01.01 00:00');
  INSERT INTO `NZDUSD_MN1`(`open`,`high`,`close`,`low`,`time`) VALUES('0.54500','0.60820','0.58650','0.52010','2008.12.01 00:00');
  INSERT INTO `NZDUSD_MN1`(`open`,`high`,`close`,`low`,`time`) VALUES('0.58430','0.61290','0.54900','0.51890','2008.11.01 00:00');
  INSERT INTO `NZDUSD_MN1`(`open`,`high`,`close`,`low`,`time`) VALUES('0.67040','0.67880','0.58300','0.53480','2008.10.01 00:00');
  INSERT INTO `NZDUSD_MN1`(`open`,`high`,`close`,`low`,`time`) VALUES('0.69950','0.70020','0.67030','0.64350','2008.09.01 00:00');
  INSERT INTO `NZDUSD_MN1`(`open`,`high`,`close`,`low`,`time`) VALUES('0.73280','0.73370','0.69970','0.68220','2008.08.01 00:00');
  INSERT INTO `NZDUSD_MN1`(`open`,`high`,`close`,`low`,`time`) VALUES('0.76140','0.77570','0.73300','0.73070','2008.07.01 00:00');
  INSERT INTO `NZDUSD_MN1`(`open`,`high`,`close`,`low`,`time`) VALUES('0.78270','0.78910','0.76150','0.74460','2008.06.01 00:00');
  INSERT INTO `NZDUSD_MN1`(`open`,`high`,`close`,`low`,`time`) VALUES('0.78120','0.79360','0.78330','0.75360','2008.05.01 00:00');
  INSERT INTO `NZDUSD_MN1`(`open`,`high`,`close`,`low`,`time`) VALUES('0.78510','0.80320','0.78110','0.77260','2008.04.01 00:00');
  INSERT INTO `NZDUSD_MN1`(`open`,`high`,`close`,`low`,`time`) VALUES('0.79920','0.82110','0.78500','0.78450','2008.03.01 00:00');
  INSERT INTO `NZDUSD_MN1`(`open`,`high`,`close`,`low`,`time`) VALUES('0.78710','0.82130','0.79930','0.77800','2008.02.01 00:00');
  INSERT INTO `NZDUSD_MN1`(`open`,`high`,`close`,`low`,`time`) VALUES('0.76800','0.79310','0.78740','0.73850','2008.01.01 00:00');
  INSERT INTO `NZDUSD_MN1`(`open`,`high`,`close`,`low`,`time`) VALUES('0.76200','0.79340','0.76620','0.75040','2007.12.01 00:00');
  INSERT INTO `NZDUSD_MN1`(`open`,`high`,`close`,`low`,`time`) VALUES('0.77250','0.78900','0.76210','0.74350','2007.11.01 00:00');
  INSERT INTO `NZDUSD_MN1`(`open`,`high`,`close`,`low`,`time`) VALUES('0.76050','0.77560','0.77240','0.73650','2007.10.01 00:00');
  INSERT INTO `NZDUSD_MN1`(`open`,`high`,`close`,`low`,`time`) VALUES('0.70030','0.75850','0.75730','0.68240','2007.09.01 00:00');
  INSERT INTO `NZDUSD_MN1`(`open`,`high`,`close`,`low`,`time`) VALUES('0.75970','0.77130','0.70170','0.66400','2007.08.01 00:00');
  INSERT INTO `NZDUSD_MN1`(`open`,`high`,`close`,`low`,`time`) VALUES('0.77080','0.81060','0.75960','0.75520','2007.07.01 00:00');
  
  