date_trunc('day', BLOCK_TIMESTAMP) as date, platform, count(DISTINCT tx_hash) as "Number of swaps",

round(sum(amount_in_usd)) as amount_usd, count(DISTINCT sender) as "Unique users"

FROM ethereum.core.ez_dex_swaps

Where date >= CURRENT_DATE - 180

group by 1,2