select date_trunc('day', block_timestamp) as dayz, sum(amount_in)
from ethereum.dex_swaps
where platform ='sushiswap'
and token_address='0x8798249c2e607446efb7ad49ec89dd1865ff4272'
and direction='IN'
and block_timestamp >= current_date - 30
group by 1
order by 1 desc