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)	NCC	74.95	75.15	75.4	73.8	73.95	2354614	1751.31	9557	1012720	43.0099983215332
Mon Feb 07 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	NCC	73.95	73.8	74.5	73	73.75	2076696	1529.12	9196	857165	41.27999877929688
Tue Feb 08 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	NCC	73.75	74.15	75.1	71.3	72	4407128	3213.42	22155	1453405	32.97999954223633
Wed Feb 09 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	NCC	72	71.65	72.45	70.5	71.15	3905742	2782.32	46315	2284878	58.5
Fri Feb 11 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	NCC	71.05	70.5	71	70.05	70.45	2425693	1709	19978	1237938	51.02999877929688
Thu Feb 10 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	NCC	71.15	71.55	71.7	70.25	71.05	2923709	2074.82	22564	1409240	48.20000076293945
Thu Feb 03 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	NCC	75.05	75.35	75.85	74.55	74.95	2369331	1779.34	9197	843906	35.619998931884766
Wed Jan 01 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	NCC	56	56	56.2	54.75	55	9941641	5495.25	19037	1238411	12.46
Thu Jan 02 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	NCC	55	55	58.8	55	58.45	18742116	10743.28	37089	3528122	18.82
Fri Jan 03 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	NCC	58.45	58.05	59.2	57.35	58.1	17243630	10053.06	31796	2198540	12.75


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