date_trunc('day',block_timestamp) as block_day,

count(*) as transactions,

sum(amount) as Algo_daily_transfers

from algorand.payment_transaction

where block_day >= '2022-04-25'

and

asset_id = 0

group by block_day

order by block_day