SELECT

user_address as address,

current_bal as balancer_balance

FROM ETHEREUM.CORE.EZ_CURRENT_BALANCES

WHERE contract_address = LOWER('0xba100000625a3754423978a60c9317c58a424e3D')

AND current_bal > 0

),

aave_users as (

SELECT

user_address as address,

current_bal as aave_balance

FROM ETHEREUM.CORE.EZ_CURRENT_BALANCES

WHERE contract_address = LOWER('0x7Fc66500c84A76Ad7e9c93437bFc5Ac33E2DDaE9')

AND current_bal > 0

),

both as (

SELECT

a.address,

aave_balance,

balancer_balance

FROM aave_users a

LEFT OUTER JOIN balancer_users b

ON a.address = b.address

),

pools as (

SELECT

DISTINCT

sender,

pool_name

FROM ETHEREUM.CORE.EZ_DEX_SWAPS

WHERE platform = 'balancer'

AND pool_name ilike '%bb%'

SELECT

sender as address,