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	2770	2770	2717.65	2728	2746.7849940294545	15074	2089	41405037	3954	26.23	52.35	-42
8-June-2021	2779.95	2779.95	2744.8	2762.9	2764.276069992906	25374	3387	70140741	11705	46.13	35.15	-17.05
7-June-2021	2755	2796.95	2750.3	2755.2	2773.5998366983367	26944	2662	74731874	7322	27.17	46.65	0.2
4-June-2021	2773.95	2774.95	2726.75	2742.35	2749.860911333247	38515	4116	105910893	14303	37.14	48.2	-31.6
3-June-2021	2680	2775	2680	2768.15	2737.228647909565	51927	6336	142136072	21161	40.75	95	88.15
2-June-2021	2656	2693.45	2640.05	2677.4	2674.650484901917	18148	2013	48539557	4324	23.83	53.4	21.4
1-June-2021	2630	2702.7	2630	2665.6	2683.4403695408732	60724	6197	162949233	21138	34.81	72.7	35.6
31-May-2021	2640	2684.15	2616.2	2676.55	2662.3130057723642	36207	3494	96394367	11839	32.7	67.95	36.55
28-May-2021	2621	2709.2	2621	2638.05	2667.265294771969	122264	12478	326110524	35511	29.04	88.2	17.05
27-May-2021	2648	2676.75	2590	2605.3	2634.304711813768	32132	3450	84645479	7233	22.51	86.75	-42.7


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