with SEND as
(select SENDER,
sum(AMOUNT) as sent_amount
from
terra.core.ez_transfers
WHERE
CURRENCY ilike 'uluna'
group by SENDER
),
RECEIVE as
(select RECEIVER,
sum(AMOUNT) as received_amount
from
terra.core.ez_transfers
WHERE
CURRENCY ilike 'uluna'
group by RECEIVER
),
total_supp as (select sum(received_amount)/1e4 as total_supply
from RECEIVE r
left join SEND s on r.RECEIVER=s.SENDER
where sent_amount is null),
t1 as
(select date_trunc('day',BLOCK_TIMESTAMP) as date,
sum(case when FROM_CURRENCY ilike 'uluna' then FROM_AMOUNT/1e6 else null end) as from_amountt,
sum(case when to_CURRENCY ilike 'uluna' then FROM_AMOUNT/1e6 else null end) as to_amountt,
from_amountt-to_amountt as circulating_volume
from
terra.core.ez_swaps
group by 1
),
t3 as (select
sum(circulating_volume) over (order by date) as circulating_supply ,