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)	SUPRAJIT	410.35	412	417.4	407.75	412.3	56559	233.7	4588	28496	50.380001068115234
Mon Feb 07 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	SUPRAJIT	412.3	408	410	388.85	398.7	149673	597.87	10413	69159	46.209999084472656
Tue Feb 08 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	SUPRAJIT	398.7	400	404.8	393.1	402.2	94850	377.21	9871	46417	48.93999862670898
Wed Feb 09 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	SUPRAJIT	402.2	400	403.1	394.8	396.05	50522	201.06	3627	24914	49.310001373291016
Fri Feb 11 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	SUPRAJIT	393.95	396.5	396.9	388	388.9	52623	206.03	6086	27508	52.27000045776367
Thu Feb 10 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	SUPRAJIT	396.05	396	401.4	391	393.95	74954	297.04	7201	33292	44.41999816894531
Thu Feb 03 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	SUPRAJIT	414.7	414	416.7	406.1	410.35	61515	252.93	4371	26784	43.540000915527344
Wed Jan 01 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	SUPRAJIT	197.2	197.2	213.45	192.6	206.85	219606	453.2	7647	33015	15.03
Thu Jan 02 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	SUPRAJIT	206.85	205.8	205.8	201	202.95	47927	97.32	2166	29555	61.67
Fri Jan 03 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	SUPRAJIT	202.95	202.75	207.9	198.8	205.55	28934	59.12	1582	16559	57.23


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