select

case

when signers [0] = 'pay3JiXTbGTdjfoYo1caZ1oGdQgWVLQ3ws8LoqbxU8i' then signers [1]

else signers [0]

end as User_address,

block_timestamp

from

solana.core.ez_events_decoded

where

program_id = 'FitAFk15vtx2PBjfr7QTnefaHRx6HwajRiZMt1DdSSKU'

and SUCCEEDED

and event_type in ('deposit', 'depositSol')

),

earliest_activity as (

select

min(block_timestamp) as Earliest_date,

User_address

from

solana.core.ez_events_decoded

inner join (

select

distinct user_address

from

Moonwalk_activity

) Users on case

when ez_events_decoded.signers [0] = 'pay3JiXTbGTdjfoYo1caZ1oGdQgWVLQ3ws8LoqbxU8i' then ez_events_decoded.signers [1]

else ez_events_decoded.signers [0]

end = Users.user_address

where

program_id = 'FitAFk15vtx2PBjfr7QTnefaHRx6HwajRiZMt1DdSSKU'

and SUCCEEDED

and event_type in ('deposit', 'depositSol')

group by

User_address

),