The current ERC20 balance of all addresses.
Column Name | Description | Example |
---|---|---|
address | Address of the account. | 0x4b805632240e35b06d93e42af2aee45417f9af6b |
token_address | Addres of the token. | 0xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb48 |
token_name | Name of the token. | USD Coin |
token_symbol | Symbol of the token. | USDC |
raw_balance | Balance of ERC20 token unnormalized. | 84,005 |
raw_balance_str | Balance of ERC20 token unnormalized in string. | 84005 |
balance_str | Balance of ERC20 token in string. | 0.084005 |
balance | Balance of ERC20 token. | 0.084005 |
usd_balance_current | USD balance of ERC20 token at the current timestamp. | 0.0839797985 |
usd_balance_at_block_timestamp | USD balance of ERC20 token at the timestamp of the last activity that resulted in balance change. | 0.083920995 |
usd_exchange_rate_current | USD exchange rate of ERC20 token at the current timestamp. | 0.9997 |
usd_exchange_rate_at_block_timestamp | USD exchange rate of ERC20 token at the timestamp of the last activity that resulted in balance update. | 0.999 |
last_activity_block_timestamp | The last timestamp of the block that that resulted in the balance update. | 2020-08-01 13:12:58 |
last_activity_block_number | The last block number that resulted in the balance update. | 10,574,102 |
last_activity_block_hash | The last hash of the block that resulted in the balance update. | 0x1e8003f10add525ff56b7bc28c65f5011a8d6d098aa086ecba0f87c881ffb7ae |
_updated_at__usd_exchange_rate_current | Timestamp of the current USD exchange. | 2023-03-10 22:00:00 |
unique_id | Unique ID of the balance | block-10574102_address-0x4b805632240e35b06d93e42af2aee45417f9af6b_token_address-0xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb48_erc20 |
_updated_at | Timestamp of the balance update. | 2023-03-10 10:18:08 |