select TX_HASH

,AMOUNT_USD

,FROM_ADDRESS

from polygon.core.ez_token_transfers

where ORIGIN_TO_ADDRESS='0x88dcdc47d2f83a99cf0000fdf667a468bb958a78'

and ORIGIN_FUNCTION_SIGNATURE in ('0xa5977fbb')),

tab2 as (

select date_trunc('week',BLOCK_TIMESTAMP) as week

,case

when DECODED_LOG:dstChainId='7700' then 'Canto'

when DECODED_LOG:dstChainId='1' then 'Ethereum Mainnet'

when DECODED_LOG:dstChainId='250' then 'Fantom Opera'

when DECODED_LOG:dstChainId='42161' then 'Arbitrum One'

when DECODED_LOG:dstChainId='1313161554' then 'Aurora Mainnet'

when DECODED_LOG:dstChainId='56' then 'BNB Smart Chain Mainnet'

when DECODED_LOG:dstChainId='1666600000' then 'Harmony Mainnet Shard 0'

when DECODED_LOG:dstChainId='288' then 'Boba Network'

when DECODED_LOG:dstChainId='2222' then 'Kava EVM'

when DECODED_LOG:dstChainId='592' then 'Astar'

when DECODED_LOG:dstChainId='324' then 'zkSync Era Mainnet'

when DECODED_LOG:dstChainId='59144' then 'Linea'

when DECODED_LOG:dstChainId='10' then 'OP Mainnet'

when DECODED_LOG:dstChainId='128' then 'Huobi ECO Chain Mainnet'

when DECODED_LOG:dstChainId='1285' then 'Moonriver'

when DECODED_LOG:dstChainId='336' then 'Shiden'

when DECODED_LOG:dstChainId='44' then 'Darwinia Crab Network'

when DECODED_LOG:dstChainId='43114' then 'Avalanche C-Chain'

when DECODED_LOG:dstChainId='248' then 'Oasys Mainnet' end as ch_name

,TX_HASH

from polygon.core.ez_decoded_event_logs

where DECODED_LOG:dstChainId is not null )

select week

,ch_name

,sum(AMOUNT_USD) as "VOLUME OUT"

from tab1