with eth_from_ethereum AS(

select

(CASE

WHEN RIGHT (ethereum.public.udf_hex_to_int(data:value :: STRING),4) = 9001 THEN 'ethereum'

WHEN RIGHT (ethereum.public.udf_hex_to_int(data:value :: STRING),4) = 9002 THEN 'arbitrum'

WHEN RIGHT (ethereum.public.udf_hex_to_int(data:value :: STRING),4) = 9003 THEN 'zksync_lite'

WHEN RIGHT (ethereum.public.udf_hex_to_int(data:value :: STRING),4) = 9004 THEN 'starknet'

WHEN RIGHT (ethereum.public.udf_hex_to_int(data:value :: STRING),4) = 9006 THEN 'polygon'

WHEN RIGHT (ethereum.public.udf_hex_to_int(data:value :: STRING),4) = 9007 THEN 'optimism'

WHEN RIGHT (ethereum.public.udf_hex_to_int(data:value :: STRING),4) = 9008 THEN 'immutablex'

WHEN RIGHT (ethereum.public.udf_hex_to_int(data:value :: STRING),4) = 9009 THEN 'loopring'

WHEN RIGHT (ethereum.public.udf_hex_to_int(data:value :: STRING),4) = 9010 THEN 'metis'

WHEN RIGHT (ethereum.public.udf_hex_to_int(data:value :: STRING),4) = 9011 THEN 'dydx'

WHEN RIGHT (ethereum.public.udf_hex_to_int(data:value :: STRING),4) = 9012 THEN 'zkspace'

WHEN RIGHT (ethereum.public.udf_hex_to_int(data:value :: STRING),4) = 9013 THEN 'boba'

WHEN RIGHT (ethereum.public.udf_hex_to_int(data:value :: STRING),4) = 9014 THEN 'zksync_era'

WHEN RIGHT (ethereum.public.udf_hex_to_int(data:value :: STRING),4) = 9015 THEN 'bsc'

WHEN RIGHT (ethereum.public.udf_hex_to_int(data:value :: STRING),4) = 9016 THEN 'arbitrum_nova'

WHEN RIGHT (ethereum.public.udf_hex_to_int(data:value :: STRING),4) = 9017 THEN 'zkevm'

WHEN RIGHT (ethereum.public.udf_hex_to_int(data:value :: STRING),4) = 9021 THEN 'base'

WHEN RIGHT (ethereum.public.udf_hex_to_int(data:value :: STRING),4) = 9023 THEN 'linea'

WHEN RIGHT (ethereum.public.udf_hex_to_int(data:value :: STRING),4) = 9024 THEN 'mantle'

WHEN RIGHT (ethereum.public.udf_hex_to_int(data:value :: STRING),4) = 9030 THEN 'zora'

else 'others'

end

) AS destination,

ethereum.public.udf_hex_to_int(data:value :: STRING) AS raw_amount,

block_timestamp,

from_address,