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	2936	2964.95	2920.4	2944.1	2950.193109918926	124701	6780	367892031	77662	62.28	44.55	8.1
8-June-2021	2922.7	2944.65	2906.9	2928.1	2925.331754592493	73054	4851	213707186	45761	62.64	37.75	5.4
7-June-2021	2930	2940	2904.55	2934.1	2917.421699893452	155798	2311	454528466	141076	90.55	35.45	4.1
4-June-2021	2946.25	2990	2909.25	2924	2944.7496533422586	83656	3288	246345977	49730	59.45	80.75	-22.25
3-June-2021	2906	2941.95	2904	2934.9	2919.25557022784	47709	4583	139274764	20508	42.99	37.95	28.9
2-June-2021	2912.75	2934.65	2877.4	2905.35	2916.418588410104	134600	7390	392549942	83265	61.86	57.25	-7.4
1-June-2021	2956	2982	2915.25	2933.15	2956.858272972461	110861	9333	327800265	37443	33.77	66.75	-22.85
31-May-2021	2940	2995	2935.1	2978.15	2972.468449311573	112866	6989	335490624	20371	18.05	59.9	38.15
28-May-2021	2965	2965	2901.35	2939.95	2943.465583247196	52242	5145	153772529	23352	44.7	63.65	-25.05
27-May-2021	2944.2	2969.95	2902.6	2951.25	2933.476348464284	39786	3064	116711290	8360	21.01	67.35	7.05


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