Assets
The Assets vertical records all wallet balances and transfers on Ethereum from the genesis block to the present.
There are 4 main categories of tables in the assets vertical. Below are some examples of use cases for each of the tables under the asset vertical.
| Table | Use Case | Question |
|---|---|---|
Tracks all changes in asset balance for a given address, from wallet creation to the present. | What is the USDC balance of a particular wallet over time? | |
Checking the current balances of assets for a given address. | What is the current distribution of ETH holdings of OpenSea NFT buyers in the last 7 days? | |
Account for the inflow or outflows of assets from one address to another. | What is the total inflow of USDC into a wallet in the last 30 days? (not accounting for outflows) | |
Accounting for inflows and outflows of assets. | What is the net balance change of USDC into a wallet in the last 14 days? |
Each of the categories has both aggregated and asset-specific (ETH, ERC20, ERC721 & ERC1155) tables.
For example,ethereum.assets.balances provides an aggregate of all assets while ethereum.assets.eth_balancescontaining ETH balances only.
Last updated