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)	TATACOFFEE	216.3	217.5	217.65	213	213.55	894205	1923.27	10338	263524	29.46999931335449
Mon Feb 07 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	TATACOFFEE	213.55	213.55	215.3	210.2	211.65	665736	1417.58	8915	230451	34.619998931884766
Tue Feb 08 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	TATACOFFEE	211.65	212	213.5	208.1	210.75	738699	1558.33	9263	265805	35.97999954223633
Wed Feb 09 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	TATACOFFEE	210.75	215	215.85	211.5	212.3	483370	1027.89	6322	176306	36.470001220703125
Fri Feb 11 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	TATACOFFEE	214.55	212.95	213.55	209.5	210.9	570283	1208.04	7074	232336	40.7400016784668
Thu Feb 10 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	TATACOFFEE	212.3	215	218	212	214.55	1899653	4104.83	21191	516224	27.170000076293945
Thu Feb 03 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	TATACOFFEE	220.5	220.5	221	215.25	216.3	1028629	2240.71	10194	343676	33.40999984741211
Wed Jan 01 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	TATACOFFEE	92.1	92.5	92.7	91.3	91.5	147147	135.23	2052	67688	46
Thu Jan 02 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	TATACOFFEE	91.5	91.9	93.25	91.55	92.45	271918	251.95	2577	124231	45.69
Fri Jan 03 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	TATACOFFEE	92.45	92.7	96.2	92.5	93.9	1281570	1214.37	9109	370283	28.89


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