Cryptocurrency Historical Prices

sno SNo	name Name	symbol Symbol	date Date	high High	low Low	open Open	close Close	volume Volume	marketcap Marketcap
1	NEM	XEM	Thu Apr 02 2015 23:59:59 GMT+0000 (Coordinated Universal Time)	0.0003230780130252	0.0002272779966006	0.0002421469980617	0.000313725991873	28549.400390625	2823533.99969
2	NEM	XEM	Fri Apr 03 2015 23:59:59 GMT+0000 (Coordinated Universal Time)	0.0003296759969089	0.0002907729940488	0.0003087499935645	0.0003102729970123	20677.900390625	2792456.99969
3	NEM	XEM	Sat Apr 04 2015 23:59:59 GMT+0000 (Coordinated Universal Time)	0.0003182360087521	0.0002505139855202	0.0003102349874097	0.0002765299868769	23550.19921875	2488769.99972
4	NEM	XEM	Sun Apr 05 2015 23:59:59 GMT+0000 (Coordinated Universal Time)	0.0002826320123858	0.0002182650059694	0.0002715240116231	0.0002319320046808	26800.19921875	2087387.99977
5	NEM	XEM	Mon Apr 06 2015 23:59:59 GMT+0000 (Coordinated Universal Time)	0.0002986830077134	0.0002293680008733	0.000232042002608	0.000288706010906	22511.5	2598353.99971
6	NEM	XEM	Tue Apr 07 2015 23:59:59 GMT+0000 (Coordinated Universal Time)	0.0002884599962271	0.0002337129990337	0.0002884599962271	0.000240520996158	14437	2164688.99976
7	NEM	XEM	Wed Apr 08 2015 23:59:59 GMT+0000 (Coordinated Universal Time)	0.0002585719921626	0.0002232080005342	0.000245472008828	0.0002278699976159	6932.85009765625	2050829.99977
8	NEM	XEM	Thu Apr 09 2015 23:59:59 GMT+0000 (Coordinated Universal Time)	0.0002390300069237	0.0002128159976564	0.0002276180020999	0.0002241820038761	10013.599609375	2017637.99978
9	NEM	XEM	Fri Apr 10 2015 23:59:59 GMT+0000 (Coordinated Universal Time)	0.0002269410033477	0.0001673789956839	0.000224197996431	0.0001746930065564	16846	1572236.99983
10	NEM	XEM	Sat Apr 11 2015 23:59:59 GMT+0000 (Coordinated Universal Time)	0.0001919450005516	0.0001432230055797	0.0001746519992593	0.000163339995197	22845.900390625	1470059.99984


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