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)	MANAPPURAM	157.7	157.55	159.8	156.25	157.1	2313152	3648.78	16236	813334	35.15999984741211
Mon Feb 07 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	MANAPPURAM	157.1	157.4	157.9	154.4	155.25	3529098	5501.86	19274	834802	23.649999618530277
Tue Feb 08 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	MANAPPURAM	155.25	156.45	160.4	154.4	159.1	4760610	7522.43	24872	1512795	31.780000686645508
Wed Feb 09 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	MANAPPURAM	159.1	160.15	161	157.4	158.35	2646012	4199.96	18719	1124654	42.5
Fri Feb 11 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	MANAPPURAM	159	158.1	158.25	152	152.75	4735593	7322.99	29737	1497529	31.6200008392334
Thu Feb 10 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	MANAPPURAM	158.35	159.15	160.3	157	159	1496525	2379.12	11156	480308	32.09000015258789
Thu Feb 03 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	MANAPPURAM	159.8	160.3	160.95	157.1	157.7	1470097	2328.97	16450	569381	38.72999954223633
Wed Jan 01 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	MANAPPURAM	177.4	178	178.65	175.5	177.25	1531363	2711.31	8310	231796	15.14
Thu Jan 02 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	MANAPPURAM	177.25	177.15	180.35	177.05	178.8	1916321	3430.21	13616	431846	22.54
Fri Jan 03 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	MANAPPURAM	178.8	179.7	179.7	175.6	176.95	1742423	3086.61	10353	362984	20.83


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