date_trunc('day', block_timestamp) as date,

sum(amount_in) as amount_in, sum(amount_out) as amount_out, amount_usd,

direction, platform

from ethereum.dex_swaps

group by 1,4,5,6

limit 2000