boomer77UST Holders
Updated 2021-11-10
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
›
⌄
with krt as (select address, balance as KRT
from terra.daily_balances
where currency = 'UST' and date = CURRENT_DATE - 1 and balance > 0
group by 1,2
order by balance desc
limit 10),
luna as (select address, balance
from terra.daily_balances
where currency = 'LUNA' and date = CURRENT_DATE - 1 and balance_type = 'liquid'
)
select a.address, a.KRT, sum(b.balance) as luna
from krt a
join luna b on a.address = b.address
group by 1,2
order by 2 desc
Run a query to Download Data