-- ('0xe9f1d7076c084974c78265f686ecf2f56157064e4ea521045c19df9082586c9e', '0x600ee40232da9687743d953f0193aa8b32d76dfb59819ad00c05c05b575cf4c1')

--and platform = 'sushiswap';

with test as (

select date(block_timestamp) as day, to_address, amount_usd from ethereum.udm_events

where lower(from_address) = lower('0xEF0881eC094552b2e128Cf945EF17a6752B4Ec5d')

and amount_usd is not null and amount_usd>0

)

select a.day, a.to_address, b.pool_name, a.amount_usd from test a inner join ethereum.dex_liquidity_pools b

on a.to_address = b.pool_address