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 price, in the listing currencydoubleSourcedaily_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 address as reported by AlphaVantage, in the format of the SEC-filedbusiness address. Its country is the company'shome country, including for foreign issuers(TSM: Taiwan), but may differ from where thecompany is run (MDT: Galway, Ireland).varcharSourcecompany_overviews.addressUnchangedstaging, marts (2 models)asset_typeAsset type, e.g. "Common Stock". ADRs arealso reported as "Common Stock" (TSM, SONY,NVO)varcharSourcecompany_overviews.asset_typeUnchangedstaging, marts (2 models)business_descriptionBusiness descriptionvarcharSourcecompany_overviews.descriptionrenamed from descriptionstaging, marts (2 models)central_index_keySEC Central Index Key uniquely identifyingentitiesvarcharSourcecompany_overviews.cikrenamed from cikstaging, marts (2 models)company_nameCompany namevarcharSourcecompany_overviews.namerenamed from namestaging, marts (3 models)countryMarket country assigned by Alpha Vantage:USA for every US-listed security, includingforeign companies traded through ADRs (TSM,SONY, NVO all return USA). Says nothing aboutthe company itself: not its incorporation (CCL,Panama), headquarters or operations. Useaddress for the home country and SEC EDGARvia cik for legal domicile.varcharSourcecompany_overviews.countryUnchangedstaging, marts (2 models)currencyCurrency used in associated price andvaluation fieldsvarcharSourcecompany_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_exchangeListing exchange where the asset is tradedvarcharSourcecompany_overviews.exchangerenamed from exchangestaging, marts (2 models)official_siteCompany website URLvarcharSourcecompany_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 decimal fraction (0.025 =2.5%)doubleSourcecompany_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 decimal fraction, trailingtwelve monthsdoubleSourcecompany_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 insiders (0.04 = 4%)doubleSourcecompany_overviews.percent_insiderscast from varchar; source: Percentage of sharesheld by insiders (0-100), as textstaging, marts (2 models)percent_institutionsFraction of shares held by institutions (0.71 =71%)doubleSourcecompany_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 decimal fractiondoubleSourcecompany_overviews.profit_margincast from varcharstaging, marts (2 models)quarterly_earnings_growth_yoyYear-over-year growth in quarterly earnings asa decimal fractiondoubleSourcecompany_overviews.quarterly_earnings_growth_yoycast from varcharstaging, marts (2 models)quarterly_revenue_growth_yoyYear-over-year growth in quarterly revenue asa decimal fractiondoubleSourcecompany_overviews.quarterly_revenue_growth_yoycast from varcharstaging, marts (2 models)return_on_assets_ttmReturn on assets as a decimal fraction, trailingtwelve monthsdoubleSourcecompany_overviews.return_on_assets_ttmcast from varcharstaging, marts (2 models)return_on_equity_ttmReturn on equity as a decimal fraction, trailingtwelve monthsdoubleSourcecompany_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 InindicatorAlpha Vantage function name for the series,e.g. CPI or REAL_GDPvarcharSourceeconomic_indicators.indicatorUnchangedstaging, intermediate, marts (5models)period_start_dateStart date of the period the observation coversdateSourceeconomic_indicators.daterenamed from datestaging, intermediate, marts (5models)series_intervalPeriod covered by each observation; one ofannual, quarterly or monthlyvarcharSourceeconomic_indicators.intervalrenamed from intervalstaging, intermediate, marts (4models)series_nameFull name of the series, e.g. "Consumer PriceIndex for all Urban Consumers"varcharSourceeconomic_indicators.namerenamed from namestaging, intermediate, marts (5models)series_unitUnit of the observed value, e.g. "fraction" or"billions of dollars"varcharSourceeconomic_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 in the series unit (percentagesas fractions, 0.041 = 4.1%); null where the APIreported no valuedoubleSourceeconomic_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 date an economic observation is treated asavailable: the day after its period ends. Actualpublication is usually later, and Alpha Vantagegives no release dates.dateDerivedcalculated inint_alpha_vantage__economic_observationsDerived from other conceptsintermediate, marts (4 models)close_indexClosing price rebased to 100 at the ticker's firsttrading day in the data, for comparing tickerson one axisdoubleDerivedcalculated in fct_daily_pricesDerived from other conceptsmarts (2 models)daily_returnClose-to-close return from the ticker's previoustrading day, as a fraction (0.012 = 1.2%); null onits first daydoubleDerivedcalculated in fct_daily_pricesDerived from other conceptsmarts (2 models)indicator_record_idrecord_id 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 therecord (valid_to is null)booleanDerivedcalculated in dim_companiesDerived from other conceptsmarts (1 model)price_record_idrecord_id of the daily price row, for tracing amart row back to its sourcevarcharDerivedcalculated in fct_portfolio_positions_dailyDerived from other conceptsmarts (2 models) PortfolioHoldings, values and returns; dividends are estimatesConceptDefinitionTypeOriginComes FromSource to FinalUsed Incost_basisshares_held x purchase_pricedoubleDerivedcalculated in fct_portfolio_positions_dailyDerived from other conceptsmarts (1 model)estimated_dividendsESTIMATED dividends accrued since purchase:shares_held x trailing-twelve-month dividendper share x days held / 365. Uses thecompany's current fundamentals; no paymenthistory is loaded.doubleDerivedcalculated in fct_portfolio_positions_dailyDerived from other conceptsmarts (1 model)portfolio_cost_basisSum of cost_basis across the portfoliodoubleDerivedcalculated in fct_portfolio_dailyDerived from other conceptsmarts (1 model)portfolio_daily_returnChange in portfolio_value from the previoustrading day, as a fraction; null on the first daydoubleDerivedcalculated in fct_portfolio_dailyDerived from other conceptsmarts (1 model)portfolio_estimated_dividendsSum of estimated_dividends across theportfolio (an estimate, see estimated_dividends)doubleDerivedcalculated in fct_portfolio_dailyDerived from other conceptsmarts (1 model)portfolio_price_returnPrice-only portfolio return since purchase, as afraction, weighted by position sizedoubleDerivedcalculated 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_gainportfolio_value - portfolio_cost_basis, excludingdividendsdoubleDerivedcalculated in fct_portfolio_dailyDerived from other conceptsmarts (1 model)portfolio_valueSum of position_value across the portfolio onthe trading daydoubleDerivedcalculated in fct_portfolio_dailyDerived from other conceptsmarts (1 model)portfolio_weightShare of the portfolio's value in this position 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_valueshares_held x close_price on the trading day, inthe listing currencydoubleDerivedcalculated in fct_portfolio_positions_dailyDerived from other conceptsmarts (1 model)price_record_ids_hashAudit hash of the price rows behind anaggregate: md5 of the sorted price_record_idsjoined with ','varcharDerivedcalculated in fct_portfolio_dailyDerived from other conceptsmarts (1 model)price_returnPrice-only return since purchase, as a fraction(close_price / purchase_price - 1)doubleDerivedcalculated in fct_portfolio_positions_dailyDerived from other conceptsmarts (1 model)purchase_dateDate the position was bought; the purchaseprice is the close of the first trading day on orafter itdateSeedportfolio_holdings.purchase_dateUnchangedmarts (1 model)purchase_priceClose on the position's first trading day on orafter its 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 fraction ((position_value +estimated_dividends) / cost_basis - 1)doubleDerivedcalculated in fct_portfolio_positions_dailyDerived from other conceptsmarts (1 model)unrealized_gainposition_value - cost_basis, excludingdividendsdoubleDerivedcalculated 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_atStart time of the dlt load that last wrote the row.Upserted tables rewrite every re-fetched row;versioned (scd2) tables write a row only whenits values change.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_iddlt row identifier. Upserted tables: a hash of theprimary key, stable across loads. Versioned(scd2) tables: a hash of the row's content, so itidentifies the values, and repeats if valuesrevert.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 current(start of the dlt load that first saw it)timestamp withtime zoneSourcecompany_overviews._dlt_valid_fromrenamed from _dlt_valid_fromstaging, marts (2 models)valid_toWhen this version was replaced by a newerone; null while it is the current versiontimestamp withtime zoneSourcecompany_overviews._dlt_valid_torenamed from _dlt_valid_tostaging, marts (2 models) Data as of 19:55 UTC on 28 Sep 2026 made withdbt Charts