Cryptocurrency Historical Prices

sno SNo	name Name	symbol Symbol	date Date	high High	low Low	open Open	close Close	marketcap Marketcap
1	Dogecoin	DOGE	Mon Dec 16 2013 23:59:59 GMT+0000 (Coordinated Universal Time)	0.0008658739970996	0.0001502130035078	0.0002993119996972	0.0002047309972112	1509085.15965
2	Dogecoin	DOGE	Tue Dec 17 2013 23:59:59 GMT+0000 (Coordinated Universal Time)	0.0002887900045607	0.0001155930003733	0.0002068890025839	0.0002685399958863	2169687.9813
3	Dogecoin	DOGE	Wed Dec 18 2013 23:59:59 GMT+0000 (Coordinated Universal Time)	0.0003616310132201	0.0002046080044237	0.0002673169947229	0.0003616310132201	3188943.20963
4	Dogecoin	DOGE	Thu Dec 19 2013 23:59:59 GMT+0000 (Coordinated Universal Time)	0.0015196700114756	0.0003283029946032	0.0003950539976358	0.0011624899925664	11150339.2183
5	Dogecoin	DOGE	Fri Dec 20 2013 23:59:59 GMT+0000 (Coordinated Universal Time)	0.0011429199948906	0.0006617510225623	0.0011429199948906	0.0007038660114631	7284337.11836
6	Dogecoin	DOGE	Sat Dec 21 2013 23:59:59 GMT+0000 (Coordinated Universal Time)	0.0007004869985394	0.0003542760096024	0.0007004869985394	0.0003936789871659	4360316.34343
7	Dogecoin	DOGE	Sun Dec 22 2013 23:59:59 GMT+0000 (Coordinated Universal Time)	0.0004975799820385	0.0002796530025079	0.0003911569947376	0.0003147620009258	3706592.18772
8	Dogecoin	DOGE	Mon Dec 23 2013 23:59:59 GMT+0000 (Coordinated Universal Time)	0.0004595300124492	0.0002935240045189	0.0003126609954051	0.0004511850129347	5644793.35139
9	Dogecoin	DOGE	Tue Dec 24 2013 23:59:59 GMT+0000 (Coordinated Universal Time)	0.0009130489779636	0.0004504809912759	0.0004504809912759	0.0006855470128357	9075937.82287
10	Dogecoin	DOGE	Wed Dec 25 2013 23:59:59 GMT+0000 (Coordinated Universal Time)	0.0006936800200492	0.0005582980229519	0.000686298997607	0.0005867009749636	8194483.24403


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