balances tables can be used to easily plot the change in the balance of an address or a group of addresses over time.
Table Columns
| Column Name | Description | Example |
|---|---|---|
| address | Address of the account. | 0xe6c27255fbb9d3a9718fb5e2dc313cd6eba10b78 |
| token_address | Token address of the asset. | 0x0000000000000000000000000000000000000000 |
| token_name | Name of the ERC20 token. | MATIC |
| token_symbol | Token symbol of this token. | MATIC |
| token_id | Unique token ID of the asset. Only applicable for ERC721 and ERC1155 tokens. | |
| raw_balance | Balance of tokens (unnormalized) | 7.33E+21 |
| raw_balance_str | Balance of tokens (unnormalized) in string. | 7.33E+21 |
| balance_str | Balance of the token, normalized by the decimal points defined in the ERC20 token contract. For example, USDC has 6 decimals, so this value is the raw_balance divided by 10^6. | 7,326.74 |
| balance_str | Balance of this token, normalized by the decimal points defined in the token contract. | 7326.738152 |
| usd_balance | The amount of tokens, in $USD. | 14,741.40 |
| usd_exchange_rate | The exchange rate used to calculate the usd_value. | 2.012 |
| block_timestamp | The timestamp of the block that that resulted in the balance. | 2021-10-29 21:49:19 |
| block_number | The number of the block that resulted in the balance. | 20,755,138 |
| block_hash | The hash of the block that resulted in the balance. | 0x217645cca87d00afbe22bc21734e7201cbf106e257ad38f1462bb7a42c7eeb0e |
| token_type | Token type of asset. Includes ETH, ERC20, ERC721 and ERC1155. | MATIC |
| unique_id | Unique ID of the balances entry | block-20755138_address-0xe6c27255fbb9d3a9718fb5e2dc313cd6eba10b78_eth |