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)	TCNSBRANDS	749.2	753.7	759.5	745.5	748.6	5533	41.65	641	2540	45.90999984741211
Mon Feb 07 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	TCNSBRANDS	748.6	758	758	730	731.35	15102	111.31	1591	7532	49.869998931884766
Tue Feb 08 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	TCNSBRANDS	731.35	727	742.2	689.95	707.85	19856	141.43	2544	9384	47.2599983215332
Wed Feb 09 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	TCNSBRANDS	707.85	707.85	727.75	688.3	696.35	19916	140.09	2424	11031	55.38999938964844
Fri Feb 11 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	TCNSBRANDS	678.85	678.85	678.85	667.1	670.6	13498	90.66	911	9696	71.83000183105469
Thu Feb 10 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	TCNSBRANDS	696.35	695	695	675	678.85	21538	147.22	2318	13055	60.61000061035156
Thu Feb 03 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	TCNSBRANDS	747.8	754	759	737.05	749.2	10153	76.22	1265	5418	53.36000061035156
Wed Jan 01 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	TCNSBRANDS	620.9	621.9	625	608	611.55	3234	19.78	418	1859	57.48
Thu Jan 02 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	TCNSBRANDS	611.55	605.1	615	605.1	610.8	2160	13.17	453	1393	64.49
Fri Jan 03 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	TCNSBRANDS	610.8	605.2	615.1	593	600.8	4119	24.89	667	2155	52.32


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