a.block_timestamp::date as day,

case when symbol is null then 'others' else symbol end as symbol,

sum(b.amount_usd) AS amount_usd

from ethereum.core.fact_transactions a

left join ethereum.core.ez_token_transfers b on a.tx_hash = b.tx_hash

where a.to_address = lower('0x3ee18b2214aff97000d974cf647e7c347e8fa585')

and a.origin_function_signature = '0x0f5287b0' AND a.status = 'SUCCESS' and amount_usd is not null

AND day >='2022-01-01'

group by 1,2