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)	TATASTEEL	1166.6	1173.8	1197.75	1170.25	1176.3	9317418	110320.97	212738	1565436	16.799999237060547
Mon Feb 07 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	TATASTEEL	1176.3	1168.3	1214.6	1161	1183	14510525	173301.02	321698	2468210	17.010000228881836
Tue Feb 08 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	TATASTEEL	1183	1195	1222.4	1171.5	1219.6	14083984	169366.57	316614	3087211	21.920000076293945
Wed Feb 09 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	TATASTEEL	1219.6	1231	1234	1208.15	1222.35	7352060	89680.1	167342	1841908	25.049999237060547
Fri Feb 11 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	TATASTEEL	1248.35	1239	1264.95	1233.1	1254.45	9676226	121188.83	211755	2754991	28.46999931335449
Thu Feb 10 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	TATASTEEL	1222.35	1230	1254.25	1226	1248.35	9392057	116848.1	222188	3046067	32.43000030517578
Thu Feb 03 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	TATASTEEL	1167.5	1153	1181.7	1146.3	1166.6	6514090	76194.18	151104	916256	14.06999969482422
Wed Jan 01 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	TATASTEEL	472.05	473	476.5	464.8	467.75	12100530	56847.09	80242	545190	4.51
Thu Jan 02 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	TATASTEEL	467.75	472	487.8	472	484.85	21674961	104230.6	188842	3261715	15.05
Fri Jan 03 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	TATASTEEL	484.85	483	486.2	479.45	483.7	12956863	62530.74	124603	1647867	12.72


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