date,

currency,

b.address,

l.address_name,

b.balance_usd,

sum(balance_usd) as USD_in_wallets,

rank() over (PARTITION BY date ORDER BY balance_usd DESC) AS rank

FROM terra.daily_balances b

INNER JOIN terra.labels l

ON b.address = l.address

WHERE currency = 'UST'

AND l.address_name like '%Pair'

AND DATE >= ADD_MONTHS(CURRENT_DATE, -6)

GROUP BY 1, 2, 3, 4,5

WHERE rank <= 5

order by 1 desc, 5 desc