SELECT

origin_from_address as user1,

event_inputs:proxy as wallet

FROM ethereum.core.fact_event_logs

where contract_address like lower('0x76E2cFc1F5Fa8F6a5b3fC4c8F4788F0116861F9B')

), tab2 as (

SELECT

to_address,

sum(amount_usd) as in_volume,

avg(amount_usd) as avg_in_volume,

count(DISTINCT tx_hash) as in_events ,

min(block_timestamp) as min_deposit

FROM ethereum.core.ez_token_transfers

where to_address in (SELECT wallet from tab1)

AND symbol in ('USDC', 'USDT', 'DAI')

GROUP BY 1

), tab3 as (

SELECT

from_address,

sum(amount_usd) as out_volume,

avg(amount_usd) as avg_out_volume,

count(DISTINCT tx_hash) as out_events,

max(block_timestamp) as max_withdraw

FROM ethereum.core.ez_token_transfers

where from_address in (SELECT wallet from tab1)

AND symbol in ('USDC', 'USDT', 'DAI')

GROUP BY 1

), tab4 as (

SELECT

user1 as user2,

COUNT(DISTINCT wallet) as wallets

FROM tab1

GROUP BY 1

), tab5 as (

SELECT