select date(block_timestamp) as date, project_name, count(DISTINCT(from_address)) as users, sum(amount) as amount
from bsc.core.ez_token_transfers a join bsc.core.dim_labels b on a.to_address = b.address
where block_timestamp::date >= current_date - 30
and contract_address = lower('0x9Fb9a33956351cf4fa040f65A13b835A3C8764E3')
and label_type != 'cex'
and project_name != 'burn address'
group by 1,2