SELECT
user_address,
SUM(amount_usd)
FROM ethereum.erc20_balances
WHERE balance_date > getdate() - interval '1 day'
AND balance > 0
AND amount_usd > 0
AND contract_address <> user_address
AND balance > 0.000001
AND address_name IS NULL
GROUP BY user_address
ORDER BY ethereum.erc20_balances.user_address DESC