date_trunc('w', block_timestamp) as _date,

platform,

count(tx_hash) as transaction_count,

count(distinct origin_from_address) as unique_swappers,

transaction_count / unique_swappers as tx_per_wallet

from ethereum.core.ez_dex_swaps

where block_timestamp::date >= current_date - 365

group by 1,2

order by 1