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)	MCX	1467.2	1460	1467.5	1421	1427.85	1709407	24746.51	51394	493299	28.86000061035156
Mon Feb 07 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	MCX	1427.85	1424.95	1424.95	1385.2	1399.25	906789	12727.22	55121	262763	28.979999542236328
Tue Feb 08 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	MCX	1399.25	1407.95	1434	1395.05	1424.7	491958	6974.63	30174	104797	21.299999237060547
Wed Feb 09 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	MCX	1424.7	1432.2	1458.8	1430.05	1444.1	426870	6168.25	32315	108218	25.350000381469727
Fri Feb 11 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	MCX	1452.3	1439.1	1443	1406.6	1410.7	398727	5672.82	23389	178819	44.84999847412109
Thu Feb 10 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	MCX	1444.1	1452	1462	1423	1452.3	303268	4390.84	19342	104096	34.31999969482422
Thu Feb 03 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	MCX	1540.95	1534	1535.85	1458	1467.2	1282971	19106.68	70219	572099	44.59000015258789
Wed Jan 01 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	MCX	1168.05	1169.45	1188	1169.45	1181.65	104402	1231.01	3701	22809	21.85
Thu Jan 02 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	MCX	1181.65	1181.65	1193.95	1167	1190.05	191628	2266.74	6554	89263	46.58
Fri Jan 03 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	MCX	1190.05	1190	1277.95	1185	1237.55	1336455	16596.22	50925	401740	30.06


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