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)	STARCEMENT	95.05	95.1	95.8	93.5	94.05	134431	126.96	2711	84958	63.20000076293945
Mon Feb 07 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	STARCEMENT	94.05	94.75	94.75	93.15	93.8	107830	101.06	2777	63636	59.02000045776367
Tue Feb 08 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	STARCEMENT	93.8	94	95.2	92.5	92.95	98590	92.11	3098	58149	58.97999954223633
Wed Feb 09 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	STARCEMENT	92.95	93.5	95	92.75	93.3	86926	81.17	2921	50602	58.209999084472656
Fri Feb 11 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	STARCEMENT	92.9	92.75	93.1	92	92.25	83351	76.97	1688	42360	50.81999969482422
Thu Feb 10 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	STARCEMENT	93.3	93.5	93.8	92.4	92.9	88664	82.33	2612	60311	68.0199966430664
Thu Feb 03 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	STARCEMENT	95.65	96.5	96.5	94.8	95.05	121005	115.65	2296	74600	61.650001525878906
Wed Jan 01 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	STARCEMENT	88.6	89.95	90	87.5	88.95	28391	25.32	390	20408	71.88
Thu Jan 02 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	STARCEMENT	88.95	89.75	94.55	88.35	93.4	102700	95.35	2305	55008	53.56
Fri Jan 03 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	STARCEMENT	93.4	93.75	93.8	90.1	91.05	49385	45.45	991	29450	59.63


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