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)	JMFINANCIL	73.45	73.45	74.3	72.6	72.7	339833	249.17	3314	179124	52.709999084472656
Mon Feb 07 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	JMFINANCIL	72.7	73	73.9	72.05	73.4	436110	318.11	4279	230943	52.959999084472656
Tue Feb 08 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	JMFINANCIL	73.4	74.3	74.3	70.35	71.05	1343268	961.55	10185	523120	38.93999862670898
Wed Feb 09 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	JMFINANCIL	71.05	70.85	72.3	70.85	71.8	482211	345.45	3664	216919	44.97999954223633
Fri Feb 11 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	JMFINANCIL	71.6	71	71.9	69.75	70	768967	542.62	7241	467037	60.7400016784668
Thu Feb 10 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	JMFINANCIL	71.8	72.5	73.7	71.3	71.6	901262	651.13	10675	426763	47.34999847412109
Thu Feb 03 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	JMFINANCIL	73	73.2	74.65	72.75	73.45	576248	424.73	5359	253912	44.060001373291016
Wed Jan 01 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	JMFINANCIL	94.2	94.4	94.65	91.4	91.85	249907	232.14	2356	119903	47.98
Thu Jan 02 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	JMFINANCIL	91.85	91.8	95.1	90.5	94.45	772251	723.84	6892	259899	33.65
Fri Jan 03 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	JMFINANCIL	94.45	93.7	95	88.5	90.65	879520	816.6	8737	454522	51.68


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