KaskoazulHead to Head UST
Updated 2022-03-26
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
›
⌄
WITH TOP10UST as (
select db.address,
db.address_label,
db.address_label_subtype,
db.address_label_type,
l.address_name,
l.label,
l.label_subtype,
l.label_type,
db.balance,
db.balance_usd,
db.currency
from terra.daily_balances db
left join terra.labels l
on db.address = l.address
where date = '2022-03-23'
and currency in ('UST')
and balance > 0
--and db.address = 'terra1gr0xesnseevzt3h4nxr64sh5gk4dwrwgszx3nw' --LFG
order by balance desc
LIMIT 10
),
LFG as (
select db.address,
db.address_label,
db.address_label_subtype,
db.address_label_type,
'luna foundation guard' as address_name,
l.label,
l.label_subtype,
l.label_type,
db.balance,
db.balance_usd,
db.currency
from terra.daily_balances db
Run a query to Download Data