Skip to main content

Asset Balances Daily Agg

Table Metadata​

PropertyConfiguration
Natural Key(s)day, contract_id
Partition Field(s)day (DAY partition)
Clustered Field(s)N/A
Documentationdbt docs

Column Details​

NameDescriptionData TypeDomain ValuesRequired?Notes
dayDate by which all metrics are aggregated.DATEYes
asset_typeThe identifier for type of asset code, can be an alphanumeric with 4 characters, 12 characters or the native asset to the network, XLM.STRINGNoXLM is the native asset to the network. XLM has no asset code or issuer representation and will instead be displayed with an asset type of 'native'
asset_codeThe code representation of the asset on the network.STRINGNoFor classic assets this is the 4 or 12 character asset code. For contract tokens it is resolved via int_asset_metadata, which coalesces the asset_code from SAC transfer events with the SEP-41 symbol from contract storage metadata; SEP-41 places no length constraint on symbol, so values outside 4/12 characters occur. Null when a contract publishes neither. Asset codes have no guarantees of uniqueness.
asset_issuerThe account address of the original asset issuer that created the asset.STRINGNo
liquidity_pool_balanceThe sum of balances across all liquidity pools for a given asset.FLOATYes
offer_balanceThe sum of balances across all selling liabilities(SDEX only) for a given asset.FLOATYes
trustline_balanceThe sum of trustline balance for a given asset.FLOATYes
total_accounts_with_liquidity_pool_balanceThe count of positive liquidity pool balance holders for a given asset.INTEGERYes
total_accounts_with_offer_balanceThe count of positive offer balance holders for a given asset.INTEGERYes
total_accounts_with_trustline_balanceThe count of positive trustline balance holders for a given asset.INTEGERYes
contract_idSoroban contract id of the SAC or contract token the balance is denominated in.STRINGYes
contract_balanceThe sum of contract balance for a given asset.FLOATYesProduced with coalesce(..., 0) upstream, so never null; 0 means no contract balance.
total_accounts_with_contract_balanceThe count of positive contract balance holders for a given asset.INTEGERYesProduced with coalesce(..., 0) upstream, so never null.
total_accounts_with_trustlineThe count of accounts holding a trustline for a given asset, including accounts with a zero balance.INTEGERYesProduced with coalesce(..., 0) upstream, so never null.