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)	SBICARD	884.55	883	884	850.1	854.9	1566360	13498.4	62890	662472	42.290000915527344
Mon Feb 07 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	SBICARD	854.9	860	860	831.75	835.05	1299577	10929.08	57543	715713	55.06999969482422
Tue Feb 08 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	SBICARD	835.05	835.5	842.9	816	819.35	1175450	9687.5	57935	599520	51
Wed Feb 09 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	SBICARD	819.35	825	866.7	825	863.7	2729856	23321.34	75207	616437	22.57999992370605
Fri Feb 11 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	SBICARD	869.7	852	860	843	846.75	739551	6302.66	36950	326915	44.20000076293945
Thu Feb 10 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	SBICARD	863.7	868	873.1	854.35	869.7	1248047	10800.63	44524	488201	39.119998931884766
Thu Feb 03 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	SBICARD	896	899	899	882.25	884.55	771285	6835.23	29233	403353	52.29999923706055
Mon Mar 16 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	SBICARD	755	661	755	656	681.4	60893377	431983.82	1341563	35341400	58.04
Tue Mar 17 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	SBICARD	681.4	691	747.95	689	730.9	15147702	109862.21	601347	5690604	37.57
Wed Mar 18 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	SBICARD	730.9	752.1	769	680	689.2	8950986	64190.95	394939	3197852	35.73


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