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)	KRBL	240.85	241.55	241.55	235.85	237.15	144930	346.14	3325	65788	45.38999938964844
Mon Feb 07 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	KRBL	237.15	237.2	240.45	231	232.5	297600	697.05	5382	155151	52.130001068115234
Tue Feb 08 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	KRBL	232.5	234.1	236	229.2	232.45	200616	465.31	3844	73664	36.720001220703125
Wed Feb 09 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	KRBL	232.45	233.6	236	228	230.05	298680	692.1	5567	145922	48.86000061035156
Fri Feb 11 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	KRBL	228.05	226.7	229.45	226.3	228.25	188232	429.52	3426	84828	45.06999969482422
Thu Feb 10 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	KRBL	230.05	230.9	233.5	227.2	228.05	449772	1034.2	6213	193379	42.9900016784668
Thu Feb 03 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	KRBL	242.75	242	245	240	240.85	147352	356.23	2952	56372	38.2599983215332
Wed Jan 01 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	KRBL	285.35	285	289.9	282.35	283.15	95792	272.62	2402	34509	36.02
Thu Jan 02 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	KRBL	283.15	284.9	307.4	283	290.7	716569	2129.25	13288	130532	18.22
Fri Jan 03 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	KRBL	290.7	290.8	296	287.5	288.6	170708	498.8	4196	60818	35.63


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