
    fi!                        d Z ddlZddlZddlmZ dej        fdZddedej        fdZ	ddedej        fd	Z
dej        fd
Zdej        fdZedk    r e            Z ee            e
d          Z ee            e            Z ee            e            Z ee           ed                                         D ]Z e
e          Z ee            e	d          Z ee           dS dS )u   
Date: 2025/4/11 22:00
Desc: 上海黄金交易所-数据资讯-行情走势
https://www.sge.com.cn/sjzx/mrhq
上海黄金交易所-数据资讯-上海金基准价-历史数据
上海黄金交易所-数据资讯-上海银基准价-历史数据
    N)headersreturnc                      g d} t          j        |           }|                    d           ddg|_        |d         dz   |d<   |S )u   
    上海黄金交易所-数据资讯-行情走势-品种表
    https://www.sge.com.cn/sjzx/mrhq
    :return: 品种表
    :rtype: pandas.DataFrame
    )Au99.99zAu99.95Au100gzPt99.95zAg(T+D)zAu(T+D)zmAu(T+D)zAu(T+N1)zAu(T+N2)zAg99.99ziAu99.99zAu99.5iAu100gziAu99.5PGC30gNYAuTN06NYAuTN12T)inplaceu   序号   品种   )pd	DataFramereset_indexcolumns)	temp_listtemp_dfs     @/usr/local/lib/python3.11/dist-packages/akshare/spot/spot_sge.pyspot_symbol_table_sger      s`      I& l9%%G%%%*GO)A-GHN    r   symbolc                    d}d| i}i ddddddd	d
dddddddddddd
ddddddddddd d!d"d#d$d%d&}t          j        |||'          }|                                }t          j        |d(         |d)         |d*         |d+         d,          }t          j        |d-         d./          |d-<   |d0         j        d1                                         d2         }t          j        |d3         d45          j	        j
        |d3<   ||d3                             t                    |k              }|                    d3g6          }|                    d7d78           |S )9u  
    上海黄金交易所-实时行情数据
    https://www.sge.com.cn/
    https://www.sge.com.cn/graph/quotations
    :param symbol: choice of {'Au99.99', 'Au99.95', 'Au100g', 'Pt99.95', 'Ag(T+D)', 'Au(T+D)',
    'mAu(T+D)', 'Au(T+N1)', 'Au(T+N2)', 'Ag99.99', 'iAu99.99', 'Au99.5', 'iAu100g',
    'iAu99.5', 'PGC30g', 'NYAuTN06', 'NYAuTN12'}; 可以通过 ak.spot_symbol_table_sge() 获取品种表
    :type symbol: str
    :return: 行情数据
    :rtype: pandas.DataFrame
    z'https://www.sge.com.cn/graph/quotationsinstidAcceptz.application/json, text/javascript, */*; q=0.01Accept-Encodingzgzip, deflate, br, zstdAccept-Languagezh-CN,zh;q=0.9,en;q=0.8Cache-Controlno-cache
Connection
keep-aliveContent-Length15Content-Type0application/x-www-form-urlencoded; charset=UTF-8Hostwww.sge.com.cnOriginhttps://www.sge.com.cnPragmaRefererzhttps://www.sge.com.cn/	sec-ch-uaA"Google Chrome";v="107", "Chromium";v="107", "Not=A?Brand";v="24"sec-ch-ua-mobile?0sec-ch-ua-platform	"Windows"Sec-Fetch-DestemptySec-Fetch-ModecorsSec-Fetch-Sitesame-originoMozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/107.0.0.0 Safari/537.36XMLHttpRequestz
User-AgentzX-Requested-Withdatar   heyuetimesr=   delaystr)r      时间   现价   更新时间rB   coerceerrorsrC   r   r   rA   z%H:%M)format)byT)r   drop)requestsgetjsonr   r   
to_numericilocsplitto_datetimedttimeastypestrsort_valuesr   )r   urlpayloadr   r	data_jsonr   update_times           r   spot_quotations_sger[   2   s     4C GB4 	4 		
 	l 	$ 	J 	  	* 	* 	, 	X 	D 	k 	'  	&!" 	-#$),)  G, 	Sw888AIl(('%j1		
 	
 G gh&7IIIGH.).q17799!<Kwx'8IIILQGHgh'..s33kABG!!hZ!00G4000Nr   c                 l   d}d| i}i ddddddd	d
dddddddddddd
ddddddddddd d!d"d#d$d%d&}t          j        |||'          }|                                }t          j        |d(                   }g d)|_        t          j        |d*         d+,          j        j        |d*<   t          j	        |d-         d+,          |d-<   t          j	        |d.         d+,          |d.<   t          j	        |d/         d+,          |d/<   t          j	        |d0         d+,          |d0<   |S )1u  
    上海黄金交易所-数据资讯-行情走势-历史数据
    https://www.sge.com.cn/sjzx/mrhq
    :param symbol: choice of {'Au99.99', 'Au99.95', 'Au100g', 'Pt99.95', 'Ag(T+D)', 'Au(T+D)',
    'mAu(T+D)', 'Au(T+N1)', 'Au(T+N2)', 'Ag99.99', 'iAu99.99', 'Au99.5', 'iAu100g', 'iAu99.5',
    'PGC30g', 'NYAuTN06', 'NYAuTN12'}; 可以通过 ak.spot_symbol_table_sge() 获取品种表
    :type symbol: str
    :return: 历史数据
    :rtype: pandas.DataFrame
    z$https://www.sge.com.cn/graph/Dailyhqr   r   ztext/html, */*; q=0.01r   zgzip, deflate, brr   r   r   r    r!   r"   r#   r$   r%   r&   r'   r(   r)   r*   r+   r,   z https://www.sge.com.cn/sjzx/mrhqr-   r.   r/   r0   r1   r2   r3   r4   r5   r6   r7   r8   r9   r:   r;   r<   rR   )dateopencloselowhighr]   rD   rE   r^   r_   ra   r`   )
