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)	ASAHIINDIA	596.5	603.4	606.8	570	573.35	452971	2647.65	19075	160766	35.4900016784668
Mon Feb 07 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	ASAHIINDIA	573.35	571.2	574.7	548	563.1	368579	2056.67	14255	156161	42.369998931884766
Tue Feb 08 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	ASAHIINDIA	563.1	564	569.8	556.6	560.45	187347	1056.65	9454	45945	24.520000457763672
Wed Feb 09 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	ASAHIINDIA	560.45	562.05	570	556.45	563.9	120761	680.62	6826	49606	41.08000183105469
Fri Feb 11 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	ASAHIINDIA	547.8	540	559.15	530.05	535.4	157437	854.25	8861	62522	39.709999084472656
Thu Feb 10 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	ASAHIINDIA	563.9	565.1	567	544.05	547.8	89564	495.72	4336	46359	51.7599983215332
Thu Feb 03 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	ASAHIINDIA	563.65	563.65	612.9	559.9	596.5	1440314	8610.61	46442	285554	19.82999992370605
Wed Jan 01 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	ASAHIINDIA	199.55	199.85	203.15	199	200.65	12833	25.79	363	6468	50.4
Thu Jan 02 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	ASAHIINDIA	200.65	203.8	204.8	200.05	203.65	10218	20.7	284	5185	50.74
Fri Jan 03 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	ASAHIINDIA	203.65	204.85	210.6	204.65	208.65	33228	69.22	789	24541	73.86


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