美股数据 - 美股数据

📑 目录
  1. 表列表
  2. 字段快速索引

美股数据 - 美股数据

共 19 张数据表

标签: #数据字典 #12_美股数据


表列表

表名中文名字段数说明
[[tus major_ shareholders]]14
[[tusbalance_sheet]]美股资产负债表63
[[Tusbase]]美股基本资料14
[[tuscash_flow]]美股现金流量表52
[[tusdividend_history]]美股除权除息12
[[tusequity_ownership]]美股股权10
[[tusfinancial_indicators]]美股财务指标29
[[tusidccname]]美股每股指标8
[[tusidcsymbol]]美股每股指标8
[[tusincome_statement]]美股利润表67
[[tusindex_components]]美指成分股6
[[tusindustry_classification]]美股行业8
[[tuslatest_sta]]美股最新统计资料38
[[tusper_share]]美股每股指标13
[[tusper_share]]美股每股指标11
[[tusper_share]]美股每股指标12
[[tussplit_history]]美股拆分7
[[TUSSTOCK_NAME]]美股简称7
[[TUSWEIGHT]]美股权息资料14

字段快速索引

按字段名首字母分组,方便快速查找字段所属表。

#

字段名中文名所属表类型
``[[tus major_ shareholders]]

C

字段名中文名所属表类型
cname中文名称[[tusper_share]]varchar2
CNAME英文名称[[tusidccname]]VARCHAR2(16)
CODE股票代码[[tusper_share]]
code股票代码[[tusper_share]]varchar2
CODE股票代码[[tusidccname]]VARCHAR2(16)
CODE股票代码[[tusidcsymbol]]VARCHAR2(16)
components成分股[[tusindex_components]]varchar
currency货币单位[[tusincome_statement]]char
currency货币单位[[tusbalance_sheet]]char
currency货币单位[[tuscash_flow]]char
currency货币单位[[tusdividend_history]]char

E

字段名中文名所属表类型
ENUMSRCID交易市场[[TUSSTOCK_NAME]]char
EXCHANGE市场[[tusper_share]]
exchange市场[[tusper_share]]varchar2
EXCHANGE市场[[tusidcsymbol]]VARCHAR2(12)

F

