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.
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
Column Name | Description | Example |
|---|---|---|
address | Address of the account. | 0xd387a6e4e84a6c86bd90c158c6028a58cc8ac459 |
raw_balance | 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 modified 7mo ago