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)	EDELWEISS	68.5	69	69	67.8	67.95	516050	351.78	6003	333451	64.62000274658203
Mon Feb 07 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	EDELWEISS	67.95	68.5	68.5	66.9	66.95	792425	532.85	8211	520789	65.72000122070312
Tue Feb 08 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	EDELWEISS	66.95	67	67.4	64	65.15	1303131	853.87	13592	726311	55.7400016784668
Wed Feb 09 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	EDELWEISS	65.15	65.2	66.05	64.85	65.45	1235703	810.9	12807	764855	61.900001525878906
Fri Feb 11 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	EDELWEISS	65.1	64.55	65.45	62.25	62.65	1803596	1140.04	18966	1195267	66.2699966430664
Thu Feb 10 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	EDELWEISS	65.45	67.45	67.45	64.8	65.1	1330560	867.13	17021	676490	50.84000015258789
Thu Feb 03 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	EDELWEISS	68.75	69	69.35	68.2	68.5	553453	380.04	4938	349526	63.150001525878906
Wed Jan 01 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	EDELWEISS	109.2	110.5	112.9	109.2	110.3	471336	521.27	5315	172634	36.63
Thu Jan 02 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	EDELWEISS	110.3	111	121.3	110.55	120.25	3110336	3678.13	21309	1239442	39.85
Fri Jan 03 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	EDELWEISS	120.25	120.6	124.7	117	119.25	3103427	3765.9	35559	1482145	47.76


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