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)	NETWORK18	87.75	88	88.8	85	85.45	907217	788.11	5401	382985	42.220001220703125
Mon Feb 07 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	NETWORK18	85.45	85.35	86.45	82.4	83.25	674298	569.35	4344	359002	53.2400016784668
Tue Feb 08 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	NETWORK18	83.25	84	85.7	79.3	83.6	839546	687.26	5087	377461	44.959999084472656
Wed Feb 09 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	NETWORK18	83.6	84.05	87.75	84.05	87.75	1753634	1527.1	5811	1043732	59.52000045776367
Fri Feb 11 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	NETWORK18	92.1	91.95	96	88.2	91.45	3604878	3359.11	19094	1634667	45.34999847412109
Thu Feb 10 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	NETWORK18	87.75	88	92.1	88	92.1	2310127	2095.92	10021	1350999	58.47999954223633
Thu Feb 03 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	NETWORK18	85.9	85.9	89.4	84	87.75	2143866	1875.79	10513	773947	36.09999847412109
Wed Jan 01 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	NETWORK18	24.15	24.15	24.6	23.9	24.25	35799	8.66	180
Thu Jan 02 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	NETWORK18	24.25	23.65	25.45	23.65	25.25	1101983	279.67	357
Fri Jan 03 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	NETWORK18	25.25	25.75	25.75	24.6	24.8	86120	21.73	357


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