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)	NHPC	29.95	30.15	30.2	29.85	29.9	2252827	675.94	7365	1256997	55.79999923706055
Mon Feb 07 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	NHPC	29.9	30	30.1	29.85	29.95	2895330	867.99	8657	1400200	48.36000061035156
Tue Feb 08 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	NHPC	29.95	29.95	30.05	29.5	29.55	3674570	1088.95	10474	2312721	62.93999862670898
Wed Feb 09 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	NHPC	29.55	29.75	29.8	29.6	29.75	2558294	759.68	8767	1624531	63.5
Fri Feb 11 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	NHPC	29.6	29.5	29.6	29.1	29.3	3409504	1003.55	8602	2213335	64.91999816894531
Thu Feb 10 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	NHPC	29.75	29.8	29.8	29.4	29.6	4339168	1283.67	9914	2273623	52.400001525878906
Thu Feb 03 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	NHPC	29.95	30	30.35	29.9	29.95	3706845	1113.72	8832	2224607	60.0099983215332
Wed Jan 01 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	NHPC	23.95	23.9	24.1	23.9	24	362729	87.12	882	167679	46.23
Thu Jan 02 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	NHPC	24	24	24.1	24	24	945076	227.12	1782	587443	62.16
Fri Jan 03 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	NHPC	24	24	24.1	24	24.05	1034706	248.56	3147	692466	66.92


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