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)	TATAMOTORS	504.5	503.8	507.8	499	500.6	12663199	63722.05	159322	2163696	17.09000015258789
Mon Feb 07 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	TATAMOTORS	500.6	502.9	504.35	492.5	494.6	13392910	66547.2	183916	2618801	19.549999237060547
Tue Feb 08 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	TATAMOTORS	494.6	498	498.5	479.15	492.75	23378623	114376.54	339842	4645516	19.8700008392334
Wed Feb 09 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	TATAMOTORS	492.75	496.5	503.7	494.7	501.25	12430730	62195.89	146963	3041913	24.46999931335449
Fri Feb 11 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	TATAMOTORS	507.45	503.25	507	497	498.85	13534899	67839.91	144160	3610241	26.670000076293945
Thu Feb 10 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	TATAMOTORS	501.25	506.7	510.5	504.2	507.45	14537945	73828.08	203341	4626324	31.81999969482422
Thu Feb 03 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	TATAMOTORS	506.4	509.1	514.3	502.85	504.5	15249245	77663.88	169805	3349208	21.959999084472656
Wed Jan 01 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	TATAMOTORS	185.15	185.15	186.7	183.6	184.45	25968357	48069.46	99072	1878537	7.23
Thu Jan 02 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	TATAMOTORS	184.45	185	194.7	184.6	193.75	57289863	109175.49	251258	9368491	16.35
Fri Jan 03 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	TATAMOTORS	193.75	192.9	195.65	189.25	191.1	47572728	91341.4	185614	4181757	8.79


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