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)	ASTERDM	185.5	185.45	188.25	184.45	185.7	151882	282.66	3025	56645	37.29999923706055
Mon Feb 07 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	ASTERDM	185.7	186.5	189.25	183.75	184.2	231066	430.17	4296	98630	42.68000030517578
Tue Feb 08 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	ASTERDM	184.2	184.9	188.2	176.1	184.4	289114	531.19	8030	102356	35.400001525878906
Wed Feb 09 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	ASTERDM	184.4	192.9	196.8	188	192.95	1646400	3163.12	36427	351223	21.32999992370605
Fri Feb 11 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	ASTERDM	190.45	182.15	188.85	182	185.6	223632	416.17	5880	77933	34.849998474121094
Thu Feb 10 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	ASTERDM	192.95	192.85	194	188.95	190.45	366508	700.78	13742	117935	32.18000030517578
Thu Feb 03 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	ASTERDM	185.9	186.95	188.75	185	185.5	181103	338.54	3342	66888	36.93000030517578
Wed Jan 01 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	ASTERDM	160.75	160.7	170.95	160.7	162.7	446861	740.11	9981	162366	36.33
Thu Jan 02 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	ASTERDM	162.7	163.9	164.95	160.5	161.05	135580	220.69	6502	79409	58.57
Fri Jan 03 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	ASTERDM	161.05	160.8	165	160.8	164.1	121551	198.37	4195	93258	76.72


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