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)	MASTEK	2743.4	2731	2792	2705	2744.15	26640	733.34	4346	16081	60.36000061035156
Mon Feb 07 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	MASTEK	2744.15	2769.5	2790	2725.15	2727.35	39583	1088.79	6652	25996	65.66999816894531
Tue Feb 08 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	MASTEK	2727.35	2758.5	2758.5	2613.5	2625.95	56089	1486.95	8680	37248	66.41000366210938
Wed Feb 09 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	MASTEK	2625.95	2649	2690	2649	2680.15	31540	843.6	5796	20042	63.540000915527344
Fri Feb 11 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	MASTEK	2721.6	2704	2713	2627.6	2683.9	34945	929.26	7534	17786	50.900001525878906
Thu Feb 10 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	MASTEK	2680.15	2712	2759.95	2650	2721.6	29809	803.77	5120	14979	50.25
Thu Feb 03 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	MASTEK	2781.95	2799.95	2820	2700.5	2743.4	33767	926.66	6157	17232	51.02999877929688
Wed Jan 01 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	MASTEK	418.3	421	422	414.15	418.75	44059	184.54	2306	17241	39.13
Thu Jan 02 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	MASTEK	418.75	420	433.9	417.55	426.2	135646	579.33	4566	45367	33.45
Fri Jan 03 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	MASTEK	426.2	425.9	434.9	418.55	421	66935	286.58	3275	12870	19.23


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