with gmp as (with tab1 as (select date_trunc('hour',created_at) as date, id, call:transaction:from as user,

call:chain as source_chain,

case

when call:returnValues:destinationChain='Arbitrum' or call:returnValues:destinationChain='arbitrum' then 'arbitrum'

when call:returnValues:destinationChain='Avalanche' or call:returnValues:destinationChain='avalanche' then 'avalanche'

when call:returnValues:destinationChain='Binance' or call:returnValues:destinationChain='binance' then 'binance'

when call:returnValues:destinationChain='Ethereum' or call:returnValues:destinationChain='ethereum' then 'ethereum'

when call:returnValues:destinationChain='Fantom' or call:returnValues:destinationChain='fantom' then 'fantom'

when call:returnValues:destinationChain='Moonbeam' or call:returnValues:destinationChain='moonbeam' then 'moonbeam'

when call:returnValues:destinationChain='Polygon' or call:returnValues:destinationChain='polygon' then 'polygon'

else call:returnValues:destinationChain

end as destination_chain,

amount,

call:returnValues:symbol as symbol, case

when call:returnValues:symbol='ARB' then '0xb50721bcf8d664c30412cfbc6cf7a15145234ad1'

when call:returnValues:symbol='axlARB' then '0xb50721bcf8d664c30412cfbc6cf7a15145234ad1'

when call:returnValues:symbol='APE' then '0x4d224452801aced8b2f0aebe155379bb5d594381' --

when call:returnValues:symbol='ARX' then '0x7d8daff6d70cead12c6f077048552cf89130a2b1'

when call:returnValues:symbol='AXL' then '0x467719ad09025fcc6cf6f8311755809d45a5e5f3'

when call:returnValues:symbol='BAL' then '0xba100000625a3754423978a60c9317c58a424e3d'

when call:returnValues:symbol='axlBAL' then '0xba100000625a3754423978a60c9317c58a424e3d'

when call:returnValues:symbol='BUSD' then '0xdac17f958d2ee523a2206206994597c13d831ec7'

when call:returnValues:symbol='axlBUSD' then '0xdac17f958d2ee523a2206206994597c13d831ec7'

when call:returnValues:symbol='AvalancheUSDC' then '0xdac17f958d2ee523a2206206994597c13d831ec7' --

when call:returnValues:symbol='PolygonUSDC' then '0xdac17f958d2ee523a2206206994597c13d831ec7' --

when call:returnValues:symbol='DAI' then '0xdac17f958d2ee523a2206206994597c13d831ec7'

when call:returnValues:symbol='USDC' then '0xdac17f958d2ee523a2206206994597c13d831ec7'

when call:returnValues:symbol='USDT' then '0xdac17f958d2ee523a2206206994597c13d831ec7'

when call:returnValues:symbol='axlUSDC' then '0xdac17f958d2ee523a2206206994597c13d831ec7'

when call:returnValues:symbol='axlUSDT' then '0xdac17f958d2ee523a2206206994597c13d831ec7'

when call:returnValues:symbol='FRAX' then '0xdac17f958d2ee523a2206206994597c13d831ec7' --

when call:returnValues:symbol='sFRAX' then '0xdac17f958d2ee523a2206206994597c13d831ec7'

when call:returnValues:symbol='axlFRAX' then '0xdac17f958d2ee523a2206206994597c13d831ec7'