BALANCE_DATE,

SUM(balance) AS TOTAL_BALANCE_ETH,

count(distinct USER_ADDRESS) AS Total_user_metamask,

TOTAL_BALANCE_ETH/Total_user_metamask AS Average_ETH

FROM flipside_prod_db.ethereum.erc20_balances

WHERE SYMBOL='ETH' AND BALANCE_DATE='2022-06-23'

AND (USER_ADDRESS)

SELECT ( FROM_ADDRESS) FROM ethereum.core.fact_transactions

WHERE TO_ADDRESS='0x881d40237659c251811cec9c364ef91dc08d300c'

AND BLOCK_TIMESTAMP::date <='2022-06-23'

AND BALANCE IS NOT NULL

AND HAS_DECIMAL='0')

GROUP BY 1