Cryptocurrency Historical Prices

sno SNo	name Name	symbol Symbol	date Date	high High	low Low	open Open	close Close	volume Volume	marketcap Marketcap
1	Aave	AAVE	Mon Oct 05 2020 23:59:59 GMT+0000 (Coordinated Universal Time)	55.11235847	49.78789992	52.67503496	53.21924296		89128128.86084658
2	Aave	AAVE	Tue Oct 06 2020 23:59:59 GMT+0000 (Coordinated Universal Time)	53.40227002	40.73457791	53.29196931	42.40159861	583091.4597628	71011441.25451232
3	Aave	AAVE	Wed Oct 07 2020 23:59:59 GMT+0000 (Coordinated Universal Time)	42.40831364	35.97068975	42.39994711	40.08397561	682834.18632335	67130036.89981823
4	Aave	AAVE	Thu Oct 08 2020 23:59:59 GMT+0000 (Coordinated Universal Time)	44.90251114	36.69605677	39.88526234	43.76446306	1658816.92260445	220265142.10956785
5	Aave	AAVE	Fri Oct 09 2020 23:59:59 GMT+0000 (Coordinated Universal Time)	47.56953274	43.2917758	43.76446306	46.81774415	815537.6607835	235632208.16269895
6	Aave	AAVE	Sat Oct 10 2020 23:59:59 GMT+0000 (Coordinated Universal Time)	51.4056548	46.70332768	46.81814554	49.13371767	1074627.02770495	247288428.7561697
7	Aave	AAVE	Sun Oct 11 2020 23:59:59 GMT+0000 (Coordinated Universal Time)	51.45337431	48.71603954	49.13312951	49.66072573	692150.60094118	249940843.43242228
8	Aave	AAVE	Mon Oct 12 2020 23:59:59 GMT+0000 (Coordinated Universal Time)	54.42141763	48.75407708	49.66157329	52.23869222	1354836.06481028	262915666.29307267
9	Aave	AAVE	Tue Oct 13 2020 23:59:59 GMT+0000 (Coordinated Universal Time)	57.48190422	49.59873521	52.23839242	51.12431679	1386221.2066711	257307050.4308017
10	Aave	AAVE	Wed Oct 14 2020 23:59:59 GMT+0000 (Coordinated Universal Time)	57.85394649	49.62952942	51.37289869	51.31651791	3132405.42216768	258274392.50811112


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