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	642.5	645.5	629.1	635.95	638.3331168904754	882450	18331	563297059	442981	50.2	16.4	-6.55
8-June-2021	647.25	647.5	637.5	642.4	641.3683130851665	483089	12074	309837977	243352	50.37	10	-4.85
7-June-2021	644.2	649.75	644.2	648.25	647.2535520334009	533638	12143	345399091	378798	70.98	5.55	4.05
4-June-2021	653.55	654.85	639.35	642.8	645.5800178435201	464034	8596	299571078	139326	30.02	15.5	-10.75
3-June-2021	654	654.95	644.8	650.2	649.0495760155517	596720	11062	387300863	302955	50.77	10.15	-3.8
2-June-2021	648.9	649.3	641.15	648.35	644.7921512201159	735299	13429	474115024	388867	52.89	8.15	-0.55
1-June-2021	663.35	664.65	648.3	650.25	653.501703301707	592966	8853	387504291	259176	43.71	16.35	-13.1
31-May-2021	643.15	664.9	643.15	662.2	656.6345380640028	1359723	35171	892841084	897541	66.01	21.75	19.05
28-May-2021	656	660	639.35	643.2	648.3902357977673	541693	12513	351228452	150830	27.84	20.65	-12.8
27-May-2021	651.2	656.45	648.25	652.7	652.5473088226689	888756	15203	579955336	435771	49.03	8.2	1.5


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