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)	AFFLE	1290.65	1254.05	1280	1245	1259.2	391988	4956.51	30014	193948	49.47999954223633
Mon Feb 07 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	AFFLE	1259.2	1340	1380	1280.05	1292.3	979408	13066.01	70374	355698	36.31999969482422
Tue Feb 08 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	AFFLE	1292.3	1315	1323.05	1270	1288.9	444138	5747.84	50101	187445	42.20000076293945
Wed Feb 09 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	AFFLE	1288.9	1300.95	1309.95	1282	1286.5	220429	2849.34	17993	106935	48.5099983215332
Fri Feb 11 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	AFFLE	1262.2	1242	1255	1219.05	1222.7	381828	4702.25	30314	221857	58.09999847412109
Thu Feb 10 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	AFFLE	1286.5	1296.45	1296.45	1256	1262.2	329900	4174.56	25727	148701	45.06999969482422
Thu Feb 03 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	AFFLE	1309.25	1314	1343.95	1280	1290.65	281166	3680.27	24545	121679	43.27999877929688
Wed Jan 01 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	AFFLE	1581.35	1580	1621	1576.15	1611.4	99256	1589.39	7798	28760	28.98
Thu Jan 02 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	AFFLE	1611.4	1615	1624.8	1579.55	1587.65	64955	1040.57	6853	26569	40.9
Fri Jan 03 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	AFFLE	1587.65	1590	1607.3	1557.4	1562.45	88039	1392.45	8258	31358	35.62


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