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)	MGL	851.15	852.7	858.9	841	842.5	324250	2755.73	10548	123920	38.220001220703125
Mon Feb 07 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	MGL	842.5	848	849.1	830	832.5	293792	2464.86	13089	144029	49.02000045776367
Tue Feb 08 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	MGL	832.5	835	836.65	817.3	828.85	517859	4284.81	13794	260901	50.380001068115234
Wed Feb 09 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	MGL	828.85	799.95	812	781.05	799.3	2253223	17948.15	74006	722238	32.04999923706055
Fri Feb 11 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	MGL	793.3	786	808.95	783.1	798.9	1077916	8636.19	27395	572947	53.150001525878906
Thu Feb 10 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	MGL	799.3	805	805	791.4	793.3	584987	4658.99	19909	308288	52.70000076293945
Thu Feb 03 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	MGL	847	850	854.95	842.2	851.15	300091	2552.11	10776	77233	25.739999771118164
Wed Jan 01 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	MGL	1065.2	1063.85	1071.65	1061.45	1066.1	225628	2403.72	5617	75496	33.46
Thu Jan 02 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	MGL	1066.1	1069.9	1074.4	1061	1063.85	229512	2448.55	6975	89047	38.8
Fri Jan 03 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	MGL	1063.85	1070	1070	1052.6	1060.15	297783	3159.01	9340	94617	31.77


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