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)	BSE	2191.95	2225	2249.4	2177	2220	1586695	35118.52	85966	325702	20.530000686645508
Mon Feb 07 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	BSE	2220	2225	2225	2108.85	2136.25	1217314	26192.66	74567	373334	30.670000076293945
Tue Feb 08 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	BSE	2136.25	2154	2183.15	2050.1	2077.5	1215822	25602.3	74266	324110	26.65999984741211
Wed Feb 09 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	BSE	2077.5	2090	2289.9	2015	2234.95	5277096	116058.17	279271	904352	17.139999389648438
Fri Feb 11 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	BSE	2279.1	2250	2318	2222.6	2271.4	1409962	32188.86	71170	225609	16
Thu Feb 10 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	BSE	2234.95	2253.9	2325	2250.05	2279.1	2536788	58168.57	128512	405422	15.979999542236328
Thu Feb 03 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	BSE	2078.05	2080	2219	2078.05	2191.95	2550689	55340.03	112907	562692	22.059999465942383
Wed Jan 01 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	BSE	501.45	500.5	507.1	496.7	500.85	54161	272.12	3696	27414	50.62
Thu Jan 02 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	BSE	500.85	503.8	532.5	500	522.5	255269	1330.22	8855	128912	50.5
Fri Jan 03 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	BSE	522.5	522.9	523.95	510.1	513.95	95456	491.97	4636	58101	60.87


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