+
    Ȝi!                     x   R t ^ RIt^ RIt^ RIHt R R ltRR R lltRR R	 lltR
 R lt	R R lt
]R8X  d   ]! 4       t]! ]4       ]! RR7      t]! ]4       ]	! 4       t]! ]4       ]
! 4       t]! ]4       ]R,          P#                  4        F  t]! ]R7      t]! ]4       K  	  ]! RR7      t]! ]4       R# R# )u   
Date: 2025/4/11 22:00
Desc: 上海黄金交易所-数据资讯-行情走势
https://www.sge.com.cn/sjzx/mrhq
上海黄金交易所-数据资讯-上海金基准价-历史数据
上海黄金交易所-数据资讯-上海银基准价-历史数据
N)headersc                8    V ^8  d   QhR\         P                  /#    returnpd	DataFrame)formats   "^/Users/mibo/.openclaw/workspace/.venv-ak/lib/python3.14/site-packages/akshare/spot/spot_sge.py__annotate__r      s      r||     c                     . ROp \         P                  ! V 4      pVP                  RR7       RR.Vn        VR,          ^,           VR&   V# )u   
上海黄金交易所-数据资讯-行情走势-品种表
https://www.sge.com.cn/sjzx/mrhq
:return: 品种表
:rtype: pandas.DataFrame
T)inplaceu   序号   品种)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NYAuTN12)r   r	   reset_indexcolumns)	temp_listtemp_dfs     r   spot_symbol_table_sger      sO    I& ll9%G%*GO)A-GHNr   r   c                D    V ^8  d   QhR\         R\        P                  /# r   symbolr   strr   r	   )r
   s   "r   r   r   2   s     8 8 8BLL 8r   c                   RpRV /p/ RRbRRbRRbR	R
bRRbRRbRRbRRbRRbRR
bRRbRRbRRbRRbRRbR R!bR"R#bR$R%R&R'/Cp\         P                  ! WVR(7      pVP                  4       p\        P                  ! R)VR*,          R+VR,,          R-VR.,          R/VR0,          /4      p\        P
                  ! VR-,          R1R27      VR-&   VR/,          P                  ^ ,          P                  4       ^,          p\        P                  ! VR+,          R3R47      P                  P                  VR+&   WfR+,          P                  \        4      V8  ,          pVP                  R+.R57      pVP                  R6R6R77       V# )8u  
上海黄金交易所-实时行情数据
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-origin
User-AgentoMozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/107.0.0.0 Safari/537.36X-Requested-WithXMLHttpRequestdatar   r   heyueu   时间timesu   现价rF   u   更新时间delaystrcoerceerrorsz%H:%M)r
   )byT)r   drop)requestsgetjsonr   r	   
to_numericilocsplitto_datetimedttimeastyper    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, 	S8AIlli(i(i'Ij1		
G gh&7IGH.)..q1779!<Kwx'8ILLQQGHh'..s3kABG!!hZ!0G40Nr   c                D    V ^8  d   QhR\         R\        P                  /# r   r   )r
   s   "r   r   r   m   s     3 3# 3bll 3r   c                   RpRV /p/ RRbRRbRRbR	R
bRRbRRbRRbRRbRRbRR
bRRbRRbRRbRRbRRbR R!bR"R#bR$R%R&R'/Cp\         P                  ! WVR(7      pVP                  4       p\        P                  ! VR),          4      p. R1OVn        \        P                  ! VR*,          R/R07      P                  P                  VR*&   \        P                  ! VR+,          R/R07      VR+&   \        P                  ! VR,,          R/R07      VR,&   \        P                  ! VR.,          R/R07      VR.&   \        P                  ! VR-,          R/R07      VR-&   V# )2u  
上海黄金交易所-数据资讯-行情走势-历史数据
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/   r0   r1   r2   r3   r4   z https://www.sge.com.cn/sjzx/mrhqr5   r6   r7   r8   r9   r:   r;   r<   r=   r>   r?   r@   rA   rB   rC   rD   rE   rW   dateopencloselowhighrJ   rK   )rb   rc   rd   re   rf   )
rO   postrQ   r   r	   r   rU   rV   rb   rR   )r   rZ   r[   r   r\   r]   r   s   &      r   spot_hist_sgerh   m   s    1C G*. 	4 		
 	l 	$ 	J 	  	* 	* 	5 	X 	D 	k 	'  	&!" 	-#$ 	 ),)G, 	c9AIll9V,-GGO nnWV_XFIINNGFOmmGFOHEGFO}}WW%5hGGGmmGFOHEGFO]]75>(CGENNr   c                8    V ^8  d   QhR\         P                  /# r   r   )r
   s   "r   r   r            2<< r   c                 x   Rp / p\         P                  ! W\        R7      pVP                  4       p\        P
                  ! VR,          4      pRR.Vn        \        P                  ! VR,          RR7      P                  P                  VR&   \        P
                  ! VR,          4      pRR	.Vn        \        P                  ! VR,          RR
R7      P                  P                  VR&   VR	,          VR	&   \        P                  ! VR,          R
R7      VR&   \        P                  ! VR	,          R
R7      VR	&   V# )u   
上海黄金交易所-数据资讯-上海金基准价-历史数据
https://www.sge.com.cn/sjzx/jzj
:return: 历史数据
:rtype: pandas.DataFrame
z&https://www.sge.com.cn/graph/DayilyJzjrE   wp   交易时间	   晚盘价msunitzp	   早盘价rJ   rq   rL   rK   rO   rg   r   rQ   r   r	   r   rU   rV   rb   rR   rZ   r[   r\   r]   r   
temp_zp_dfs         r   spot_golden_benchmark_sgerx      s    3CGc9AIll9T?+GGO !nnW^-D4PSSXXGNio.JJ "$>"h"b ~ &k2GK==)=hOGK==)=hOGKNr   c                8    V ^8  d   QhR\         P                  /# r   r   )r
   s   "r   r   r      rj   r   c                 x   Rp / p\         P                  ! W\        R7      pVP                  4       p\        P
                  ! VR,          4      pRR.Vn        \        P                  ! VR,          RR7      P                  P                  VR&   \        P
                  ! VR,          4      pRR	.Vn        \        P                  ! VR,          RR
R7      P                  P                  VR&   VR	,          VR	&   \        P                  ! VR,          R
R7      VR&   \        P                  ! VR	,          R
R7      VR	&   V# )u   
上海黄金交易所-数据资讯-上海银基准价-历史数据
https://www.sge.com.cn/sjzx/mrhq
:return: 历史数据
:rtype: pandas.DataFrame
z.https://www.sge.com.cn/graph/DayilyShsilverJzjrE   rl   rm   rn   ro   rp   rr   rs   rJ   rt   rK   ru   rv   s         r   spot_silver_benchmark_sger{      s    ;CGc9AIll9T?+GGO !nnW^-D4PSSXXGNio.JJ "$>"h"b ~ &k2GK==)=hOGK==)=hOGKNr   __main__)r   r   )r   )__doc__pandasr   rO   akshare.utils.consr   r   r_   rh   rx   r{   __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      &B8v3l>> z46	
"#$I6	
#<#> 	
&'#<#> 	
&'(299;(5 < 1	B	
 !% r   