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)	HEMIPROP	135.5	136.3	136.95	132.9	133.75	836258	1128.39	8080	404041	48.31999969482422
Mon Feb 07 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	HEMIPROP	133.75	133.35	134.8	130.5	131.1	1788921	2359.69	9602	1380531	77.16999816894531
Tue Feb 08 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	HEMIPROP	131.1	132	132.75	125.65	128.6	1274730	1640.96	12973	661457	51.88999938964844
Wed Feb 09 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	HEMIPROP	128.6	129.7	133.25	127.8	129.45	1106505	1442.68	10237	412528	37.27999877929688
Fri Feb 11 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	HEMIPROP	128.85	128.75	129.8	126.85	127.65	702369	899.61	6995	332086	47.27999877929688
Thu Feb 10 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	HEMIPROP	129.45	130	130.9	128.1	128.85	704457	913.35	7449	342481	48.619998931884766
Thu Feb 03 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	HEMIPROP	137.15	137.6	138.7	134.6	135.5	951295	1302.01	8284	438832	46.130001068115234
Thu Oct 22 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	HEMIPROP	426.8	97	97	92.15	92.15	254790	236.43	1591
Fri Oct 23 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	HEMIPROP	92.15	87.55	87.55	87.55	87.55	39370	34.47	336
Mon Oct 26 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	HEMIPROP	87.55	83.2	83.2	83.2	83.2	22653	18.85	224


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