Cryptocurrency Historical Prices

sno SNo	name Name	symbol Symbol	date Date	high High	low Low	open Open	close Close	volume Volume
1	Polkadot	DOT	Fri Aug 21 2020 23:59:59 GMT+0000 (Coordinated Universal Time)	3.09009266777	2.73091868399	2.89692328556	2.8750282692	49313136.825242
2	Polkadot	DOT	Sat Aug 22 2020 23:59:59 GMT+0000 (Coordinated Universal Time)	4.51061338901	2.81676185336	2.87857004326	4.48469014343	485801095.84575
3	Polkadot	DOT	Sun Aug 23 2020 23:59:59 GMT+0000 (Coordinated Universal Time)	4.48705836489	3.71627105392	4.48705836489	3.96706569209	320749483.243806
4	Polkadot	DOT	Mon Aug 24 2020 23:59:59 GMT+0000 (Coordinated Universal Time)	4.78315823996	3.81266951913	3.98741349226	4.60261415178	407690170.881454
5	Polkadot	DOT	Tue Aug 25 2020 23:59:59 GMT+0000 (Coordinated Universal Time)	5.76077535015	4.50122274573	4.58495324614	5.52339300736	898847538.456415
6	Polkadot	DOT	Wed Aug 26 2020 23:59:59 GMT+0000 (Coordinated Universal Time)	6.55468826139	5.13620529549	5.54140585585	6.08171646879	1054351759.40317
7	Polkadot	DOT	Thu Aug 27 2020 23:59:59 GMT+0000 (Coordinated Universal Time)	6.78917991364	5.31392627262	6.07577223774	5.62833735301	1289248953.26494
8	Polkadot	DOT	Fri Aug 28 2020 23:59:59 GMT+0000 (Coordinated Universal Time)	6.33374606123	5.54096300109	5.63948557226	6.15995475836	727162235.007699
9	Polkadot	DOT	Sat Aug 29 2020 23:59:59 GMT+0000 (Coordinated Universal Time)	6.56290582908	6.04230882692	6.17592465036	6.15914322499	527290028.288721
10	Polkadot	DOT	Sun Aug 30 2020 23:59:59 GMT+0000 (Coordinated Universal Time)	6.21950641987	5.74997752639	6.15343993195	5.86988080945	485335136.160243


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