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)	AMBER	3888.05	3850	3870	3601	3642.65	221684	8354.01	28347	64847	29.25
Mon Feb 07 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	AMBER	3642.65	3657.7	3664.55	3565.25	3604.7	51572	1858.17	9446	9429	18.280000686645508
Tue Feb 08 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	AMBER	3604.7	3618.95	3649	3376.45	3413.95	94582	3295.73	12760	29321	31
Wed Feb 09 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	AMBER	3413.95	3452	3524.95	3327.25	3482.85	139097	4800.07	21724	35888	25.799999237060547
Fri Feb 11 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	AMBER	3489.45	3480	3559	3426	3484.4	62216	2166.32	10871	11008	17.690000534057617
Thu Feb 10 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	AMBER	3482.85	3495	3614	3440	3489.45	91729	3225.5	14680	21979	23.959999084472656
Thu Feb 03 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	AMBER	3568.85	3550	3924.75	3541.85	3888.05	613246	23436.77	67955	123230	20.09000015258789
Wed Jan 01 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	AMBER	1117.15	1120	1167.7	1117.15	1149.5	30349	346.11	2217	18175	59.89
Thu Jan 02 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	AMBER	1149.5	1161.8	1176.95	1121.45	1147.3	52642	612.61	5961	26432	50.21
Fri Jan 03 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	AMBER	1147.3	1147	1162.5	1130.45	1139.4	38359	437.81	3291	29249	76.25


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