Cryptocurrency Historical Prices

sno SNo	name Name	symbol Symbol	date Date	high High	low Low	open Open	close Close	marketcap Marketcap
1	Litecoin	LTC	Mon Apr 29 2013 23:59:59 GMT+0000 (Coordinated Universal Time)	4.573599815368652	4.225639820098877	4.366759777069092	4.383900165557861	75388963.842
2	Litecoin	LTC	Tue Apr 30 2013 23:59:59 GMT+0000 (Coordinated Universal Time)	4.572380065917969	4.168960094451904	4.403520107269287	4.29649019241333	74020917.9127
3	Litecoin	LTC	Wed May 01 2013 23:59:59 GMT+0000 (Coordinated Universal Time)	4.356860160827637	3.520289897918701	4.289539813995361	3.8010098934173584	65604596.3778
4	Litecoin	LTC	Thu May 02 2013 23:59:59 GMT+0000 (Coordinated Universal Time)	4.039299964904785	3.0071699619293213	3.780019998550415	3.3719799518585205	58287978.8404
5	Litecoin	LTC	Fri May 03 2013 23:59:59 GMT+0000 (Coordinated Universal Time)	3.4536099433898926	2.395940065383911	3.390439987182617	3.044909954071045	52694847.0708
6	Litecoin	LTC	Sat May 04 2013 23:59:59 GMT+0000 (Coordinated Universal Time)	3.638279914855957	2.895250082015991	3.0322699546813965	3.4796199798583984	60290867.7155
7	Litecoin	LTC	Sun May 05 2013 23:59:59 GMT+0000 (Coordinated Universal Time)	3.692460060119629	3.346060037612915	3.4931299686431885	3.5908899307250977	62298185.4291
8	Litecoin	LTC	Mon May 06 2013 23:59:59 GMT+0000 (Coordinated Universal Time)	3.781019926071167	3.11601996421814	3.594219923019409	3.3712499141693115	58594361.235
9	Litecoin	LTC	Tue May 07 2013 23:59:59 GMT+0000 (Coordinated Universal Time)	3.406719923019409	2.9397900104522705	3.3708701133728027	3.332740068435669	58051265.0352
10	Litecoin	LTC	Wed May 08 2013 23:59:59 GMT+0000 (Coordinated Universal Time)	3.4911201000213623	3.2836201190948486	3.2836201190948486	3.4092400074005127	59508216.0152


CREATE TABLE coin_litecoin (
  "sno" BIGINT,
  "name" VARCHAR,
  "symbol" VARCHAR,
  "date" TIMESTAMP,
  "high" DOUBLE,
  "low" DOUBLE,
  "open" DOUBLE,
  "close" DOUBLE,
  "volume" DOUBLE,
  "marketcap" DOUBLE
);