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)	ISEC	725.15	723.5	741.85	717.55	733.4	341039	2499.76	22962	155052	45.459999084472656
Mon Feb 07 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	ISEC	733.4	730	737	710	715.45	255908	1852.93	14965	123361	48.209999084472656
Tue Feb 08 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	ISEC	715.45	715.45	740	715.4	737.5	357148	2610.03	17209	148041	41.45000076293945
Wed Feb 09 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	ISEC	737.5	739.4	746	731.7	734.7	151592	1116.94	11064	52302	34.5
Fri Feb 11 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	ISEC	737.75	737.75	737.75	726	729.05	212731	1554.55	14008	128973	60.630001068115234
Thu Feb 10 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	ISEC	734.7	736	748	725	737.75	288387	2132.21	17347	136678	47.38999938964844
Thu Feb 03 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	ISEC	746.55	748	750	723	725.15	312864	2304.06	23429	169575	54.20000076293945
Wed Jan 01 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	ISEC	406.8	411.4	422.9	406.4	413.9	1018976	4212.84	26997	229703	22.54
Thu Jan 02 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	ISEC	413.9	416.05	424.25	412.2	417.3	622136	2601.53	18484	162688	26.15
Fri Jan 03 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	ISEC	417.3	419	422	412	414.6	414355	1730.57	16379	139948	33.77


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