b.date,

currency,

l.address_name,

balance_usd,

balance_usd / latest_ust as balance_ust

-- sum(balance_usd) as USD_in_wallets

from terra.daily_balances b inner join

(SELECT * FROM terra.labels where address_name like '%m%Pair' OR address_name LIKE '%m%UST LP' or address_name IN ('Terraswap MIR-UST Pair', 'Terraswap MIR-UST LP'))

l on b.address = l.address

INNER JOIN latest_mir_ust mu ON b.date = mu.date

WHERE b.balance_usd > 0 --and b.date > CURRENT_DATE - 1

-- group by 1, 2, 3

order by 1 desc