Address balance on a block level

mucryptoAddress balance on a block level

Updated 2023-04-19

select

block_number,

current_bal,

iff(user_address = lower('0xcbcdf9626bc03e24f779434178a73a0b4bad62ed'), 'WBTC/WETH', 'USDC/WETH') as pool_name

from ethereum.core.ez_balance_deltas

where block_timestamp::date = '2022-10-13'

and user_address in (lower('0x88e6a0c2ddd26feeb64f039a2c41296fcb3f5640'), lower('0xcbcdf9626bc03e24f779434178a73a0b4bad62ed'))

and contract_address in (lower('0xC02aaA39b223FE8D0A0e5C4F27eAD9083C756Cc2'))

and block_number between '15739000' and '15741000'

Run a query to Download Data

flipside