superflyTotal Luna Supply
Updated 2022-12-14
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
›
⌄
with total_supply as (
select sum(received_amount)/1e4 as luna_total_supply
from (select sum(AMOUNT) as received_amount, RECEIVER
from
terra.core.ez_transfers
WHERE
CURRENCY='uluna'
group by receiver) data_one
left join (select sum(AMOUNT) as amount_transferred, SENDER
from
terra.core.ez_transfers
WHERE
CURRENCY='uluna'
group by sender) data_two on data_one.RECEIVER=data_two.SENDER
where amount_transferred is null
limit 10
)
select * from total_supply
Run a query to Download Data