SELECT date_trunc('month', block_timestamp) as date,
platform,
sum(ABS(amount_in_usd) + ABS(amount_out_usd))/2 as monthly_trading_volume
--count(distinct tx_hash) as Swaps_count,
--count(distinct origin_from_address) as Traders_count
FROM ethereum.core.ez_dex_swaps
WHERE 'monthly_trading_volume' IS NOT NULL
--AND date > 2021-5-05
GROUP BY 1,2
ORDER BY 3