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)	HATHWAY	22.6	22.8	23.15	22.3	22.45	5674030	1288.55	10170	2042767	36
Mon Feb 07 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	HATHWAY	22.45	22.5	22.75	21.75	22	4130870	917.57	8961	1770484	42.86000061035156
Tue Feb 08 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	HATHWAY	22	22.2	22.3	21.75	21.9	3561384	781.75	6708	1619957	45.4900016784668
Wed Feb 09 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	HATHWAY	21.9	21.95	22.7	21.8	21.9	7492927	1660.8	10195	2806806	37.459999084472656
Fri Feb 11 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	HATHWAY	21.95	21.8	22.45	21.6	21.7	9156476	2018.32	10699	3013896	32.91999816894531
Thu Feb 10 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	HATHWAY	21.9	22	22.65	21.9	21.95	13846836	3072.88	13352	3866885	27.93000030517578
Thu Feb 03 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	HATHWAY	21.5	21.6	23	21.4	22.6	16403674	3674.82	20128	5735590	34.970001220703125
Wed Jan 01 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	HATHWAY	20.15	20.15	20.45	19.55	19.8	93143	18.71	459	51880	55.7
Thu Jan 02 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	HATHWAY	19.8	19.6	20.1	19.35	19.8	146612	29	770	66401	45.29
Fri Jan 03 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	HATHWAY	19.8	19.5	21.9	18.65	19	14617942	2869.3	7288	12057046	82.48


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