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)	HUDCO	41.5	41.55	41.7	41.15	41.35	856779	354.81	3473	406922	47.4900016784668
Mon Feb 07 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	HUDCO	41.35	41.15	41.5	40.65	40.85	988645	406.8	4067	574378	58.09999847412109
Tue Feb 08 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	HUDCO	40.85	41	41.2	40.1	40.4	746537	302.42	3758	328349	43.97999954223633
Wed Feb 09 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	HUDCO	40.4	40.9	41	40.3	40.5	697759	282.88	3250	339334	48.630001068115234
Fri Feb 11 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	HUDCO	40.45	40.25	40.6	38.75	38.9	2502994	988.71	11449	1332073	53.220001220703125
Thu Feb 10 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	HUDCO	40.5	40.7	40.8	40.3	40.45	695758	281.75	2937	354562	50.959999084472656
Thu Feb 03 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	HUDCO	41.8	41.75	41.95	41.4	41.5	1189415	495.67	4367	523826	44.040000915527344
Wed Jan 01 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	HUDCO	36.05	36.25	38.8	36.15	37.55	2483055	934.26	8794	681329	27.44
Thu Jan 02 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	HUDCO	37.55	37.85	39.4	37.45	38.85	2121953	815.53	8353	674352	31.78
Fri Jan 03 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	HUDCO	38.85	38.55	39.6	38.1	38.45	1342084	518.73	5325	381680	28.44


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