字段名中文名所属表类型
F001每10股送股数[[TUSWEIGHT]]number
F001公平价值[[tuslatest_sta]]number
F001CIK代码[[Tusbase]]vchar2
F001营业收入[[tusincome_statement]]number
F001现金与现金等价物[[tusbalance_sheet]]number
F001净利润[[tuscash_flow]]number
F001除净日期[[tusdividend_history]]date
F001拆分日期[[tussplit_history]]date
F001机构持有比率[[tusequity_ownership]]number
F001截止日期[[tusfinancial_indicators]]date
F001行业分类标准[[tusindustry_classification]]char
F001截止日期[[tusper_share]]date
F001持有人类型[[tus major_ shareholders]]1
F002每10股配股数[[TUSWEIGHT]]number
F002股票类型[[tuslatest_sta]]vchar2
F002网站[[Tusbase]]vchar2
F002营业成本[[tusincome_statement]]number
F002限制性现金[[tusbalance_sheet]]number
F002折旧与摊销[[tuscash_flow]]number
F002公告日期[[tusdividend_history]]date
F002拆分比例[[tussplit_history]]number
F002基金持有比率[[tusequity_ownership]]number
F002类型[[tusfinancial_indicators]]char
F002行业编码[[tusindustry_classification]]vchar2
F002类型[[tusper_share]]char
F002持有人名称[[tus major_ shareholders]]400
F003配股价[[TUSWEIGHT]]number
F003股票风格[[tuslatest_sta]]vchar2
F003电话[[Tusbase]]vchar2
F003毛利[[tusincome_statement]]number
F003现金及存放同业[[tusbalance_sheet]]number
F003投资/资产减值[[tuscash_flow]]number
F003记录日期[[tusdividend_history]]date
F003内部人士持有比率[[tusequity_ownership]]number
F003总资产回报率[[tusfinancial_indicators]]number
F003行业说明[[tusindustry_classification]]vchar2
F003每股收益[[tusper_share]]number
F003持股数量[[tus major_ shareholders]]22
F004每10股红利[[TUSWEIGHT]]number
F004股息收益率[[tuslatest_sta]]number
F004邮件[[Tusbase]]vchar2
F004研发费用[[tusincome_statement]]number
F004短期投资[[tusbalance_sheet]]number
F004递延所得税[[tuscash_flow]]number
F004支付日期[[tusdividend_history]]date
F004机构家数[[tusequity_ownership]]number
F004股东权益回报率[[tusfinancial_indicators]]number
F004每股收益货币单位[[tusper_share]]char
F004持股占比[[tus major_ shareholders]]18,6
F005每10股转增数[[TUSWEIGHT]]number
F005市值[[tuslatest_sta]]number
F005地址[[Tusbase]]vchar2
F005销售及一般行政费用[[tusincome_statement]]number
F005证券投资[[tusbalance_sheet]]number
F005股权激励[[tuscash_flow]]number
F005股利类型[[tusdividend_history]]vchar2
F005基金家数[[tusequity_ownership]]number
F005投入资本回报率[[tusfinancial_indicators]]number
F005每股净资产[[tusper_share]]number
F005持股变动[[tus major_ shareholders]]22
F006拆并股数[[TUSWEIGHT]]number
F006预测市盈率[[tuslatest_sta]]number
F006经营业务[[Tusbase]]clob
F006折旧与摊销[[tusincome_statement]]number
F006交易性资产[[tusbalance_sheet]]number
F006应收账款[[tuscash_flow]]number
F006股利金额[[tusdividend_history]]number
F006毛利率[[tusfinancial_indicators]]number
F006每股净资产货币单位[[tusper_share]]char
F006变动比例[[tus major_ shareholders]]18,6
F007流通股数[[TUSWEIGHT]]number
F007贝塔值[[tuslatest_sta]]number
F007雇员人数[[Tusbase]]number
F007经营费用合计[[tusincome_statement]]number
F007应收账款[[tusbalance_sheet]]number
F007存货[[tuscash_flow]]number
F007经营利润率[[tusfinancial_indicators]]number
F007每股自由现金流[[tusper_share]]number
F007占其持有总资产比例[[tus major_ shareholders]]18,6
F008[[TUSWEIGHT]]number
F008已发行股本[[tuslatest_sta]]number
F008部门[[Tusbase]]vchar2
F008经营利润[[tusincome_statement]]number
F008存货[[tusbalance_sheet]]number
F008预付费用[[tuscash_flow]]number
F008净利率[[tusfinancial_indicators]]number
F008每股自由现金流货币单位[[tusper_share]]char
F008截止日期[[tus major_ shareholders]]
F009自由流通股本[[tuslatest_sta]]number
F009行业[[Tusbase]]vchar2
F009利息收入[[tusincome_statement]]number
F009预提费用[[tusbalance_sheet]]number
F009应付账款[[tuscash_flow]]number
F009收入同比增长率[[tusfinancial_indicators]]number
F010卖空占自由流通比[[tuslatest_sta]]number
F010贷款及租赁收入[[tusincome_statement]]number
F010流动资产合计[[tusbalance_sheet]]number
F010应计负债[[tuscash_flow]]number
F010收入3年平均增长率[[tusfinancial_indicators]]number
F011卖空比[[tuslatest_sta]]number
F011银行存款收入[[tusincome_statement]]number
F011物业厂房及设备总额[[tusbalance_sheet]]number
F011应缴所得税[[tuscash_flow]]number
F011营业利润同比增长率[[tusfinancial_indicators]]number
F012华尔街覆盖率[[tuslatest_sta]]number
F012债券利息收入[[tusincome_statement]]number
F012累计折旧[[tusbalance_sheet]]number
F012信贷损失准备[[tuscash_flow]]number
F012营业利润3年平均增长率[[tusfinancial_indicators]]number
F013华尔街综合评级[[tuslatest_sta]]number
F013交易性资产利息收入[[tusincome_statement]]number
F013物业厂房及设备净额[[tusbalance_sheet]]number
F013投资损失(收益)[[tuscash_flow]]number
F013净利润同比增长率[[tusfinancial_indicators]]number
F014市盈率[[tuslatest_sta]]number
F014总利息收入[[tusincome_statement]]number
F014股权及其他投资[[tusbalance_sheet]]number
F014保费与保险合同[[tuscash_flow]]number
F014净利润3年平均增长率[[tusfinancial_indicators]]number
F015行业平均市盈率[[tuslatest_sta]]number
F015利息支出[[tusincome_statement]]number
F015商誉[[tusbalance_sheet]]number
F015客户贷款[[tuscash_flow]]number
F015经营现金流同比增长率[[tusfinancial_indicators]]number
F016市净率[[tuslatest_sta]]number
F016存款利息支出[[tusincome_statement]]number
F016无形资产[[tusbalance_sheet]]number
F016来自经营活动的净现金[[tuscash_flow]]number
F016自由现金流同比增长率[[tusfinancial_indicators]]number
F017行业平均市净率[[tuslatest_sta]]number
F017联邦基金购入[[tusincome_statement]]number
F017递延所得税[[tusbalance_sheet]]number
F017物业厂房设备增加[[tuscash_flow]]number
F017自由现金流/净利润[[tusfinancial_indicators]]number
F018市销率[[tuslatest_sta]]number
F018短期借款利息支出[[tusincome_statement]]number
F018非流动资产合计[[tusbalance_sheet]]number
F018物业厂房设备减少[[tuscash_flow]]number
F018流动比率[[tusfinancial_indicators]]number
F019行业平均市销率[[tuslatest_sta]]number
F019长期债项利息支出[[tusincome_statement]]number
F019客户贷款[[tusbalance_sheet]]number
F019投资增加[[tuscash_flow]]number
F019速动比率[[tusfinancial_indicators]]number
F020收入3年平均增长率[[tuslatest_sta]]number
F020总利息支出[[tusincome_statement]]number
F020贷款损失准备[[tusbalance_sheet]]number
F020投资减少[[tuscash_flow]]number
F020负债权益比率[[tusfinancial_indicators]]number
F021收入3年行业平均增长率[[tuslatest_sta]]number
F021净利息收入[[tusincome_statement]]number
F021贷款净额[[tusbalance_sheet]]number
F021来自投资活动的净现金[[tuscash_flow]]number
F021应收平均回收期[[tusfinancial_indicators]]number
F022净利3年平均增长率[[tuslatest_sta]]number
F022投资银行收入[[tusincome_statement]]number
F022总资产[[tusbalance_sheet]]number
F022债务增加[[tuscash_flow]]number
F022存货周转期[[tusfinancial_indicators]]number
F023净利3年行业平均增长率[[tuslatest_sta]]number
F023资产管理及证券服务收入[[tusincome_statement]]number
F023短期债务[[tusbalance_sheet]]number
F023债务偿还[[tuscash_flow]]number
F023应付账款平均付款期[[tusfinancial_indicators]]number
F024经营利润率[[tuslatest_sta]]number
F024佣金与手续费[[tusincome_statement]]number
F024应付账款[[tusbalance_sheet]]number
F024普通股发行[[tuscash_flow]]number
F024现金转换周期[[tusfinancial_indicators]]number
F025行业平均经营利润率[[tuslatest_sta]]number
F025做市交易收入[[tusincome_statement]]number
F025应缴税款[[tusbalance_sheet]]number
F025普通股回购[[tuscash_flow]]number
F026净利率[[tuslatest_sta]]number
F026股权投资收入[[tusincome_statement]]number
F026应计负债[[tusbalance_sheet]]number
F026股利支付[[tuscash_flow]]number
F027行业平均净利率[[tuslatest_sta]]number
F027借款存款手续费收入[[tusincome_statement]]number
F027递延收入[[tusbalance_sheet]]number
F027客户存款变动[[tuscash_flow]]number
F028总资产回报率[[tuslatest_sta]]number
F028证券收益(损失)[[tusincome_statement]]number
F028流动负债合计[[tusbalance_sheet]]number
F028短期借款变动[[tuscash_flow]]number
F029行业平均总资产回报率[[tuslatest_sta]]number
F029信用卡收入[[tusincome_statement]]number
F029养老金与其他退休福利[[tusbalance_sheet]]number
F029优先股发行[[tuscash_flow]]number
F030股东权益回报率[[tuslatest_sta]]number
F030保险费收入[[tusincome_statement]]number
F030少数股东权益[[tusbalance_sheet]]number
F030优先股赎回[[tuscash_flow]]number
F031行业平均股东权益回报率[[tuslatest_sta]]number
F031总非息收入[[tusincome_statement]]number
F031递延所得税负债[[tusbalance_sheet]]number
F031来自融资活动的净现金[[tuscash_flow]]number
F032负债权益比率[[tuslatest_sta]]number
F032扣除利息费用后营业收入[[tusincome_statement]]number
F032非流动负债合计[[tusbalance_sheet]]number
F032汇兑差额[[tuscash_flow]]number
F033行业平均负债权益比率[[tuslatest_sta]]number
F033净收入[[tusincome_statement]]number
F033客户存款[[tusbalance_sheet]]number
F033现金净变动[[tuscash_flow]]number
F034投保人给付与赔偿[[tusincome_statement]]number
F034交易性负债[[tusbalance_sheet]]number
F034期初现金余额[[tuscash_flow]]number
F035保单获得成本及其他开支[[tusincome_statement]]number
F035衍生负债[[tusbalance_sheet]]number
F035期末现金余额[[tuscash_flow]]number
F036贷款损失准备[[tusincome_statement]]number
F036保险合约负债[[tusbalance_sheet]]number
F036经营现金流[[tuscash_flow]]number
F037薪酬与福利[[tusincome_statement]]number
F037投保人资金[[tusbalance_sheet]]number
F037资本支出[[tuscash_flow]]number
F038场地占用费[[tusincome_statement]]number
F038未赚取保费[[tusbalance_sheet]]number
F038自由现金流[[tuscash_flow]]number
F039技术通讯和设备费[[tusincome_statement]]number
F039短期借款[[tusbalance_sheet]]number
F040专业和外部服务费[[tusincome_statement]]number
F040长期债务[[tusbalance_sheet]]number
F041广告和市场费[[tusincome_statement]]number
F041总负债[[tusbalance_sheet]]number
F041其他经营资产[[tuscash_flow]]number
F042无形资产摊销[[tusincome_statement]]number
F042优先股[[tusbalance_sheet]]number
F042其他非现金项目[[tuscash_flow]]number
F043非息费用合计[[tusincome_statement]]number
F043普通股[[tusbalance_sheet]]number
F043购入无形资产[[tuscash_flow]]number
F044息税前收入[[tusincome_statement]]number
F044资本公积[[tusbalance_sheet]]number
F044其他投资活动[[tuscash_flow]]number
F045持续经营税前利润[[tusincome_statement]]number
F045留存收益[[tusbalance_sheet]]number
F045其他金融活动[[tuscash_flow]]number
F046所得税[[tusincome_statement]]number
F046库藏股[[tusbalance_sheet]]number
F047终止经营业务收入[[tusincome_statement]]number
F047累计其他综合收益[[tusbalance_sheet]]number
F048净利润[[tusincome_statement]]number
F048股东权益合计[[tusbalance_sheet]]number
F049优先股股利[[tusincome_statement]]number
F049负债与股东权益合计[[tusbalance_sheet]]number
F050归属于普通股股东的净利润[[tusincome_statement]]number
F050现金合计[[tusbalance_sheet]]number
F051基本每股收益[[tusincome_statement]]number
F051其他流动资产[[tusbalance_sheet]]number
F052稀释每股收益[[tusincome_statement]]number
F052其他长期资产[[tusbalance_sheet]]number
F053基本加权股本[[tusincome_statement]]number
F053其他流动负债[[tusbalance_sheet]]number
F054稀释加权股本[[tusincome_statement]]number
F054其他长期负债[[tusbalance_sheet]]number
F055息税摊销前利润[[tusincome_statement]]number
F056其他经营费用[[tusincome_statement]]number
F057其他收入(支出)[[tusincome_statement]]number
F058持续经营利润[[tusincome_statement]]number

