SELECT
date_trunc('day',block_timestamp) AS date,
--COUNT(DISTINCT a.tx_hash) AS No_of_Transaction,
a.to_address AS receiver,
b.label_type
FROM arbitrum.core.fact_token_transfers a
JOIN arbitrum.core.dim_labels b
on a.contract_address = b.address
WHERE label_type = 'cex'
GROUP BY 1,2,3
LIMIT 10