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)	WIPRO	578.25	577	577.8	568.05	571.75	6816779	39109.92	138822	3149406	46.20000076293945
Mon Feb 07 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	WIPRO	571.75	571.9	573.8	555.6	557	7545679	42403.62	180732	3845730	50.970001220703125
Tue Feb 08 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	WIPRO	557	561.4	565.8	554.45	560.25	6976907	39084.37	127178	2790796	40
Wed Feb 09 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	WIPRO	560.25	564.4	570.75	563.3	568.95	5103738	29008.83	97434	2427954	47.56999969482422
Fri Feb 11 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	WIPRO	573.65	566	566	557.1	561.45	7721229	43299.93	159312	3511364	45.47999954223633
Thu Feb 10 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	WIPRO	568.95	572.4	574.75	566.2	573.65	5801912	33119.19	131663	3359182	57.900001525878906
Thu Feb 03 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	WIPRO	588	584.7	588.8	576.15	578.25	7041390	41041.24	129088	3095774	43.970001220703125
Wed Jan 01 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	WIPRO	245.8	246.5	248.65	246.2	247.7	1413866	3502.93	14240	288194	20.38
Thu Jan 02 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	WIPRO	247.7	246.6	249.9	246.35	248.3	1443966	3586.71	19476	592368	41.02
Fri Jan 03 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	WIPRO	248.3	249.5	252.7	247.35	251.1	3381404	8486.89	38677	801622	23.71


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