select

avg(price) as eth_price,

sum(amount) as eth_volume,

date_trunc('day', block_timestamp::date) as TIME

from ethereum.core.ez_eth_transfers t

inner join ethereum.core.fact_hourly_token_prices p on t.block_timestamp::date = p.hour::date

where origin_to_address = '0x99c9fc46f92e8a1c0dec1b1747d010903e884be1'

and block_timestamp > CURRENT_DATE - 120

and symbol = 'WETH'

group by TIME