-- forked from Etherfi Count - Daily Stakers & Deposits Count @ https://flipsidecrypto.xyz/edit/queries/c6611652-3788-4669-84fc-22dcebb6d81b

-- forked from Etherfi Count - total count by token @ https://flipsidecrypto.xyz/edit/queries/5ce23d7d-e7b1-4b26-96c2-99982d1b45b6

-- 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,

'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,

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'

),