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)	BBTC	1095.75	1095.05	1124	1092.55	1105.5	33658	373.27	3633	10074	29.93000030517578
Mon Feb 07 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	BBTC	1105.5	1110.9	1110.9	1075.1	1085.5	30250	329.2	5416	9620	31.799999237060547
Tue Feb 08 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	BBTC	1085.5	1086	1094.7	1049.4	1061.8	30429	324.46	3585	11903	39.119998931884766
Wed Feb 09 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	BBTC	1061.8	1070.1	1089.45	1050	1054.45	56697	603.6	8298	21159	37.31999969482422
Fri Feb 11 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	BBTC	1072.25	1061	1069.05	1045	1050.65	23656	249.84	3738	10286	43.47999954223633
Thu Feb 10 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	BBTC	1054.45	1058	1077.5	1057.45	1072.25	26541	283.49	2536	10221	38.5099983215332
Thu Feb 03 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	BBTC	1116.45	1124.6	1136	1089.25	1095.75	59530	662.56	5346	22874	38.41999816894531
Wed Jan 01 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	BBTC	1038.95	1036.85	1043.95	1022.95	1029.2	44974	463.82	2667	12485	27.76
Thu Jan 02 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	BBTC	1029.2	1033	1072.75	1026.35	1058.75	208020	2193.19	10246	43117	20.73
Fri Jan 03 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	BBTC	1058.75	1055.8	1078.9	1039.05	1070.8	159352	1694.39	8665	41216	25.86


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