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)	GODREJIND	608.25	608	608	598.3	599.9	65587	394.94	3984	30109	45.90999984741211
Mon Feb 07 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	GODREJIND	599.9	602.55	609.25	581.15	591.05	77147	456.89	5799	28890	37.45000076293945
Tue Feb 08 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	GODREJIND	591.05	596	604	578.05	585.95	108129	635.6	6305	28989	26.809999465942383
Wed Feb 09 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	GODREJIND	585.95	586.7	594.1	575.7	579.8	99926	583.66	6803	38193	38.220001220703125
Fri Feb 11 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	GODREJIND	582.9	583	594	566.7	571.05	365760	2106.79	20652	87877	24.030000686645508
Thu Feb 10 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	GODREJIND	579.8	582.7	592.85	578.05	582.9	90867	531.04	6092	35869	39.470001220703125
Thu Feb 03 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	GODREJIND	615.5	617.5	619.7	606.15	608.25	46496	284.95	3191	21854	47
Wed Jan 01 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	GODREJIND	424.55	423.8	436.8	420.55	431.65	93213	402.01	4441	46392	49.77
Thu Jan 02 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	GODREJIND	431.65	430.05	437.5	427	429.25	71914	311.4	3450	35258	49.03
Fri Jan 03 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	GODREJIND	429.25	428.85	436.75	425.1	434.25	64142	276.99	4357	29082	45.34


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