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)	BLUESTARCO	1000.05	1000.05	1024.75	970	1010.9	315680	3190.85	22445	72408	22.940000534057617
Mon Feb 07 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	BLUESTARCO	1010.9	1005	1072	1000.1	1053.2	378736	3989.43	26175	74800	19.75
Tue Feb 08 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	BLUESTARCO	1053.2	1055	1065	1021	1036.3	73200	759.55	6395	27263	37.2400016784668
Wed Feb 09 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	BLUESTARCO	1036.3	1039.65	1047.95	1020.25	1029.25	49233	507.27	3944	22573	45.84999847412109
Fri Feb 11 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	BLUESTARCO	1044.4	1054.9	1054.9	1020	1041.3	34481	356.94	3921	13884	40.27000045776367
Thu Feb 10 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	BLUESTARCO	1029.25	1035	1047.5	1025	1044.4	46241	479.96	4643	17335	37.4900016784668
Thu Feb 03 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	BLUESTARCO	911.95	936	1024.15	923.75	1000.05	1835722	18256.84	77810	154376	8.40999984741211
Wed Jan 01 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	BLUESTARCO	840.85	844.8	847	823	828.9	53296	443.27	4261	26465	49.66
Thu Jan 02 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	BLUESTARCO	828.9	825	833.45	807	809.9	34985	285.04	3194	20785	59.41
Fri Jan 03 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	BLUESTARCO	809.9	813.95	820	800.1	816.8	29289	237.78	2543	15699	53.6


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