WHEN INSTRUCTION:accounts[6]='So11111111111111111111111111111111111111112' THEN 'Bitcoin - SOL'

WHEN INSTRUCTION:accounts[6]='mSoLzYCxHdYgdzU16g5QSh3i5K3z3KZK7ytfqcJm7So' THEN 'Bitcoin - mSOL'

WHEN INSTRUCTION:accounts[6]='F6v4wfAdJB8D8p77bMXZgYt8TDKsYxLYxH5AFhUkYx9W' THEN 'Bitcoin - wLUNA'

WHEN INSTRUCTION:accounts[6]='2FPyTwcZLUg1MDrwsyoP4D6s1tM7hAkHYRjkNb5w6Pxk' THEN 'Bitcoin - Ethereum'

WHEN INSTRUCTION:accounts[6]='9n4nbM75f5Ui33ZbPYXn59EwSgE8CGsHtAeTH5YFeJ9E' THEN 'Bitcoin - Bitcoin'

END as vaults , (count(distinct INNER_INSTRUCTION:instructions[0]:parsed:info:authority)/76*100) as percentage_of_wallets

from solana.fact_events

where

date(block_timestamp) > '2022-02-01'

and INNER_INSTRUCTION:index=2

and INNER_INSTRUCTION:instructions[0]:parsed:type='transfer'

and INSTRUCTION:accounts[6] in ('So11111111111111111111111111111111111111112','mSoLzYCxHdYgdzU16g5QSh3i5K3z3KZK7ytfqcJm7So'

,'F6v4wfAdJB8D8p77bMXZgYt8TDKsYxLYxH5AFhUkYx9W','2FPyTwcZLUg1MDrwsyoP4D6s1tM7hAkHYRjkNb5w6Pxk')

and INNER_INSTRUCTION:instructions[0]:parsed:info:authority in(

select distinct INNER_INSTRUCTION:instructions[0]:parsed:info:authority from solana.fact_events

where

date(block_timestamp) > '2022-02-01'

and INNER_INSTRUCTION:index=2

and INNER_INSTRUCTION:instructions[0]:parsed:type='transfer'

and INSTRUCTION:accounts[6] in ('9n4nbM75f5Ui33ZbPYXn59EwSgE8CGsHtAeTH5YFeJ9E')

)

and program_id='1349iiGjWC7ZTbu6otFmJwztms122jEEnShKgpVnNewy'

group by 1