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)	SWSOLAR	395.15	395.15	395.5	386.25	387.6	309478	1208.2	12153	162273	52.43000030517578
Mon Feb 07 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	SWSOLAR	387.6	388	389.85	375	377.9	487724	1855.16	15437	228062	46.7599983215332
Tue Feb 08 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	SWSOLAR	377.9	380.25	381.9	371.35	374.65	402799	1513.93	11060	172704	42.880001068115234
Wed Feb 09 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	SWSOLAR	374.65	377	379.45	373.1	374.5	274833	1031.57	7222	166802	60.68999862670898
Fri Feb 11 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	SWSOLAR	372.05	371	377.95	369.4	371.25	458491	1714.55	10921	171989	37.5099983215332
Thu Feb 10 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	SWSOLAR	374.5	380	385.7	368.5	372.05	1008547	3797.19	19299	478496	47.43999862670898
Thu Feb 03 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	SWSOLAR	400.6	401	402.9	394.2	395.15	315564	1254.21	8257	150978	47.84000015258789
Wed Jan 01 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	SWSOLAR	323.3	335	339.45	318.15	331.75	1093435	3612.38	10398	616842	56.41
Thu Jan 02 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	SWSOLAR	331.75	333.1	337.6	325	331.5	214273	709.99	3961	131801	61.51
Fri Jan 03 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	SWSOLAR	331.5	332	333.45	316	317.6	226140	726.27	3784	136319	60.28


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