ETH balances table contains the balance of all addresses, at every block height. Use this table to easily plot the change in the balance of an address or a group of addresses over time.

​
Sample Query

Get ETH balances of an address in the last 7 days. If no ETH transactions are performed over the previous 7 days, the output will be empty.

select * from ethereum.assets.eth_balances

where address = '0xd387a6e4e84a6c86bd90c158c6028a58cc8ac459' -- Pranksy

and current_date - date(block_timestamp) < 7

order by block_number desc

​
Table Columns

Column NameDescriptionExampleColumn Name
addressAddress of the account.0xd387a6e4e84a6c86bd90c158c6028a58cc8ac459
raw_balanceBalance of eth in wei.1,000,000,000,000,000,000
balanceBalance of ether.1
usd_valueThe amount of ether, in $USD.10
usd_exchange_rateThe exchange rate used to calculate the usd_value.1
block_timestampThe timestamp of the block that that resulted in the balance.2022-09-15 13:51:47
block_numberThe number of the block that resulted in the balance.15539508
block_hashThe hash of the block that resulted in the balance.0x25680259dfb40b4ee724ae22fda01a34e6d598c5f2fc25b6d871cb56c488de70