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)	FDC	292.95	291.95	295.9	289.9	294.25	47659	139.84	2007	26480	55.560001373291016
Mon Feb 07 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	FDC	294.25	318	319	303.6	306	957618	2973.33	22867	295393	30.850000381469727
Tue Feb 08 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	FDC	306	306	314.4	304.4	311.9	215769	667.32	7980	87558	40.58000183105469
Wed Feb 09 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	FDC	311.9	314	318	311	313.35	199447	626.33	6353	96987	48.630001068115234
Fri Feb 11 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	FDC	300.15	302	308.8	301.05	304.7	593915	1811.32	15333	285528	48.08000183105469
Thu Feb 10 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	FDC	313.35	303.8	310.55	298.2	300.15	900474	2724.66	25902	435969	48.41999816894531
Thu Feb 03 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	FDC	292.8	293.7	295.35	291.15	292.95	53797	158.15	1840	26270	48.83000183105469
Wed Jan 01 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	FDC	211.75	212	215.65	211	212.75	18936	40.41	693	11061	58.41
Thu Jan 02 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	FDC	212.75	212	213.95	208.75	210.5	29269	61.8	940	17453	59.63
Fri Jan 03 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	FDC	210.5	216.8	222	213.25	214.85	173614	376.25	3366	56789	32.71


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