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)	FINCABLES	503.65	500.15	503.65	492.45	499.9	70679	352.47	4213	35205	49.810001373291016
Mon Feb 07 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	FINCABLES	499.9	504.7	509.8	492	498.4	48703	242.78	3787	22721	46.650001525878906
Tue Feb 08 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	FINCABLES	498.4	496	499.9	485	487.1	52469	257.43	4734	21059	40.13999938964844
Wed Feb 09 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	FINCABLES	487.1	495	512	485.5	500	246966	1225.93	12311	40644	16.459999084472656
Fri Feb 11 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	FINCABLES	491.2	490	492.4	482.1	484.7	50796	246.4	3892	20169	39.709999084472656
Thu Feb 10 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	FINCABLES	500	499	499	490	491.2	60188	296.5	3537	26024	43.2400016784668
Thu Feb 03 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	FINCABLES	509.25	515	517.25	501	503.65	62061	315.17	3878	23632	38.08000183105469
Wed Jan 01 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	FINCABLES	371.1	372.05	386.85	370.4	384.25	89801	342.41	3050	41068	45.73
Thu Jan 02 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	FINCABLES	384.25	384.25	407.05	384.25	400.75	229224	915.39	6259	94505	41.23
Fri Jan 03 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	FINCABLES	400.75	400.7	410	400.65	402.75	120803	491.39	4944	60530	50.11


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