date,

sum(balance) as circulating,

sum(circulating)over(order by date asc) as cumulative_ust

from terra.daily_balances

where CURRENCY='UST'

and date<=CURRENT_DATE-3

and date>= '2022-01-01'

group by 1),

ancnot as(select

date,

sum(balance) as circulating_without,

sum(circulating_without)over(order by date asc) as cumulative_ust_without

from terra.daily_balances

where CURRENCY='UST'

and date<=CURRENT_DATE-3

and date>= '2022-01-01'

and address!='terra1sepfj7s0aeg5967uxnfk4thzlerrsktkpelm5s'

group by 1)

anc.date as dt,

circulating,

circulating_without,

cumulative_ust,

from anc

inner join ancnot on anc.date=ancnot.date