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)	COFORGE	4678.5	4675	4739	4588	4695.1	411521	19287.7	47020	94239	22.899999618530277
Mon Feb 07 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	COFORGE	4695.1	4690	4759	4613	4658.85	327157	15346.99	29775	140616	42.97999954223633
Tue Feb 08 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	COFORGE	4658.85	4677	4717	4545	4581.4	276669	12720.7	28041	93036	33.630001068115234
Wed Feb 09 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	COFORGE	4581.4	4625	4775	4610.05	4763.8	322221	15220.5	32946	103954	32.2599983215332
Fri Feb 11 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	COFORGE	4729.55	4645	4659.15	4525	4541.6	355001	16204.21	45363	142487	40.13999938964844
Thu Feb 10 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	COFORGE	4763.8	4790	4819.15	4713.5	4729.55	188286	8916.69	15886	57734	30.65999984741211
Thu Feb 03 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	COFORGE	4822.8	4829	4842	4660.05	4678.5	347569	16448.84	44071	118510	34.099998474121094
Thu Aug 20 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	COFORGE	2017.45	2000	2028	1990.45	2002.5	102303	2057.38	6617	25468	24.89
Fri Aug 21 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	COFORGE	2002.5	2009.95	2019.4	1974.15	1984.6	126598	2533.52	6214	52479	41.45
Mon Aug 24 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	COFORGE	1984.6	1988	2000	1945.4	1955.45	140538	2762.78	8461	44193	31.45


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