date_trunc('day', block_timestamp) as day_date,

sum(amount_in_usd) as sum_amount_usd

FROM ethereum.core.ez_dex_swaps

WHERE block_timestamp > current_date - 30

AND amount_in_usd is not null

group by 1 -- this is the first column