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)	TATAPOWER	252.85	253.8	257.9	253	254.35	39309420	100447.58	223643	7183610	18.270000457763672
Mon Feb 07 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	TATAPOWER	254.35	255.5	256.7	250.55	251.8	32770930	83201.6	195588	6647485	20.280000686645508
Tue Feb 08 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	TATAPOWER	251.8	252.5	253.6	232.6	234.85	82053977	195435.68	539522	22031262	26.850000381469727
Wed Feb 09 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	TATAPOWER	234.85	236.7	238.9	232.6	238	35604075	84208.58	248213	7677656	21.559999465942383
Fri Feb 11 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	TATAPOWER	241.3	240	242.05	230.2	232.3	36050888	85405.66	239698	10531107	29.209999084472656
Thu Feb 10 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	TATAPOWER	238	238.5	244.5	234.1	241.3	55153254	132812.89	318356	8783495	15.93000030517578
Thu Feb 03 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	TATAPOWER	250.6	250.55	254.4	249.3	252.85	27724870	69787.67	156181	5649413	20.3799991607666
Wed Jan 01 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	TATAPOWER	56.5	56.8	57.85	56.65	57.6	3878107	2221.39	10437	913336	23.55
Thu Jan 02 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	TATAPOWER	57.6	57.9	58.15	56.8	58	12142359	6978.76	43097	5942670	48.94
Fri Jan 03 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	TATAPOWER	58	58	58.55	57.3	57.75	9746134	5638.95	23266	3939492	40.42


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