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	1486	1501.65	1472	1479.75	1488.6761616345611	263508	16962	392278078	112037	42.52	29.65	-6.25
8-June-2021	1499.3	1501.4	1482	1484	1487.307365826944	87648	5200	130359516	34166	38.98	19.4	-15.3
7-June-2021	1505.1	1512.15	1495.85	1499.2	1501.0203478636631	185130	12545	277883897	85141	45.99	16.3	-5.9
4-June-2021	1521	1521	1499	1501.15	1508.461678552431	110917	5449	167314044	30944	27.9	22	-19.85
3-June-2021	1509.7	1524.9	1488.15	1520.2	1515.366683941431	258566	15930	391822302	161219	62.35	36.75	10.5
2-June-2021	1511	1511.05	1493.2	1504.1	1499.8015233223996	89935	4824	134884650	24896	27.68	17.85	-6.9
1-June-2021	1517.2	1526.35	1508	1511.45	1515.7766377491964	247947	15039	375832270	131278	52.95	18.35	-5.75
31-May-2021	1503.8	1519.35	1487.6	1516.4	1507.3921936710713	205090	8717	309151065	60237	29.37	31.75	12.6
28-May-2021	1496.45	1513	1479.4	1501.15	1493.2594569630958	166729	6628	248969656	66352	39.8	33.6	4.7
27-May-2021	1477.7	1488.65	1462.35	1479.4	1469.8729584477776	210073	7639	308780622	54859	26.11	26.3	1.7


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