select
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 l.address_name like '%shuttle'
group by 1, 2, 3, 4
order by 1 desc, 5 desc;