NIFTY ALL STOCK Dataset

date Date	symbol Symbol	pre_close Pre Close	open Open	high High	low Low	close Close	volume Volume	turnover_lacs Turnover Lacs	no_of_trades No Of Trades	deliv_volume Deliv Volume	deliv Deliv %
Fri Feb 04 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	ITC	234.45	237.25	238.5	231.55	234.3	56705951	133350.87	326999	24798688	43.72999954223633
Mon Feb 07 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	ITC	234.3	234	234.75	228.5	230.2	24171083	55778.57	140323	12817471	53.02999877929688
Tue Feb 08 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	ITC	230.2	230.3	232.3	229.05	231.25	16201280	37363.25	117574	8911274	55
Wed Feb 09 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	ITC	231.25	232.3	233	228.75	230.15	11893807	27418.57	96037	5358292	45.04999923706055
Fri Feb 11 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	ITC	232.25	232	233.3	229.8	232.45	18096561	41921.37	103557	11334540	62.630001068115234
Thu Feb 10 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	ITC	230.15	228.7	233.4	227.75	232.25	19563580	45098.98	128409	11230132	57.400001525878906
Thu Feb 03 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	ITC	232.15	232.15	235.2	231.8	234.45	27845963	65059.14	192214	11700940	42.02000045776367
Wed Jan 01 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	ITC	237.7	238.6	238.6	237.1	238.1	4208837	10010.78	38576	1848314	43.92
Thu Jan 02 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	ITC	238.1	238.2	240.95	238.1	239.85	8402979	20142.41	84223	5619818	66.88
Fri Jan 03 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	ITC	239.85	241	241	238	238.5	9284478	22158.53	64049	6344169	68.33


CREATE TABLE itc (
  "date" TIMESTAMP,
  "symbol" VARCHAR,
  "pre_close" DOUBLE,
  "open" DOUBLE,
  "high" DOUBLE,
  "low" DOUBLE,
  "close" DOUBLE,
  "volume" BIGINT,
  "turnover_lacs" DOUBLE,
  "no_of_trades" BIGINT,
  "deliv_volume" DOUBLE,
  "deliv" DOUBLE
);