select
block_timestamp :: date as date,
platform,
sum(amount_in_usd) as volume,
avg(amount_in_usd) as avg_volume
from
ethereum.defi.ez_dex_swaps
where 1=1
and block_timestamp > '2024-08-01 00:00:00.000'
and block_timestamp < '2024-08-10 00:00:00.000'
group by date, platform