count(DISTINCT pool_name) as asset_traded,

count (DISTINCT platform) as n_dexes,

count (*) as n_transactions

FROM ethereum.defi.ez_dex_swaps

WHERE ORIGIN_FROM_ADDRESS = lower('0x4ec2DcdFb3c165dA62DD1367cB42fe7551524984')

AND EVENT_NAME = 'Swap'

GROUP BY ORIGIN_FROM_ADDRESS