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)	GSFC	128	129.9	130.3	127.25	129.3	1656079	2127.13	17715	1049720	63.38999938964844
Mon Feb 07 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	GSFC	129.3	130.1	137.45	130.1	132.6	11282044	15149.06	70621	3495938	30.989999771118164
Tue Feb 08 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	GSFC	132.6	132.2	133.9	127.75	130.45	3157161	4129.65	23798	949475	30.06999969482422
Wed Feb 09 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	GSFC	130.45	130.7	133	129.55	130	1795088	2354.81	18828	801592	44.650001525878906
Fri Feb 11 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	GSFC	128.5	127	131.85	126.5	130.05	1665006	2166.51	19389	686148	41.209999084472656
Thu Feb 10 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	GSFC	130	130.35	130.8	127.5	128.5	2030287	2624.34	17464	977532	48.150001525878906
Thu Feb 03 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	GSFC	127.4	128	129.3	127.1	128	903083	1156.88	6737	474033	52.4900016784668
Wed Jan 01 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	GSFC	70.05	70	70.8	69.5	69.95	141032	98.73	1323	75046	53.21
Thu Jan 02 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	GSFC	69.95	70.3	73.05	69.35	72.6	718126	514.93	4682	250098	34.83
Fri Jan 03 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	GSFC	72.6	72.1	74.4	71.65	72.9	559836	409.11	4441	194953	34.82


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