I

字段名中文名所属表类型
index指数[[tusindex_components]]varchar
ISINISIN[[tusper_share]]

L

字段名中文名所属表类型
LASTTRADEDATE最后交易日[[tusper_share]]

N

字段名中文名所属表类型
NAME[[tusper_share]]
name中文名称[[tusper_share]]varchar2
NAME英文名称[[tusidcsymbol]]VARCHAR2(256)

P

字段名中文名所属表类型
PRECLOSEPRICE校正昨收价[[tusper_share]]
precloseprice校正昨收价[[tusper_share]]number

Q

字段名中文名所属表类型
qldate除净日期[[TUSWEIGHT]]date

R

字段名中文名所属表类型
remark补充说明[[TUSSTOCK_NAME]]Varchar2
remark补充说明[[tuslatest_sta]]Vchar2
remark补充说明[[Tusbase]]Vchar2
remark补充说明[[tusincome_statement]]Vchar2
remark补充说明[[tusbalance_sheet]]Vchar2
remark补充说明[[tuscash_flow]]Vchar2
remark补充说明[[tusdividend_history]]Vchar2
remark补充说明[[tussplit_history]]Vchar2
remark补充说明[[tusequity_ownership]]Vchar2
remark补充说明[[tusfinancial_indicators]]Vchar2
remark补充说明[[tusindustry_classification]]Vchar2
remark补充说明[[tusper_share]]Vchar2
REMARK补充说明[[tusper_share]]
remark补充说明[[tusper_share]]varchar2
REMARK补充说明[[tusidccname]]VARCHAR2(500)
REMARK补充说明[[tusidcsymbol]]VARCHAR2(400)
remark补充说明[[tus major_ shareholders]]400
remark补充说明[[tusindex_components]]Varchar2
reportmonth报表月[[tusincome_statement]]char
reportmonth报表月[[tusbalance_sheet]]char
reportmonth报表月[[tuscash_flow]]char
reporttype报表类型[[tusincome_statement]]char
reporttype报表类型[[tusbalance_sheet]]char
reporttype报表类型[[tuscash_flow]]char
reportyear报表年[[tusincome_statement]]char
reportyear报表年[[tusbalance_sheet]]char
reportyear报表年[[tuscash_flow]]char

