instructions[0]:parsed:info:amount AS token_amount,

pre_token_balances[3]:mint::string as source_token,

l.ADDRESS_NAME as name,

SIGNERS[0] as users

-- inner_instructions[0]:instructions[2]:parsed:info:mint::string as destination_chain_token

from solana.core.fact_transactions t

left join solana.core.dim_labels l

ON t.pre_token_balances[3]:mint::string = l.address

where succeeded = 'TRUE'

AND instructions[1]:programId = 'SWiMDJYFUGj6cPrQ6QYYYWZtvXQdRChSVAygDZDsCHC'

),

main1 as (

distinct source_token,

case when SOURCE_TOKEN='8qJSyQprMC57TWKaYEmetUR3UUiTP2M3hXdcvFhkZdmv' then '8'

when SOURCE_TOKEN='Es9vMFrzaCERmJfrF4H2FYD4KCoNkY11McCe8BenwNYB' then '6'

when SOURCE_TOKEN='Dn4noZ5jgGfkntzcQSUZ8czkreiZ1ForXYoV2H8Dm7S1' then '6'

when SOURCE_TOKEN='A9mUU4qviSctJVPJdBJWkb28deg915LYJKrzQ19ji3FM' then '6'

when SOURCE_TOKEN='BJUH9GJLaMSLV1E7B3SQLCy9eCfyr6zsrwGcpS2MkqR1' then '8'

when SOURCE_TOKEN='5RpUwQ8wtdPCZHhu6MERp2RGrpobsbZ6MH5dDHkUjs2' then '8'

when SOURCE_TOKEN='EPjFWdd5AufqSSqeM2qN1xzybapC8G4wEGGkZwyTDt1v' then '6'

end as decimals_amount

from amounts

),

main2 as (

select

distinct b.source_token as tokens,

decimals_amount as decimals,

a.name,

count(distinct(users)) as summ

from amounts a

join main1 b