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)	DCMSHRIRAM	1114.2	1115	1200	1111.1	1191.7	663189	7817.3	42292	168031	25.34000015258789
Mon Feb 07 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	DCMSHRIRAM	1191.7	1205.2	1224.1	1160.25	1183.75	198074	2357.72	17599	51675	26.09000015258789
Tue Feb 08 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	DCMSHRIRAM	1183.75	1171.15	1189	1125	1150.7	101345	1167.75	11775	36867	36.380001068115234
Wed Feb 09 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	DCMSHRIRAM	1150.7	1157	1165	1115.15	1131.05	94293	1069.57	10794	33713	35.75
Fri Feb 11 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	DCMSHRIRAM	1148.25	1129	1146.85	1100.05	1106.3	61187	684.2	5142	29750	48.619998931884766
Thu Feb 10 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	DCMSHRIRAM	1131.05	1139.8	1170.95	1121.6	1148.25	69759	796.93	6461	22817	32.709999084472656
Thu Feb 03 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	DCMSHRIRAM	1095.3	1095.3	1125	1095	1114.2	82291	913.26	6525	30355	36.88999938964844
Wed Jan 01 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	DCMSHRIRAM	394.9	400	414	396.35	409.5	391573	1592.53	10321	78682	20.09
Thu Jan 02 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	DCMSHRIRAM	409.5	410.1	414.25	392.2	397.55	155586	632.36	4687	52566	33.79
Fri Jan 03 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	DCMSHRIRAM	397.55	397.45	405.1	386.3	388.05	119354	470.12	4416	36562	30.63


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