with total_number_of_transfered_ALGO as (
select date(BLOCK_TIMESTAMP) as day , sum(AMOUNT) as total_number_of_transfered_ALGO
from flipside_prod_db.algorand.transfers
where ASSET_ID=0
group by day
order by day
)
select * from total_number_of_transfered_ALGO