FROM ethereum.core.fact_transactions

WHERE to_address = lower('0x881D40237659C251811CEC9c364ef91dC08D300C')),

eth_price as (select price, TRIM(symbol, 'W') as symbol

FROM ethereum.core.fact_hourly_token_prices

WHERE symbol = 'WETH'

ORDER BY HOUR

DESC

LIMIT 1)

SELECT avg(amount_usd) as avg_usd, avg(amount_usd / e.price) as balance_eth, e.symbol

FROM flipside_prod_db.ethereum.erc20_balances as b

JOIN metamask_wallets as m on b.user_address = m.Metamask_Wallet

JOIN eth_price as e on e.symbol = b.symbol

WHERE balance_date = CURRENT_DATE and b.symbol = 'ETH'

GROUP BY 3