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)	BHEL	60.1	60.2	60.2	58.5	58.75	25226133	14944.68	53376	5565100	22.059999465942383
Mon Feb 07 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	BHEL	58.75	58.75	59.2	57.3	57.6	26932812	15638	48317	5945130	22.06999969482422
Tue Feb 08 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	BHEL	57.6	57.9	58	55.2	55.75	41744108	23426.73	81397	10863189	26.020000457763672
Wed Feb 09 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	BHEL	55.75	56	56.5	55.2	55.7	17705304	9864.61	40035	5835897	32.959999084472656
Fri Feb 11 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	BHEL	57.05	56.5	57	55.85	56.3	13652835	7689.86	33024	3551307	26.01000022888184
Thu Feb 10 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	BHEL	55.7	56	57.45	55.6	57.05	19498660	11045.35	38583	4600409	23.59000015258789
Thu Feb 03 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	BHEL	60.35	60.4	61.05	59.7	60.1	27294506	16490.63	44032	5987711	21.940000534057617
Wed Jan 01 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	BHEL	43.45	43.5	44.1	43.25	43.5	12283581	5355.01	20548	3138229	25.55
Thu Jan 02 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	BHEL	43.5	43.75	45.85	43.5	45.4	24677041	11045.04	43357	6970568	28.25
Fri Jan 03 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	BHEL	45.4	45.4	45.65	44.3	44.6	10859861	4873.83	22406	2487436	22.9


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