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)	UJJIVANSFB	19.35	19.5	19.85	19.4	19.65	2117403	414.49	4266	1049415	49.560001373291016
Mon Feb 07 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	UJJIVANSFB	19.65	20	20.15	19.05	19.15	2289199	443.14	6908	1287265	56.22999954223633
Tue Feb 08 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	UJJIVANSFB	19.15	19.15	19.4	18.75	18.95	1452439	276.29	4607	732689	50.45000076293945
Wed Feb 09 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	UJJIVANSFB	18.95	18.85	19.1	18.85	18.9	1193824	226.36	3430	613140	51.36000061035156
Fri Feb 11 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	UJJIVANSFB	18.85	18.8	19	18.65	18.7	1216447	227.9	3483	819464	67.37000274658203
Thu Feb 10 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	UJJIVANSFB	18.9	18.95	19.1	18.75	18.85	1672122	315.38	3644	991533	59.29999923706055
Thu Feb 03 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	UJJIVANSFB	19.15	19.2	19.6	19.15	19.35	1549270	300.19	4169	667482	43.08000183105469
Wed Jan 01 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	UJJIVANSFB	53.85	53.85	54.2	52.9	53.05	3369319	1797.96	13576	1584289	47.02
Thu Jan 02 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	UJJIVANSFB	53.05	53.3	57.25	52.9	55.6	10788226	5965.09	36485	3208500	29.74
Fri Jan 03 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	UJJIVANSFB	55.6	55.6	56.2	54.65	54.9	3802527	2101.81	13900	1238629	32.57


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