with swaps as (select trunc(block_timestamp,'day') as day,
platform,
origin_from_address,
count(DISTINCT tx_hash) as count_tx
from ethereum.core.ez_dex_swaps
where day >= CURRENT_DATE - 60
group by 1,2,3)
select day,
platform,
avg(count_tx) as average_swap
from swaps
group by 1,2