select
balance_date::date as date,
sum(amount_usd) as total
from
flipside_prod_db.ethereum.erc20_balances
where
YEAR(balance_date::date) = 2022
and
user_address = '0x99c9fc46f92e8a1c0dec1b1747d010903e884be1'
and date between '2022-07-01' and '2022-07-31'
group by 1