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)	MAHABANK	21	21.05	21.15	20.4	20.55	4320692	899.72	6660	1889022	43.720001220703125
Mon Feb 07 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	MAHABANK	20.55	20.5	21	20.05	20.3	4598812	947.2	7185	1539180	33.470001220703125
Tue Feb 08 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	MAHABANK	20.3	20.4	20.55	19.9	20.15	3737874	755.41	5946	1222470	32.70000076293945
Wed Feb 09 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	MAHABANK	20.15	20.3	20.6	20.1	20.2	2501753	506.97	3855	970301	38.77999877929688
Fri Feb 11 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	MAHABANK	20.1	20	20.1	19.7	19.8	2644697	526.47	4911	1626713	61.5099983215332
Thu Feb 10 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	MAHABANK	20.2	20.3	20.45	20.05	20.1	2959514	598.73	4498	1418234	47.91999816894531
Thu Feb 03 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	MAHABANK	21.3	21.45	21.95	20.9	21	16731852	3564.33	15013	5444298	32.540000915527344
Wed Jan 01 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	MAHABANK	12.9	12.8	13	12.7	12.9	252522	32.53	620	143987	57.02
Thu Jan 02 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	MAHABANK	12.9	12.95	13.2	12.85	12.95	432532	56.17	1110	257724	59.58
Fri Jan 03 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	MAHABANK	12.95	13	13.05	12.8	12.85	470447	60.72	875	327642	69.64


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