select

date_trunc('day',block_timestamp) as dt2,

avg(price_usd) as luna_price

from terra.oracle_prices

where SYMBOL='LUNA'

group by 1

),

t1 as (select

date as dt1,

sum(balance) as LunaCirculatingSupply,

count(distinct address) as unique_address

from terra.daily_balances

where currency = 'LUNA'

and address_label_type is NULL

group by 1

order by 1)

select

t1.dt1 as dt,

LunaCirculatingSupply,

luna_price,

luna_price*LunaCirculatingSupply as Market_cap,

sum(Market_cap) over (order by dt) as rate

from t1

inner join prc on t1.dt1=prc.dt2