With OM as (

SELECT

date_trunc('week', block_timestamp) as Date,

a.tx_hash,

a.to_address,

a.amount_usd,

symbol

FROM ethereum.core.ez_token_transfers a

JOIN crosschain.core.dim_labels c on a.from_address = c.address

WHERE

label_type = 'cex'

AND symbol = 'OM'

OM.Date as date,

count(DISTINCT OM.tx_hash) as Total_Transaction,

count(DISTINCT OM.to_address) as Total_Active_Trader,

sum(OM.amount_usd) as Total_Volume_Traded,

avg(OM.amount_usd) as Avg_volume

FROM OM

GROUP BY 1