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)	LINDEINDIA	2793.8	2816.65	2837	2730	2749.85	106231	2939.93	9703	61616	58
Mon Feb 07 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	LINDEINDIA	2749.85	2769.55	2791	2710.05	2740.5	144206	3963.42	7331	114485	79.38999938964844
Tue Feb 08 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	LINDEINDIA	2740.5	2725	2740.45	2581	2631.5	146093	3850.48	16006	59076	40.43999862670898
Wed Feb 09 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	LINDEINDIA	2631.5	2650	2669	2604.7	2639.25	38921	1022.85	5802	18450	47.400001525878906
Fri Feb 11 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	LINDEINDIA	2655	2630	2664.4	2602.2	2619.25	33995	895.79	5251	9615	28.280000686645508
Thu Feb 10 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	LINDEINDIA	2639.25	2660.35	2678.95	2615	2655	34910	922.34	6172	14815	42.43999862670898
Thu Feb 03 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	LINDEINDIA	2757.25	2775	2885	2748.95	2793.8	233137	6588.71	25123	96750	41.5
Wed Jan 01 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	LINDEINDIA	661.45	663.85	674	660.9	663.05	10967	72.94	1108	3475	31.69
Thu Jan 02 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	LINDEINDIA	663.05	662.35	678	660.85	669	45568	305.42	1651	22623	49.65
Fri Jan 03 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	LINDEINDIA	669	674.4	678	649.2	664.3	32135	214.6	1291	19881	61.87


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