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)	RADICO	1049.6	1040	1050.6	970.2	977.6	2257150	22572.55	95088	1208133	53.52000045776367
Mon Feb 07 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	RADICO	977.6	978	978	901.65	947.75	2374028	21979.82	114275	846852	35.66999816894531
Tue Feb 08 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	RADICO	947.75	945	970.95	881.1	890.4	1310097	11950.2	67050	556139	42.45000076293945
Wed Feb 09 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	RADICO	890.4	908.4	919.9	886.65	909.4	721538	6513.85	41523	302344	41.900001525878906
Fri Feb 11 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	RADICO	958.15	953	969.35	921.5	960.15	564583	5378.4	23097	172395	30.530000686645508
Thu Feb 10 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	RADICO	909.4	915.9	962	898.45	958.15	1104663	10355.45	36040	528053	47.79999923706055
Thu Feb 03 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	RADICO	1075.25	1080	1104.9	1040	1049.6	647206	6905.07	36684	146005	22.559999465942383
Wed Jan 01 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	RADICO	313.5	314.8	323.7	312.25	320.9	475206	1517.26	8341	231016	48.61
Thu Jan 02 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	RADICO	320.9	321	330	319.45	325.45	469926	1527.22	10739	214295	45.6
Fri Jan 03 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	RADICO	325.45	325	326.5	316.25	319.55	291801	936.39	10658	205384	70.38


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