select 'sushiswap' as type,
count(distinct from_address) as all_users,
count(distinct tx_id) as transactions,
sum(amount_usd) as total_volume,
trunc(block_timestamp,'day') as date_time
from ethereum.dex_swaps
where platform ='sushiswap'
and date_time <= CURRENT_DATE - 2
group by date_time