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	2370	2371.95	2345.7	2356.3	2357.261795040597	27342	2371	64452252	8781	32.12	26.25	-13.7
8-June-2021	2342	2361.15	2333	2354.3	2350.0155155915368	131674	9975	309435943	78106	59.32	28.15	12.3
7-June-2021	2351	2351	2331	2339.45	2336.612311691929	43081	4598	100663595	26433	61.36	20	-11.55
4-June-2021	2369	2369	2333.4	2341.65	2341.9718751224095	51058	7267	119576400	31100	60.91	35.6	-27.35
3-June-2021	2370	2371	2345.05	2361.9	2356.1151214782094	18563	2022	43736565	6938	37.38	25.95	-8.1
2-June-2021	2358.45	2373.85	2348.95	2358.65	2358.953540348101	50560	4913	119268691	21843	43.2	24.9	0.2
1-June-2021	2345	2362	2329.95	2358.45	2351.2075111230783	77991	7023	183373025	52697	67.57	32.05	13.45
31-May-2021	2325	2344.55	2320	2341.35	2332.149487510965	86636	6015	202048103	55854	64.47	24.55	16.35
28-May-2021	2340	2349.35	2320	2322.8	2331.415678333816	51855	7767	120895560	27838	53.68	29.35	-17.2
27-May-2021	2357	2357	2320.75	2327.6	2332.6365436770734	79275	3607	184919762	24197	30.52	36.25	-29.4


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