(CASE

WHEN RIGHT (RAW_AMOUNT_PRECISE,4) = 9001 THEN 'ethereum'

WHEN RIGHT (RAW_AMOUNT_PRECISE,4) = 9002 THEN 'arbitrum'

WHEN RIGHT (RAW_AMOUNT_PRECISE,4) = 9003 THEN 'zksync_lite'

WHEN RIGHT (RAW_AMOUNT_PRECISE,4) = 9004 THEN 'starknet'

WHEN RIGHT (RAW_AMOUNT_PRECISE,4) = 9006 THEN 'polygon'

WHEN RIGHT (RAW_AMOUNT_PRECISE,4) = 9007 THEN 'optimism'

WHEN RIGHT (RAW_AMOUNT_PRECISE,4) = 9008 THEN 'immutablex'

WHEN RIGHT (RAW_AMOUNT_PRECISE,4) = 9009 THEN 'loopring'

WHEN RIGHT (RAW_AMOUNT_PRECISE,4) = 9010 THEN 'metis'

WHEN RIGHT (RAW_AMOUNT_PRECISE,4) = 9011 THEN 'dydx'

WHEN RIGHT (RAW_AMOUNT_PRECISE,4) = 9012 THEN 'zkspace'

WHEN RIGHT (RAW_AMOUNT_PRECISE,4) = 9013 THEN 'boba'

WHEN RIGHT (RAW_AMOUNT_PRECISE,4) = 9014 THEN 'zksync_era'

WHEN RIGHT (RAW_AMOUNT_PRECISE,4) = 9015 THEN 'bsc'

WHEN RIGHT (RAW_AMOUNT_PRECISE,4) = 9016 THEN 'arbitrum_nova'

WHEN RIGHT (RAW_AMOUNT_PRECISE,4) = 9017 THEN 'zkevm'

WHEN RIGHT (RAW_AMOUNT_PRECISE,4) = 9021 THEN 'base'

WHEN RIGHT (RAW_AMOUNT_PRECISE,4) = 9023 THEN 'linea'

WHEN RIGHT (RAW_AMOUNT_PRECISE,4) = 9024 THEN 'mantle'

WHEN RIGHT (RAW_AMOUNT_PRECISE,4) = 9030 THEN 'zora'

else 'others'

end) AS destination,

block_timestamp::date AS day,

count(DISTINCT from_address) AS wallet_count,

count(tx_hash) AS transacton_count,

sum(RAW_AMOUNT_PRECISE / pow(10,18)) AS eth_value

from polygon.core.fact_token_transfers

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

AND destination <> 'others'

GROUP BY day, destination