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	1503.85	1527.35	1485	1491.55	1511.44451668468	118432	6471	179003397	33375	28.18	42.35	-12.3
8-June-2021	1505	1515.6	1490.25	1503.85	1504.1944319913923	66918	2895	100657683	9593	14.34	25.35	-1.15
7-June-2021	1518	1559.6	1495.25	1499.5	1516.3427216745208	172945	8857	262243892	30412	17.58	64.35	-18.5
4-June-2021	1455	1506.75	1452.95	1503.25	1491.418927646592	162577	8017	242470415	46696	28.72	53.8	48.25
3-June-2021	1455	1463.85	1435.95	1458.8	1451.3216211708457	35974	1818	52209844	8940	24.85	27.9	3.8
2-June-2021	1447.95	1453.5	1426.1	1441.85	1437.4620808380491	54603	3444	78489742	12725	23.3	27.4	-6.1
1-June-2021	1479.8	1479.8	1437.25	1444.8	1451.6560319377347	59616	3280	86541926	9522	15.97	42.55	-35
31-May-2021	1470	1494.7	1455.05	1470.75	1476.2310450344637	129412	7577	191042012	23804	18.39	39.65	0.75
28-May-2021	1433	1480.75	1421.1	1465.65	1455.7668448112568	147820	8175	215191455	57598	38.96	59.65	32.65
27-May-2021	1418.8	1435.3	1393.15	1420.3	1415.164542685054	86002	4469	121706981	24290	28.24	42.15	1.5


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