SELECT

user_address,

avg(balance) as bal

FROM flipside_prod_db.ethereum.erc20_balances

WHERE symbol LIKE 'ETH'

and balance_date > CURRENT_DATE - 4

GROUP by 1

HAVING bal > 10000

), tab2 as (

SELECT

DISTINCT FROM_ADDRESS

FROM ethereum.core.fact_transactions

WHERE block_timestamp > CURRENT_DATE - 90

AND from_address in (SELECT user_address FROM tab1)

SELECT

date_trunc('day', block_timestamp),

count(*) as ETH_Transfers,

sum(amount) as ETH_volume,

COUNT(DISTINCT ORIGIN_FROM_ADDRESS) as senders

FROM ethereum.core.ez_eth_transfers

WHERE ORIGIN_FROM_ADDRESS in (SELECT * from tab2)

AND block_timestamp > '2022-05-01'

group by 1