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)	SOLARA	956.6	958	969.75	945	949.25	31917	305.21	3349	11993	37.58000183105469
Mon Feb 07 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	SOLARA	949.25	951.9	963	942.9	948.25	39570	376.89	3433	13078	33.04999923706055
Tue Feb 08 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	SOLARA	948.25	948.25	968.9	917.2	960.15	73695	695.8	6892	26532	36
Wed Feb 09 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	SOLARA	960.15	961	976.2	951	969.1	49627	478.94	6725	15369	30.96999931335449
Fri Feb 11 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	SOLARA	775.3	631.25	689.9	620.25	620.3	2758917	17785.35	154587	1300712	47.150001525878906
Thu Feb 10 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	SOLARA	969.1	775.3	775.3	775.3	775.3	129149	1001.29	4964	129146	100
Thu Feb 03 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	SOLARA	956.55	965	975.75	950.65	956.6	39051	376.48	3520	14613	37.41999816894531
Wed Jan 01 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	SOLARA	434.8	430.15	440	425	426.95	8978	38.72	1719	5937	66.13
Thu Jan 02 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	SOLARA	426.95	426.15	434.45	425.15	427.9	8290	35.46	1470	5117	61.72
Fri Jan 03 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	SOLARA	427.9	430	432.5	424.65	426.75	6388	27.33	1587	3628	56.79


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