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)	RAJESHEXPO	816.15	821	828.35	807.5	810.05	67888	553.18	5478	23955	35.290000915527344
Mon Feb 07 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	RAJESHEXPO	810.05	810.75	821.15	795	800.15	66423	536.51	6565	22679	34.13999938964844
Tue Feb 08 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	RAJESHEXPO	800.15	803	838.95	792.55	833.2	264757	2189.86	17896	62480	23.600000381469727
Wed Feb 09 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	RAJESHEXPO	833.2	837	882.95	828	864.05	163923	1398.8	11229	57602	35.13999938964844
Fri Feb 11 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	RAJESHEXPO	868.25	875.45	909.45	863	884.3	331246	2960.49	28161	66707	20.13999938964844
Thu Feb 10 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	RAJESHEXPO	864.05	864.1	876	849.05	868.25	84971	732.06	7490	21970	25.86000061035156
Thu Feb 03 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	RAJESHEXPO	832.85	835.85	838.2	815	816.15	68831	565.25	5972	25897	37.619998931884766
Wed Jan 01 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	RAJESHEXPO	669.35	670.5	679.9	670.45	678.2	129323	871.73	3051	30129	23.3
Thu Jan 02 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	RAJESHEXPO	678.2	679	690	678.15	686.9	123865	843.98	2938	31951	25.8
Fri Jan 03 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	RAJESHEXPO	686.9	687.7	697	684.5	693.2	117773	812.14	5021	45957	39.02


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