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)	VMART	3708.85	3708.85	3787.05	3700	3750.2	9440	351.64	4703	4132	43.77000045776367
Mon Feb 07 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	VMART	3750.2	3720.25	3759.15	3651.35	3668.9	5144	190.09	1548	2764	53.72999954223633
Tue Feb 08 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	VMART	3668.9	3677	3748.2	3641.35	3663.1	9634	355.24	4641	4244	44.04999923706055
Wed Feb 09 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	VMART	3663.1	3672.9	3704.95	3615.4	3683.15	7041	258.07	3193	4234	60.130001068115234
Fri Feb 11 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	VMART	3693.45	3700	3726.35	3550	3582.95	17726	644.6	6042	8961	50.54999923706055
Thu Feb 10 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	VMART	3683.15	3683.15	3719.85	3657.15	3693.45	4655	171.88	1484	3198	68.69999694824219
Thu Feb 03 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	VMART	3743.9	3733.6	3783	3680	3708.85	4660	173.52	1942	1885	40.45000076293945
Wed Jan 01 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	VMART	1652.9	1661	1665.05	1643.3	1657.8	9828	162.69	1235	8358	85.04
Thu Jan 02 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	VMART	1657.8	1678.95	1678.95	1650.5	1664.25	10172	169.09	1006	8545	84.01
Fri Jan 03 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	VMART	1664.25	1679.95	1698	1650	1672.15	10807	180.64	1479	7133	66


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