Skip to main content

Asset Balances Daily Agg

Table Metadata​

PropertyConfiguration
Natural Key(s)day, asset_type, asset_code, asset_issuer
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.STRINGYesXLM 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 4 or 12 character code representation of the asset on the network.STRINGYesAsset codes have no guarantees of uniqueness. The combination of asset code, issuer and type represents a distinct asset
asset_issuerThe account address of the original asset issuer that created the asset.STRINGYes
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