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	881.4	901	831.3	852.55	868.0689243466454	1417148	31843	1230182140	191869	13.54	69.7	-28.85
8-June-2021	887.65	887.7	859.25	874.05	875.4653580812231	793172	16275	694394609	99676	12.57	28.45	-13.6
7-June-2021	838	898.8	836	878.5	877.2156930178347	2122651	53035	1862022768	467381	22.02	62.8	40.5
4-June-2021	831.9	842	823	834.05	832.9788404795135	847609	20716	706040362	198139	23.38	19	2.15
3-June-2021	819.5	849.2	810.6	825.4	829.3954329479702	1490283	35855	1236033914	319627	21.45	38.6	5.9
2-June-2021	803.95	824	802.9	811.6	815.3843040655095	1165512	27652	950340191	140388	12.05	21.1	7.65
1-June-2021	775	801.5	749.6	798.15	787.4968360231665	1178264	29906	927879172	436369	37.03	51.9	23.15
31-May-2021	780.7	780.75	761.7	769.65	767.8125876506015	317311	6545	243635380	53536	16.87	19.05	-11.05
28-May-2021	757	784.85	754.05	776.15	770.7986868433293	541748	10888	417578647	95195	17.57	30.8	19.15
27-May-2021	759.9	765	748.85	751.15	758.3361966036861	353442	9320	268027862	86826	24.57	16.15	-8.75


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