select * from flipside_prod_db.algorand.labels

where label_type = 'cex'

and label_subtype = 'hot_wallet'

select label, date(block_timestamp) as date, count(*) as transactions from cexs join flipside_prod_db.algorand.payment_transaction p_transactions on cexs.address = p_transactions.sender

group by label, date

order by label, date