date,

currency,

b.address,

l.address_name,

sum(balance_usd) as USD_in_wallets

from terra.daily_balances b

inner join terra.labels l

on b.address = l.address

where currency = 'UST'

and date = current_date()

group by 1, 2, 3, 4

order by 1 desc, 5 desc;