select

user_address , balance , amount_usd , LABEL,LABEL_TYPE , ADDRESS_NAME , LABEL_SUBTYPE

from flipside_prod_db.ethereum.erc20_balances

where CONTRACT_ADDRESS = 'ETH' and symbol = 'ETH'

and balance_date = CURRENT_DATE - 1

)

, top100 as (

select top 5000

user_address,

sum(amount_usd) as usd_amt,

sum(balance) as balanc

from balance

where amount_usd >= 1e6

and user_address != '0x00000000219ab540356cbb839cbe05303d7705fa' --Eth2 Deposit Contract

and LABEL is null

and LABEL_TYPE is null

and ADDRESS_NAME is null and LABEL_SUBTYPE is null

group by 1

order by 2 desc

)

,

tb1 as (

select block_timestamp::date as date, ORIGIN_FROM_ADDRESS as wallet, tx_hash , AMOUNT_OUT_USD

from ethereum.core.ez_dex_swaps

where ORIGIN_FROM_ADDRESS in (select user_address from top100) and symbol_out in ('WETH' , 'ETH')

and block_timestamp::date >= '2022-05-01' and block_timestamp::date < '2022-07-01'

,

tb2 as (

select block_timestamp::date as date, ORIGIN_FROM_ADDRESS as wallet, tx_hash , AMOUNT_IN_USD

from ethereum.core.ez_dex_swaps

where ORIGIN_FROM_ADDRESS in (select user_address from top100) and symbol_in in ('WETH' , 'ETH')

and block_timestamp::date >= '2022-05-01' and block_timestamp::date < '2022-07-01'