S

字段名中文名所属表类型
seccode股票id[[TUSWEIGHT]]Varchar2
seq记录唯一标识[[TUSWEIGHT]]number
seq记录唯一标识[[TUSSTOCK_NAME]]number
seq记录唯一标识[[tuslatest_sta]]number
seq记录唯一标识[[Tusbase]]number
seq记录唯一标识[[tusincome_statement]]number
seq记录唯一标识[[tusbalance_sheet]]number
seq记录唯一标识[[tuscash_flow]]number
seq记录唯一标识[[tusdividend_history]]number
seq记录唯一标识[[tussplit_history]]number
seq记录唯一标识[[tusequity_ownership]]number
seq记录唯一标识[[tusfinancial_indicators]]number
seq记录唯一标识[[tusindustry_classification]]number
seq记录唯一标识[[tusper_share]]number
SEQ记录唯一标识[[tusper_share]]
seq记录唯一标识[[tusper_share]]number
SEQ记录唯一标识[[tusidccname]]NUMBER
SEQ记录唯一标识[[tusidcsymbol]]NUMBER
seq记录唯一标识[[tus major_ shareholders]]22
seq记录唯一标识[[tusindex_components]]number
seqsource来源[[TUSWEIGHT]]varchar2
seqsource来源[[TUSSTOCK_NAME]]varchar2
seqsource来源[[tuslatest_sta]]varchar2
seqsource来源[[Tusbase]]varchar2
seqsource来源[[tusincome_statement]]varchar2
seqsource来源[[tusbalance_sheet]]varchar2
seqsource来源[[tuscash_flow]]varchar2
seqsource来源[[tusdividend_history]]varchar2
seqsource来源[[tussplit_history]]varchar2
seqsource来源[[tusequity_ownership]]varchar2
seqsource来源[[tusfinancial_indicators]]varchar2
seqsource来源[[tusindustry_classification]]varchar2
seqsource来源[[tusper_share]]varchar2
seqsource来源[[tusper_share]]varchar2
seqsource来源[[tusper_share]]varchar2
seqsource来源[[tusidccname]]varchar2
seqsource来源[[tusidcsymbol]]varchar2
seqsource来源[[tus major_ shareholders]]100
seqsource来源[[tusindex_components]]varchar2
STOCK_NAME股票简称[[TUSSTOCK_NAME]]char
SYMBOL_TICKER股票代码[[TUSSTOCK_NAME]]char

