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)	TORNTPOWER	539.85	543.5	589.9	543.1	580.35	7770569	44756.92	116607	1249804	16.079999923706055
Mon Feb 07 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	TORNTPOWER	580.35	577	578	522.35	524.1	3768139	20426.36	63854	811816	21.540000915527344
Tue Feb 08 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	TORNTPOWER	524.1	526	535.05	505.2	510.1	3109561	16029.61	61394	340730	10.960000038146973
Wed Feb 09 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	TORNTPOWER	510.1	514.8	522.45	503.85	512.35	1220257	6239.5	20065	134662	11.039999961853027
Fri Feb 11 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	TORNTPOWER	506.2	505.8	511.8	491.2	495.4	1400187	7057.94	27326	224636	16.040000915527344
Thu Feb 10 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	TORNTPOWER	512.35	508.8	511.45	500.5	506.2	917329	4643.7	19555	144259	15.729999542236328
Thu Feb 03 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	TORNTPOWER	546.3	546	547.5	537.3	539.85	266058	1443.06	7472	83600	31.420000076293945
Wed Jan 01 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	TORNTPOWER	284	284	286.8	282.4	285.55	263594	750.75	2535	42934	16.29
Thu Jan 02 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	TORNTPOWER	285.55	287	290	285.5	288.3	438931	1261.45	4466	100109	22.81
Fri Jan 03 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	TORNTPOWER	288.3	288.3	293.3	286.3	288.65	1799065	5219.29	16139	354388	19.7


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