select
BALANCE_DATE,
sum(zeroifnull(balance)) as supply,
avg(price)
from flipside_prod_db.ethereum.erc20_balances
where CONTRACT_ADDRESS = lower('0x7D1AfA7B718fb893dB30A3aBc0Cfc608AaCfeBB0')
and USER_ADDRESS not in(
'0x5e3ef299fddf15eaa0432e6e66473ace8c13d908',
'0x50d669f43b484166680ecc3670e4766cdb0945ce',
'0xcbfe11b78c2e6cb25c6eda2c6ff46cd4755c8fca'
)
GROUP BY BALANCE_DATE