date_trunc('week', block_timestamp) as week,

label,

count(DISTINCT tx_hash) as events,

count(DISTINCT ORIGIN_FROM_ADDRESS) as users

FROM ethereum.core.ez_token_transfers

LEFT outer JOIN ethereum.core.dim_labels

ON address = to_address

WHERE label_type LIKE 'cex'

and block_timestamp > '2022-01-01'

GROUP BY 1,2

having events > 500