platform,

avg(coalesce(amount_in_usd, amount_out_usd)) as volume_usd,

FROM blast.defi.ez_dex_swaps

GROUP BY platform