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)	DRREDDY	4374.65	4404.55	4406.5	4337	4351.95	246993	10780.81	37945	95208	38.54999923706055
Mon Feb 07 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	DRREDDY	4351.95	4320	4350	4250.05	4309.2	255958	11013.36	29851	87603	34.22999954223633
Tue Feb 08 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	DRREDDY	4309.2	4309	4379.35	4280.05	4321.95	396403	17169.61	36968	138857	35.029998779296875
Wed Feb 09 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	DRREDDY	4321.95	4322.2	4395	4311.5	4368.75	198880	8674.72	24276	76973	38.70000076293945
Fri Feb 11 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	DRREDDY	4370.7	4311	4349.55	4280.15	4325.4	337538	14554.46	39425	179520	53.18999862670898
Thu Feb 10 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	DRREDDY	4368.75	4385	4388.75	4333.7	4370.7	237865	10372.21	33156	122082	51.31999969482422
Thu Feb 03 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	DRREDDY	4415.35	4418	4436.95	4360	4374.65	221537	9725.53	28400	78922	35.619998931884766
Wed Jan 01 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	DRREDDY	2874.55	2880	2888.5	2860.2	2879.4	154779	4450.88	7138	13871	8.96
Thu Jan 02 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	DRREDDY	2879.4	2883.8	2892.4	2860.2	2864.9	298831	8577.69	19727	132540	44.35
Fri Jan 03 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	DRREDDY	2864.9	2864.9	2897	2852.05	2883.9	344678	9930.29	23970	100853	29.26


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