SELECT

date_trunc('month', block_timestamp) as month,

sum(case WHEN symbol_in LIKE 'USDC' then amount_in_usd ELSE amount_out_usd END) as swap_volume_usd,

count(DISTINCT tx_hash) as swaps,

count(DISTINCT ORIGIN_FROM_ADDRESS) as users

FROM ethereum.core.ez_dex_swaps

WHERE symbol_in LIKE 'USDC'

OR symbol_out LIKE 'USDC'

GROUP BY 1