avg(price) as eth_price,

sum(amount_usd) as stablecoin_volume,

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

from ethereum.core.ez_token_transfers t

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

where origin_to_address in ('0x99c9fc46f92e8a1c0dec1b1747d010903e884be1', '0x10e6593cdda8c58a1d0f14c5164b376352a55f2f')

and block_timestamp > CURRENT_DATE - 120

and t.symbol in ('USDC','USDT', 'DAI')

and p.symbol = 'WETH'

group by TIME