select date_trunc('day',block_timestamp) as date, sum(AMOUNT) as AMOUNTs, 501700-sum(AMOUNTs) over (order by date) as left_Supply
from flipside_prod_db.algorand.transfers
where TX_SENDER ='ISSY3W2SLS3S5NHLUH3G77PH6SCBQ5ZTZ22ZCIPXGB26ESHYP32MELSMU4'
and ASSET_ID = '725937713'
group by 1