select

price,

hour

from

ethereum.price.ez_hourly_token_prices

where

token_address = '0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2'

),

raw_input as (

select

raw_amount / 1e18 as amount,

case

when contract_address = '0xfae103dc9cf190ed75350761e95403b7b8afa6c0' then 'Swell'

when contract_address = '0xd9a442856c234a39a81a089c06451ebaa4306a72' then 'Puffer'

when contract_address = '0xa1290d69c65a6fe4df752f95823fae25cb99e5a7' then 'Kelp'

when contract_address = '0xbf5495efe5db9ce00f80364c8b423567e58d2110' then 'Renzo'

when contract_address = '0x35fa164735182de50811e8e2e824cfb9b6118ac2' then 'Ether.fi'

when contract_address = '0xf1376bcef0f78459c0ed0ba5ddce976f1ddf51f4' then 'Bedrock'

when contract_address = '0x6ef3d766dfe02dc4bf04aae9122eb9a0ded25615' then 'Prime'

end as protocol,

date_trunc('week', block_timestamp) as time

from

ethereum.core.fact_token_transfers

where

contract_address in (

'0xfae103dc9cf190ed75350761e95403b7b8afa6c0',

'0xd9a442856c234a39a81a089c06451ebaa4306a72',

'0xa1290d69c65a6fe4df752f95823fae25cb99e5a7',

'0xbf5495efe5db9ce00f80364c8b423567e58d2110',

'0x35fa164735182de50811e8e2e824cfb9b6118ac2',

'0xf1376bcef0f78459c0ed0ba5ddce976f1ddf51f4',

'0x6ef3d766dfe02dc4bf04aae9122eb9a0ded25615'

)

and from_address = '0x0000000000000000000000000000000000000000'

) -- rsweth, pufeth, rseth/kelp, rzeth/renzo, eeth/etherfi