SELECT sum(balance) as SUM ,
avg(Balance) as AVERAGE ,
CAST(block_timestamp as DATE) as Daily
from algorand.account AS Acc,
algorand.block AS BLO
where BLO.block_id = Acc.created_at
and Daily BETWEEN '2022-01-01' and '2022-01-31'
and balance >= 0
group by Daily
ORDER by Daily