13 获取指定日期郑州商品交易所期货行情数据

lildkdkdkjf

已于 2024-10-02 15:14:26 修改

阅读量515

点赞数 2

分类专栏：【Python量化交易】文章标签： python 金融

于 2024-03-19 23:21:56 首次发布

本文链接：https://blog.csdn.net/lildkdkdkjf/article/details/136858438

版权

【Python量化交易】专栏收录该内容

21 篇文章

订阅专栏

该篇文章展示了2024年3月19日从中国郑州商品交易所获取的期货市场数据，包括苹果、棉花等多品种的开盘价、收盘价、最高价、最低价、成交量和持仓量等关键信息。

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

数据来源：http://www.czce.com.cn/cn/jysj/mrhq/H770301index_1.htm

代码：

import akshare as ak
from datetime import datetime
import pandas as pd
pd.set_option('display.max_columns', None)
pd.set_option('display.max_rows', None)
pd.set_option('display.width', 1000)

czce_daily = ak.get_czce_daily(datetime.now().strftime('%Y%m%d'))

print(czce_daily)

获取到的数据：苹果、棉花、红枣、棉纱、玻璃、粳稻、晚籼稻、甲醇、菜油、短纤、花生、普麦、对二甲苯、早籼稻、菜粕、菜籽、纯碱、硅铁、烧碱、锰硅、白糖、PTA、尿素、强麦、动力煤

结果：

    symbol      date     open     high      low    close   volume  open_interest    turnover   settle  pre_settle variety
0    AP404  20240319   7505.0   7532.0   7383.0   7425.0      296            695     2203.52   7444.0      7569.0      AP
1    AP405  20240319   7826.0   7970.0   7762.0   7860.0   136816         105583  1074045.36   7850.0      7826.0      AP
2    AP410  20240319   8321.0   8482.0   8297.0   8405.0     8332          12115    69890.61   8388.0      8310.0      AP
3    AP411  20240319   7945.0   8106.0   7935.0   8040.0      618           2649     4954.38   8017.0      7941.0      AP
4    AP412  20240319   8043.0   8185.0   8043.0   8142.0       22            132      178.39   8108.0      8025.0      AP
5    AP501  20240319   8179.0   8315.0   8179.0   8237.0       73            324      602.31   8251.0      8174.0      AP
6    AP503  20240319      0.0      0.0      0.0      0.0        0              0        0.00   8250.0      8250.0      AP
7    CF405  20240319  16090.0  16095.0  15950.0  15980.0   256415         493121  2053194.34  16015.0     16105.0      CF
8    CF407  20240319  16120.0  16130.0  15990.0  16030.0    14123          29082   113277.15  16040.0     16140.0      CF
9    CF409  20240319  16250.0  16255.0  16110.0  16150.0    72443         142723   585922.88  16175.0     16255.0      CF
10   CF411  20240319  16220.0  16225.0  16115.0  16150.0      395           6634     3193.31  16170.0     16225.0      CF
11   CF501  20240319  16085.0  16105.0  15990.0  16005.0     4690          28325    37604.17  16035.0     16080.0      CF
12   CF503  20240319  16020.0  16020.0  16020.0  16020.0        1              7        8.01  16020.0     16110.0      CF
13   CJ405  20240319  12255.0  12470.0  12135.0  12460.0    24014          38561   148068.07  12330.0     12355.0      CJ
14   CJ407  20240319  12460.0  12655.0  12340.0  12650.0      321           3567     2008.53  12515.0     12510.0      CJ
15   CJ409  20240319  12630.0  12855.0  12520.0  12840.0     7106          26745    45135.47  12705.0     12705.0      CJ
16   CJ412  20240319  13060.0  13230.0  12960.0  13230.0      180           1258     1179.99  13110.0     13045.0      CJ
17   CJ501  20240319  13110.0  13280.0  12990.0  13280.0      742           4214     4878.10  13150.0     13100.0      CJ
18   CJ503  20240319  13400.0  13400.0  13100.0  13375.0       17             18      112.51  13235.0     13095.0      CJ
19   CY404  20240319      0.0      0.0      0.0      0.0        0              0        0.00  21480.0     21545.0      CY
20   CY405  20240319  21290.0  21290.0  21080.0  21265.0     4459           5929    47207.10  21175.0     21325.0      CY
21   CY406  20240319  20635.0  21635.0  20635.0  21635.0        3              2       31.95  21295.0     21455.0      CY
22   CY407  20240319      0.0      0.0      0.0      0.0        0              3        0.00  21530.0     21530.0      CY
23   CY408  20240319      0.0      0.0      0.0      0.0        0              0        0.00  20110.0     20260.0      CY
24   CY409  20240319  22160.0  22160.0  21970.0  22075.0       66            220      727.81  22055.0     22185.0      CY
25   CY410  20240319      0.0      0.0      0.0      0.0        0              0        0.00  22400.0     22400.0      CY
26   CY411  20240319      0.0      0.0      0.0      0.0        0              1        0.00  22455.0     22455.0      CY
27   CY412  20240319      0.0      0.0      0.0      0.0        0              0        0.00  22400.0     22400.0      CY
28   CY501  20240319  22175.0  22315.0  22150.0  22315.0       11             30      122.17  22210.0     22310.0      CY
29   CY502  20240319      0.0      0.0      0.0      0.0        0              0        0.00  22595.0     22595.0      CY
30   CY503  20240319      0.0      0.0      0.0      0.0        0              0        0.00  22550.0     22595.0      CY
31   FG404  20240319   1573.0   1598.0   1569.0   1585.0      596           1573     1890.28   1586.0      1590.0      FG
32   FG405  20240319   1534.0   1568.0   1529.0   1553.0   853912         663693  2645011.46   1549.0      1559.0      FG
33   FG406  20240319   1546.0   1570.0   1538.0   1556.0     2868           7988     8918.74   1555.0      1561.0      FG
34   FG407  20240319   1518.0   1549.0   1518.0   1534.0      875           4390     2688.60   1536.0      1540.0      FG
35   FG408  20240319   1527.0   1555.0   1527.0   1545.0      444           4323     1367.65   1540.0      1558.0      FG
36   FG409  20240319   1504.0   1528.0   1497.0   1514.0   187031         385352   565545.02   1512.0      1516.0      FG
37   FG410  20240319   1528.0   1542.0   1515.0   1530.0      587           2781     1792.74   1527.0      1532.0      FG
38   FG411  20240319   1497.0   1516.0   1490.0   1506.0      366           3311     1098.95   1501.0      1509.0      FG
39   FG412  20240319   1502.0   1525.0   1500.0   1513.0      226           2847      682.64   1510.0      1517.0      FG
40   FG501  20240319   1478.0   1497.0   1471.0   1483.0    16264          45413    48260.97   1484.0      1488.0      FG
41   FG502  20240319   1497.0   1510.0   1490.0   1501.0       93           1029      278.58   1498.0      1502.0      FG
42   FG503  20240319   1474.0   1496.0   1473.0   1483.0      190            363      563.41   1483.0      1486.0      FG