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

-- Get the latest ETH balance of a particular user address

select * from ethereum.assets.eth_balances_latest

where address = '0xd387a6e4e84a6c86bd90c158c6028a58cc8ac459' -- Pranksy

Table Columns

Column NameDescriptionExample
addressAddress of the account.0x66a84d487780c088d862971045d84b02d9b25aab
token_addressAddress of the Ether, which is represented as nulll address.0x0000000000000000000000000000000000000000
token_nameName of the token.ETH
token_symbolSymbol of the token.ETH
raw_balanceRaw balance of ether in wei.216,765,847,229,634
raw_balance_strRaw balance of ether in wei and in string format.216765847229634
balanceBalance of ether normalized.0.0002167658472
balance_strBalance of ether normalized and in string format.0.0002167658472
usd_balance_currentUSD balance of ETH at the current timestamp.0.308804626
usd_balance_at_block_timestampUSD balance of ETH at the timestamp of the last activity that resulted in balance change.0.2800939895
usd_exchange_rate_currentUSD exchange rate of ETH at the current timestamp.1,424.60
usd_exchange_rate_at_block_timestampUSD exchange rate of ETH at the timestamp of the last activity that resulted in balance update.1,292.15
last_activity_block_timestampThe last timestamp of the block that that resulted in the balance update.2022-12-05 03:58:11
last_activity_block_numberThe last block number that resulted in the balance update.16,116,061
last_activity_block_hashThe last hash of the block that resulted in the balance update.0x49ae37a2a5feb07d3f237dbfe4af59abb3b9ef19e3cd47ef083f1d7e45a2e616
_updated_at__usd_exchange_rate_currentTimestamp of the current USD exchange.2023-03-10 22:00:00
unique_idUnique ID of the balance.block-16116061_address-0x66a84d487780c088d862971045d84b02d9b25aab_eth
_updated_atTimestamp of the balance update.2023-03-10 10:18:07