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	745	751.45	730.05	736.55	742.3610705288222	173858	5747	129065411	46602	26.8	21.4	-8.45
8-June-2021	750.7	750.7	739.5	746.1	744.7638180237232	182859	7174	136186767	74885	40.95	11.2	-4.6
7-June-2021	742.1	753.7	741.35	751.1	742.6438184535123	4216639	9569	3131460888	4091059	97.02	12.35	9
4-June-2021	749.6	760.1	740	742.1	748.5792590239806	264462	6993	197970768	53145	20.1	20.1	-7.5
3-June-2021	743.35	752	739.05	750.45	746.6030484224493	446198	12543	333132787	270997	60.73	12.95	7.1
2-June-2021	746	746.1	734.2	737.05	737.0709431832579	173646	4935	127989421	57472	33.1	11.9	-8.95
1-June-2021	752.3	753.15	741.35	745.1	745.7881174635005	186509	5476	139096196	39084	20.96	11.8	-7.2
31-May-2021	740	752.85	734.1	750.25	745.2854511288407	404973	10906	301820485	169066	41.75	18.75	10.25
28-May-2021	753.6	759.75	738.35	739.95	749.1284742910144	325606	8776	243920726	78341	24.06	21.4	-13.65
27-May-2021	735.2	754	731.05	750.25	744.3488674961258	380087	8130	282917328	140255	36.9	22.95	15.05


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