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)	MUTHOOTFIN	1422.15	1433.8	1439	1409.55	1420.55	650058	9256.24	33606	256588	39.470001220703125
Mon Feb 07 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	MUTHOOTFIN	1420.55	1420.55	1429.15	1396.25	1422.9	711152	10057.15	36230	322633	45.369998931884766
Tue Feb 08 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	MUTHOOTFIN	1422.9	1425	1448	1410.5	1439.95	481143	6903.93	22930	142154	29.549999237060547
Wed Feb 09 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	MUTHOOTFIN	1439.95	1448	1460	1446.3	1456.35	258503	3760.2	15779	124024	47.97999954223633
Fri Feb 11 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	MUTHOOTFIN	1465.5	1465.4	1465.4	1415	1424.15	526337	7545.22	31026	274131	52.08000183105469
Thu Feb 10 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	MUTHOOTFIN	1456.35	1459.3	1470	1440.05	1465.5	314990	4605.55	17602	121850	38.68000030517578
Thu Feb 03 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	MUTHOOTFIN	1469.9	1475	1475	1416	1422.15	1160781	16620.01	62157	536953	46.2599983215332
Wed Jan 01 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	MUTHOOTFIN	761.45	761	765.6	758	760.6	248641	1892.61	5414	35468	14.26
Thu Jan 02 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	MUTHOOTFIN	760.6	764.4	772.3	762.3	768.55	459220	3523.51	12352	72874	15.87
Fri Jan 03 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	MUTHOOTFIN	768.55	763.1	772.85	763.1	770.8	414687	3183.66	7197	157986	38.1


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