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)	GODREJCP	923.3	924	929.2	907.85	912.35	781566	7171.95	22548	492942	63.06999969482422
Mon Feb 07 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	GODREJCP	912.35	912	912	885.75	889.4	881015	7865.49	52542	444018	50.400001525878906
Tue Feb 08 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	GODREJCP	889.4	888	894.4	873.05	877.95	1308258	11560.57	47064	439685	33.61000061035156
Wed Feb 09 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	GODREJCP	877.95	874.95	874.95	848.05	860	1538750	13185.98	54213	799430	51.95000076293945
Fri Feb 11 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	GODREJCP	853.1	850	852	820.35	825	1853146	15327.41	52387	1236229	66.70999908447266
Thu Feb 10 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	GODREJCP	860	860.6	864.95	849.2	853.1	711095	6080.27	47198	406912	57.220001220703125
Thu Feb 03 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	GODREJCP	910.3	910.3	929.5	905.1	923.3	884886	8170.59	29538	556301	62.869998931884766
Wed Jan 01 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	GODREJCP	684.55	684.9	693.9	683.6	691.35	279887	1924.61	5933	96620	34.52
Thu Jan 02 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	GODREJCP	691.35	691	693.9	679.2	683.7	501299	3430.24	15660	207532	41.4
Fri Jan 03 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	GODREJCP	683.7	682.8	691.05	682.2	688.95	885454	6090.12	42342	505519	57.09


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