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)	TASTYBITE	12902.7	13099.95	13150	12800	12934.75	713	92.57	405	332	46.560001373291016
Mon Feb 07 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	TASTYBITE	12934.75	13124.15	13124.2	12777.25	12890.65	529	68.15	289	287	54.25
Tue Feb 08 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	TASTYBITE	12890.65	12890	13065.4	12800	12898.8	416	53.67	272	169	40.630001068115234
Wed Feb 09 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	TASTYBITE	12898.8	11900	12999.8	11899.95	12832.35	17093	2125.4	3154	5998	35.09000015258789
Fri Feb 11 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	TASTYBITE	12808.95	12731.05	12970	12489.15	12877.9	1695	216.89	660	1003	59.16999816894531
Thu Feb 10 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	TASTYBITE	12832.35	12832.35	12988.7	12689.95	12808.95	764	97.95	441	388	50.790000915527344
Thu Feb 03 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	TASTYBITE	12994.85	13001.05	13082.7	12853.45	12902.7	450	58.27	329	207	46
Wed Jan 01 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	TASTYBITE	8315.2	8374.95	8498	8125	8393.6	331	27.28	157	190	57.4
Thu Jan 02 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	TASTYBITE	8393.6	8390	8445	8303.05	8384.15	240	20.11	152	157	65.42
Fri Jan 03 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	TASTYBITE	8384.15	8335.05	8364	8245	8336.4	186	15.43	85	131	70.43


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