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)	AUROPHARMA	670.75	673.4	673.4	660	662.6	695091	4622.07	19435	199830	28.75
Mon Feb 07 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	AUROPHARMA	662.6	659.4	665	647	649.75	961493	6276.23	23032	364059	37.86000061035156
Tue Feb 08 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	AUROPHARMA	649.75	651	657.95	643.1	650.1	827594	5375.47	18599	176397	21.309999465942383
Wed Feb 09 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	AUROPHARMA	650.1	656.95	666.4	651.1	656.05	1460263	9598.82	28513	560913	38.40999984741211
Fri Feb 11 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	AUROPHARMA	684.4	674.05	702.5	674.05	700.05	4099949	28369.03	98341	1394547	34.0099983215332
Thu Feb 10 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	AUROPHARMA	656.05	651	688.95	643	684.4	8212849	55276.01	184127	2266758	27.600000381469727
Thu Feb 03 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	AUROPHARMA	673.85	673	674.75	663.1	670.75	1567696	10486.4	28574	853465	54.43999862670898
Wed Jan 01 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	AUROPHARMA	456.85	459.6	463.5	456.85	458.1	1081955	4971.18	15524	213396	19.72
Thu Jan 02 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	AUROPHARMA	458.1	458.8	465.95	457.5	461.6	1320717	6098.8	22854	312764	23.68
Fri Jan 03 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	AUROPHARMA	461.6	461	471.9	457.2	460.3	2784762	12926.92	38419	516049	18.53


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