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)	GLAND	3579.5	3598	3598	3500	3513.95	77655	2751.26	17853	38450	49.5099983215332
Mon Feb 07 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	GLAND	3513.95	3506	3541.2	3414.2	3483.15	69246	2411.57	14752	24518	35.40999984741211
Tue Feb 08 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	GLAND	3483.15	3476.85	3500	3373.35	3467.35	85739	2949.31	15847	32340	37.720001220703125
Wed Feb 09 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	GLAND	3467.35	3435.8	3598	3435.8	3533.8	114116	4060.86	15935	58572	51.33000183105469
Fri Feb 11 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	GLAND	3454.65	3439.95	3594.7	3413.4	3543.15	200387	7113.77	32358	73151	36.5
Thu Feb 10 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	GLAND	3533.8	3549	3549	3430	3454.65	193850	6707.03	24259	119477	61.630001068115234
Thu Feb 03 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	GLAND	3474.35	3491	3597	3439.6	3579.5	148365	5214.34	34174	70410	47.459999084472656
Fri Nov 20 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	GLAND	1500	1710	1850	1700	1819.55	11310647	199698.03	405609	6362366	56.25
Mon Nov 23 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	GLAND	1819.55	1844	2183.45	1840	2089.05	3893237	80605.29	192919	1037982	26.66
Tue Nov 24 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	GLAND	2089.05	2110	2174.8	1960.2	2048.5	1961368	40255.33	137870	585146	29.83


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