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	428	432.3	418.15	421.45	426.88133154475616	1375395	19896	587130449	212440	15.45	14.15	-6.55
8-June-2021	432.5	432.5	423.8	427.15	427.33929775130264	1995333	37091	852684203	657198	32.94	8.7	-5.35
7-June-2021	435.45	437.35	430.55	432.4	434.862586690794	996934	13774	433529298	192194	19.28	6.8	-3.05
4-June-2021	437.5	441.85	431.7	433.6	436.35338124731226	1618456	21526	706218748	319957	19.77	10.15	-3.9
3-June-2021	437.4	442	433.5	439.65	437.5286785863216	1776953	20254	777467898	396706	22.32	8.5	2.25
2-June-2021	431.85	437.9	429	437.2	434.6882658508183	2580545	45217	1121732631	1045302	40.51	8.9	5.35
1-June-2021	426.4	435.2	425.35	432.6	430.5548577108832	3328821	32409	1433240052	657119	19.74	9.85	6.2
31-May-2021	421.8	426	418	424.25	423.05369226549885	1965311	22664	831432075	340517	17.33	8	2.45
28-May-2021	429.7	433.6	420	422.05	426.5991948519524	4506252	55809	1922363475	1153726	25.6	13.6	-7.65
27-May-2021	414	428.95	412	425.3	419.1020341854224	3154678	31049	1322131967	577247	18.3	16.95	11.3


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