with Luna as (select date_trunc('day',date) as t, count(address),sum(balance) as bal

from terra.daily_balances

where currency='LUNA'

group by 1

order by 1

),

cum as (with first as

(select address as ad1, min(date) as mindate

from terra.daily_balances

where currency='LUNA' and balance>0

group by 1 order by 2),

raw as ( select *

from terra.daily_balances)

select date_trunc('day',date) as date1,count(distinct ad1)as n_new_hodler,

sum(n_new_hodler) OVER(ORDER BY date1 asc ROWS BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW) as cum_new_hodler

from FIRST

inner join raw on first.mindate=raw.date

group by 1 order by 1

select t, bal/1000 as circulation_luna_per_1K , cum_new_hodler

from luna

inner join cum on luna.t= cum.date1