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 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 NameDescriptionExample

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

Last updated