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	808	816.55	801.05	804.25	809.6189426286779	128810	3845	104287016	45825	35.58	15.5	-3.75
8-June-2021	806	810.05	797.7	807.8	805.5397644643417	70138	2737	56498948	18289	26.08	12.35	1.8
7-June-2021	805.15	811.6	802.55	803.8	806.5384623500489	94781	3613	76444522	36774	38.8	9.05	-1.35
4-June-2021	813	813.75	803.1	804.4	807.8708686085603	301321	9631	243428458	126389	41.94	10.65	-8.6
3-June-2021	813	813	798	802.1	803.9925313870821	211552	9029	170086228	89264	42.19	15	-10.9
2-June-2021	806.4	811.95	802.5	806.2	805.3469570219203	159942	6275	128808803	58251	36.42	9.45	-0.2
1-June-2021	814.5	818	800.3	806.4	808.3470350565415	250966	11023	202867622	107693	42.91	17.7	-8.1
31-May-2021	829.5	829.5	790	807.9	802.9083154744756	871183	27999	699480075	198856	22.83	39.5	-21.6
28-May-2021	830	852.5	810.95	846.2	834.1553937865413	401258	12101	334711525	49955	12.45	41.55	16.2
27-May-2021	822.5	830.9	817	828.55	826.3891770221202	182593	7467	150892879	95530	52.32	13.9	6.05


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