select date_trunc('day',BLOCK_TIMESTAMP) Date_Transfer,
(sum(asset_amount)/1000000) as DAILy_TRANSFER
from algorand.asset_transfer_transaction
where asset_id= '31566704'
and asset_sender is NULL
and BLOCK_TIMESTAMP>= '2022-01-01'
group by Date_Transfer
order by Date_Transfer desc