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	1115	1127.95	1094.4	1100.9	1109.88199224187	418142	10404	464088276	57696	13.8	33.55	-14.1
8-June-2021	1133	1134	1100.05	1110.5	1110.1713856610604	519355	11958	576573060	123101	23.7	33.95	-22.5
7-June-2021	1129.95	1150	1125.7	1128.3	1135.6810749341812	661287	14466	751011131	282703	42.75	24.3	-1.65
4-June-2021	1119	1128.9	1107.25	1119.9	1116.5386699213232	343303	8515	383311075	44869	13.07	21.65	0.9
3-June-2021	1128	1139.4	1113.3	1121.7	1126.0917524903937	415095	10174	467435056	55707	13.42	26.1	-6.3
2-June-2021	1107.95	1129	1105	1123.55	1116.508406357904	566476	12407	632475216	91059	16.07	24	15.6
1-June-2021	1128	1128	1085.5	1100.3	1097.8714469913125	939978	21087	1031975007	258553	27.51	42.5	-27.7
31-May-2021	1105.2	1129.85	1099.45	1125.65	1116.0338331245796	930922	23996	1038940448	240686	25.85	30.4	20.45
28-May-2021	1127.1	1143.8	1097.55	1103.75	1124.118519922634	881008	19057	990357409	182953	20.77	46.25	-23.35
27-May-2021	1082	1109.65	1075	1096.6	1091.7123632694174	1100979	18406	1201952386	150291	13.65	34.65	14.6


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