with pricet as (

HOUR::date as dates,

avg(price) as usd

from ethereum.price.ez_hourly_token_prices

where SYMBOL ilike 'weth'

group by 1

select

when destination ilike '0x2da10a1e27bf85cedd8ffb1abbe97e53391c0295' then 'syncSwap'

when destination ilike '0x8B791913eB07C32779a16750e3868aA8495F5964' then 'mute'

when destination ilike '0xb9061E38FeE7d30134F56aEf7117E2F6d1580666' then 'okxSwap'

when destination ilike '0xbE7D1FD1f6748bbDefC4fbaCafBb11C6Fc506d1d' then 'spacefi'

when destination ilike '0x6e2B76966cbD9cF4cC2Fa0D76d24d5241E0ABC2F' then '1inch'

when destination ilike '0x9606eC131EeC0F84c95D82c9a63959F2331cF2aC' or

destination ilike '0x943ac2310D9BC703d6AB5e5e76876e212100f894' then 'izumi'

when destination ilike '0x5B91962F5ECa75E6558E4d32Df69B30f75cc6FE5' then 'rollup'

when destination ilike '0xCBE2093030F485adAaf5b61deb4D9cA8ADEAE509' then 'zns'

when destination ilike '0xd999E16e68476bC749A28FC14a0c3b6d7073F50c' then 'velo'

when destination ilike '0xC5db68F30D21cBe0C9Eac7BE5eA83468d69297e6' or

destination ilike '0x04e9Db37d8EA0760072e1aCE3F2A219988Fdac29' then 'ReactorFusion'

when destination ilike '0x1BbD33384869b30A323e15868Ce46013C82B86FB' or

destination ilike '0x1181D7BE04D80A8aE096641Ee1A87f7D557c6aeb' then 'eraLend'

when destination ilike '0x39e098a153ad69834a9dac32f0fca92066ad03f4' then 'mav'

when destination ilike '0x6C31035D62541ceba2Ac587ea09891d1645D6D07' then 'veSync'

when destination ilike '0x84d05333f1F5Bf1358c3f63A113B1953C427925D' or

destination ilike '0xA269031037B4D5fa3F771c401D19E57def6Cb491' then 'overNight'

when destination ilike '0x36A1aCbbCAfca2468b85011DDD16E7Cb4d673230' then 'openocean'

when destination ilike '0x498f7bB59c61307De7dEA005877220e4406470e9' then 'ezk'

when destination ilike '0xA269031037B4D5fa3F771c401D19E57def6Cb491' then 'odos'

when destination ilike '0x981F198286E40F9979274E0876636E9144B8FB8E' then 'dmail'