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
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
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
Last updated