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)	MOTILALOFS	918.7	923	938.05	904.3	915.85	102286	946.48	10020	44596	43.59999847412109
Mon Feb 07 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	MOTILALOFS	915.85	921.95	949	916.5	924.95	171974	1605.28	13390	92903	54.02000045776367
Tue Feb 08 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	MOTILALOFS	924.95	920	938.65	898.6	910.65	509165	4657.82	13741	417610	82.0199966430664
Wed Feb 09 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	MOTILALOFS	910.65	914.4	945	912.15	940.4	163123	1524.06	11125	76469	46.880001068115234
Fri Feb 11 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	MOTILALOFS	936.6	933	933.75	901	905.7	78981	726.22	7320	30665	38.83000183105469
Thu Feb 10 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	MOTILALOFS	940.4	932	947	922.55	936.6	120119	1125.89	9453	53830	44.810001373291016
Thu Feb 03 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	MOTILALOFS	920.65	907.55	929.95	907.2	918.7	111948	1027.76	6472	50676	45.27000045776367
Wed Jan 01 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	MOTILALOFS	759.45	761.2	829	757.3	818.8	384924	3104.22	10568	135604	35.23
Thu Jan 02 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	MOTILALOFS	818.8	825	855.9	785	828.95	864116	7027.29	14985	478373	55.36
Fri Jan 03 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	MOTILALOFS	828.95	825	858.7	813.6	841.55	412824	3478.33	14209	160556	38.89


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