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)	SONATSOFTW	851.55	847.1	850.75	834	840.75	57740	485.94	6190	29177	50.52999877929688
Mon Feb 07 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	SONATSOFTW	840.75	845.9	874.75	815.5	824.45	294718	2493.4	22735	43141	14.640000343322754
Tue Feb 08 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	SONATSOFTW	824.45	839.4	839.4	805.6	810.4	90344	737.56	9333	37518	41.52999877929688
Wed Feb 09 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	SONATSOFTW	810.4	816.25	822.9	810.6	813.3	44648	363.85	4329	21296	47.70000076293945
Fri Feb 11 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	SONATSOFTW	806.25	800	806.15	766.1	777.85	134747	1060.07	9284	65331	48.47999954223633
Thu Feb 10 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	SONATSOFTW	813.3	814.9	820.45	803	806.25	63322	512.58	6372	28127	44.41999816894531
Thu Feb 03 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	SONATSOFTW	855.2	854	857	842	851.55	61100	518.44	5812	23133	37.86000061035156
Wed Jan 01 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	SONATSOFTW	309.2	310.5	315	308.45	312.8	71221	222.54	2362	26065	36.6
Thu Jan 02 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	SONATSOFTW	312.8	314	316.7	312.25	313.8	62862	197.42	4398	46187	73.47
Fri Jan 03 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	SONATSOFTW	313.8	315.7	321.85	311.15	312.85	152397	483.21	8596	71253	46.75


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