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)	BALRAMCHIN	445.25	448	452.25	435.9	438.75	4927131	21918.11	79327	877936	17.81999969482422
Mon Feb 07 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	BALRAMCHIN	438.75	439.75	456.9	439.3	444.1	5402993	24246.41	83049	925291	17.1299991607666
Tue Feb 08 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	BALRAMCHIN	444.1	444.95	448.35	418.65	427.5	3340368	14299.01	44081	830248	24.850000381469727
Wed Feb 09 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	BALRAMCHIN	427.5	430	447.6	428.05	443.6	2479301	10849.95	38661	426861	17.219999313354492
Fri Feb 11 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	BALRAMCHIN	440.8	432.95	438.55	425.2	427.05	2269342	9800.03	29554	311749	13.739999771118164
Thu Feb 10 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	BALRAMCHIN	443.6	445	448.7	439	440.8	1763533	7803.95	26444	280066	15.880000114440918
Thu Feb 03 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	BALRAMCHIN	415.3	415.8	448.9	415.15	445.25	7856569	34204.55	86584	1480353	18.84000015258789
Wed Jan 01 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	BALRAMCHIN	183.4	184.2	188.15	181.7	187.2	2157359	4011.03	16200	478170	22.16
Thu Jan 02 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	BALRAMCHIN	187.2	187.25	188.9	185	185.25	969346	1807.85	8827	302472	31.2
Fri Jan 03 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	BALRAMCHIN	185.25	185.7	188.2	183	184.7	1047341	1939.74	13669	324301	30.96


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