Back to datasets
Open in DuneEther.fi Assets Under Management
Balance-state dataset for ether.fi-managed/internal/protocol-controlled addresses and parent/product deployment footprint analysis
Freshness & Refresh Interval
Delayed1h 7m ago ยท Every 1h
dune.ether_fi.result_etherfi_assets_under_managementSchema
| Column | Type | Description |
|---|---|---|
day | timestamp | — |
blockchain | varchar | Chain where the tracked balance row lives; useful for chain-level deployment footprint and multi-chain Cash balance analysis. |
address | varbinary | — |
address_name | varchar | Balance-side address classification context for the tracked address; use address_name = 'CASH' for Cash balance use cases. |
parent_address | varbinary | Parent rollup address for product/vault deployment analysis; often the same as address for simple addresses, but multi-address products roll child addresses up to this parent. |
parent_name | varchar | Human-readable parent product or protocol rollup context; do not confuse this with address_name classification. |
parent_symbol | varchar | Often the best filter for product deployment-footprint questions, such as liquidETH, liquidUSD, or liquidBTC. |
token_address | varbinary | — |
token_symbol | varchar | Symbol of the held token balance; acceptable ergonomic filter for core ether.fi balance questions. |
token_type | varchar | — |
token_project | varchar | Protocol where the balance is deployed; prefer this field for protocol-deployment filters and groupings such as token_project = 'Aave' or token_project = 'Morpho'. |
secondary_trait | varchar | Balance-side trait such as supply or borrow; for token_project in (Aave, Morpho), borrow rows must be negated for net deployment exposure while supply rows stay positive. |
token_balance_raw | double | — |
token_balance | double | — |
token_balance_underlying | double | Balance expressed in underlying asset units when available. |
token_underlying_symbol | varchar | Underlying asset symbol for balances that represent or wrap another asset. |
token_balance_usd | double | USD value of the balance row; primary aggregation field for tracked AUM/deployment footprint analysis. |
token_balance_eth | double | ETH-equivalent value of the balance row when ETH-denominated comparison is needed. |
filter_balance | boolean | Currently negligible and should not be elevated into a primary query field. |
last_updated | timestamp | — |
No schema columns match this filter.