from ethereum.udm_events

where contract_address in ('0x6a091a3406e0073c3cd6340122143009adac0eda', '0x397ff1542f962076d0bfe58ea045ffa2d347aca0',

'0x055475920a8c93cffb64d039a8205f7acc7722d3', '0xd4e7a6e2d03e4e48dfc27dd3f46df1c176647e38', '0xceff51756c56ceffca006cd410b03ffc46dd3a58',

'0x06da0fd433c1a5d7a4faa01111c044910a184553', '0xe12af1218b4e9272e9628d7c7dc6354d137d024e', '0xc3f279090a47e80990fe3a9c30d24cb117ef91a8',

'0x69b81152c5a8d35a67b32a4d3772795d96cae4da', '0xb5de0c3753b6e1b4dba616db82767f17513e6d4e')

and date(block_timestamp) >= current_date - 7),

fees as (select tx_id, fee_usd/1e6 as fee_usd

from ethereum.transactions

where tx_id in (select tx_id from alltx)),

name as (select pool_name, pool_address

from ethereum.dex_swaps)

select a.contract_address, c.pool_name, sum(b.fee_usd) as fees_usd

from alltx a

left join fees b on a.tx_id = b.tx_id

left join name c on a.contract_address = c.pool_address

group by 1,2

order by 3 desc