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)	POWERINDIA	3301.85	3332	3350	3206.95	3256.6	39437	1301.05	6686	13913	35.279998779296875
Mon Feb 07 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	POWERINDIA	3256.6	3272.4	3290.05	3038.9	3094.95	59967	1901.57	9544	24426	40.72999954223633
Tue Feb 08 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	POWERINDIA	3094.95	3147.95	3172.75	3020	3111.65	41200	1279.08	8559	11954	29.01000022888184
Wed Feb 09 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	POWERINDIA	3111.65	3128	3139	3051.1	3084.35	26568	819.13	4926	13304	50.08000183105469
Fri Feb 11 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	POWERINDIA	2968.2	2968.2	2979.85	2812	2824.4	61990	1774.07	8938	25491	41.119998931884766
Thu Feb 10 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	POWERINDIA	3084.35	3120	3123.95	2922.3	2968.2	91523	2718.83	13729	42680	46.630001068115234
Thu Feb 03 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	POWERINDIA	3355.75	3390	3430	3275	3301.85	69277	2316.46	14080	22416	32.36000061035156
Mon Mar 30 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	POWERINDIA	1476	680	714	680	714	29010	207.12	806
Tue Mar 31 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	POWERINDIA	714	749.7	749.7	749.7	749.7	15930	119.43	50
Wed Apr 01 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	POWERINDIA	749.7	787.15	787.15	787.15	787.15	25057	197.24	112


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