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	550	552	535.2	540.8	542.8686453981393	1328191	18217	721033249	884918	66.63	16.8	-9.2
8-June-2021	539.95	548	533.85	546.8	541.8873188897725	928026	18798	502885521	634541	68.38	14.15	6.85
7-June-2021	534	541	532.85	536.55	537.6075625087632	763133	14739	410266072	378312	49.57	8.15	2.55
4-June-2021	534.8	535.75	531.25	532.7	533.2293057999804	661985	12196	352989802	398176	60.15	4.5	-2.1
3-June-2021	531.85	533.35	528.7	532.1	531.0130921930681	735782	15452	390709875	479872	65.22	4.65	0.25
2-June-2021	530.1	534.5	528	529.6	530.5443242707087	494007	11723	262092610	273203	55.3	6.5	-0.5
1-June-2021	538	538	530.15	532.9	533.4468827840583	501024	12404	267269691	232077	46.32	7.85	-5.1
31-May-2021	525.8	535.8	525.4	534.95	532.4793799369153	927325	19141	493781441	549560	59.26	10.4	9.15
28-May-2021	520	528.5	520	523.65	524.3343810453393	567586	13541	297604854	224678	39.58	8.5	3.65
27-May-2021	526	527	518.7	519.95	522.6201773994345	489855	17858	256008107	258985	52.87	8.3	-6.05


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