9 获取所有封闭式基金实时行情数据

本文介绍了如何使用Python库pandas和akshare获取中国封闭式基金的实时行情数据,包括名称、价格变动等,并将这些数据保存到CSV文件中以便后续分析。

摘要生成于 C知道 ,由 DeepSeek-R1 满血版支持, 前往体验 >

获取所有封闭式基金实时行情数据,打印完整数据,并保存到csv文件

代码:

import pandas as pd
import akshare as ak
# 列名与数据对其显示
pd.set_option('display.unicode.ambiguous_as_wide', True)
pd.set_option('display.unicode.east_asian_width', True)
# 显示所有列
pd.set_option('display.max_columns', None)
# 显示所有行
pd.set_option('display.max_rows', None)

close_fund = ak.fund_etf_category_sina(symbol="封闭式基金")
close_fund.to_csv("sina_close_fund_list.csv", encoding='utf-8-sig')
print(close_fund)

输出:

,代码,名称,最新价,涨跌额,涨跌幅,买入,卖出,昨收,今开,最高,最低,成交量,成交额
0,sz180801,首钢绿能,13.838,-0.038,-0.274,13.831,13.838,13.876,13.876,13.9,13.801,516180,7141699
1,sz180601,华润商业,6.849,-0.029,-0.422,6.841,6.849,6.878,6.878,6.88,6.805,530480,3633327
2,sz180501,红土安居,2.59,0.01,0.388,2.582,2.593,2.58,2.57,2.59,2.561,2249996,5796134
3,sz180401,鹏华深能,6.9,0.051,0.745,6.898,6.9,6.849,6.849,6.918,6.821,3834089,26331337
4,sz180301,盐港REIT,2.273,-0.017,-0.742,2.273,2.274,2.29,2.285,2.3,2.263,2422419,5508021
5,sz180202,越秀高速,7.1,0.0,0.0,7.089,7.1,7.1,7.09,7.18,7.04,479291,3400258
6,sz180201,广州广河,9.675,-0.028,-0.289,9.672,9.675,9.703,9.703,9.73,9.669,869061,8413896
7,sz180103,和达高科,2.358,0.003,0.127,2.351,2.358,2.355,2.355,2.4,2.326,2968848,6939684
8,sz180102,合肥高新,1.857,-0.007,-0.376,1.857,1.858,1.864,1.864,1.878,1.846,5758016,10688394
9,sz180101,蛇口产园,1.916,-0.002,-0.104,1.914,1.916,1.918,1.916,1.92,1.904,6268240,11978730
10,sh508099,中关村,2.277,-0.02,-0.871,2.278,2.28,2.297,2.293,2.294,2.253,5419170,12328785
11,sh508098,京东仓储,2.919,-0.048,-1.618,2.917,2.919,2.967,2.957,2.977,2.916,4287199,12572134
12,sh508096,京能光伏,10.176,-0.009,-0.088,10.122,10.177,10.185,10.185,10.186,10.062,560355,5690813
13,sh508088,东久REIT,3.166,-0.009,-0.283,3.164,3.166,3.175,3.175,3.206,3.163,2901691,9195890
14,sh508077,华润有巢,2.473,0.014,0.569,2.464,2.474,2.459,2.457,2.474,2.444,5890705,14502217
15,sh508068,京保REIT,2.902,0.007,0.242,2.901,2.902,2.895,2.895,2.916,2.859,3384434,9755985
16,sh508066,苏交REIT,6.814,-0.011,-0.161,6.817,6.831,6.825,6.82,6.839,6.785,766837,5216915
17,sh508058,厦门安居,2.724,-0.027,-0.981,2.722,2.723,2.751,2.744,2.759,2.72,3572761,9755839
18,sh508056,普洛斯,3.573,-0.016,-0.446,3.575,3.576,3.589,3.6,3.63,3.544,3246293,11596594
19,sh508031,城投宽庭,3.035,-0.005,-0.164,3.029,3.044,3.04,3.029,3.047,3.0,1011224,3064086
20,sh508028,国家电投,10.069,0.004,0.04,10.062,10.069,10.065,10.025,10.082,9.986,1132958,11389581
21,sh508027,东吴苏园,3.111,0.015,0.484,3.1,3.111,3.096,3.096,3.128,3.073,4509187,13951580
22,sh508021,临港REIT,4.37,0.009,0.206,4.349,4.36,4.361,4.38,4.399,4.304,2208998,9594775
23,sh508019,湖北科投,2.235,0.007,0.314,2.23,2.235,2.228,2.228,2.249,2.222,3643975,8143290
24,sh508018,中交REIT,5.258,-0.015,-0.284,5.257,5.258,5.273,5.273,5.292,5.25,3682911,19366098
25,sh508017,金茂商业,2.646,-0.027,-1.01,2.65,2.651,2.673,2.67,2.675,2.629,676400,1788740
26,sh508011,物美消费,2.367,-0.033,-1.375,2.365,2.369,2.4,2.39,2.39,2.365,520753,1238615
27,sh508009,安徽交控,8.385,-0.016,-0.19,8.385,8.397,8.401,8.401,8.415,8.337,1721481,14402320
28,sh508008,铁建REIT,9.508,-0.045,-0.471,9.508,9.529,9.553,9.55,9.6,9.483,1404605,13363130
29,sh508007,山东高速,7.069,-0.032,-0.451,7.037,7.069,7.101,7.101,7.137,7.034,1425186,10077753
30,sh508006,首创水务,3.807,-0.009,-0.236,3.806,3.807,3.816,3.816,3.837,3.774,4001636,15256409
31,sh508001,浙江杭徽,8.296,-0.015,-0.18,8.295,8.297,8.311,8.314,8.315,8.295,293870,2438864
32,sh508000,张江REIT,2.599,-0.004,-0.154,2.6,2.602,2.603,2.6,2.615,2.589,3771428,9810713

评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包

打赏作者

HelloCode5110

你的鼓励将是我创作的最大动力

¥1 ¥2 ¥4 ¥6 ¥10 ¥20
扫码支付:¥1
获取中
扫码支付

您的余额不足,请更换扫码支付或充值

打赏作者

实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值