balance_date,

SUM(balance) AS eth_Balance,

sum(AMOUNT_USD) as eth_balance_USD,

count(distinct USER_ADDRESS) AS Num_wallets,

eth_Balance/Num_wallets AS Avg_eth_balance,

eth_balance_USD/Num_wallets as Avg_eth_balance_USD

FROM flipside_prod_db.ethereum.erc20_balances

WHERE SYMBOL='ETH' AND BALANCE_DATE<='2022-06-22' AND BALANCE_DATE>='2022-06-01' and HAS_DECIMAL='0'

--and tx_hash='0xf4ea81c5d3fb5de1fae16179fbb99240f04a655c853f082ba5f96838498e7a8e' --sample tx

AND USER_ADDRESS IN

( SELECT FROM_ADDRESS FROM ethereum.core.fact_transactions

WHERE TO_ADDRESS='0x881d40237659c251811cec9c364ef91dc08d300c' -- Metamask: Swap Router

AND BLOCK_TIMESTAMP::date <='2022-06-22')

group by 1

order by 1 asc