S&P BSE SENSEX 50

date Date	open_price Open Price	high_price High Price	low_price Low Price	close_price Close Price	wap WAP	no_of_shares No.of Shares	no_of_trades No. Of Trades	total_turnover_rs Total Turnover (Rs.)	deliverable_quantity Deliverable Quantity	n__deli_qty_to_traded_qty % Deli. Qty To Traded Qty	spread_high_low Spread High-Low	spread_close_open Spread Close-Open
9-June-2021	558.9	561.45	554	558.55	558.242604285892	233277	6901	130225160	145885	62.54	7.45	-0.35
8-June-2021	549	560.55	549	556.4	556.7098219453239	146865	4225	81761188	52200	35.54	11.55	7.4
7-June-2021	544.1	549.2	542.9	548.35	546.5747001529421	49692	1892	27160390	19776	39.8	6.3	4.25
4-June-2021	542.95	544.8	539.8	543.85	542.7713319596344	56781	1652	30819099	24575	43.28	5	0.9
3-June-2021	534	541.65	534	540.45	537.7721298219467	126142	4578	67835652	100360	79.56	7.65	6.45
2-June-2021	539.5	540.25	529.6	532.5	533.148590930594	147970	4857	78889997	76335	51.59	10.65	-7
1-June-2021	543	544.25	535.05	537.5	537.7526109025846	102838	3339	55301403	63825	62.06	9.2	-5.5
31-May-2021	530.5	543.9	529.55	540.4	538.539360150885	240713	6909	129633425	156287	64.93	14.35	9.9
28-May-2021	533.7	533.7	528	530.45	530.0966100407604	39499	1587	20938286	17125	43.36	5.7	-3.25
27-May-2021	533.9	533.9	524.2	527	528.7312430433716	53007	2203	28026457	25740	48.56	9.7	-6.9


CREATE TABLE dabur (
  "date" VARCHAR,
  "open_price" DOUBLE,
  "high_price" DOUBLE,
  "low_price" DOUBLE,
  "close_price" DOUBLE,
  "wap" DOUBLE,
  "no_of_shares" BIGINT,
  "no_of_trades" BIGINT,
  "total_turnover_rs" DOUBLE,
  "deliverable_quantity" DOUBLE,
  "n__deli_qty_to_traded_qty" DOUBLE,
  "spread_high_low" DOUBLE,
  "spread_close_open" DOUBLE
);