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)	MRPL	47.7	48.15	48.85	47.1	47.45	2765007	1328.06	10879	1138554	41.18000030517578
Mon Feb 07 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	MRPL	47.45	47.2	48.65	46.95	47.85	1367866	653.5	7811	561627	41.060001373291016
Tue Feb 08 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	MRPL	47.85	47.85	48.15	46.25	46.95	1214226	571.79	6125	512377	42.20000076293945
Wed Feb 09 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	MRPL	46.95	47.1	47.8	46.3	46.85	868348	408.57	5007	284787	32.79999923706055
Fri Feb 11 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	MRPL	46.3	45.75	46.7	45.65	46	786439	362.59	3972	340663	43.31999969482422
Thu Feb 10 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	MRPL	46.85	46.8	47.5	46	46.3	846967	394.81	4349	352220	41.59000015258789
Thu Feb 03 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	MRPL	46.4	46.4	49	46.2	47.7	4828308	2311.52	18555	1865180	38.630001068115234
Wed Jan 01 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	MRPL	44.95	45	45.15	43.4	43.7	263049	116.05	2329	152433	57.95
Thu Jan 02 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	MRPL	43.7	44.1	44.4	42.9	44	437588	191.66	2545	263898	60.31
Fri Jan 03 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	MRPL	44	43.7	44.5	43.7	43.95	280877	123.69	1517	120771	43


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