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)	KALPATPOWR	402.95	400.5	408	398.55	406.6	94425	383.27	5471	41599	44.060001373291016
Mon Feb 07 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	KALPATPOWR	406.6	408	414.95	405.3	408.45	138592	567.86	9207	62108	44.810001373291016
Tue Feb 08 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	KALPATPOWR	408.45	408	412	396.65	399.9	121901	494.83	9146	70913	58.16999816894531
Wed Feb 09 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	KALPATPOWR	399.9	398.7	411	398.7	409.4	154560	628.44	9119	108276	70.05000305175781
Fri Feb 11 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	KALPATPOWR	403.4	401.45	401.75	388	391.9	122724	484.72	11736	76887	62.650001525878906
Thu Feb 10 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	KALPATPOWR	409.4	408	408.9	400.05	403.4	70435	285.63	9222	35347	50.18000030517578
Thu Feb 03 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	KALPATPOWR	402.15	404.2	404.5	399	402.95	80626	324.52	5938	41589	51.58000183105469
Wed Jan 01 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	KALPATPOWR	410.35	415	418	408.2	412.85	40097	165.97	2830	12200	30.43
Thu Jan 02 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	KALPATPOWR	412.85	414.95	417.9	410.5	416.8	54923	227.81	3582	33486	60.97
Fri Jan 03 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	KALPATPOWR	416.8	418	424.75	415.35	420.95	62058	259.59	2946	40303	64.94


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