Balances Latest
ETH Balances Latest
The current ETH balance of all addresses.
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.
Sample Query
Table Columns
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 |