ETH Balances

Historical ETH balance of all addresses at every block height.

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 there are no ETH transactions performed in the last 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 Name	Description	Example
address	Address of the account.	0xd387a6e4e84a6c86bd90c158c6028a58cc8ac459
raw_balance	Balance of eth in wei.	1,000,000,000,000,000,000
balance	Balance of ether.	1
usd_value	The amount of ether, in $USD.	10
usd_exchange_rate	The exchange rate used to calculate the usd_value.	1
block_timestamp	The timestamp of the block that that resulted in the balance.	2022-09-15 13:51:47
block_number	The number of the block that resulted in the balance.	15539508
block_hash	The hash of the block that resulted in the balance.	0x25680259dfb40b4ee724ae22fda01a34e6d598c5f2fc25b6d871cb56c488de70