(select

date_trunc('day',BLOCK_TIMESTAMP) as date,

sum(case when FROM_CURRENCY='uluna' then FROM_AMOUNT/1e6 else null end) as from_amount_,

sum(case when to_CURRENCY='uluna' then FROM_AMOUNT/1e6 else null end) as to_amount_ ,

from_amount_-to_amount_ as circulating_volume,

sum(circulating_volume) over (order by date) as circulating_supply

from

terra.core.ez_swaps

group by date

), sender as

(select sum(AMOUNT) as sent, SENDER

from

terra.core.ez_transfers

group by 2),

receiver as

(select sum(AMOUNT) as rec, RECEIVER

from

terra.core.ez_transfers

group by 2),

total_ as

(select sum(rec)/1e4 as total_supply from receiver a left join sender b on a.RECEIVER=b.SENDER

where sent is null) ,

supply as

(select * , circulating_supply/(SELECT * from total_)*100 as ratio from t1

where ratio >=0 and circulating_supply >0 )

SELECT *, cum_amount/1e9*100 as percent_staked from

(SELECT date(block_timestamp) as day, count(DISTINCT tx_id) as total_txs,

count(DISTINCT delegator_address) as total_delegators,

sum(case when action = 'undelegate' then amount*(-1) else amount end ) as total_amount,