SELECT
date(block_timestamp) as date,
count(DISTINCT sender) as count_senders,
sum(amount) as volume,
case when date>='2022-05-02' then 'after'
else 'before' end as spliter
from algorand.payment_transaction
where date(block_timestamp) >= '2022-04-01'
and amount is not NULL
and amount != 0
and asset_id = 0 -- ALGO
GROUP BY date