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)	BLUEDART	6779.75	6780	6829.8	6608.15	6645.55	6590	441.48	2129	2947	44.720001220703125
Mon Feb 07 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	BLUEDART	6645.55	6680.5	6684.15	6405	6470.45	20572	1332	4850	7755	37.70000076293945
Tue Feb 08 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	BLUEDART	6470.45	6479	6616.45	6461.7	6500.2	15543	1013.19	4779	5685	36.58000183105469
Wed Feb 09 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	BLUEDART	6500.2	6500	6732	6496.6	6708.6	12979	859.6	3747	6051	46.619998931884766
Fri Feb 11 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	BLUEDART	6607.95	6411	6643	6411	6560.75	7816	511.82	2774	2579	33
Thu Feb 10 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	BLUEDART	6708.6	6749	6758.95	6574.65	6607.95	7831	518.23	2721	3052	38.970001220703125
Thu Feb 03 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	BLUEDART	6801.1	6830	6920	6755	6779.75	21548	1478.52	2873	15765	73.16000366210938
Wed Jan 01 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	BLUEDART	2184	2190.7	2190.7	2145	2159.9	946	20.54	280	650	68.71
Thu Jan 02 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	BLUEDART	2159.9	2160	2210	2150.1	2196.5	1816	39.84	433	1152	63.44
Fri Jan 03 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	BLUEDART	2196.5	2220	2222.4	2188	2213.25	2050	45.23	664	1428	69.66


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