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)	TATAMTRDVR	242.85	243.75	245.4	236.4	238.15	2998627	7196.21	33363	1820148	60.70000076293945
Mon Feb 07 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	TATAMTRDVR	238.15	238.95	242.4	236.05	237.7	1823270	4350.54	24084	817615	44.84000015258789
Tue Feb 08 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	TATAMTRDVR	237.7	239.5	240.75	231.25	236.5	2266913	5346.9	24706	1082806	47.77000045776367
Wed Feb 09 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	TATAMTRDVR	236.5	238.85	242.9	236.7	241	1445363	3472.53	17030	626555	43.34999847412109
Fri Feb 11 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	TATAMTRDVR	246.15	243.7	246.2	238.8	240.45	1484655	3597.49	14533	814802	54.880001068115234
Thu Feb 10 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	TATAMTRDVR	241	241.8	247.85	241.2	246.15	1913399	4680.93	21569	1116210	58.34000015258789
Thu Feb 03 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	TATAMTRDVR	249.2	250.85	252.75	241.7	242.85	4294800	10606.88	49378	2582093	60.119998931884766
Wed Jan 01 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	TATAMTRDVR	77	77.35	77.45	75.5	75.8	3501656	2668.5	9950	616494	17.61
Thu Jan 02 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	TATAMTRDVR	75.8	76.45	80.15	75.85	79.75	8177517	6411.31	25095	1817490	22.23
Fri Jan 03 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	TATAMTRDVR	79.75	79.55	80.3	77.05	78.1	5934025	4660.88	15879	1094644	18.45


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