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	214.1	214.75	211.5	212.4	213.35296969426383	2060633	23425	439642170	1075455	52.19	3.25	-1.7
8-June-2021	212	214.1	211.1	213.65	212.65074341933288	2019856	24071	429523880	1243273	61.55	3	1.65
7-June-2021	210.15	212.35	210.15	211.45	210.6518835321665	4170834	30508	878594038	2906600	69.69	2.2	1.3
4-June-2021	209.85	209.85	208	208.8	208.5567616697972	1752644	28770	365525757	1001386	57.14	1.85	-1.05
3-June-2021	210.5	210.8	208.75	209.1	209.5675341267037	2012427	27562	421739364	1005950	49.99	2.05	-1.4
2-June-2021	211.1	212.5	208.7	209	210.0230462649088	2494504	25023	523903329	1117483	44.8	3.8	-2.1
1-June-2021	218.45	219.35	214.2	215.2	216.6894920782676	1325657	11701	287255942	488681	36.86	5.15	-3.25
31-May-2021	215.5	217.95	214.4	216.6	216.7323819470353	2404281	19074	521085548	731716	30.43	3.55	1.1
28-May-2021	212.05	213.45	211.45	212.85	212.7006569396453	1804732	18059	383867682	1007225	55.81	2	0.8
27-May-2021	211.45	214.15	210.25	211.2	212.14023565817288	1270654	9681	269556839	418313	32.92	3.9	-0.25


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