with addresses as (

select USER_ADDRESS as users

,avg(AMOUNT_USD) as avg_balance

from flipside_prod_db.ethereum.erc20_balances

where symbol = 'ETH' and BALANCE_DATE between '{{Start_Date}}' and '{{End_Date}}'

--and LABEL is null

--and lABEL_TYPE is null

group by 1 having avg_balance >= '1000000' )

select BLOCK_TIMESTAMP::date as date,

address_name,

sum(AMOUNT_USD) transferres_amount

from ethereum.core.ez_eth_transfers t,ethereum.core.dim_labels l

where t.ETH_TO_ADDRESS = l.address

and BLOCK_TIMESTAMP between '{{Start_Date}}' and '{{End_Date}}'

and label_type = 'defi' and ETH_FROM_ADDRESS in (select users from addresses)

group by 1 ,2

order by 2 desc