when eth_to_address = '0xae7ab96520de3a18e5e111b5eaab095312d7fe84' then 'lido'

when eth_to_address = '0xc874b064f465bdd6411d45734b56fac750cda29a' then 'stakewise'

when eth_to_address = '0x84db6ee82b7cf3b47e8f19270abde5718b936670' then 'stkr'

when eth_to_address in ('0xcbc1065255cbc3ab41a6868c22d1f1c573ab89fd', '0x49d72e3973900a195a155a46441f0c08179fdb64') then 'cream'

when eth_to_address = '0x4d05e3d48a938db4b7a9a59a802d5b45011bde58' then 'rocket pool'

when eth_to_address = '0x00000000219ab540356cbb839cbe05303d7705fa' then 'direct staking' end as name, sum(amount) as stake_eth, sum(stake_eth) over (partition by name order by date)

as cumulative_stake_eth, sum(amount_usd) as stake_usd, sum(stake_usd) over (partition by name order by date) as cumulative_stake_usd, count(distinct eth_from_address)

as unique_user, sum(unique_user) over (partition by name order by date) as cumulative_unique_user, count(distinct tx_hash) as tx_count, sum(tx_count) over (partition by name order by

date) as cumulative_tx_count

from ethereum.core.ez_eth_transfers

where eth_to_address in ('0xae7ab96520de3a18e5e111b5eaab095312d7fe84', '0xc874b064f465bdd6411d45734b56fac750cda29a', '0x84db6ee82b7cf3b47e8f19270abde5718b936670',

'0xcbc1065255cbc3ab41a6868c22d1f1c573ab89fd', '0x49d72e3973900a195a155a46441f0c08179fdb64', '0x4d05e3d48a938db4b7a9a59a802d5b45011bde58', '0x00000000219ab540356cbb839cbe05303d7705fa') and identifier = 'CALL_ORIGIN' and date >= '2022-06-01'

group by 1, 2