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)	DLF	403.25	405	407.25	396.6	399.5	4128681	16567.48	52310	592773	14.359999656677246
Mon Feb 07 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	DLF	399.5	399.8	401.55	385.4	387.15	4851736	18970.79	62727	1109796	22.8700008392334
Tue Feb 08 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	DLF	387.15	388.8	391.9	376.4	384.55	5011220	19198.1	63306	1556642	31.059999465942383
Wed Feb 09 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	DLF	384.55	387.5	391.65	385.2	386.35	3351979	12985.61	36596	1197255	35.720001220703125
Fri Feb 11 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	DLF	391.15	386.5	388.75	377.1	378.6	4872433	18594.59	56233	1536165	31.530000686645508
Thu Feb 10 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	DLF	386.35	388.8	394.6	382	391.15	4747069	18498.9	49850	1739056	36.630001068115234
Thu Feb 03 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	DLF	399.55	400.4	409.75	398.75	403.25	8273002	33405.23	92156	1206536	14.579999923706056
Wed Jan 01 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	DLF	230.9	231.4	232.15	227.1	227.55	3761160	8605.82	22409	668092	17.76
Thu Jan 02 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	DLF	227.55	227.5	234.4	226.5	233.75	4513308	10429.2	26456	818948	18.15
Fri Jan 03 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	DLF	233.75	232.65	233.7	227.05	228.6	4289982	9865.59	32321	821709	19.15


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