select

date_trunc('day',block_timestamp) as dt2,

avg(price_usd) as luna_price

from terra.oracle_prices

where SYMBOL='LUNA'

and block_timestamp>= CURRENT_DATE - interval '30 days'

group by 1

),

t1 as (select

date as dt1,

sum(balance) as LunaCirculatingSupply,

count(distinct address) as unique_address

from terra.daily_balances

where date >= CURRENT_DATE - interval '30 days'

and 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

from t1

inner join prc on t1.dt1=prc.dt2