Cryptocurrency Historical Prices

sno SNo	name Name	symbol Symbol	date Date	high High	low Low	open Open	close Close	volume Volume	marketcap Marketcap
1	Cardano	ADA	Mon Oct 02 2017 23:59:59 GMT+0000 (Coordinated Universal Time)	0.0300877001136541	0.0199692994356155	0.0246070008724927	0.0259317997843027	57641300	628899051.78
2	Cardano	ADA	Tue Oct 03 2017 23:59:59 GMT+0000 (Coordinated Universal Time)	0.0274251997470855	0.0206898991018533	0.025756599381566	0.0208158008754253	16997800	539692714.905
3	Cardano	ADA	Wed Oct 04 2017 23:59:59 GMT+0000 (Coordinated Universal Time)	0.0228062998503446	0.0208640992641448	0.0208640992641448	0.0219314992427825	9000050	568619547.504
4	Cardano	ADA	Thu Oct 05 2017 23:59:59 GMT+0000 (Coordinated Universal Time)	0.0221535991877317	0.0208592992275953	0.0219512991607189	0.0214887000620365	5562510	557139040.67
5	Cardano	ADA	Fri Oct 06 2017 23:59:59 GMT+0000 (Coordinated Universal Time)	0.0215418990701437	0.018359700217843	0.0213588997721672	0.0185391008853912	7780710	480664553.411
6	Cardano	ADA	Sat Oct 07 2017 23:59:59 GMT+0000 (Coordinated Universal Time)	0.0210503004491329	0.0176199991255998	0.0184138994663953	0.0209408998489379	7411240	542936191.429
7	Cardano	ADA	Sun Oct 08 2017 23:59:59 GMT+0000 (Coordinated Universal Time)	0.0235977005213499	0.0201473999768495	0.0209293998777866	0.0204771999269723	7727460	530913808.821
8	Cardano	ADA	Mon Oct 09 2017 23:59:59 GMT+0000 (Coordinated Universal Time)	0.0228071995079517	0.0203419998288154	0.0203443001955747	0.02211369946599	4663310	573343459.756
9	Cardano	ADA	Tue Oct 10 2017 23:59:59 GMT+0000 (Coordinated Universal Time)	0.0224460996687412	0.0212792996317148	0.0221120994538068	0.0215313006192445	2725600	558243533.875
10	Cardano	ADA	Wed Oct 11 2017 23:59:59 GMT+0000 (Coordinated Universal Time)	0.0225757006555795	0.0209764000028371	0.0214799996465444	0.0225195009261369	3606720	583864664.98


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