SELECT date_trunc('day', block_timestamp) as date,
count(DISTINCT tx_id) as n_txs,
sum(amount) as amount,
CASE WHEN (date>= '2022-02-10' and date<= '2022-02-17') then 'the week following announcement'
else 'other days' end as specific_days
FROM algorand.payment_transaction
WHERE receiver in (SELECT address
FROM algorand.labels
WHERE label_type = 'cex')
AND asset_id = 0
AND date between '2022-01-15' and '2022-03-15'
group by date