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)	KEC	520	520	529.25	518.05	525.1	259969	1365.4	11731	107409	41.31999969482422
Mon Feb 07 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	KEC	525.1	534	549.5	509.05	520.2	620685	3345.51	21425	159695	25.729999542236328
Tue Feb 08 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	KEC	520.2	524.8	526.95	504.55	508.9	163290	844.33	7654	33708	20.63999938964844
Wed Feb 09 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	KEC	508.9	512	515.8	503.25	506.5	77557	395.19	4019	27774	35.810001373291016
Fri Feb 11 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	KEC	516.45	514	514.1	495	500.25	69287	349.57	4016	26264	37.90999984741211
Thu Feb 10 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	KEC	506.5	510.5	518.3	502.5	516.45	100777	516.66	5202	32256	32.0099983215332
Thu Feb 03 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	KEC	516.8	516.8	522	516.8	520	207192	1076.82	6367	106423	51.36000061035156
Wed Jan 01 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	KEC	302.05	302.1	305.65	302.1	304.5	291679	886.66	5089	221201	75.84
Thu Jan 02 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	KEC	304.5	306	324.8	304.8	310.55	981219	3082.88	13921	302329	30.81
Fri Jan 03 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	KEC	310.55	310.9	314.2	307.25	311.45	262781	817.32	5334	97257	37.01


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