## 一、数据简介 本表记录 A 股融资融券的全市场统计,由 `cn_stock_margin_trading_detail` 当日全部股票汇总得到。每个交易日 2 行,分别是 `sum`(求和)和 `mean`(平均)两种计算方法。 - 数据起始时间:2010-04-01 - 数据结束时间:2026-11-16 - 数据更新频率:每个交易日,在个股明细表更新之后更新 ## 二、主键说明 | 关键字 | 释意 | | --- | --- | | date | 交易日 | | method | 计算方法,取值为 `sum` 和 `mean`,每个交易日各一行 | 本表没有 `instrument` 列。 ## 三、字段口径 金额字段的单位为元,数量字段的单位为股。 | 字段 | 口径 | | --- | --- | | financing_balance | 融资余额。`method` 为 `sum` 时是当日个股融资余额之和,`mean` 时是个股平均值 | | financing_balance_ratio | 融资余额占流通市值比,小数形式。`sum` 行为 `financing_balance` 除以当日这些股票的流通市值之和。`mean` 行的分子是个股平均融资余额,分母仍是流通市值之和,所以 `mean` 行的比值约等于 `sum` 行的比值除以当日股票数量,不是个股比值的平均 | | margin_trading_balance | 融资融券余额,`sum` 行是当日个股融资融券余额之和,`mean` 行是个股平均值 | 其余字段(融资买入额、偿还额、净买入额,融券余额、卖出额、偿还额、净卖出额及对应数量)与 `cn_stock_margin_trading_detail` 同名字段含义相同,`sum` 行是全部个股求和,`mean` 行是个股平均值。 ## 四、已知限制 - 汇总范围是 `cn_stock_margin_trading_detail` 当日有数据的股票。 - 按 `sum` 汇总全市场数据时,需要用 `method = 'sum'` 过滤,否则会把 `mean` 行一并读入。 ## 五、示例数据 示例取 2026-10-18 至 2026-11-17 的数据,按 `date`、`method` 排序,展示前 5 行和后 5 行。 | date | method | financing_balance | financing_quantity | financing_balance_ratio | financing_purchase | financing_purchase_quantity | financing_repayment | financing_repayment_quantity | financing_net_purchase | financing_net_purchase_quantity | securities_lending_balance | securities_lending_quantity | securities_lending_sales | securities_lending_sales_quantity | securities_lending_repayment | securities_lending_repayment_quantity | securities_lending_net_sales | securities_lending_net_sales_quantity | margin_trading_balance | |:--------------------|:---------|--------------------:|---------------------:|--------------------------:|---------------------:|------------------------------:|----------------------:|-------------------------------:|-------------------------:|----------------------------------:|-----------------------------:|------------------------------:|---------------------------:|------------------------------------:|-------------------------------:|----------------------------------------:|-------------------------------:|----------------------------------------:|-------------------------:| | 2026-10-19 00:00:00 | mean | 5.98247e+08 | 3.50663e+07 | 6.99661e-06 | 2.47059e+07 | 1.41549e+06 | 2.67332e+07 | 1.52944e+06 | -2.02728e+06 | -113951 | 5.64806e+06 | 415095 | 182495 | 11004.8 | 159951 | 8463.27 | 22543.8 | 2541.51 | 6.03895e+08 | | 2026-10-19 00:00:00 | sum | 2.32419e+12 | 1.36232e+11 | 0.0271818 | 9.59826e+10 | 5.49919e+09 | 1.03859e+11 | 5.94189e+09 | -7.87597e+09 | -4.42701e+08 | 2.19427e+10 | 1.61265e+09 | 7.08993e+08 | 4.27536e+07 | 6.21411e+08 | 3.28798e+07 | 8.75828e+07 | 9.87376e+06 | 2.34613e+12 | | 2026-10-20 00:00:00 | mean | 5.97796e+08 | 3.51126e+07 | 6.98129e-06 | 2.49151e+07 | 1.41947e+06 | 2.53661e+07 | 1.37824e+06 | -450971 | 41229.4 | 5.62669e+06 | 414063 | 170455 | 9581.35 | 175853 | 10613.7 | -5397.84 | -1032.4 | 6.03422e+08 | | 2026-10-20 00:00:00 | sum | 2.32244e+12 | 1.36413e+11 | 0.0271223 | 9.67953e+10 | 5.51465e+09 | 9.85473e+10 | 5.35447e+09 | -1.75202e+09 | 1.60176e+08 | 2.18597e+10 | 1.60863e+09 | 6.62217e+08 | 3.72235e+07 | 6.83187e+08 | 4.12344e+07 | -2.09706e+07 | -4.01088e+06 | 2.3443e+12 | | 2026-10-21 00:00:00 | mean | 5.97308e+08 | 3.50686e+07 | 7.01478e-06 | 2.49363e+07 | 1.34656e+06 | 2.52703e+07 | 1.38428e+06 | -333953 | -37723.7 | 5.5468e+06 | 413428 | 165676 | 9689.02 | 189397 | 10217.2 | -23720.7 | -528.192 | 6.02855e+08 | | 2026-11-12 00:00:00 | sum | 2.14688e+12 | 1.29129e+11 | 0.0257119 | 1.44564e+11 | 7.44197e+09 | 1.44417e+11 | 7.35353e+09 | 1.46898e+08 | 8.84338e+07 | 2.18118e+10 | 1.62313e+09 | 8.27806e+08 | 4.68697e+07 | 6.90056e+08 | 4.29589e+07 | 1.3775e+08 | 3.91073e+06 | 2.16869e+12 | | 2026-11-13 00:00:00 | mean | 5.47679e+08 | 3.29327e+07 | 6.62509e-06 | 2.85186e+07 | 1.57381e+06 | 3.23106e+07 | 1.81847e+06 | -3.79197e+06 | -244665 | 5.66143e+06 | 422977 | 240612 | 15476.5 | 159250 | 9434.34 | 81361.8 | 6042.21 | 5.5334e+08 | | 2026-11-13 00:00:00 | sum | 2.13211e+12 | 1.28207e+11 | 0.0257915 | 1.11023e+11 | 6.12683e+09 | 1.25785e+11 | 7.07931e+09 | -1.47622e+10 | -9.5248e+08 | 2.20399e+10 | 1.64665e+09 | 9.36703e+08 | 6.02502e+07 | 6.19961e+08 | 3.67279e+07 | 3.16741e+08 | 2.35223e+07 | 2.15415e+12 | | 2026-11-16 00:00:00 | mean | 5.41534e+08 | 3.26382e+07 | 6.6329e-06 | 2.25674e+07 | 1.38077e+06 | 2.87124e+07 | 1.68568e+06 | -6.14505e+06 | -304914 | 5.69227e+06 | 428023 | 240552 | 16364.8 | 174180 | 11319.3 | 66372.9 | 5045.52 | 5.47226e+08 | | 2026-11-16 00:00:00 | sum | 2.10819e+12 | 1.27061e+11 | 0.0258219 | 8.78549e+10 | 5.37534e+09 | 1.11778e+11 | 6.56237e+09 | -2.39227e+10 | -1.18703e+09 | 2.216e+10 | 1.66629e+09 | 9.36471e+08 | 6.37083e+07 | 6.78081e+08 | 4.40661e+07 | 2.5839e+08 | 1.96422e+07 | 2.13035e+12 |
融资融券市场统计 (cn_stock_margin_trading_market)
数据描述: 该表提供了中国股市融资融券市场的整体统计数据。这些数据反映了市场上融资融券活动的总体情况,通过求和或平均来计算整个市场融资和融券的余额、买入额、偿还额、净买入额、净卖出额等关键指标,以及融资余额占流通市值的比例。
文档
用例
表结构
| 字段 | 字段类型 | 字段描述 |
| date | timestamp[ns] | - |
| financing_quantity | double | 融资余量 |
| margin_trading_balance | double | 融资融券余额 |
| financing_balance_ratio | double | 融资余额占流通市值比 |
| securities_lending_sales | double | 融券卖出额 |
| financing_purchase_quantity | double | 融资买入量 |
| securities_lending_quantity | double | 融券余量 |
| financing_repayment_quantity | double | 融资偿还量 |
| securities_lending_net_sales | double | 融券净卖出额 |
| securities_lending_repayment | double | 融券偿还额 |
| financing_net_purchase_quantity | double | 融资净买入量 |
| securities_lending_sales_quantity | double | 融券卖出量 |
| securities_lending_net_sales_quantity | double | 融券净卖出量 |
| securities_lending_repayment_quantity | double | 融券偿还量 |
| financing_balance | double | 融资余额 |
| financing_purchase | double | 融资买入额 |
| financing_repayment | double | 融资偿还额 |
| financing_net_purchase | double | 融资净买入额 |
| securities_lending_balance | double | 融券余额 |
| method | string | 计算方法 |
表名:cn_stock_margin_trading_market
起始时间:
最近更新时间: