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)	GSPL	317.7	317.6	323.5	315.1	318.7	661189	2116.4	13127	221324	33.470001220703125
Mon Feb 07 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	GSPL	318.7	317.85	325.4	309.2	314.8	857123	2723.67	15810	253881	29.6200008392334
Tue Feb 08 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	GSPL	314.8	313.05	314.2	295.6	304.25	1272738	3851.74	23596	281957	22.149999618530277
Wed Feb 09 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	GSPL	304.25	304.25	309.7	300.7	302.6	745023	2273.73	14782	226954	30.459999084472656
Fri Feb 11 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	GSPL	299.25	294.95	305.8	292.85	297.6	1102480	3300.64	20405	202698	18.38999938964844
Thu Feb 10 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	GSPL	302.6	302.95	306.75	297.65	299.25	488662	1474.95	11584	213744	43.7400016784668
Thu Feb 03 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	GSPL	314.2	316.35	328	315.05	317.7	3235979	10441.13	58434	929164	28.709999084472656
Wed Jan 01 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	GSPL	219.5	218.35	222.5	218.35	220.6	632970	1398.73	6176	471952	74.56
Thu Jan 02 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	GSPL	220.6	221	233.6	219.1	231.8	1045112	2378.59	18557	639981	61.24
Fri Jan 03 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	GSPL	231.8	233.2	243.8	233	235.7	1395209	3328.01	24115	831913	59.63


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