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)	STAR	408.5	409	410.1	401.05	403.85	284385	1152.85	6795	98903	34.779998779296875
Mon Feb 07 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	STAR	403.85	401	404.45	384.6	389.7	743965	2905.31	16129	214398	28.81999969482422
Tue Feb 08 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	STAR	389.7	393	395.05	385	394.2	617840	2418.22	16056	159701	25.850000381469727
Wed Feb 09 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	STAR	394.2	396.2	399.45	390.5	395	385863	1523.33	10114	146315	37.91999816894531
Fri Feb 11 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	STAR	390.8	385	400	382.15	386.7	1337726	5236.23	25023	412110	30.809999465942383
Thu Feb 10 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	STAR	395	387.25	401.85	381.5	390.8	2980051	11605.23	53037	532557	17.8700008392334
Thu Feb 03 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	STAR	407.3	406.85	413.75	404.8	408.5	447980	1834.94	9908	103280	23.049999237060547
Wed Jan 01 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	STAR	361.95	363	363.5	358.2	361.6	118293	427.06	3506	20185	17.06
Thu Jan 02 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	STAR	361.6	361.6	377.7	361.6	375.5	384300	1427.01	6612	141470	36.81
Fri Jan 03 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	STAR	375.5	373.9	388.45	373.65	379.05	497552	1900.4	10285	92377	18.57


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