-- forked from Etherfi Volume - Total @ https://flipsidecrypto.xyz/edit/queries/6d039c5a-ba94-409f-b80c-69a1fbcc45ad

-- forked from Etherfi Count - total @ https://flipsidecrypto.xyz/edit/queries/ded0ef30-05c2-438f-b086-8e2b954462d0

with deposits as (

select

tx_hash,

block_timestamp,

eth_from_address as depositor,

amount_usd,

'ETH' as token

from ethereum.core.ez_eth_transfers

where eth_to_address = '0x7623e9dc0da6ff821ddb9ebaba794054e078f8c4'

and origin_function_signature = '0x98ea5fca'

select

tx_hash,

block_timestamp,

from_address as depositor,

amount_usd,

CASE

when contract_address = '0x7f39c581f595b53c5cb19bd0b3f8da6c935e2ca0' then 'wstETH'

when contract_address = '0xac3e018457b222d93114458476f3e3416abbe38f' then 'sfrxETH'

when contract_address = '0xae78736cd615f374d3085123a210448e74fc6393' then 'rETH'

when contract_address = '0xbe9895146f7af43049ca1c1ae358b0541ea49704' then 'cbETH'

end as token

from ethereum.core.ez_token_transfers

where to_address = '0x7623e9dc0da6ff821ddb9ebaba794054e078f8c4'

and origin_function_signature = '0x47e7ef24'

),