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	972	985.25	965	971.85	975.4829205287588	838492	13307	817934625	616024	73.47	20.25	-0.15
8-June-2021	950	971.75	950	967.05	964.623100765619	599123	23744	577927886	411263	68.64	21.75	17.05
7-June-2021	936.95	951.8	936.95	949.65	946.2036016089696	409206	13311	387192191	264405	64.61	14.85	12.7
4-June-2021	939.85	944.25	935.15	936.95	939.7378641329731	351108	13910	329949482	249384	71.03	9.1	-2.9
3-June-2021	946.45	949.35	937	939.85	940.2616469824856	191101	6921	179684941	134012	70.13	12.35	-6.6
2-June-2021	950.6	950.6	937.2	943.45	941.59187676249	118795	4138	111856407	48116	40.5	13.4	-7.15
1-June-2021	948	952.3	942.4	950.55	948.0422206297683	118615	4371	112452028	51519	43.43	9.9	2.55
31-May-2021	940.5	946.95	925.95	945.2	941.1808494324832	371707	12049	349843510	224106	60.29	21	4.7
28-May-2021	941.65	949.15	937.95	943.65	943.9946951519181	138364	4557	130614882	72891	52.68	11.2	2
27-May-2021	950	956.5	935.7	941.35	948.5386581641176	335272	7536	318018453	191866	57.23	20.8	-8.65


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