with datetime_info AS (

SELECT DATE(block_timestamp) AS Date, ROUND(SUM(amount),2) AS Total Amount

FROM algorand.payment_transaction

WHERE YEAR(block_timestamp)>2021 AND DATE(block_timestamp)<CURRENT_DATE

GROUP BY DATE(block_timestamp);

),

cex_info as (

select

label

FROM algorand.labels

WHERE label_type = 'cex' AND label_subtype = 'hot_wallet' AND YEAR(block_timestamp)>=2021 AND DATE(block_timestamp)<CURRENT_DATE

GROUP BY label