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)	MRF	70987.15	70987	71297.5	69851.9	70006.4	11034	7757.84	7197	3842	34.81999969482422
Mon Feb 07 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	MRF	70006.4	70398.95	70421.85	68600	68798.8	12143	8413.2	7468	4795	39.4900016784668
Tue Feb 08 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	MRF	68798.8	69240	69800	68500	69426.35	11669	8079.49	7043	3605	30.88999938964844
Wed Feb 09 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	MRF	69426.35	69601	70579.85	69601	70426.6	5620	3940.16	3457	1664	29.61000061035156
Fri Feb 11 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	MRF	69769.2	69700	69700	68038.2	68233.45	15042	10327.48	9938	6299	41.880001068115234
Thu Feb 10 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	MRF	70426.6	70919.6	70919.6	69501	69769.2	14416	10084.88	8706	3106	21.549999237060547
Thu Feb 03 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	MRF	71462.45	70450	71930	70111.3	70987.15	10786	7670.01	6852	1573	14.579999923706056
Wed Jan 01 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	MRF	66330.3	66199	66944	66100	66709.05	4235	2820.64	2684	840	19.83
Thu Jan 02 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	MRF	66709.05	66709.05	67715.95	66266	67302.55	6603	4441.57	3895	2130	32.26
Fri Jan 03 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	MRF	67302.55	67400	67466.65	66250	66583.45	5527	3681.53	3873	1756	31.77


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