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)	GODFRYPHLP	1142.3	1160	1171.05	1108.5	1114.4	48966	557.01	6732	18178	37.119998931884766
Mon Feb 07 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	GODFRYPHLP	1114.4	1113	1124.9	1100	1110.8	15739	174.67	2604	6624	42.09000015258789
Tue Feb 08 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	GODFRYPHLP	1110.8	1115	1120	1084.5	1096.7	12602	138.07	2318	5107	40.52999877929688
Wed Feb 09 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	GODFRYPHLP	1096.7	1101.35	1113	1076.2	1081.75	12631	137.79	1792	6137	48.59000015258789
Fri Feb 11 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	GODFRYPHLP	1077.25	1077	1102.2	1067.5	1079.4	22643	245.77	4551	7049	31.1299991607666
Thu Feb 10 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	GODFRYPHLP	1081.75	1085	1093.85	1072.2	1077.25	11246	121.64	1537	3504	31.15999984741211
Thu Feb 03 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	GODFRYPHLP	1145.1	1155	1195	1135	1142.3	48080	561.58	5580	14846	30.8799991607666
Wed Jan 01 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	GODFRYPHLP	1271.9	1275	1307	1275	1293.35	75696	977.84	4124	24576	32.47
Thu Jan 02 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	GODFRYPHLP	1293.35	1296.1	1420	1296.1	1357.05	404995	5497.11	18089	90852	22.43
Fri Jan 03 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	GODFRYPHLP	1357.05	1352	1365.8	1325	1335.45	93223	1252.1	6153	26589	28.52


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