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)	WABCOINDIA	8121.9	8165	8180.8	8074	8091.6	1044	84.6	435	612	58.619998931884766
Mon Feb 07 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	WABCOINDIA	8091.6	7979.8	8135.75	7926.95	7990.75	1459	116.86	544	814	55.790000915527344
Tue Feb 08 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	WABCOINDIA	7990.75	8150	8150	7960	7998.3	1798	143.83	308	1523	84.70999908447266
Wed Feb 09 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	WABCOINDIA	7998.3	8139	8139	7851	7985.55	4614	366.08	2268	2875	62.310001373291016
Fri Feb 11 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	WABCOINDIA	7855.55	7827.75	7937.45	7685	7697.7	1236	95.75	561	664	53.720001220703125
Thu Feb 10 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	WABCOINDIA	7985.55	7927	8000	7805	7855.55	3458	273.46	1572	2740	79.23999786376953
Thu Feb 03 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	WABCOINDIA	8040.95	8161.55	8161.55	8001	8121.9	4420	357.76	1166	2674	60.5
Wed Jan 01 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	WABCOINDIA	6481.15	6475	6570	6430	6517.05	4995	323.86	649	3715	74.37
Thu Jan 02 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	WABCOINDIA	6517.05	6517	6599	6511.8	6585.65	2117	139.01	399	1344	63.49
Fri Jan 03 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	WABCOINDIA	6585.65	6595	6604.95	6554	6596.9	3768	248.52	532	2988	79.3


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