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)	SRTRANSFIN	1263.2	1260	1267.6	1229.05	1233.2	526797	6553.87	18406	120758	22.920000076293945
Mon Feb 07 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	SRTRANSFIN	1233.2	1235	1251	1211	1218.8	406059	4979.5	18374	71944	17.719999313354492
Tue Feb 08 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	SRTRANSFIN	1218.8	1225.6	1245.35	1206.65	1240.25	761581	9354.36	28407	263477	34.599998474121094
Wed Feb 09 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	SRTRANSFIN	1240.25	1240	1254	1233	1245.15	444026	5525.41	21081	176122	39.65999984741211
Fri Feb 11 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	SRTRANSFIN	1265.6	1253	1264	1228.2	1235.55	583974	7250.66	28540	211887	36.27999877929688
Thu Feb 10 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	SRTRANSFIN	1245.15	1245	1275	1232.1	1265.6	633358	7979.94	30910	211577	33.40999984741211
Thu Feb 03 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	SRTRANSFIN	1283.8	1287	1287	1255	1263.2	473461	5997.55	21627	80997	17.110000610351562
Wed Jan 01 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	SRTRANSFIN	1171.1	1174.7	1177.45	1140.1	1142.45	428045	4935.07	12907	37310	8.72
Thu Jan 02 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	SRTRANSFIN	1142.45	1145	1163.85	1145	1160.45	617425	7121.24	19539	191685	31.05
Fri Jan 03 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	SRTRANSFIN	1160.45	1159.9	1167	1151	1159.9	458679	5319.07	17568	163017	35.54


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