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)	HOMEFIRST	770	772	773	731	740.35	118579	885.58	8500	78306	66.04000091552734
Mon Feb 07 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	HOMEFIRST	740.35	755	755	685.25	700.85	236717	1668.47	15263	162276	68.55000305175781
Tue Feb 08 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	HOMEFIRST	700.85	725	734.45	692	695.6	62397	435.54	3608	30396	48.709999084472656
Wed Feb 09 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	HOMEFIRST	695.6	696.05	725	696.05	709.6	57290	407.01	5273	28022	48.90999984741211
Fri Feb 11 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	HOMEFIRST	728.85	717.9	719.95	700	704.8	39275	278.58	3431	25259	64.30999755859375
Thu Feb 10 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	HOMEFIRST	709.6	720.25	732.5	703	728.85	51990	373.59	5752	29025	55.83000183105469
Thu Feb 03 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	HOMEFIRST	766.3	768.3	777	755.6	770	43806	336.92	6465	19079	43.54999923706055
Wed Feb 03 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	HOMEFIRST	518	618.8	640	522	527.55	24532661	144582.59	835668	9636855	39.28
Thu Feb 04 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	HOMEFIRST	527.55	517.8	593.65	515	560.55	7574165	42840.83	309443	2574242	33.99
Fri Feb 05 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	HOMEFIRST	560.55	570	576	545	547.9	1179817	6572.64	47143	441570	37.43


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