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)	SUNDRMFAST	849.85	854	858.55	837.8	841.1	17235	146.13	2517	5507	31.950000762939453
Mon Feb 07 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	SUNDRMFAST	841.1	845.5	857.95	833.1	850.65	17194	145.41	4557	8492	49.38999938964844
Tue Feb 08 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	SUNDRMFAST	850.65	841	841	825	829.7	26279	219.26	3156	12726	48.43000030517578
Wed Feb 09 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	SUNDRMFAST	829.7	824.9	848.85	813	838.7	51755	427.3	5309	25098	48.4900016784668
Fri Feb 11 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	SUNDRMFAST	847.35	842.7	863	820	844.8	39915	335.43	5621	13597	34.060001373291016
Thu Feb 10 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	SUNDRMFAST	838.7	848	853.05	822.1	847.35	39172	329.15	5075	11751	30
Thu Feb 03 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	SUNDRMFAST	869.6	870	900	791.3	849.85	28781	246.03	3602	11527	40.04999923706055
Wed Jan 01 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	SUNDRMFAST	500.05	505	518	500	502.8	243120	1233.41	5053	130342	53.61
Thu Jan 02 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	SUNDRMFAST	502.8	506.6	507.95	489.4	501.65	77385	386.74	2205	40346	52.14
Fri Jan 03 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	SUNDRMFAST	501.65	503.85	504	500	501.65	25140	125.97	1516	15836	62.99


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