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)	GREAVESCOT	221.55	223.4	223.4	209	211.2	2190250	4714.6	23365	795123	36.29999923706055
Mon Feb 07 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	GREAVESCOT	211.2	214	218.75	207.5	209.1	2454471	5188.26	30700	610575	24.8799991607666
Tue Feb 08 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	GREAVESCOT	209.1	211.3	212.9	197.85	202.5	2502999	5096.92	29201	696570	27.82999992370605
Wed Feb 09 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	GREAVESCOT	202.5	203.05	207.4	192.85	193.65	4469916	8881.79	55856	1140708	25.520000457763672
Fri Feb 11 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	GREAVESCOT	200	197.9	203.95	194.3	195.9	2509828	4998.61	26198	528610	21.059999465942383
Thu Feb 10 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	GREAVESCOT	193.65	195.4	201.85	191.1	200	3617330	7102.6	33668	701678	19.399999618530277
Thu Feb 03 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	GREAVESCOT	213.35	214.9	226.15	212.7	221.55	4564674	10111.2	44755	1076472	23.57999992370605
Wed Jan 01 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	GREAVESCOT	133.85	134.8	134.8	131.8	132.4	85728	113.75	1757	43072	50.24
Thu Jan 02 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	GREAVESCOT	132.4	132.9	135.6	132	134.75	116598	156.55	2277	53599	45.97
Fri Jan 03 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	GREAVESCOT	134.75	135.95	137.4	132.2	135.55	193341	262.6	4530	101662	52.58


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