财务衍生(单季度) (cn_stock_financial_mrq_shift)

数据描述: 该数据表收录了公司单季度财务数据,包括现金流量表、利润表的相关字段和内容。单季度数据提供了对每个季度独立会计期间内企业财务活动的深入洞察,允许用户监测季节性趋势和季度业绩变化。

文档
数据简介

用例
* 用例1:分析公司现金流量健康状况 ``` import dai df = dai.query(""" SELECT date, instrument, report_date, net_cffoa_mrq, net_cffia_mrq, net_cfffa_mrq FROM cn_stock_financial_mrq_shift""", filters={"date": ["2023-01-01", "2023-12-31"]} ).df() ``` * 用例2:查询某只股票所有首次披露的单季度数据 ``` import dai df = dai.query(""" SELECT * FROM cn_stock_financial_mrq_shift WHERE instrument = '000001.SZ' AND shift = 0 ORDER BY date,report_date,instrument""", filters={"date": ["2018-01-01", "2023-12-31"]} ).df() ``` * 用例3:计算公司季度总营业收入增长率 ``` import dai df = dai.query(""" SELECT date, instrument, report_date, total_operating_revenue_mrq, LAG(total_operating_revenue_mrq, 1) OVER (PARTITION BY instrument ORDER BY report_date) AS prev_quarter_revenue, (total_operating_revenue_mrq - prev_quarter_revenue) / abs(prev_quarter_revenue) AS growth_rate FROM cn_stock_financial_mrq_shift WHERE instrument = '000001.SZ' AND shift = 0""", filters={"date": ["2021-01-01", "2023-12-31"]} ).df() ```
表结构
字段 字段类型 字段描述
selling_epense_mrq DOUBLE 销售费用(单季度)
asset_disposal_income_mrq DOUBLE 资产处置收益(单季度)
subtotal_ciffa_mrq DOUBLE 筹资活动现金流入小计(单季度)
asset_impairment_loss_mrq DOUBLE 资产减值损失(单季度)
subtotal_cifia_mrq DOUBLE 投资活动现金流入小计(单季度)
spec_diff_of_operating_revenue_mrq DOUBLE 营业总收入差额(特殊报表科目)(单季度)
subtotal_cifoa_mrq DOUBLE 经营活动现金流入小计(单季度)
net_amount_of_insurance_reserve_mrq DOUBLE 提取保险合同准备金净额(单季度)
subtotal_cofoa_mrq DOUBLE 经营活动现金流出小计(单季度)
cash_paid_for_interests_fees_and_commissions_mrq DOUBLE 支付利息、手续费及佣金的现金(单季度)
cce_balance_beginning_mrq DOUBLE 现金等价物的期初余额(单季度)
administrative_expense_mrq DOUBLE 管理费用(单季度)
spec_diff_of_net_profit_mrq DOUBLE 净利润差(特殊报表科目)(单季度)
reinsurance_premium_expense_mrq DOUBLE 分保费用(单季度)
cash_balance_beginning_mrq DOUBLE 现金的期初余额(单季度)
totbal_diff_of_operating_costs_mrq DOUBLE 营业总成本差额(合计平衡科目)(单季度)
depreciation_of_fa_oga_pba_mrq DOUBLE 固定资产折旧、油气资产折耗、生产性生物资产折旧(单季度)
research_and_development_expense_mrq DOUBLE 研发费用(单季度)
cce_ending_mrq DOUBLE 期末现金及现金等价物余额(单季度)
fair_value_chg_gain_mrq DOUBLE 公允价值变动收益(单季度)
fin_interest_income_mrq DOUBLE 财务费用:利息收入(单季度)
netinc_in_cce_mrq DOUBLE 现金及现金等价物净增加额(单季度)
other_income_mrq DOUBLE 其他收益(单季度)
credit_impairment_loss_mrq DOUBLE 信用减值损失(单季度)
other_reclass_mrq DOUBLE 其他以后将重分类进损益(单季度)
totbal_diff_of_operating_revenue_mrq DOUBLE 营业总收入差额(合计平衡科目)(单季度)
totbal_diff_of_total_profit_mrq DOUBLE 利润总额差额(合计平衡科目)(单季度)
spec_diff_of_net_cffoa_indirect_mrq DOUBLE 间接法-经营活动现金流量净额差额(特殊报表科目)(单季度)
net_profit_mrq DOUBLE 净利润(单季度)
cce_beginning_mrq DOUBLE 期初现金及现金等价物余额(单季度)
net_income_of_open_hedge_mrq DOUBLE 净敞口套期收益(单季度)
asset_impairment_reserve_mrq DOUBLE 资产减值准备(单季度)
totbal_diff_of_operating_profit_mrq DOUBLE 营业利润差额(合计平衡科目)(单季度)
cash_paid_for_debt_repayment_mrq DOUBLE 偿还债务支付的现金(单季度)
net_profit_to_parent_shareholders_mrq DOUBLE 归属于母公司所有者的净利润(单季度)
fin_lease_fixed_assets_mrq DOUBLE 融资租入固定资产(单季度)
spec_diff_of_netinc_in_cce_mrq DOUBLE 直接法-现金及现金等价物净增加额差额(特殊报表科目)(单季度)
exchange_gain_mrq DOUBLE 汇兑收益(单季度)
amorization_of_intangible_assets_mrq DOUBLE 无形资产摊销(单季度)
invest_income_mrq DOUBLE 投资收益(单季度)
total_comprehensive_income_mrq DOUBLE 综合收益总额(单季度)
date TIMESTAMP_NS -
debt_transfer_to_capital_mrq DOUBLE 债务转为资本(单季度)
net_profit_to_minority_mrq DOUBLE 少数股东损益(单季度)
netinc_in_cce_indirect_mrq DOUBLE 间接法-现金及现金等价物净增加额(单季度)
netinc_in_loans_from_banks_and_fin_institutions_mrq DOUBLE 拆入资金净增加额(单季度)
others_in_cashflow_sheet_mrq DOUBLE 其他(单季度)
fee_and_commission_costs_mrq DOUBLE 手续费及佣金支出(单季度)
income_tax_expense_mrq DOUBLE 所得税费用(单季度)
netinc_in_pledge_loans_mrq DOUBLE 质押贷款净增加额(单季度)
othcom_income_cannt_reclass_under_equity_method_mrq DOUBLE 权益法下在被投资单位不能重分类进损益的其他综合收益中享有的份额(单季度)
eps_diluted_mrq DOUBLE 稀释每股收益(单季度)
cash_received_from_premiums_mrq DOUBLE 收到原保险合同保费取得的现金(单季度)
taxes_and_levies_rebates_mrq DOUBLE 收到的税费返还(单季度)
invest_loss_mrq DOUBLE 投资损失(单季度)
insurance_premium_income_mrq DOUBLE 已赚保费(单季度)
net_cffoa_indirect_mrq DOUBLE 间接法-经营活动产生的现金流量净额(单季度)
other_cofoa_mrq DOUBLE 支付其他与经营活动有关的现金(单季度)
expense_on_policy_dividends_mrq DOUBLE 保单红利支出(单季度)
net_profit_in_cashflow_sheet_mrq DOUBLE 现金流量表-净利润(单季度)
taxes_and_levies_mrq DOUBLE 税金及附加(单季度)
cash_received_from_other_investing_mrq DOUBLE 收到其他与投资活动有关的现金(单季度)
netinc_in_loans_and_advances_mrq DOUBLE 客户贷款及垫款净增加额(单季度)
finance_expenses_in_cashflow_sheet_mrq DOUBLE 现金流量表-财务费用(单季度)
cash_paid_for_goods_and_services_mrq DOUBLE 购买商品、接受劳务支付的现金(单季度)
total_comprehensive_income_to_parent_shareholders_mrq DOUBLE 归属于母公司股东的综合收益总额(单季度)
invest_income_of_jv_and_associates_mrq DOUBLE 对联营企业和合营企业的投资收益(单季度)
cash_received_from_interests_fess_and_commissions_mrq DOUBLE 收取利息、手续费及佣金的现金(单季度)
totbal_diff_of_net_cfffa_mrq DOUBLE 筹资活动产生的现金流量净额差额(合计平衡科目)(单季度)
spec_diff_of_net_cfffa_mrq DOUBLE 筹资活动产生的现金流量净额差额(特殊报表科目)(单季度)
totbal_diff_of_net_cffia_mrq DOUBLE 投资活动产生的现金流量净额差额(合计平衡科目)(单季度)
spec_diff_of_net_cffia_mrq DOUBLE 投资活动产生的现金流量净额差额(特殊报表科目)(单季度)
totbal_diff_of_net_cffoa_mrq DOUBLE 经营活动产生的现金流量净额差额(合计平衡科目)(单季度)
spec_diff_of_net_cffoa_mrq DOUBLE 经营活动产生的现金流量净额差额(特殊报表科目)(单季度)
spec_diff_of_operating_costs_mrq DOUBLE 营业总成本差额(特殊报表科目)(单季度)
effective_of_gains_or_losses_on_cashflow_hedge_mrq DOUBLE 现金流量套期损益的有效部分(单季度)
net_cash_received_from_reinsurance_mrq DOUBLE 收到再保业务现金净额(单季度)
cash_received_from_bond_issue_mrq DOUBLE 发行债券收到的现金(单季度)
net_cash_received_from_disposal_subsidiaries_mrq DOUBLE 处置子公司及其他营业单位收到的现金净额(单季度)
cash_received_from_borrowings_mrq DOUBLE 取得借款收到的现金(单季度)
available_for_sale_fin_assets_fair_value_chg_mrq DOUBLE 可供出售金融资产公允价值变动损益(单季度)
eps_basic_mrq DOUBLE 基本每股收益(单季度)
othcom_income_from_reclass_of_fin_assets_mrq DOUBLE 金融资产重分类计入其他综合收益的金额(单季度)
totbal_diff_of_netinc_in_cce_indirect_mrq DOUBLE 间接法-现金及现金等价物净增加额差额(合计平衡科目)(单季度)
cash_paid_for_other_investing_mrq DOUBLE 支付其他与投资活动有关的现金(单季度)
net_cash_received_from_disposal_filt_assets_mrq DOUBLE 处置固定资产、无形资产和其他长期资产收回的现金净额(单季度)
income_translation_diff_of_foreign_currency_mrq DOUBLE 外币财务报表折算差额(单季度)
credit_impairment_of_other_debt_investments_mrq DOUBLE 其他债权投资信用减值准备(单季度)
cash_paid_for_claims_mrq DOUBLE 支付原保险合同赔付款项的现金(单季度)
net_cffoa_mrq DOUBLE 经营活动产生的现金流量净额(单季度)
effect_of_exchange_chg_on_cce_mrq DOUBLE 汇率变动对现金及现金等价物的影响(单季度)
instrument VARCHAR 证券代码
loss_from_disposal_of_fa_ia_lta_mrq DOUBLE 处置固定资产、无形资产和其他长期资产的损失(单季度)
totbal_diff_of_cofoa_mrq DOUBLE 经营活动现金流出差额(合计平衡科目)(单季度)
net_cffia_mrq DOUBLE 投资活动产生的现金流量净额(单季度)
chg_by_remeasurements_mrq DOUBLE 重新计量设定受益计划净负债或净资产的变动(单季度)
cash_paid_for_filt_assets_mrq DOUBLE 购建固定资产、无形资产和其他长期资产支付的现金(单季度)
credit_impairment_loss_in_cashflow_sheet_mrq DOUBLE 信用减值损失(单季度)
cash_paid_for_investments_mrq DOUBLE 投资支付的现金(单季度)
report_date TIMESTAMP_NS 报告期
cash_paid_for_dividends_profits_interests_mrq DOUBLE 分配股利、利润或偿付利息支付的现金(单季度)
netinc_in_insurance_deposits_and_invest_mrq DOUBLE 保户储金及投资款净增加额(单季度)
shift TINYINT 偏移报告期
netinc_in_borrowings_from_central_bank_mrq DOUBLE 向中央银行借款净增加额(单季度)
netinc_deposits_central_bank_interbank_mrq DOUBLE 存放中央银行和同业款项净增加额(单季度)
fin_interest_expense_mrq DOUBLE 财务费用:利息费用(单季度)
totbal_diff_of_netinc_in_cce_mrq DOUBLE 直接法-现金及现金等价物净增加额差额(合计平衡科目)(单季度)
cash_paid_for_employees_mrq DOUBLE 支付给职工以及为职工支付的现金(单季度)
other_debt_investments_fair_value_chg_mrq DOUBLE 其他债权投资公允价值变动(单季度)
cash_received_from_sales_and_services_mrq DOUBLE 销售商品、提供劳务收到的现金(单季度)
income_othcom_income_mrq DOUBLE 其他综合收益(单季度)
cash_paid_by_subsidiaries_to_minority_mrq DOUBLE 子公司支付给少数股东的股利、利润(单季度)
spec_diff_of_cofia_mrq DOUBLE 投资活动现金流出差额(特殊报表科目)(单季度)
netinc_in_disposal_fin_assets_mrq DOUBLE 处置以公允价值计量且其变动计入当期损益的金融资产净增加额(单季度)
othcom_income_reclass_under_equity_method_mrq DOUBLE 权益法下在被投资单位以后将重分类进损益的其他综合收益中享有的份额(单季度)
return_on_investment_mrq DOUBLE 取得投资收益收到的现金(单季度)
loss_from_scraping_of_fixed_assets_mrq DOUBLE 固定资产报废损失(单季度)
cash_paid_by_acquiring_subsidiaries_mrq DOUBLE 取得子公司及其他营业单位支付的现金净额(单季度)
cash_received_from_other_operating_mrq DOUBLE 收到其他与经营活动有关的现金(单季度)
cash_received_from_other_financing_mrq DOUBLE 收到其他与筹资活动有关的现金(单季度)
totbal_diff_of_net_cffoa_indirect_mrq DOUBLE 间接法-经营活动现金流量净额差额(合计平衡科目)(单季度)
netinc_in_repurchase_transactions_mrq DOUBLE 回购业务资金净增加额(单季度)
discontinued_operation_net_profit_mrq DOUBLE (二)终止经营净利润(单季度)
decrease_in_operating_receivables_mrq DOUBLE 经营性应收项目的减少(单季度)
income_derecognition_of_fin_assets_at_amortized_cost_mrq DOUBLE 以摊余成本计量的金融资产终止确认收益(单季度)
operating_revenue_mrq DOUBLE 营业收入(单季度)
amortization_of_longterm_deferred_expenses_mrq DOUBLE 长期待摊费用摊销(单季度)
decrease_in_inventories_mrq DOUBLE 存货的减少(单季度)
capital_contributions_received_mrq DOUBLE 吸收投资收到的现金(单季度)
fee_and_commission_income_mrq DOUBLE 手续费及佣金收入(单季度)
cash_paid_for_policy_dividends_mrq DOUBLE 支付保单红利的现金(单季度)
gains_or_losses_from_htm_to_afs_mrq DOUBLE 持有至到期投资重分类为可供出售金融资产损益(单季度)
cash_paid_for_taxes_and_levies_mrq DOUBLE 支付的各项税费(单季度)
decrease_in_deferred_tax_assets_mrq DOUBLE 递延所得税资产减少(单季度)
nonoperating_costs_mrq DOUBLE 营业外支出(单季度)
finance_expense_mrq DOUBLE 财务费用(单季度)
spec_diff_of_operating_profit_mrq DOUBLE 营业利润差额(特殊报表科目)(单季度)
net_insurance_claims_paid_mrq DOUBLE 赔付支出净额(单季度)
other_cannt_reclass_mrq DOUBLE 其他以后不能重分类进损益(单季度)
nonoperating_income_mrq DOUBLE 营业外收入(单季度)
increase_in_deferred_tax_liabilities_mrq DOUBLE 递延所得税负债增加(单季度)
cash_balance_ending_mrq DOUBLE 现金的期末余额(单季度)
totbal_diff_of_cofia_mrq DOUBLE 投资活动现金流出差额(合计平衡科目)(单季度)
total_profit_mrq DOUBLE 利润总额(单季度)
totbal_diff_of_coffa_mrq DOUBLE 筹资活动现金流出差额(合计平衡科目)(单季度)
totbal_diff_of_cifoa_mrq DOUBLE 经营活动现金流入差额(合计平衡科目)(单季度)
netinc_in_deposits_mrq DOUBLE 客户存款和同业存放款项净增加额(单季度)
interest_income_mrq DOUBLE 利息收入(单季度)
cashflow_hedge_reserve_mrq DOUBLE 现金流量套期储备(单季度)
loss_from_fair_value_chg_mrq DOUBLE 公允价值变动损失(单季度)
total_operating_costs_mrq DOUBLE 营业总成本(单季度)
cash_received_from_disposal_investments_mrq DOUBLE 收回投资收到的现金(单季度)
othcom_income_to_minority_mrq DOUBLE 归属于少数股东的其他综合收益(单季度)
othcom_income_to_parent_shareholders_mrq DOUBLE 归属母公司所有者的其他综合收益(单季度)
interest_costs_mrq DOUBLE 利息支出(单季度)
increase_in_operating_payables_mrq DOUBLE 经营性应付项目的增加(单季度)
spec_diff_of_coffa_mrq DOUBLE 筹资活动现金流出差额(特殊报表科目)(单季度)
othcom_income_reclass_mrq DOUBLE 以后将重分类进损益的其他综合收益(单季度)
net_cfffa_mrq DOUBLE 筹资活动产生的现金流量净额(单季度)
spec_diff_of_ciffa_mrq DOUBLE 筹资活动现金流入差额(特殊报表科目)(单季度)
surrenders_mrq DOUBLE 退保金(单季度)
spec_diff_of_cifia_mrq DOUBLE 投资活动现金流入差额(特殊报表科目)(单季度)
spec_diff_of_netinc_in_cce_indirect_mrq DOUBLE 间接法-现金及现金等价物净增加额差额(特殊报表科目)(单季度)
spec_diff_of_cifoa_mrq DOUBLE 经营活动现金流入差额(特殊报表科目)(单季度)
cash_received_by_subsidiaries_from_minority_mrq DOUBLE 子公司吸收少数股东投资收到的现金(单季度)
subtotal_of_coffa_mrq DOUBLE 筹资活动现金流出小计(单季度)
other_equity_instruments_fair_value_chg_mrq DOUBLE 其他权益工具投资公允价值变动(单季度)
spec_diff_of_total_profit_mrq DOUBLE 利润总额差额(特殊报表科目)(单季度)
operating_costs_mrq DOUBLE 营业成本(单季度)
spec_diff_of_cofoa_mrq DOUBLE 经营活动现金流出差额(特殊报表科目)(单季度)
operating_profit_mrq DOUBLE 营业利润(单季度)
total_operating_revenue_mrq DOUBLE 营业总收入(单季度)
totbal_diff_of_ciffa_mrq DOUBLE 筹资活动现金流入差额(合计平衡科目)(单季度)
subtotal_of_cofia_mrq DOUBLE 投资活动现金流出小计(单季度)
totbal_diff_of_cifia_mrq DOUBLE 投资活动现金流入差额(合计平衡科目)(单季度)
conv_corp_bonds_within_1y_mrq DOUBLE 一年内到期的可转换公司债券(单季度)
totbal_diff_of_net_profit_mrq DOUBLE 净利润差额(合计平衡科目)(单季度)
continuing_operation_net_profit_mrq DOUBLE (一)持续经营净利润(单季度)
cce_balance_ending_mrq DOUBLE 现金等价物的期末余额(单季度)
own_credit_risk_fair_value_chg_mrq DOUBLE 企业自身信用风险公允价值变动(单季度)
noncurr_assets_dispose_gain_mrq DOUBLE 非流动资产处置利得(单季度)
othcom_income_cannt_reclass_mrq DOUBLE 以后不能重分类进损益的其他综合收益(单季度)
noncurr_assets_dispose_loss_mrq DOUBLE 非流动资产处置损失(单季度)
cash_paid_for_other_financing_mrq DOUBLE 支付其他与筹资活动有关的现金(单季度)
netinc_in_loans_from_other_fin_institutions_mrq DOUBLE 向其他金融机构拆入资金净增加额(单季度)

表名cn_stock_financial_mrq_shift

起始时间:

最近更新时间: