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)	NAM-INDIA	346.8	343.6	347.35	340.6	346.25	496130	1710.69	12541	274101	55.25
Mon Feb 07 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	NAM-INDIA	346.25	345.05	345.05	330.2	331.8	385772	1294.85	10424	164171	42.560001373291016
Tue Feb 08 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	NAM-INDIA	331.8	332.45	332.45	323.15	328.55	681992	2233.38	15125	233341	34.209999084472656
Wed Feb 09 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	NAM-INDIA	328.55	328.9	333.75	326	332.65	518306	1707.25	13585	231054	44.58000183105469
Fri Feb 11 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	NAM-INDIA	333.2	331	332.85	325.65	330.75	398441	1310.68	6007	169177	42.459999084472656
Thu Feb 10 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	NAM-INDIA	332.65	335	335	328.2	333.2	496917	1646.95	9916	200855	40.41999816894531
Thu Feb 03 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	NAM-INDIA	350.2	350.2	351.35	342.35	346.8	520144	1798.17	16482	220980	42.47999954223633
Thu Jan 23 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	NAM-INDIA	346.35	347.7	353.45	341.4	346.85	1573539	5471.67	22852	615090	39.09
Fri Jan 24 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	NAM-INDIA	346.85	348.5	362.4	348.5	359.6	2884049	10268.83	41402	1199283	41.58
Mon Jan 27 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	NAM-INDIA	359.6	357.3	373.9	354.6	366.5	3575864	13107.44	50537	1273787	35.62


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