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	236.8	245.5	233.95	242	241.01779923429984	1092856	9902	263397748	131188	12	11.55	5.2
8-June-2021	239	239.2	232	234	235.10477682620837	424445	5023	99789047	107976	25.44	7.2	-5
7-June-2021	226.5	237.6	226.5	236.2	232.14605642947097	1661933	8658	385811192	1355451	81.56	11.1	9.7
4-June-2021	226.95	228	224.85	226.15	226.3818255551415	91238	1368	20654625	24689	27.06	3.15	-0.8
3-June-2021	229	231.45	225.6	226.15	227.91901688111017	138498	2053	31566328	49043	35.41	5.85	-2.85
2-June-2021	224	228	224	227.4	226.50547507311435	176436	2977	39963720	90701	51.41	4	3.4
1-June-2021	225.5	228	223.85	224.4	225.65661434536	203104	2669	45831761	75329	37.09	4.15	-1.1
31-May-2021	225.1	226.5	223.75	225.5	225.35101715745168	145651	2523	32822601	44301	30.42	2.75	0.4
28-May-2021	229.5	230.45	224.7	225.55	227.05030118339636	182779	3045	41500027	72715	39.78	5.75	-3.95
27-May-2021	226.7	229.5	223.2	228.45	226.20379138368753	387985	5182	87763678	120464	31.05	6.3	1.75


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