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)	GODREJPROP	1667.85	1501.1	1574.8	1500.1	1506.9	8765781	134473.59	301824	2489518	28.399999618530277
Mon Feb 07 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	GODREJPROP	1506.9	1590.25	1609.7	1532.15	1561.55	5441200	85008.97	216394	1637479	30.09000015258789
Tue Feb 08 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	GODREJPROP	1561.55	1570	1579.95	1520	1551.2	1668512	25819.33	62892	465604	27.90999984741211
Wed Feb 09 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	GODREJPROP	1551.2	1560	1564	1537.95	1547.15	1037914	16103.45	46481	396511	38.20000076293945
Fri Feb 11 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	GODREJPROP	1576.7	1569.9	1580.8	1532.25	1560.45	1067208	16675.28	38358	375187	35.15999984741211
Thu Feb 10 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	GODREJPROP	1547.15	1556.65	1585	1542	1576.7	1150733	18059.91	48511	360322	31.309999465942383
Thu Feb 03 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	GODREJPROP	1782.2	1784.9	1792	1651.7	1667.85	3044456	52031.9	134300	687176	22.56999969482422
Wed Jan 01 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	GODREJPROP	988.3	991	1004	980	990.2	249292	2474.21	12943	51405	20.62
Thu Jan 02 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	GODREJPROP	990.2	988.95	988.95	955	968.45	298307	2919.71	8930	198997	66.71
Fri Jan 03 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	GODREJPROP	968.45	964	979	955.7	965.05	138815	1341.45	11813	46412	33.43


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