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	389	390.95	382.25	383.1	388.1808740692002	498496	4751	193506613	261865	52.53	8.7	-5.9
8-June-2021	395	395.05	381.1	387.65	385.9076621207769	616161	11839	237781251	168987	27.43	13.95	-7.35
7-June-2021	395.2	401.25	394.4	395.15	397.2025650165795	389939	5753	154884771	142309	36.5	6.85	-0.05
4-June-2021	399.2	399.25	392.35	395.15	395.58068624337744	299165	3934	118343896	35339	11.81	6.9	-4.05
3-June-2021	404.8	405.45	398	399.1	401.1108321180354	655532	8610	262940986	155511	23.72	7.45	-5.7
2-June-2021	390	402	389.1	398.9	396.42265682612816	503089	7579	199435878	268872	53.44	12.9	8.9
1-June-2021	396	396.6	386.7	394.8	391.8667777359775	279105	3605	109371977	36076	12.93	9.9	-1.2
31-May-2021	394	395.2	388	394.2	390.7329238658287	1030444	5947	402628397	90273	8.76	7.2	0.2
28-May-2021	392	398.35	385	387.55	392.5209803750291	686880	9891	269614811	186968	27.22	13.35	-4.45
27-May-2021	382.5	388.4	380.05	385.9	384.5041565182317	451219	4648	173495581	46367	10.28	8.35	3.4


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