(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,

date_trunc(month, block_timestamp) AS month,

count(DISTINCT from_address) AS wallet_count,

count(tx_hash) AS transacton_count,

sum(eth_value) AS eth_value

from arbitrum.core.fact_traces

to_address IN ('0xe4edb277e41dc89ab076a1f049f4a3efa700bce8','0x80c67432656d59144ceff962e8faf8926599bcf8')

AND destination <> 'others'

GROUP BY month, destination