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)	BRITANNIA	3562.4	3583.45	3593.7	3540	3562	162672	5791.8	27870	75198	46.22999954223633
Mon Feb 07 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	BRITANNIA	3562	3561.95	3579.8	3440	3448.6	279194	9702.89	40037	158616	56.810001373291016
Tue Feb 08 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	BRITANNIA	3448.6	3441	3490	3418.4	3473.45	363856	12592.45	38498	190575	52.380001068115234
Wed Feb 09 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	BRITANNIA	3473.45	3509	3540.7	3473.45	3517.35	172750	6079.76	18025	71293	41.27000045776367
Fri Feb 11 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	BRITANNIA	3534.55	3499	3509.35	3429	3480.55	340217	11760.89	40974	207530	61
Thu Feb 10 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	BRITANNIA	3517.35	3522	3543.85	3485	3534.55	172088	6060.17	32016	93639	54.40999984741211
Thu Feb 03 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	BRITANNIA	3621.05	3622	3652	3555	3562.4	203975	7329.46	24095	74372	36.459999084472656
Wed Jan 01 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	BRITANNIA	3027.8	3044.7	3053	3027.4	3039.65	110561	3362.12	6813	20175	18.25
Thu Jan 02 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	BRITANNIA	3039.65	3047	3065	3043.05	3053.4	138428	4227.82	10506	42417	30.64
Fri Jan 03 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	BRITANNIA	3053.4	3045	3060	3025.65	3038.8	168305	5114.7	16811	73037	43.4


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