ETH Balances Latest
The current ETH balance of all addresses.
Last updated
The current ETH balance of all addresses.
Last updated
Note that the USD prices of any given latest balance might lag more than you expect them to. Check the _updated_at__usd_exchange_rate_current column to ensure the price is fresh enough for your use case.
The assets.eth_balances_latest table contains the latest balance of ETH of all addresses. It is otherwise identical to ETH Balances.
| Column Name | Description | Example |
|---|---|---|
address
Address of the account.
0x66a84d487780c088d862971045d84b02d9b25aab
token_address
Address of the Ether, which is represented as nulll address.
0x0000000000000000000000000000000000000000
token_name
Name of the token.
ETH
token_symbol
Symbol of the token.
ETH
raw_balance
Raw balance of ether in wei.
216,765,847,229,634
raw_balance_str
Raw balance of ether in wei and in string format.
216765847229634
balance
Balance of ether normalized.
0.0002167658472
balance_str
Balance of ether normalized and in string format.
0.0002167658472
usd_balance_current
USD balance of ETH at the current timestamp.
0.308804626
usd_balance_at_block_timestamp
USD balance of ETH at the timestamp of the last activity that resulted in balance change.
0.2800939895
usd_exchange_rate_current
USD exchange rate of ETH at the current timestamp.
1,424.60
usd_exchange_rate_at_block_timestamp
USD exchange rate of ETH at the timestamp of the last activity that resulted in balance update.
1,292.15
last_activity_block_timestamp
The last timestamp of the block that that resulted in the balance update.
2022-12-05 03:58:11
last_activity_block_number
The last block number that resulted in the balance update.
16,116,061
last_activity_block_hash
The last hash of the block that resulted in the balance update.
0x49ae37a2a5feb07d3f237dbfe4af59abb3b9ef19e3cd47ef083f1d7e45a2e616
_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-16116061_address-0x66a84d487780c088d862971045d84b02d9b25aab_eth
_updated_at
Timestamp of the balance update.
2023-03-10 10:18:07