rJ   postrL   r   r   r   rP   rQ   r]   rM   )r   rV   rW   r   rX   rY   r   s          r   spot_hist_sgerc   m   s    1C G*. 	4 		
 	l 	$ 	J 	  	* 	* 	5 	X 	D 	k 	'  	&!" 	-#$),)  G, 	c999AIl9V,--G  GO nWV_XFFFINGFOmGFOHEEEGFO}WW%5hGGGGGmGFOHEEEGFO]75>(CCCGENNr   c                  2   d} i }t          j        | |t                    }|                                }t	          j        |d                   }ddg|_        t	          j        |d         d          j        j	        |d<   t	          j        |d                   }dd	g|_        t	          j        |d         dd
          j        j	        |d<   |d	         |d	<   t	          j
        |d         d
          |d<   t	          j
        |d	         d
          |d	<   |S )u   
    上海黄金交易所-数据资讯-上海金基准价-历史数据
    https://www.sge.com.cn/sjzx/jzj
    :return: 历史数据
    :rtype: pandas.DataFrame
    z&https://www.sge.com.cn/graph/DayilyJzjr<   wp   交易时间	   晚盘价msunitzp	   早盘价rD   rj   rF   rE   rJ   rb   r   rL   r   r   r   rP   rQ   r]   rM   rV   rW   rX   rY   r   
temp_zp_dfs         r   spot_golden_benchmark_sgerq      s    3CGc999AIl9T?++GGO !nW^-D4PPPSXGNio..JJ "$>"h" " " ~ &k2GK=)=hOOOGK=)=hOOOGKNr   c                  2   d} i }t          j        | |t                    }|                                }t	          j        |d                   }ddg|_        t	          j        |d         d          j        j	        |d<   t	          j        |d                   }dd	g|_        t	          j        |d         dd
          j        j	        |d<   |d	         |d	<   t	          j
        |d         d
          |d<   t	          j
        |d	         d
          |d	<   |S )u   
    上海黄金交易所-数据资讯-上海银基准价-历史数据
    https://www.sge.com.cn/sjzx/mrhq
    :return: 历史数据
    :rtype: pandas.DataFrame
    z.https://www.sge.com.cn/graph/DayilyShsilverJzjr<   re   rf   rg   rh   ri   rk   rl   rD   rm   rE   rn   ro   s         r   spot_silver_benchmark_sgers      s    ;CGc999AIl9T?++GGO !nW^-D4PPPSXGNio..JJ "$>"h" " " ~ &k2GK=)=hOOOGK=)=hOOOGKNr   __main__)r   r   )r   )__doc__pandasr   rJ   akshare.utils.consr   r   r   rT   r[   rc   rq   rs   __name__spot_symbol_table_sge_dfprintspot_hist_sge_dfspot_golden_benchmark_sge_dfspot_silver_benchmark_sge_dftolistspotspot_quotations_sge_df r   r   <module>r      s         & & & & & &r|    B8 8 8BL 8 8 8 8v3 3# 3bl 3 3 3 3l2<    >2<    > z4466	E
"###$}I666	E
#<#<#>#> 	E
&'''#<#<#>#> 	E
&'''(299;;    (=55500	BBB	E
 !!!!!% r   