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)	MCDOWELL-N	887.7	886.1	893.9	876.35	885.15	548582	4860.15	17637	168184	30.65999984741211
Mon Feb 07 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	MCDOWELL-N	885.15	885.15	888.1	852.1	855.9	1952437	16837.12	34087	964623	49.40999984741211
Tue Feb 08 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	MCDOWELL-N	855.9	856	865.95	843.25	847.8	1534006	13082.19	26932	603575	39.34999847412109
Wed Feb 09 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	MCDOWELL-N	847.8	848.25	865.95	848.25	854.6	1010236	8666.87	23122	565680	55.9900016784668
Fri Feb 11 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	MCDOWELL-N	861.35	862	862	840.65	844.3	1515571	12885.23	53454	837149	55.2400016784668
Thu Feb 10 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	MCDOWELL-N	854.6	858.7	864.95	843.6	861.35	820059	7015.03	25750	383530	46.77000045776367
Thu Feb 03 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	MCDOWELL-N	887.05	891.8	896.85	881	887.7	969604	8618.83	23268	291122	30.020000457763672
Wed Jan 01 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	MCDOWELL-N	599.55	601	602.7	595.8	596.9	372494	2232.11	7352	65381	17.55
Thu Jan 02 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	MCDOWELL-N	596.9	598.3	599.4	589.45	593.7	448857	2663.8	11860	128459	28.62
Fri Jan 03 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	MCDOWELL-N	593.7	591.5	593	580.1	583.05	1179798	6903.31	30997	660846	56.01


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