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)	HDFCAMC	2308.75	2312.2	2319	2290	2300.3	162681	3745	11150	77957	47.91999816894531
Mon Feb 07 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	HDFCAMC	2300.3	2302	2304.25	2196.25	2209.7	347872	7754.68	31441	175558	50.470001220703125
Tue Feb 08 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	HDFCAMC	2209.7	2220	2227.75	2176	2209.45	276126	6081.14	21166	131185	47.5099983215332
Wed Feb 09 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	HDFCAMC	2209.45	2212	2244	2212	2232.8	201889	4506.25	21479	116575	57.7400016784668
Fri Feb 11 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	HDFCAMC	2220.9	2200	2224.05	2190.35	2211.85	252172	5572.46	17079	147408	58.459999084472656
Thu Feb 10 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	HDFCAMC	2232.8	2242.8	2245	2203.7	2220.9	204512	4546.82	21926	112716	55.11000061035156
Thu Feb 03 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	HDFCAMC	2295.3	2301.05	2333.05	2281	2308.75	354323	8190.42	21382	174694	49.29999923706055
Wed Jan 01 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	HDFCAMC	3199.7	3198.05	3214.95	3168.5	3177.4	217655	6939.18	18149	66685	30.64
Thu Jan 02 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	HDFCAMC	3177.4	3171.25	3212	3160.65	3171.8	322391	10254.92	26019	118864	36.87
Fri Jan 03 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	HDFCAMC	3171.8	3170	3218.45	3165.2	3190.3	342200	10932.53	25517	115497	33.75


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