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	156	161.35	155.35	156.3	158.2030077714963	1279419	8733	202407934	297724	23.27	6	0.3
8-June-2021	157.4	157.4	152.9	155.95	155.32322013104107	756404	5522	117487105	154354	20.41	4.5	-1.45
7-June-2021	155.45	158.75	155.45	156.2	156.97070678404356	2156472	20983	338502934	973013	45.12	3.3	0.75
4-June-2021	149.1	154.3	148.25	153.1	151.77258940473732	2765821	18025	419775815	1198431	43.33	6.05	4
3-June-2021	149.8	150.35	148.65	149.1	149.70070773172415	806379	4128	120715507	141272	17.52	1.7	-0.7
2-June-2021	147.55	149.8	147.2	149	149.0098164227206	756793	7460	112769586	425800	56.26	2.6	1.45
1-June-2021	149	149.35	146.9	147.6	147.9878208890778	741105	6574	109674514	304662	41.11	2.45	-1.4
31-May-2021	147.9	148.35	145.05	147.8	146.7802165288851	571194	3790	83839979	110084	19.27	3.3	-0.1
28-May-2021	146.1	148.85	144.8	146.85	147.2985177192106	714507	5274	105245822	168357	23.56	4.05	0.75
27-May-2021	146.5	146.5	144.15	144.55	145.20086983835503	413870	3464	60094284	119614	28.9	2.35	-1.95


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