SELECT date_trunc('day',DATE(block_timestamp)) as DATE , SUM(amount) AS Total_Amount
FROM algorand.payment_transaction
WHERE receiver IN (
SELECT address FROM algorand.labels WHERE label_type = 'cex'
)
AND DATE >= '2022-01-01'
GROUP BY DATE
ORDER BY DATE