SELECT

block_timestamp::date as day,

symbol,

current_bal

FROM

ethereum.core.ez_balance_deltas

WHERE

block_timestamp >= '2023-02-01'

AND user_address = '0xbebc44782c7db0a1a60cb6fe97d0b483032ff1c7'

AND contract_address IN (

'0x6b175474e89094c44da98b954eedeac495271d0f'

,'0xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb48'

,'0xdac17f958d2ee523a2206206994597c13d831ec7'

qualify row_number() over (partition by day, symbol order by block_timestamp desc) = 1