f i dZddlZddlZddlZddlZddlmZdejfdZdejfdZ dejfdZ e dkrAeZ e e e Ze ee Ze edSdS) un Date: 2024/4/3 16:08 Desc: 金十数据-数据中心-主要机构-宏观经济 https://datacenter.jin10.com/ N)tqdmreturnc Ftj}ddddd}d}ddd ttt|d zd }t j} t j||| }|}|ddsnt j|dd}t j ||gd }|j d}tj |dtj dz }|d|igd|_d|d<|gd}t j|ddjj|d<t j|dd|d<t j|dd|d<t j|dd|d<|dgd |d d !|S)"u 全球最大黄金 ETF—SPDR Gold Trust 持仓报告, 数据区间从 20041118-至今 https://datacenter.jin10.com/reportType/dc_etf_gold :return: 持仓报告 :rtype: pandas.DataFrame oMozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/107.0.0.0 Safari/537.36rU6QIu7JHe2gOUeR x-csrf-token1.0.0 user-agentx-app-idr x-version0https://datacenter-api.jin10.com/reports/list_v2etf1categoryattr_idmax_date_Tparamsheadersdatavaluesobjs ignore_indexr%Y-%m-%ddaysr日期 总库存 增持/减持 总价值u黄金商品r+r'r(r)r*r'coerceerrorsr(r)r*inplacer1droptimestrintroundpd DataFramerequestsgetjsonconcatiatdatetimestrptime timedeltadate isoformatupdatecolumns to_datetimedt to_numeric sort_values reset_index trurlrbig_dfr data_jsontemp_df last_date_strs L/usr/local/lib/python3.11/dist-packages/akshare/economic/macro_constitute.pymacro_cons_goldrUC A)&& G =C U1t8__%% & & F \^^F8 LVW = = =FFHH  *  ,y0:;; 1EEE E* !**=*EE$!,,,-TVV Y[[   zm#56777!8"FN  F8    F~fX&6xHHHKPF8-{(;HMMMF; mF?,CHUUUF?-{(;HMMMF; z4000 t$/// Mc Ftj}ddddd}d}ddd ttt|d zd }t j} t j||| }|}|ddsnt j|dd}t j ||gd }|j d}tj |dtj dz }|d|igd|_d|d<|gd}t j|ddjj|d<t j|dd|d<t j|dd|d<t j|dd|d<|dgd |d d !|S)"u 全球最大白银 ETF—SPDR Gold Trust 持仓报告, 数据区间从 20041118-至今 https://datacenter.jin10.com/reportType/dc_etf_sliver :return: 持仓报告 :rtype: pandas.DataFrame rrrr r rr2rrrTrrrrr r"r#r$rr&u白银r+r,r'r-r.r(r)r*r0r2r4rLs rTmacro_cons_silverrZRrVrWctj}tj}dddddddddd d d d d }tjdt t t|dz|}|d}tt|}|D]g}| d|dtjd|dt t t|dz|}tj|ddtj|ddd j }|jdddf|_|jddddf} |gdjdddf}n #|gdjdddf}YnxYw|d !|||j<i|j }|t&}|d !|d"d#id $d|j_|S)%u 欧佩克报告-月度, 数据区间从 20170118-至今 这里返回的具体索引日期的数据为上一个月的数据, 由于某些国家的数据有缺失 只选择有数据的国家返回 20200312:fix:由于 “厄瓜多尔” 已经有几个月没有更新数据，在这里加以剔除 https://datacenter.jin10.com/reportType/dc_opec_report :return: 欧佩克报告-月度 :rtype: pandas.DataFrame z*/*zgzip, deflate, brzzh-CN,zh;q=0.9,en;q=0.8zno-cachezhttps://datacenter.jin10.comz6https://datacenter.jin10.com/reportType/dc_opec_reportcorsz same-sitezsMozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/79.0.3945.117 Safari/537.36rrr ) acceptzaccept-encodingzaccept-languagez cache-controloriginpragmarefererzsec-fetch-modezsec-fetch-siter r rr z?https://datacenter-api.jin10.com/reports/dates?category=opec&_=r)rNrrz*Please wait for a moment, now downloading z's datazAhttps://datacenter-api.jin10.com/reports/list?category=opec&date=z&_=rkeysname)rFrNr#) u阿尔及利亚u 安哥拉u加蓬u伊朗u 伊拉克u 科威特u 利比亚u 尼日利亚u沙特u 阿联酋u 委内瑞拉u欧佩克产量r!Tr0indexr')rFr1)r5r9r:r;r<r6r7r8r=rreversedset_descriptiontolistTilocrFdropnarbastypefloatrKrename)rMrOrres all_date_listbaritemrRs rTmacro_cons_opec_monthrrs A \^^F.4#0K %-&G , icRUV[\]`d\dVeVeRfRfNgNg i i   CHHJJv&M x && ' 'C0'0' VVVVWWWlG"&GG+.s5T??/C/C+D+DGG    , HHJJv x (LF!3F!;<r|s#  >>>>>B>2<>>>>BXr|XXXXv z(** E ,,.. E 4466 E "#####rW