date(BLOCK_TIMESTAMP) as date,

case

when substr(INSTRUCTION:data , 0 , 8) = '2CK5w7s2' then 'DepositNft'

when substr(INSTRUCTION:data , 0 , 8) = 'EkaEiXe8' then 'TransferEscrowNft'

when substr(INSTRUCTION:data , 0 , 8) = '8YsDD7nA' then 'InitSwap'

when substr(INSTRUCTION:data , 0 , 8) = '4wRuTmZw' then 'CompleteSwap'

when substr(INSTRUCTION:data , 0 , 8) = 'YoL1iu41' then 'TransferNft'

when substr(INSTRUCTION:data , 0 , 8) = '6XgT7RQL' then 'InitSwap'

when substr(INSTRUCTION:data , 0 , 8) = 'QsTzMXR9' then 'WithdrawNft'

when substr(INSTRUCTION:data , 0 , 8) = '3ueC7KQh' then 'CompleteSwap'

when substr(INSTRUCTION:data , 0 , 8) = 'FqKUvefT' then 'CancelSwap'

when substr(INSTRUCTION:data , 0 , 8) = 'QUbsESp6' then 'TransferNft'

when substr(INSTRUCTION:data , 0 , 8) = '2DucxJBi' then 'DepositPnft'

when substr(INSTRUCTION:data , 0 , 8) = 'KnnJpBDd' then 'TransferPnft'

when substr(INSTRUCTION:data , 0 , 8) = '7nGrDmHx' then 'TransferEscrowPnft'

when substr(INSTRUCTION:data , 0 , 8) = 'eWemNC55' then 'ReturnNft'

when substr(INSTRUCTION:data , 0 , 8) = 'GHNhaLQA' then 'RejectSwap'

when substr(INSTRUCTION:data , 0 , 8) = 'bnuYdQSV' then 'WithdrawPnft'

when substr(INSTRUCTION:data , 0 , 8) = '39W6zSBN' then 'CompleteSwap'

when substr(INSTRUCTION:data , 0 , 8) = 'B9pY9PCX' then 'TransferEscrowNft'

when substr(INSTRUCTION:data , 0 , 8) = 'Surk6h7t' then 'ExtendSwap'

when substr(INSTRUCTION:data , 0 , 8) = 'gHv564AC' then 'ReturnPnft'

when substr(INSTRUCTION:data , 0 , 8) = '29P4xLHN' then 'InitSwap'

end as methods,

INDEX,

TX_ID,

SIGNERS,

INSTRUCTION,

INNER_INSTRUCTION

from solana.core.fact_events

where program_id = '8guzmt92HbM7yQ69UJg564hRRX6N4nCdxWE5L6ENrA8P'

and SUCCEEDED = 'true'

order by 1,4,3