select block_timestamp::date as date,
count(distinct(receiver)) as wallets,
sum (amount) as transferred_amount
from algorand.labels
join algorand.payment_transaction
on address = sender
where date >= '2022-05-02'::date -7
and label_type = 'cex'
and amount >0
group by 1