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