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)	TATASTLLP	746.6	750	768	740.25	744.05	113715	857.2	7299	43926	38.630001068115234
Mon Feb 07 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	TATASTLLP	744.05	748.55	760	731.95	736.65	82944	616.89	6266	40553	48.88999938964844
Tue Feb 08 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	TATASTLLP	736.65	740	747.4	723.05	736.65	80844	595.4	5077	30444	37.65999984741211
Wed Feb 09 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	TATASTLLP	736.65	740.35	754.9	735.25	740.25	69749	517.32	4009	41479	59.470001220703125
Fri Feb 11 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	TATASTLLP	739.4	760	763.5	742.7	751.2	91319	685.35	6675	39892	43.68000030517578
Thu Feb 10 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	TATASTLLP	740.25	740.25	749.6	737.15	739.4	50312	373.77	3840	23427	46.560001373291016
Thu Feb 03 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	TATASTLLP	751.1	751.1	754.75	743.05	746.6	74281	555.93	4173	33551	45.16999816894531
Wed Jan 01 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	TATASTLLP	399.35	402.05	429.8	398	424.35	222525	931.27	10906	72112	32.41
Thu Jan 02 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	TATASTLLP	424.35	433.2	486.8	430	469.7	807898	3763.25	27366	156621	19.39
Fri Jan 03 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	TATASTLLP	469.7	472	474.7	444.95	450.05	221064	1013.63	9445	63362	28.66


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