select
date_trunc('day',a.block_timestamp) as date,
sum(amount) as Algos
from algorand.payment_transaction a
left join algorand.labels b on b.address = a.sender
where a.block_timestamp >= '2022-02-07' AND
a.block_timestamp < '2022-02-21' AND
a.sender = b.address AND
label_type = 'cex' AND
asset_id = 0
group by date
order by date