Cryptocurrency Historical Prices

sno SNo	name Name	symbol Symbol	date Date	high High	low Low	open Open	close Close	volume Volume	marketcap Marketcap
1	Crypto.com Coin	CRO	Sat Dec 15 2018 23:59:59 GMT+0000 (Coordinated Universal Time)	0.0198448168568	0.0161499362924	0.0195419431598	0.0172433664486	989709.642797211
2	Crypto.com Coin	CRO	Sun Dec 16 2018 23:59:59 GMT+0000 (Coordinated Universal Time)	0.0174962485077	0.0141272822709	0.0172127069603	0.0153006720049	717174.017781968
3	Crypto.com Coin	CRO	Mon Dec 17 2018 23:59:59 GMT+0000 (Coordinated Universal Time)	0.0167227296371	0.0114866815226	0.0151863887712	0.0144480443353	615622.639000056	15470622.8156846
4	Crypto.com Coin	CRO	Tue Dec 18 2018 23:59:59 GMT+0000 (Coordinated Universal Time)	0.0172150480817	0.013552939764	0.014308372879	0.0162596370181	764474.467656781	17855902.7527537
5	Crypto.com Coin	CRO	Wed Dec 19 2018 23:59:59 GMT+0000 (Coordinated Universal Time)	0.0315087501083	0.0156086511424	0.0160865624574	0.0207902317496	1025195.83098842	23400877.2889336
6	Crypto.com Coin	CRO	Thu Dec 20 2018 23:59:59 GMT+0000 (Coordinated Universal Time)	0.0346769764814	0.020721580129	0.0208135285275	0.0324468544943	1591947.69573578	37410186.1178573
7	Crypto.com Coin	CRO	Fri Dec 21 2018 23:59:59 GMT+0000 (Coordinated Universal Time)	0.0398536142581	0.0317242321866	0.0324717099601	0.0328158652861	2941460.27614868	38734708.5682967
8	Crypto.com Coin	CRO	Sat Dec 22 2018 23:59:59 GMT+0000 (Coordinated Universal Time)	0.034878083989	0.03158544173	0.0329211178603	0.034737226681	1786517.11129234	41954321.7220295
9	Crypto.com Coin	CRO	Sun Dec 23 2018 23:59:59 GMT+0000 (Coordinated Universal Time)	0.0372901703755	0.0300127279046	0.0348229924133	0.0304013134337	1624195.57464558	37550480.7480179
10	Crypto.com Coin	CRO	Mon Dec 24 2018 23:59:59 GMT+0000 (Coordinated Universal Time)	0.032311408786	0.0296057219408	0.0303207911296	0.0296057219408	1520019.10018649	37378913.774572


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