boomer77top ust
Updated 2022-04-05
99
1
2
3
4
5
6
7
8
9
10
11
›
⌄
select address, address_label_type, concat(address_label, '-', address_name) as account, case
when account is null then 'unknown'
else account end as owner,
ADDRESS_LABEL_SUBTYPE,
case when ADDRESS_LABEL_SUBTYPE is null then 'individual'
else ADDRESS_LABEL_SUBTYPE end as labels,
balance
from terra.daily_balances
where date = CURRENT_DATE - 2 and currency = 'UST'
order by balance desc
limit 20
Run a query to Download Data