WITH cex_address AS (
SELECT address, label
FROM algorand.labels
WHERE label_type = 'cex'
),
sent_from_cex AS (
SELECT DATE(block_timestamp) as DATE, sender as cex_address, label as cex_label, amount as sent_amount
FROM algorand.payment_transaction
INNER JOIN cex_address
ON sender = address
)
SELECT date_trunc('day', DATE) AS time_period, cex_label, sum(sent_amount) AS total_amount
FROM sent_from_cex
WHERE DATE >= '2021-01-01'
AND cex_label in ('binance')
GROUP BY time_period, cex_label
ORDER BY time_period ASC