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	1060	1064.6	1045.45	1051.9	1059.1704349762765	502878	6982	532633510	336220	66.86	19.15	-8.1
8-June-2021	1040	1061.55	1037.3	1058.55	1055.1054791699817	213682	7815	225457049	89960	42.1	24.25	18.55
7-June-2021	1020.05	1039	1020	1032.4	1027.643020806386	54118	2560	55613985	24928	46.06	19	12.35
4-June-2021	1025	1026.25	1011.1	1018.75	1020.5264726357829	81877	2567	83557646	29029	35.45	15.15	-6.25
3-June-2021	1016	1020.75	1006.8	1013.9	1012.8770302634445	45930	2463	46521442	12355	26.9	13.95	-2.1
2-June-2021	1030	1030	994.1	1016.9	1007.9442937529484	118712	5652	119655083	20006	16.85	35.9	-13.1
1-June-2021	1021.2	1032	1013.35	1030.4	1024.4402708948344	74863	4440	76692672	39566	52.85	18.65	9.2
31-May-2021	1022	1031.9	1013.05	1021.85	1022.8294642155709	50916	2454	52078385	18667	36.66	18.85	-0.15
28-May-2021	1023	1032.9	1012.9	1026.15	1025.0905413059309	61795	2513	63345470	21367	34.58	20	3.15
27-May-2021	1013.45	1031.9	1007.1	1019.6	1020.7967990386192	256298	9522	261628178	150042	58.54	24.8	6.15


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