Date_trunc('week', block_timestamp) as Date,

count(distinct tx_hash) as Swap,

count(distinct sender) as Swappers,

sum(case when amount_in_usd is null then amount_out_usd else amount_in_usd end) as Volume_usd

from base.defi.ez_dex_swaps

where platform like 'aerodrome'

group by 1