Weather.csv

date Date	tavg Tavg	tmin Tmin	tmax Tmax	prcp Prcp	wdir Wdir	wspd Wspd	pres Pres
Sun Jan 01 2023 00:00:00 GMT+0000 (Coordinated Universal Time)	10.4	3.2	17.8		141	4.7	1030.7
Mon Jan 02 2023 00:00:00 GMT+0000 (Coordinated Universal Time)	10.2	1.4	18.6		134	3.4	1030.4
Tue Jan 03 2023 00:00:00 GMT+0000 (Coordinated Universal Time)	9.6	1.2	17.4		171	3.6	1029
Wed Jan 04 2023 00:00:00 GMT+0000 (Coordinated Universal Time)	9.1	3.6	16.6		149	3.9	1027
Thu Jan 05 2023 00:00:00 GMT+0000 (Coordinated Universal Time)	8.9	3.2	17		149	4	1023.7
Fri Jan 06 2023 00:00:00 GMT+0000 (Coordinated Universal Time)	9.6	5	17.4		116	4.4	1023.1
Sat Jan 07 2023 00:00:00 GMT+0000 (Coordinated Universal Time)	9	2	17.2		144	5	1023.1
Sun Jan 08 2023 00:00:00 GMT+0000 (Coordinated Universal Time)	8.4	1.2	16.8		151	4.8	1022
Mon Jan 09 2023 00:00:00 GMT+0000 (Coordinated Universal Time)	11.6	7	16.6	16.8	144	14.4	1015.3
Tue Jan 10 2023 00:00:00 GMT+0000 (Coordinated Universal Time)	9.6	5.6	14	21.4	172	11.8	1007.6


CREATE TABLE gramsh2023 (
  "date" TIMESTAMP,
  "tavg" DOUBLE,
  "tmin" DOUBLE,
  "tmax" DOUBLE,
  "prcp" DOUBLE,
  "snow" VARCHAR,
  "wdir" BIGINT,
  "wspd" DOUBLE,
  "wpgt" VARCHAR,
  "pres" DOUBLE,
  "tsun" VARCHAR
);