财务分析(收益质量) (cn_stock_financial_earning_quality)

数据描述: 该数据表专注于分析上市公司的收益质量,通过一系列比率指标来评估公司利润的质量和可持续性。包括但不限于经营活动净收益、价值变动净收益、营业外收支净额、投资收益与利润总额的比率,以及营业利润和利润总额占营业收入的比例等。数据非日频,根据财报的发布进行更新。

文档
数据简介

用例
* 用例1:查询特定报告期的收益质量比率 ``` import dai df = dai.query(""" SELECT * FROM cn_stock_financial_earning_quality WHERE report_date = '2024-03-31' ORDER BY date""", full_db_scan=True ).df() ``` * 用例2:分析上市公司利润来源(如营业利润、投资收益)随时间的变化 ``` import dai df = dai.query(""" SELECT date, instrument, report_date, operating_profit_to_total_profit_ttm, invest_income_to_total_profit_ttm FROM cn_stock_financial_earning_quality WHERE instrument = '000001.SZ' AND shift = 0 ORDER BY date,report_date""", filters={"date": ["2020-01-01", "2024-12-31"]} ).df() ``` * 用例3:查询某只股票所有的最新一期、单季度、滚动十二期的利润总额/营业收入 ``` import dai df = dai.query(""" SELECT date, instrument, report_date, shift, total_profit_to_operating_revenue_lf, total_profit_to_operating_revenue_mrq, total_profit_to_operating_revenue_ttm FROM cn_stock_financial_earning_quality WHERE instrument = '000001.SZ' ORDER BY date,instrument,report_date """, full_db_scan=True).df() ```
表结构
字段 字段类型 字段描述
invest_income_to_total_profit_lf DOUBLE 投资收益/利润总额(最新一期)
invest_income_to_total_profit_mrq DOUBLE 投资收益/利润总额(单季度)
invest_income_to_total_profit_ttm DOUBLE 投资收益/利润总额(滚动十二期)
operating_profit_to_total_profit_lf DOUBLE 营业利润/利润总额(最新一期)
operating_profit_to_total_profit_mrq DOUBLE 营业利润/利润总额(单季度)
operating_profit_to_total_profit_ttm DOUBLE 营业利润/利润总额(滚动十二期)
total_profit_to_operating_revenue_lf DOUBLE 利润总额/营业收入(最新一期)
total_profit_to_operating_revenue_mrq DOUBLE 利润总额/营业收入(单季度)
total_profit_to_operating_revenue_ttm DOUBLE 利润总额/营业收入(滚动十二期)
profit_of_value_chg_to_total_profit_lf DOUBLE 价值变动净收益/利润总额(最新一期)
net_operating_profit_to_total_profit_lf DOUBLE 经营活动净收益/利润总额(最新一期)
profit_of_value_chg_to_total_profit_mrq DOUBLE 价值变动净收益/利润总额(单季度)
profit_of_value_chg_to_total_profit_ttm DOUBLE 价值变动净收益/利润总额(滚动十二期)
net_operating_profit_to_total_profit_mrq DOUBLE 经营活动净收益/利润总额(单季度)
instrument VARCHAR 证券代码
net_nonoperating_income_to_total_profit_lf DOUBLE 营业外收支净额/利润总额(最新一期)
report_date TIMESTAMP_NS 报告期
net_nonoperating_income_to_total_profit_ttm DOUBLE 营业外收支净额/利润总额(滚动十二期)
shift TINYINT 偏移报告期
date TIMESTAMP_NS -
net_nonoperating_income_to_total_profit_mrq DOUBLE 营业外收支净额/利润总额(单季度)
net_operating_profit_to_total_profit_ttm DOUBLE 经营活动净收益/利润总额(滚动十二期)

表名cn_stock_financial_earning_quality

起始时间:

最近更新时间: