COUNT(DISTINCT tx_hash) as tx_count,

count(DISTINCT ORIGIN_FROM_ADDRESS) as senders,

sum(amount) as volume_ETH,

sum(amount_usd) as volume_USD,

ifnull(lb.LABEL_type, lb2.LABEL_type) as project

FROM ethereum.core.ez_eth_transfers

left join ethereum.core.dim_labels lb on ORIGIN_TO_ADDRESS = lb.ADDRESS

left join crosschain.core.address_labels lb2 on ORIGIN_TO_ADDRESS = lb2.ADDRESS

WHERE block_timestamp>='2023-01-01' and block_timestamp <='2023-01-16'

and project is not NULL

GROUP by date, project