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)	HAPPSTMNDS	1159.4	1152.8	1160.05	1147	1150.65	142312	1641.08	12124	99326	69.79000091552734
Mon Feb 07 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	HAPPSTMNDS	1150.65	1150.65	1154.8	1100	1123.6	261888	2935.04	30690	171490	65.4800033569336
Tue Feb 08 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	HAPPSTMNDS	1123.6	1122.9	1130	1080	1091.1	406480	4445.22	45347	270928	66.6500015258789
Wed Feb 09 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	HAPPSTMNDS	1091.1	1100	1115.45	1091	1096.5	138479	1521.51	13041	90949	65.68000030517578
Fri Feb 11 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	HAPPSTMNDS	1082.3	1070	1078.95	1051.1	1070.4	174552	1868.32	19177	111120	63.65999984741211
Thu Feb 10 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	HAPPSTMNDS	1096.5	1100	1104.45	1063	1082.3	280410	3022.44	29035	170591	60.84000015258789
Thu Feb 03 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	HAPPSTMNDS	1187.05	1194.8	1194.8	1150	1159.4	187294	2187.1	17921	124255	66.33999633789062
Thu Sep 17 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	HAPPSTMNDS	166	350	394.95	350	370.95	52002289	194109.97	828185	19037078	36.61
Fri Sep 18 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	HAPPSTMNDS	370.95	376	380.95	357	358.7	10745573	39383.04	216555	3106798	28.91
Mon Sep 21 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	HAPPSTMNDS	358.7	354	374.5	330.3	349.4	12520549	44234.15	207865	2729573	21.8


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