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)	BDL	503.3	505.1	505.3	489.35	494.05	682438	3382.62	15663	332656	48.75
Mon Feb 07 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	BDL	494.05	496	501.95	477.5	490.25	407628	2000.6	18155	96869	23.76000022888184
Tue Feb 08 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	BDL	490.25	492.7	495	466.15	472.6	225522	1082.35	11335	71015	31.489999771118164
Wed Feb 09 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	BDL	472.6	474.4	481.95	471.5	473.8	289658	1375.15	9404	145023	50.06999969482422
Fri Feb 11 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	BDL	464.05	460	462.7	450.1	452.15	157862	718.8	6137	61168	38.75
Thu Feb 10 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	BDL	473.8	476.2	476.2	461	464.05	239475	1120.73	6951	113696	47.47999954223633
Thu Feb 03 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	BDL	487.4	516.9	536.3	498	503.3	3463965	17943.74	87366	463841	13.390000343322754
Wed Jan 01 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	BDL	294.45	295	302	291.85	297.85	31747	94.67	2019	13266	41.79
Thu Jan 02 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	BDL	297.85	297	310.5	297	306.25	80141	244.61	3557	35818	44.69
Fri Jan 03 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	BDL	306.25	307.5	309.9	300	303.9	54749	167.78	2938	27616	50.44


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