T

字段名中文名所属表类型
tradecode股票代码[[TUSWEIGHT]]Varchar2
tradecode股票代码[[tuslatest_sta]]vchar2
tradecode股票代码[[Tusbase]]vchar2
tradecode股票代码[[tusincome_statement]]vchar2
tradecode股票代码[[tusbalance_sheet]]vchar2
tradecode股票代码[[tuscash_flow]]vchar2
tradecode股票代码[[tusdividend_history]]vchar2
tradecode股票代码[[tussplit_history]]vchar2
tradecode股票代码[[tusequity_ownership]]vchar2
tradecode股票代码[[tusfinancial_indicators]]vchar2
tradecode股票代码[[tusindustry_classification]]vchar2
tradecode股票代码[[tusper_share]]vchar2
tradecode股票代码[[tus major_ shareholders]]6
TYPE商品类别[[tusper_share]]
type商品类别[[tusper_share]]varchar2
TYPE商品类别[[tusidcsymbol]]VARCHAR2(40)

U

字段名中文名所属表类型
UPDATETIME插入更新时间[[TUSWEIGHT]]DATE
UPDATETIME插入更新时间[[TUSSTOCK_NAME]]DATE
UPDATETIME插入更新时间[[tuslatest_sta]]DATE
UPDATETIME插入更新时间[[Tusbase]]DATE
UPDATETIME插入更新时间[[tusincome_statement]]DATE
UPDATETIME插入更新时间[[tusbalance_sheet]]DATE
UPDATETIME插入更新时间[[tuscash_flow]]DATE
UPDATETIME插入更新时间[[tusdividend_history]]DATE
UPDATETIME插入更新时间[[tussplit_history]]DATE
UPDATETIME插入更新时间[[tusequity_ownership]]DATE
UPDATETIME插入更新时间[[tusfinancial_indicators]]DATE
UPDATETIME插入更新时间[[tusindustry_classification]]DATE
UPDATETIME插入更新时间[[tusper_share]]DATE
UPDATETIME插入更新时间[[tusper_share]]DATE
UPDATETIME插入更新时间[[tusper_share]]DATE
UPDATETIME插入更新时间[[tusidccname]]DATE
UPDATETIME插入更新时间[[tusidcsymbol]]DATE
UPDATETIME插入更新时间[[tus major_ shareholders]]7
UPDATETIME插入更新时间[[tusindex_components]]DATE

W

字段名中文名所属表类型
week52tradehigh52周高位[[tusper_share]]number
WEEK52TRADEHIGH商品类别[[tusidccname]]NUMBER(18,6)
week52tradelow52周低位[[tusper_share]]number
WEEK52TRADELOW市场[[tusidccname]]NUMBER(18,6)