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

INNER JOIN balancer_users b

ON a.address = b.address

),

age AS (

SELECT

address,

datediff('day', min(block_timestamp :: date), current_date()) as days_old

FROM both b

INNER JOIN ETHEREUM.CORE.FACT_TRANSACTIONS t

ON b.address = t.from_address

GROUP BY address

),

counts as (

SELECT