Data Dictionary ← Portfolio overview 96 Concepts 7 categories294 Documented Columns 15 tables and views67 Source Columns Changed 79 source and seed columns0 Conflicting Definitions 010203040Company fundamentalsPortfolioCompany profilePricesDerivedEconomic seriesLineageConcepts by CategoryEach category is a section of a domain's concept bank 010203040Cast to a new typeRenamedUnchangedSource quirk declaredFrom Source to ConceptWhat happens to each raw source and seed column; one column can be both renamed and cast PricesDaily price bars for each tickerConceptDefinitionTypeOriginComes FromSource to FinalUsed Inclose_priceClosing price, not adjusted for splits ordividendsdoubleSourcedaily_prices.closerenamed from closestaging, marts (4 models)high_priceHighest traded price of the daydoubleSourcedaily_prices.highrenamed from highstaging, marts (2 models)low_priceLowest traded price of the daydoubleSourcedaily_prices.lowrenamed from lowstaging, marts (2 models)open_priceOpening pricedoubleSourcedaily_prices.openrenamed from openstaging, marts (2 models)ticker_symbolTicker symbolvarcharSource,seedcompany_overviews.symbol,daily_prices.symbol,portfolio_holdings.ticker_symbolrenamed from symbolstaging, marts (6 models)trade_volumeNumber of shares tradedbigintSourcedaily_prices.volumerenamed from volumestaging, marts (3 models)trading_dateTrading daydateSourcedaily_prices.daterenamed from datestaging, intermediate, marts (6models) Company ProfileWho each company isConceptDefinitionTypeOriginComes FromSource to FinalUsed InaddressCompany's registered business address. Itscountry is the company's home country, whichcan differ from where the company is run.varcharSourcecompany_overviews.addressUnchangedstaging, marts (2 models)asset_typeType of security. Shares in foreign companiestraded in the US count as common stock.varcharSourcecompany_overviews.asset_typeUnchangedstaging, marts (2 models)business_descriptionBusiness descriptionvarcharSourcecompany_overviews.descriptionrenamed from descriptionstaging, marts (2 models)central_index_keyIdentifier of the company in US securities filingsvarcharSourcecompany_overviews.cikrenamed from cikstaging, marts (2 models)company_nameCompany namevarcharSourcecompany_overviews.namerenamed from namestaging, marts (3 models)countryCountry of the market the security trades in, notof the company: a foreign company traded inthe US shows the US. Its address gives thecompany's home country.varcharSourcecompany_overviews.countryUnchangedstaging, marts (2 models)currencyCurrency of the security's prices and valuationsvarcharSourcecompany_overviews.currencyUnchangedstaging, marts (2 models)fiscal_year_endMonth the fiscal year endsvarcharSourcecompany_overviews.fiscal_year_endUnchangedstaging, marts (2 models)industryIndustry classificationvarcharSourcecompany_overviews.industryUnchangedstaging, marts (3 models)latest_quarterEnd date of the latest reported fiscal quarterdateSourcecompany_overviews.latest_quartercast from varcharstaging, marts (2 models)listing_exchangeExchange the security is listed onvarcharSourcecompany_overviews.exchangerenamed from exchangestaging, marts (2 models)official_siteCompany websitevarcharSourcecompany_overviews.official_siteUnchangedstaging, marts (2 models)sectorSector classificationvarcharSourcecompany_overviews.sectorUnchangedstaging, marts (3 models) Company FundamentalsValuation, profitability, growth, dividends and risk; text in the source, cast to numbers and datesConceptDefinitionTypeOriginComes FromSource to FinalUsed Inanalyst_rating_buyNumber of analysts rating the stock BuyintegerSourcecompany_overviews.analyst_rating_buycast from varcharstaging, marts (2 models)analyst_rating_holdNumber of analysts rating the stock HoldintegerSourcecompany_overviews.analyst_rating_holdcast from varcharstaging, marts (2 models)analyst_rating_sellNumber of analysts rating the stock SellintegerSourcecompany_overviews.analyst_rating_sellcast from varcharstaging, marts (2 models)analyst_rating_strong_buyNumber of analysts rating the stock Strong BuyintegerSourcecompany_overviews.analyst_rating_strong_buycast from varcharstaging, marts (2 models)analyst_rating_strong_sellNumber of analysts rating the stock Strong SellintegerSourcecompany_overviews.analyst_rating_strong_sellcast from varcharstaging, marts (2 models)analyst_target_priceConsensus analyst price targetdoubleSourcecompany_overviews.analyst_target_pricecast from varcharstaging, marts (2 models)betaBeta, the stock's volatility relative to the marketdoubleSourcecompany_overviews.betacast from varcharstaging, marts (2 models)book_valueBook value per sharedoubleSourcecompany_overviews.book_valuecast from varcharstaging, marts (2 models)diluted_eps_ttmDiluted earnings per share, trailing twelvemonthsdoubleSourcecompany_overviews.diluted_epsttmrenamed from diluted_epsttm; cast from varcharstaging, marts (2 models)dividend_datePayment date of the latest dividenddateSourcecompany_overviews.dividend_datecast from varcharstaging, marts (2 models)dividend_per_shareDividends paid per share, trailing twelvemonthsdoubleSourcecompany_overviews.dividend_per_sharecast from varcharstaging, marts (2 models)dividend_yieldDividend yield, as a fractiondoubleSourcecompany_overviews.dividend_yieldcast from varcharstaging, marts (2 models)ebitdaEarnings before interest, taxes, depreciationand amortization, trailing twelve monthsbigintSourcecompany_overviews.ebitdacast from varcharstaging, marts (2 models)epsEarnings per share, trailing twelve monthsdoubleSourcecompany_overviews.epscast from varcharstaging, marts (2 models)ev_to_ebitdaEnterprise value to EBITDAdoubleSourcecompany_overviews.ev_to_ebitdacast from varcharstaging, marts (2 models)ev_to_revenueEnterprise value to revenuedoubleSourcecompany_overviews.ev_to_revenuecast from varcharstaging, marts (2 models)ex_dividend_dateEx-dividend date of the latest dividenddateSourcecompany_overviews.ex_dividend_datecast from varcharstaging, marts (2 models)forward_pePrice-to-earnings ratio on forecast earningsdoubleSourcecompany_overviews.forward_pecast from varcharstaging, marts (2 models)gross_profit_ttmGross profit, trailing twelve monthsbigintSourcecompany_overviews.gross_profit_ttmcast from varcharstaging, marts (2 models)high_52_weekHighest price in the last 52 weeksdoubleSourcecompany_overviews._52_week_highrenamed from _52_week_high; cast from varcharstaging, marts (2 models)low_52_weekLowest price in the last 52 weeksdoubleSourcecompany_overviews._52_week_lowrenamed from _52_week_low; cast from varcharstaging, marts (2 models)market_capitalizationMarket capitalization, in the reporting currencybigintSourcecompany_overviews.market_capitalizationcast from varcharstaging, marts (2 models)moving_average_200_day200-day moving average of the closing pricedoubleSourcecompany_overviews._200_day_moving_averagerenamed from _200_day_moving_average; castfrom varcharstaging, marts (2 models)moving_average_50_day50-day moving average of the closing pricedoubleSourcecompany_overviews._50_day_moving_averagerenamed from _50_day_moving_average; castfrom varcharstaging, marts (2 models)operating_margin_ttmOperating margin, as a fraction, trailing twelvemonthsdoubleSourcecompany_overviews.operating_margin_ttmcast from varcharstaging, marts (2 models)pe_ratioPrice-to-earnings ratiodoubleSourcecompany_overviews.pe_ratiocast from varcharstaging, marts (2 models)peg_ratioPrice/earnings-to-growth ratiodoubleSourcecompany_overviews.peg_ratiocast from varcharstaging, marts (2 models)percent_insidersFraction of shares held by insidersdoubleSourcecompany_overviews.percent_insiderscast from varchar; source: Percentage of sharesheld by insiders (0-100), as textstaging, marts (2 models)percent_institutionsFraction of shares held by institutionsdoubleSourcecompany_overviews.percent_institutionscast from varchar; source: Percentage of sharesheld by institutions (0-100), as textstaging, marts (2 models)price_to_book_ratioPrice-to-book ratiodoubleSourcecompany_overviews.price_to_book_ratiocast from varcharstaging, marts (2 models)price_to_sales_ratio_ttmPrice-to-sales ratio, trailing twelve monthsdoubleSourcecompany_overviews.price_to_sales_ratio_ttmcast from varcharstaging, marts (2 models)profit_marginNet profit margin, as a fractiondoubleSourcecompany_overviews.profit_margincast from varcharstaging, marts (2 models)quarterly_earnings_growth_yoyYear-over-year growth in quarterly earnings, asa fractiondoubleSourcecompany_overviews.quarterly_earnings_growth_yoycast from varcharstaging, marts (2 models)quarterly_revenue_growth_yoyYear-over-year growth in quarterly revenue, asa fractiondoubleSourcecompany_overviews.quarterly_revenue_growth_yoycast from varcharstaging, marts (2 models)return_on_assets_ttmReturn on assets, as a fraction, trailing twelvemonthsdoubleSourcecompany_overviews.return_on_assets_ttmcast from varcharstaging, marts (2 models)return_on_equity_ttmReturn on equity, as a fraction, trailing twelvemonthsdoubleSourcecompany_overviews.return_on_equity_ttmcast from varcharstaging, marts (2 models)revenue_per_share_ttmRevenue per share, trailing twelve monthsdoubleSourcecompany_overviews.revenue_per_share_ttmcast from varcharstaging, marts (2 models)revenue_ttmTotal revenue, trailing twelve monthsbigintSourcecompany_overviews.revenue_ttmcast from varcharstaging, marts (2 models)shares_floatShares available for public tradingbigintSourcecompany_overviews.shares_floatcast from varcharstaging, marts (2 models)shares_outstandingTotal shares outstandingbigintSourcecompany_overviews.shares_outstandingcast from varcharstaging, marts (2 models)trailing_pePrice-to-earnings ratio on trailing twelve-monthearningsdoubleSourcecompany_overviews.trailing_pecast from varcharstaging, marts (2 models) Economic SeriesUS macroeconomic indicators; percent series are converted to fractionsConceptDefinitionTypeOriginComes FromSource to FinalUsed InindicatorCode identifying the economic seriesvarcharSourceeconomic_indicators.indicatorUnchangedstaging, intermediate, marts (5models)period_start_dateStart of the period an observation coversdateSourceeconomic_indicators.daterenamed from datestaging, intermediate, marts (5models)series_intervalHow often the series is observedvarcharSourceeconomic_indicators.intervalrenamed from intervalstaging, intermediate, marts (4models)series_nameFull name of the economic seriesvarcharSourceeconomic_indicators.namerenamed from namestaging, intermediate, marts (5models)series_unitUnit of the observed valuevarcharSourceeconomic_indicators.unitrenamed from unit; source: Unit of the observedvalue as reported by the API, e.g. "percent" or"billions of dollars"staging, intermediate, marts (5models)valueObserved value of the series, in its unit, withpercentages as fractions; null where none wasreporteddoubleSourceeconomic_indicators.valuesource: Observed value in the reported unit(percent series on a 0-100 scale); null where theAPI reported no valuestaging, intermediate, marts (5models) DerivedCalculated in the models, not loaded from a sourceConceptDefinitionTypeOriginComes FromSource to FinalUsed Inavailable_from_dateFirst day an observation counts as known: theday after its period ends. Actual publication isusually later, so this is an optimistic assumption.dateDerivedcalculated inint_alpha_vantage__economic_observationsDerived from other conceptsintermediate, marts (4 models)close_indexClosing price rebased to 100 on the first tradingday, for comparing securities on one scaledoubleDerivedcalculated in fct_daily_pricesDerived from other conceptsmarts (2 models)daily_returnReturn from the previous trading day's close, asa fraction; null on the first daydoubleDerivedcalculated in fct_daily_pricesDerived from other conceptsmarts (2 models)indicator_record_idIdentifier of the economic observation in effecton the trading dayvarcharDerivedcalculated in mart_daily_marketDerived from other conceptsmarts (1 model)is_currentWhether this is the current version of therecordbooleanDerivedcalculated in dim_companiesDerived from other conceptsmarts (1 model)price_record_idIdentifier of the daily price row this row comesfromvarcharDerivedcalculated in fct_portfolio_positions_dailyDerived from other conceptsmarts (2 models) PortfolioHoldings, values and returns; dividends are estimatesConceptDefinitionTypeOriginComes FromSource to FinalUsed Incost_basisAmount paid for the positiondoubleDerivedcalculated in fct_portfolio_positions_dailyDerived from other conceptsmarts (1 model)estimated_dividendsEstimated dividends earned since purchase,from the current yearly dividend per share andthe days held. An estimate, not actualpayments.doubleDerivedcalculated in fct_portfolio_positions_dailyDerived from other conceptsmarts (1 model)portfolio_cost_basisTotal amount paid for the portfoliodoubleDerivedcalculated in fct_portfolio_dailyDerived from other conceptsmarts (1 model)portfolio_daily_returnChange in the portfolio's value from theprevious trading day, as a fraction; null on thefirst daydoubleDerivedcalculated in fct_portfolio_dailyDerived from other conceptsmarts (1 model)portfolio_estimated_dividendsEstimated dividends earned across theportfolio. An estimate, not actual payments.doubleDerivedcalculated in fct_portfolio_dailyDerived from other conceptsmarts (1 model)portfolio_price_returnPortfolio return since purchase from pricesalone, as a fractiondoubleDerivedcalculated in fct_portfolio_dailyDerived from other conceptsmarts (1 model)portfolio_total_returnPortfolio return since purchase includingestimated dividends, as a fractiondoubleDerivedcalculated in fct_portfolio_dailyDerived from other conceptsmarts (1 model)portfolio_unrealized_gainGain in the portfolio's value since purchase,excluding dividendsdoubleDerivedcalculated in fct_portfolio_dailyDerived from other conceptsmarts (1 model)portfolio_valueTotal value of the portfolio on the trading daydoubleDerivedcalculated in fct_portfolio_dailyDerived from other conceptsmarts (1 model)portfolio_weightThe position's share of the portfolio's value onthe trading day, as a fractiondoubleDerivedcalculated in fct_portfolio_positions_dailyDerived from other conceptsmarts (1 model)position_countNumber of positions held on the trading daybigintDerivedcalculated in fct_portfolio_dailyDerived from other conceptsmarts (1 model)position_valueValue of the position at the day's close, in thelisting currencydoubleDerivedcalculated in fct_portfolio_positions_dailyDerived from other conceptsmarts (1 model)price_record_ids_hashFingerprint of the price rows combined into thisone, for checking which rows went invarcharDerivedcalculated in fct_portfolio_dailyDerived from other conceptsmarts (1 model)price_returnReturn since purchase from the price alone, asa fractiondoubleDerivedcalculated in fct_portfolio_positions_dailyDerived from other conceptsmarts (1 model)purchase_dateDate the position was boughtdateSeedportfolio_holdings.purchase_dateUnchangedmarts (1 model)purchase_pricePrice paid per share: the close on the firsttrading day on or after the purchase datedoubleDerivedcalculated in fct_portfolio_positions_dailyDerived from other conceptsmarts (1 model)shares_heldNumber of shares held in the positionintegerSeedportfolio_holdings.shares_heldUnchangedmarts (1 model)total_returnReturn since purchase including estimateddividends, as a fractiondoubleDerivedcalculated in fct_portfolio_positions_dailyDerived from other conceptsmarts (1 model)unrealized_gainGain in the position's value since purchase,excluding dividendsdoubleDerivedcalculated in fct_portfolio_positions_dailyDerived from other conceptsmarts (1 model) LineageWhen each row was loaded, which record it is, and which versionConceptDefinitionTypeOriginComes FromSource to FinalUsed Inloaded_atWhen the row was last loaded. A record whosehistory is kept is reloaded only when its valueschange.timestamp withtime zoneSourcecompany_overviews._dlt_load_id,daily_prices._dlt_load_id,economic_indicators._dlt_load_idrenamed from _dlt_load_id; cast from varchar;source: dlt load id; the Unix timestamp (seconds)of the load start, as textstaging, intermediate, marts (7models)record_idIdentifier of the loaded row. For a record whosehistory is kept, it identifies one version's values.varcharSourcecompany_overviews._dlt_id,daily_prices._dlt_id,economic_indicators._dlt_idrenamed from _dlt_id; renamed from _dlt_id;source: dlt row identifier; a hash of the row'scontent (repeats if values revert to an earlierversion)staging, intermediate, marts (8models)valid_fromWhen this version of the record became currenttimestamp withtime zoneSourcecompany_overviews._dlt_valid_fromrenamed from _dlt_valid_fromstaging, marts (2 models)valid_toWhen this version was replaced; null while it'scurrenttimestamp withtime zoneSourcecompany_overviews._dlt_valid_torenamed from _dlt_valid_tostaging, marts (2 models) Data as of 13:13 UTC on 17 Oct 2026 made withdbt Charts