with all_platform as (

SELECT

block_timestamp::date as date,

case

when BLOCK_NUMBER < 15537351 then 'Before Merg'

when BLOCK_NUMBER >= 15537351 then 'After Merg' -- 15,537,351 The merg block number

end as period,

case

when contract_address = lower('0xFe2e637202056d30016725477c5da089Ab0A043A') then 'Stakewise'

when contract_address = lower('0xE95A203B1a91a908F9B9CE46459d101078c2c3cb') then 'stkr'

when contract_address = lower('0xae78736Cd615f374D3085123A210448E74Fc6393') then 'Rocket Pool'

when contract_address = lower('0xae7ab96520DE3A18E5e111B5EaAb095312D7fE84') then 'Lido'

when contract_address = lower('0x2ba592F78dB6436527729929AAf6c908497cB200') then 'Cream'

end as platform,

count(DISTINCT tx_hash) as tx_cnt,

COUNT (DISTINCT to_address) as depositor_cnt,

sum(raw_amount / power(10, 18)) as eth_staked,

max((raw_amount)/pow(10,18)) as max_amnt_staked,

min((raw_amount)/pow(10,18)) as min_amnt_staked,

avg((raw_amount)/pow(10,18)) as avg_amnt_staked,

median((raw_amount)/pow(10,18)) as median_amnt_staked

FROM ethereum.core.ez_token_transfers

WHERE contract_address in (lower('0xFe2e637202056d30016725477c5da089Ab0A043A')

,lower('0xE95A203B1a91a908F9B9CE46459d101078c2c3cb')

,lower('0xae78736Cd615f374D3085123A210448E74Fc6393')

,lower('0xae7ab96520DE3A18E5e111B5EaAb095312D7fE84')

,lower('0x2ba592F78dB6436527729929AAf6c908497cB200'))

AND from_address LIKE '0x0000000000000000000000000000000000000000'

AND raw_amount > 0

GROUP BY 1,2,3

UNION ALL

SELECT

block_timestamp::date as date,