select date_trunc('day', block_timestamp) as date, avg(amount * price) as volume
from ethereum.core.ez_token_transfers t, flipside_prod_db.ethereum.erc20_balances b
where to_address = '0xf92cd566ea4864356c5491c177a430c222d7e678' and b.symbol = t.symbol and date = balance_date and amount is not null
group by 1