Skip to main content
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
⌘I