Cryptocurrency Historical Prices

sno SNo	name Name	symbol Symbol	date Date	high High	low Low	open Open	close Close	volume Volume	marketcap Marketcap
1	Ethereum	ETH	Sat Aug 08 2015 23:59:59 GMT+0000 (Coordinated Universal Time)	2.7988100051879883	0.7147250175476074	2.793760061264038	0.7533249855041504	674188	45486894.2408
2	Ethereum	ETH	Sun Aug 09 2015 23:59:59 GMT+0000 (Coordinated Universal Time)	0.8798099756240845	0.629190981388092	0.7061359882354736	0.7018970251083374	532170	42399573.4991
3	Ethereum	ETH	Mon Aug 10 2015 23:59:59 GMT+0000 (Coordinated Universal Time)	0.7298539876937866	0.6365460157394409	0.7139890193939209	0.7084479928016663	405283	42818364.3945
4	Ethereum	ETH	Tue Aug 11 2015 23:59:59 GMT+0000 (Coordinated Universal Time)	1.131410002708435	0.6632350087165833	0.7080870270729065	1.0678600072860718	1463100	64569288.4328
5	Ethereum	ETH	Wed Aug 12 2015 23:59:59 GMT+0000 (Coordinated Universal Time)	1.2899399995803833	0.8836079835891724	1.058750033378601	1.2174400091171265	2150620	73645010.9863
6	Ethereum	ETH	Thu Aug 13 2015 23:59:59 GMT+0000 (Coordinated Universal Time)	1.9650700092315676	1.1719900369644165	1.222239971160889	1.827669978141785	4068680	110607191.674
7	Ethereum	ETH	Fri Aug 14 2015 23:59:59 GMT+0000 (Coordinated Universal Time)	2.2618799209594727	1.7547500133514404	1.810920000076294	1.8278700113296509	4637030	110672321.811
8	Ethereum	ETH	Sat Aug 15 2015 23:59:59 GMT+0000 (Coordinated Universal Time)	1.8772399425506592	1.5709799528121948	1.802889943122864	1.6888999938964844	2554360	102303608.467
9	Ethereum	ETH	Sun Aug 16 2015 23:59:59 GMT+0000 (Coordinated Universal Time)	1.6952400207519531	1.0898100137710571	1.6843500137329102	1.5660300254821775	3550790	94901005.3503
10	Ethereum	ETH	Mon Aug 17 2015 23:59:59 GMT+0000 (Coordinated Universal Time)	1.58118999004364	1.1853400468826294	1.58118999004364	1.2036099433898926	1942830	87295366.5007


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