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)	JINDALSAW	105.05	105.7	108	103.85	104.45	1802768	1905.36	13144	484907	26.899999618530277
Mon Feb 07 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	JINDALSAW	104.45	105.05	106	103.2	104.3	1168641	1219.29	14144	408987	35
Tue Feb 08 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	JINDALSAW	104.3	104.95	105.6	100.5	101.95	1065569	1088.86	10226	270100	25.350000381469727
Wed Feb 09 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	JINDALSAW	101.95	102.7	103.55	100.7	102.15	1132943	1154.92	8296	488104	43.08000183105469
Fri Feb 11 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	JINDALSAW	101.85	101.8	102.45	99.2	100	1053905	1062.64	8450	381811	36.22999954223633
Thu Feb 10 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	JINDALSAW	102.15	102.05	103.4	101.3	101.85	1021564	1045.39	7457	313508	30.690000534057617
Thu Feb 03 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	JINDALSAW	102.25	102.8	108.4	102.75	105.05	3285317	3493.9	25123	970582	29.540000915527344
Wed Jan 01 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	JINDALSAW	73.05	73.25	86.75	73.2	85.15	8307178	6802.1	35703	1280785	15.42
Thu Jan 02 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	JINDALSAW	85.15	86.3	89.4	82.2	85.1	5118349	4409.99	28259	956110	18.68
Fri Jan 03 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	JINDALSAW	85.1	85.3	91	85.2	87.9	3589621	3182.29	27869	889872	24.79


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