
Dataset Name: intrinio_fundamentals_fin_balance_sheet_cik
Group: fundamental
Vendor: Intrinio
Asset Class: Equity
Data Update Time(s): 7:30 AM EST
Data Update Frequency: day
Intrinio financial fundamentals balance sheet data
Data Contained in this Dataset
Column | Type | Description |
---|---|---|
_seq | uint | Internal sequence number used to keep data rows in order |
timestamp | string | Timestamp of the Data - America/New York Time. |
muts | uint64 | Microseconds Unix Timestamp. An integer representation of a timestamp with microsecond precision that can be compared directly to other timestamps. (underlying field is nc_publish_date_actual) |
symbol | string | Trading Symbol or Ticker |
fundamental_id | string | fundamental_id |
company_id | string | Company identifier |
name | string | name |
ticker | string | Ticker symbol associated with this message or row of data. |
start_date | string | start_date |
end_date | string | end_date |
months | double | months |
fiscal_year | int | Fiscal year (ie 2017 2018 2019 2020 2021) |
fiscal_period | string | The company's fiscal period |
filing_date | string | Filining date with the regulator |
cashandequivalents | double | cash and equivalents |
restrictedcash | double | restrictedcash |
fedfundssold | double | fedfundssold |
interestbearingdepositsatotherbanks | double | interestbearingdepositsatotherbanks |
timedepositsplaced | double | timedepositsplaced |
tradingaccountsecurities | double | tradingaccountsecurities |
loansandleases | double | loansandleases |
allowanceforloanandleaselosses | double | allowance for loan and lease losses |
netloansandleases | double | netloansandleases |
loansheldforsale | double | loansheldforsale |
accruedinvestmentincome | double | accrued investment income |
customerandotherreceivables | double | customer and other receivables |
netpremisesandequipment | double | netpremisesandequipment |
mortgageservicingrights | double | mortgageservicingrights |
unearnedpremiumsdebit | double | unearnedpremiumsdebit |
deferredacquisitioncost | double | deferred acquisition cost |
separateaccountbusinessassets | double | separateaccountbusinessassets |
goodwill | double | This item represents the excess of purchase price paid over the fair market value of net assets acquired, net of any write downs for impairment in value. |
intangibleassets | double | intangibleassets |
otherassets | double | otherassets |
totalassets | double | totalassets |
noninterestbearingdeposits | double | noninterestbearingdeposits |
interestbearingdeposits | double | interestbearingdeposits |
fedfundspurchased | double | fedfundspurchased |
shorttermdebt | double | Short-term debt, also called current liabilities, is a firm's financial obligations that are expected to be paid off within a year. |
bankersacceptances | double | bankers acceptances |
accruedinterestpayable | double | Accrued interest payable |
othershorttermpayables | double | othershorttermpayables |
longtermdebt | double | longtermdebt |
capitalleaseobligations | double | capital lease obligations |
claimsandclaimexpenses | double | claims and claim expenses |
futurepolicybenefits | double | futurepolicybenefits |
unearnedpremiumscredit | double | unearnedpremiumscredit |
policyholderfunds | double | policyholderfunds |
participatingpolicyholderequity | double | participatingpolicyholderequity |
separateaccountbusinessliabilities | double | separateaccountbusinessliabilities |
otherlongtermliabilities | double | otherlongtermliabilities |
totalliabilities | double | totalliabilities |
commitmentsandcontingencies | double | commitments and contingencies |
redeemablenoncontrollinginterest | double | redeemablenoncontrollinginterest |
totalpreferredequity | double | totalpreferredequity |
commonequity | double | common equity |
retainedearnings | double | retainedearnings |
treasurystock | double | treasurystock |
aoci | double | AOCI |
otherequity | double | otherequity |
totalcommonequity | double | totalcommonequity |
totalequity | double | totalequity |
noncontrollinginterests | double | noncontrollinginterests |
totalequityandnoncontrollinginterests | double | totalequityandnoncontrollinginterests |
totalliabilitiesandequity | double | totalliabilitiesandequity |