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)	LODHA	1332.35	1335	1339.95	1300	1309.05	93801	1233.3	8267	42081	44.86000061035156
Mon Feb 07 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	LODHA	1309.05	1283.1	1337.95	1283.1	1319.15	165777	2185.12	14059	59892	36.130001068115234
Tue Feb 08 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	LODHA	1319.15	1339.75	1339.75	1270	1292.7	155912	2011.81	11580	62829	40.29999923706055
Wed Feb 09 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	LODHA	1292.7	1300	1310	1284.15	1296.15	138887	1796.16	7527	91005	65.5199966430664
Fri Feb 11 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	LODHA	1298.35	1294.9	1294.9	1261.1	1287.2	181687	2317.78	11664	89478	49.25
Thu Feb 10 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	LODHA	1296.15	1322	1339.15	1288.55	1298.35	500524	6619.12	11001	397316	79.37999725341797
Thu Feb 03 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	LODHA	1372.3	1364.7	1372	1315	1332.35	118685	1602.47	12347	51462	43.36000061035156
Mon Apr 19 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	LODHA	486	436	478	422.6	465.25	11051365	51296.54	189323	6643235	60.11
Tue Apr 20 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	LODHA	465.25	468	513.85	457.35	503.1	5852536	28641.56	108274	2440878	41.71
Thu Apr 22 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	LODHA	503.1	498	542.75	491.6	523.75	2364148	12318.54	67555	923883	39.08


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