Sbhn_NPTotal $LUNA Supply
Updated 2022-12-15
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
›
⌄
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
)
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
Run a query to Download Data