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)	BRIGADE	525.25	538.95	538.95	499.7	506.3	1234110	6448.56	38508	343394	27.82999992370605
Mon Feb 07 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	BRIGADE	506.3	502	510.85	484	497	524472	2597.83	23765	96007	18.309999465942383
Tue Feb 08 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	BRIGADE	497	500	519.9	489.65	514.65	514111	2598.93	22644	128513	25
Wed Feb 09 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	BRIGADE	514.65	518	522.5	491.9	495.7	440788	2239.78	17310	144809	32.849998474121094
Fri Feb 11 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	BRIGADE	508.1	500	507.55	493	495.9	233567	1162.95	9056	51376	22
Thu Feb 10 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	BRIGADE	495.7	495.45	513	490	508.1	383972	1932.82	13072	83345	21.709999084472656
Thu Feb 03 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	BRIGADE	521.7	525	532.5	516.7	525.25	352692	1853.22	13953	94519	26.799999237060547
Wed Jan 01 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	BRIGADE	218.5	220	221	212.75	214.8	107560	231.34	4100	83380	77.52
Thu Jan 02 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	BRIGADE	214.8	215.9	221	215	219.45	40980	89.59	1685	23868	58.24
Fri Jan 03 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	BRIGADE	219.45	216.1	219.75	212.4	215.6	47370	102.29	2705	33025	69.72


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