Account Balances Daily Agg
Table Metadata​
| Property | Configuration |
|---|---|
| Natural Key(s) | day, account_id, contract_id |
| Partition Field(s) | day (DAY partition) |
| Clustered Field(s) | account_id, contract_id |
| Documentation | dbt docs |
Column Details​
| Name | Description | Data Type | Domain Values | Required? | Notes |
|---|---|---|---|---|---|
| day | Date by which all metrics are aggregated. Balances are reported as of the end of this day. | DATE | Yes | ||
| account_id | The address holding the balance. Either a classic account address (base32, starts with G) or a Soroban contract address (starts with C). | STRING | Yes | Not limited to classic accounts: contract addresses hold SAC and custom contract token balances and are unioned into this column by the upstream int_account_balances__contracts model. | |
| asset_type | The identifier for type of asset code, can be an alphanumeric with 4 characters, 12 characters or the native asset to the network, XLM. | STRING |
| No | XLM 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_code | The code representation of the asset on the network. | STRING | No | For 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_issuer | The account address of the original asset issuer that created the asset. | STRING | No | ||
| contract_id | Soroban contract id of the SAC or contract token the balance is denominated in. | STRING | Yes | Cluster Field. | |
| liquidity_pool_balance | The sum of balances across all liquidity pools for a given asset. | FLOAT | Yes | ||
| offer_balance | The sum of balances across all selling liabilities (SDEX only) for a given asset. | FLOAT | Yes | ||
| trustline_balance | The sum of trustline balance for a given asset. | FLOAT | Yes | ||
| contract_balance | The sum of contract balance for a given asset. | FLOAT | Yes |