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)	BAJAJFINSV	16348.1	16348	16469.35	16145	16205.75	294505	47974.12	50305	78332	26.600000381469727
Mon Feb 07 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	BAJAJFINSV	16205.75	16160	16364.05	15650	15711.35	356664	56800.65	66454	99435	27.8799991607666
Tue Feb 08 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	BAJAJFINSV	15711.35	15810	16119.8	15720	15989.15	410373	65361.09	87076	76410	18.6200008392334
Wed Feb 09 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	BAJAJFINSV	15989.15	16180	16414.9	16120	16257.8	251023	40856.23	51311	53249	21.209999084472656
Fri Feb 11 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	BAJAJFINSV	16393.6	16000	16200	15910	16113.1	244696	39407.47	49340	53305	21.780000686645508
Thu Feb 10 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	BAJAJFINSV	16257.8	16344.9	16550	16033	16393.6	299770	49068.18	58366	55925	18.65999984741211
Thu Feb 03 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	BAJAJFINSV	16706	16706	16717	16263.7	16348.1	289137	47868.47	51326	72797	25.18000030517578
Wed Jan 01 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	BAJAJFINSV	9393.35	9420	9432.45	9351.95	9378.45	63668	5976.05	7532	9700	15.24
Thu Jan 02 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	BAJAJFINSV	9378.45	9378.5	9530.95	9378.45	9505.6	157891	14959.89	13307	65379	41.41
Fri Jan 03 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	BAJAJFINSV	9505.6	9465	9504.6	9324	9345.85	182479	17144.33	21847	43650	23.92


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