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	2574.95	2578.4	2538.3	2544.6	2559.834681595318	138079	6695	353459413	92012	66.64	40.1	-30.35
8-June-2021	2601.4	2601.4	2549.9	2554.3	2559.7684237697513	108474	4777	277668320	66757	61.54	51.5	-47.1
7-June-2021	2630	2635	2580.3	2584.7	2590.959092750101	153078	9963	396618836	88764	57.99	54.7	-45.3
4-June-2021	2598	2625.25	2585.05	2619.45	2611.5294368685363	100758	6397	263132483	38444	38.15	40.2	21.45
3-June-2021	2578	2603	2557.05	2582.85	2576.8974988883947	89960	5413	231817699	39742	44.18	45.95	4.85
2-June-2021	2542	2580	2532	2561.25	2544.519939804364	91701	5047	233335023	52232	56.96	48	19.25
1-June-2021	2560.25	2609.5	2560.25	2579.35	2583.677926144704	224818	15540	580857304	141140	62.78	49.25	19.1
31-May-2021	2541.35	2564.95	2439	2553.55	2534.6821730096035	213676	5791	541600748	138025	64.6	125.95	12.2
28-May-2021	2524	2549.95	2515	2540.95	2533.8659139026113	119028	4711	301600992	69269	58.2	34.95	16.95
27-May-2021	2583	2583	2488.55	2507	2526.8235796203157	174566	14851	441097485	81204	46.52	94.45	-76


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