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)	NTPC	136.65	137	137.45	133.9	134.2	7213085	9770.41	73982	3512615	48.70000076293945
Mon Feb 07 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	NTPC	134.2	134.2	136.35	134.2	135.15	10562489	14306.19	71704	5546304	52.5099983215332
Tue Feb 08 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	NTPC	135.15	135.45	135.65	132.8	135	8721631	11710.96	75003	3836564	43.9900016784668
Wed Feb 09 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	NTPC	135	135.3	135.6	133.85	135.05	5144026	6943.37	57888	2482125	48.25
Fri Feb 11 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	NTPC	136.45	134.45	137.7	134.45	137.15	8426925	11536.02	64483	4350965	51.630001068115234
Thu Feb 10 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	NTPC	135.05	135.15	136.85	134.3	136.45	6081460	8285.49	74376	3179686	52.27999877929688
Thu Feb 03 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	NTPC	141.15	137.5	138.6	136.3	136.65	9571728	13143.3	81773	4074328	42.56999969482422
Wed Jan 01 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	NTPC	119.05	119.05	122	118.25	121.55	9953746	12011.43	45323	4352709	43.73
Thu Jan 02 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	NTPC	121.55	121.5	122.15	120.6	121.4	8731299	10611.95	46881	5298030	60.68
Fri Jan 03 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	NTPC	121.4	121	121.35	119.1	119.35	7392962	8881.59	41213	4745388	64.19


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