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)	INTELLECT	749.65	747.85	769.5	738	741.35	447945	3358.29	22544	153834	34.34000015258789
Mon Feb 07 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	INTELLECT	741.35	746.7	746.7	720	721.8	317108	2313.3	15594	128353	40.47999954223633
Tue Feb 08 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	INTELLECT	721.8	719.75	744.75	698.6	705.45	440445	3130.08	17242	197904	44.93000030517578
Wed Feb 09 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	INTELLECT	705.45	707	733.75	705.05	715.4	487445	3498.85	21523	168651	34.599998474121094
Fri Feb 11 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	INTELLECT	720.05	709.95	712.95	682.2	685.3	439365	3059.62	21839	176296	40.130001068115234
Thu Feb 10 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	INTELLECT	715.4	717	728.85	709.2	720.05	272406	1955.3	13184	111771	41.02999877929688
Thu Feb 03 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	INTELLECT	774.65	779.85	779.85	747	749.65	270507	2058.32	14109	102083	37.7400016784668
Wed Jan 01 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	INTELLECT	138.35	139	146.45	139	141.45	360533	516.32	13786	127159	35.27
Thu Jan 02 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	INTELLECT	141.45	143	148.4	142.05	145.5	370869	539.35	4507	102220	27.56
Fri Jan 03 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	INTELLECT	145.5	145	147.45	142.9	143.65	106412	154.26	1836	44638	41.95


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