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)	CSBBANK	257	257	262	256.35	260.2	119688	311.47	2939	60948	50.91999816894531
Mon Feb 07 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	CSBBANK	260.2	260.2	263.6	256.75	259	129531	336.34	3084	62929	48.58000183105469
Tue Feb 08 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	CSBBANK	259	259	260.3	247.1	250.15	103563	262.56	4172	48025	46.369998931884766
Wed Feb 09 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	CSBBANK	250.15	251.8	255	249.45	252	138913	350.56	3508	36794	26.489999771118164
Fri Feb 11 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	CSBBANK	258.6	253	255.6	249.1	250.1	86543	217.98	2595	40474	46.77000045776367
Thu Feb 10 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	CSBBANK	252	253	260	253	258.6	183136	471.53	6651	63800	34.84000015258789
Thu Feb 03 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	CSBBANK	262.65	263	263.6	254.15	257	187746	484.07	4001	84613	45.06999969482422
Wed Jan 01 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	CSBBANK	216.45	215	218.75	206.2	206.9	873909	1837.68	13863	305216	34.93
Thu Jan 02 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	CSBBANK	206.9	206.5	217.95	206.5	211.3	1329504	2828.19	19730	364975	27.45
Fri Jan 03 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	CSBBANK	211.3	211.3	211.3	206.3	208.05	538331	1121.51	13149	159154	29.56


CREATE TABLE csbbank (
  "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
);