----database: ' Bittrex '---- ------------------------------------------------------------structure of the table ' LTC '--DROP TABLE IF EXISTS' LTC ';CREATE TABLE IF not EXISTS' LTC ' (' ID 'int(6) not NULLauto_increment, 'timestamp`varchar(Ten) not NULL, `datetime`datetime not NULL, `Open`float not NULL, `Close`float not NULL, ' High 'float not NULL, ' low 'float not NULL, ' volume 'float not NULL, PRIMARY KEY(' id '),UNIQUE KEY`timestamp` (`timestamp`)) ENGINE=MyISAMDEFAULTCHARSET=UTF8 auto_increment=1440 ;----data in the Dump table ' LTC '--INSERT into' LTC ' (' ID ', 'timestamp`, `datetime`, `Open`, `Close' High ', ' low ', ' volume ')VALUES(1,'1504231200','2017-09-01 10:00:00',0.0152578,0.01535,0.01535,0.0151101,7564.68),(2,'1504234800','2017-09-01 11:00:00',0.0153596,0.015645,0.0156665,0.015305,14360.2),(3,'1504238400','2017-09-01 12:00:00',0.015645,0.01585,0.01605,0.01561,20670.2);
Candlestick database table Structure