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)	NLCINDIA	67	67.2	70.8	67.2	68.1	5917089	4082.51	24065	1460334	24.68000030517578
Mon Feb 07 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	NLCINDIA	68.1	69.1	74.2	69.1	73.65	17039415	12318.65	55875	6309493	37.02999877929688
Tue Feb 08 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	NLCINDIA	73.65	74.5	75	70.9	72.8	7300553	5326.46	31286	2463308	33.7400016784668
Wed Feb 09 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	NLCINDIA	72.8	72.95	73.3	71.4	71.65	2762641	1988.52	15128	1290667	46.720001220703125
Fri Feb 11 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	NLCINDIA	72.95	73.2	77.5	72.85	75.85	16973125	12853.32	65912	5612139	33.060001373291016
Thu Feb 10 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	NLCINDIA	71.65	72	74.3	71.2	72.95	4262527	3104.23	18631	1534087	35.9900016784668
Thu Feb 03 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	NLCINDIA	68.25	68.65	68.75	64.1	67	2375394	1611.71	11634	972155	40.93000030517578
Wed Jan 01 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	NLCINDIA	57.15	57.5	58.4	56.65	57.25	732504	420.47	4352	401305	54.79
Thu Jan 02 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	NLCINDIA	57.25	57.3	58.8	57.05	58	458791	265.99	3227	256276	55.86
Fri Jan 03 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	NLCINDIA	58	58.25	58.85	57.25	57.6	270671	157.05	2855	152278	56.26


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