select date_trunc('day',block_timestamp) as date, sum(amount_in_usd) as "Swap Volume USD", count(distinct origin_from_address) as "Swapper Count",
count(distinct tx_hash) as "Swap Count", platform
from ethereum.core.ez_dex_swaps
where block_timestamp::date>='2022-10-15' and block_timestamp::date<>current_date
group by 1,5
order by 1