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)	ELGIEQUIP	404.2	397.5	419	393.85	412.8	1137373	4602.7	38405	235714	20.71999931335449
Mon Feb 07 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	ELGIEQUIP	412.8	419	421	407.85	418.35	1091075	4559.11	17961	728972	66.80999755859375
Tue Feb 08 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	ELGIEQUIP	418.35	420	422.3	390.95	406.2	461715	1860.4	17963	239989	51.97999954223633
Wed Feb 09 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	ELGIEQUIP	406.2	414	414.85	398.25	400.05	156875	631.3	9190	75404	48.06999969482422
Fri Feb 11 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	ELGIEQUIP	389.3	377.45	405	375	394.1	420204	1666.89	15594	177821	42.31999969482422
Thu Feb 10 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	ELGIEQUIP	400.05	396.05	399.45	380	389.3	582486	2273.27	11217	460532	79.05999755859375
Thu Feb 03 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	ELGIEQUIP	381.9	390	419.6	389.2	404.2	4682681	19109.12	133044	767020	16.3799991607666
Wed Jan 01 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	ELGIEQUIP	257.1	257.1	260.9	256.05	258.95	16869	43.61	408	9782	57.99
Thu Jan 02 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	ELGIEQUIP	258.95	264	284	261	274.65	185311	508.93	3631	121257	65.43
Fri Jan 03 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	ELGIEQUIP	274.65	270.4	275	269.05	274.1	42415	116.09	1005	36932	87.07


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