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)	KEI	1112.9	1122	1127	1094.4	1099.5	177968	1980.84	16973	101450	57
Mon Feb 07 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	KEI	1099.5	1104.9	1120.45	1082.3	1091.55	103993	1138.75	16042	41914	40.29999923706055
Tue Feb 08 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	KEI	1091.55	1110.4	1110.4	1047.3	1056.2	153491	1642.87	17102	68480	44.61000061035156
Wed Feb 09 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	KEI	1056.2	1065	1079	1018.35	1048.6	273599	2847.97	19514	133379	48.75
Fri Feb 11 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	KEI	1035.25	1040	1045.55	993.3	1003.55	431367	4331.62	15747	318175	73.76000213623047
Thu Feb 10 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	KEI	1048.6	1053.85	1056.75	1030	1035.25	74102	768.78	7550	28097	37.91999816894531
Thu Feb 03 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	KEI	1129	1136.7	1141.9	1106.35	1112.9	98429	1104.83	10623	33076	33.599998474121094
Wed Jan 01 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	KEI	458.25	464	484.35	458.25	474.95	201518	950.34	5320	59183	29.37
Thu Jan 02 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	KEI	474.95	470	477.95	469.9	473.25	97618	463.46	3234	45175	46.28
Fri Jan 03 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	KEI	473.25	474.4	474.95	465	467.4	74621	350.2	2931	33881	45.4


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